Reports

Reports

Reports in kBooks are live: they read your books the moment you open them, so there is never a stale copy or a generate step.

The core statements

Profit and Loss and Balance Sheet run for any period, on an accrual or cash basis, compared against a prior period or a budget if you keep one. Every number drills down: click it and the exact transactions behind it open in a window, newest first, with the date range in your hands. Spot something miscategorized? Fix it from the drill and the report reflects it immediately.

The custom report

When the question is more specific ("what did we spend on repairs, by building, this year"), build it in the custom report: choose the rows, the date range, and stack filters (accounts, classes, contacts, amounts, memo text). The account and contact filters are type-to-find: start typing a name and the list narrows as you type, and when only one name fits it fills itself in. The totals are computed over everything the filters cover, not just the rows on screen, so the answer is exact. A report worth keeping can be saved with a name and rerun any time; it remembers its filters and stays live.

Customers and vendors

Six reports answer the questions you would otherwise assemble by hand. Sales by Customer shows income per customer for any range - and its total is exactly your Profit and Loss income for the same range, because anything entered without a customer sits in its own "No customer" line instead of disappearing. Expenses by Vendor is the mirror for spend. Customer Balance tells each customer's story - what they owed coming in, every charge and payment with a running balance, where they ended - plus the average days they take to pay you. Vendor Balance does the same for what you owe. Transactions by Customer and by Vendor list every transaction entered for each name, one row per transaction.

The A/R and A/P Aging reports also gained an Open documents view: the flat list of every open invoice or unpaid bill with days past due. Tick Overdue only and it becomes a collections call sheet, with each name's phone and email right on the heading.

Classes: one set of books, many answers

If you run several stores, buildings or lines of business inside one company, give each a class and tag transactions as they enter. Every report can then answer per class or for everything at once, without a second set of books.

Budgets

Enter a budget by account and month under Budgets, and the Profit and Loss can show actuals against it, with the difference doing the talking.

Handing the year to your accountant

The quickest handoff is the Year-end package on the company's Tax tab: pick the year, press Download, and one zip holds the trial balance, the general ledger, the working trial balance and adjusting entries from Tax workpapers, the Income Tax summary, the 1099 summary and detail, and every document dated inside the year, each listed in a README that says what it is. It is built from the books as they stand when you press the button, so freeze the year in Tax workpapers first if the figures must not move.

The Trial Balance report's download menu also offers the trial balance in the layouts tax programs import: one for Lacerte, one for UltraTax CS, and a plain sheet to paste into Drake's own template. Each is the columns that program's import asks for, with the amounts as real numbers.

Income Tax is the report an accountant asks for. It has three views of the same year.

Summary totals your books by the line of the tax return each account reports on. Detail lists the transactions behind every one of those lines, grouped under it, with the section total printed where the section ends. Preparation is where an account gets its line.

Pick the company's Tax form once, at the top. Everything below follows from it, and the choice sticks for every future year.

Preparation, and the fast way through it

The view opens on Needs a line - only the accounts that still need a decision, biggest first. Two other chips sit beside it: Assigned, and All accounts if you want the whole chart.

If the form has no balance sheet to file, like Schedule C or Schedule E, the asset and liability accounts are hidden and the screen says how many: they have nowhere to go on that return.

Each row shows what the account carries this period, so the ones that move the return come first and the ones with no activity sit at the bottom. Pick a line and it saves itself, straight away - there is no Save button. A line above the table confirms what was saved and offers Undo.

Suggest lines

Most of this is typing, not judgement: an account called "Insurance:Property Insurance" reports on Insurance and nobody is in doubt about it. Press Suggest lines and kBooks proposes a line for every account it can read confidently.

It weighs three things together:

  • NAME - the words in the account's full path. "Maintenance:Repairs:AC" is a repair because "Repairs" is in it.
  • TYPE - what kind of account it is. A long-term liability belongs on "Mortgages, notes payable in 1 year or more" whatever it is called, which matters most on property books where accounts are named after addresses.
  • USED - what the ledger shows. A fixed asset carrying a credit balance is accumulated depreciation, however it was named.

Nothing is written yet. You get a list of every proposal with the account, what it carries, the line, and a chip for each signal that spoke, so you can see exactly why a line was chosen. Untick anything you disagree with and press Apply. Only the ticked lines are written, and every one can still be changed afterwards.

It stays quiet when the evidence does not agree, and tells you how many it left for you. That is deliberate: a wrong line that gets accepted ends up on a return, so silence is the better answer.

On a rental partnership or S corporation, tick Rentals on Form 8825 beside the Tax form picker. A partnership reports rental income and expenses on Form 8825 rather than in the main Deductions section, and no account name can say which kind of business you are - so you say it once, and every suggestion after that reads the Form 8825 line for the words it knows: repairs, taxes, insurance, utilities, professional fees. Leave it off for a trade or a service business and the general deduction lines are used instead.

It also learns from you. A line you have already chosen for an account named like this one - on this company or any other of yours - is offered again, translated to whatever the current form calls it: what you mapped to Repairs on a Schedule E property comes back as Repairs and maintenance on a partnership. Only your own books teach your books; another customer's chart never does.

More rows on screen

The Expand button at the left of the report toolbar gives the report the whole window, which is worth doing on a long Profit and Loss or a General Ledger. While it is expanded the same button turns solid and reads Exit full page, in the same spot it was before, and Esc brings you back too.

Sharing

Every report prints cleanly and downloads as PDF, Excel or CSV. The numbers in the export are real numbers, so columns still add up in a spreadsheet.