The reports, and which to use when
Seventeen of them. Each says whether it reads the journal or the documents, because the two answer different questions.
On this page
Every report says, under its title, whether it is built from the posted journal or from the documents entered. That distinction is the thing to understand.
The journal is what the books say. Only documents that post to the ledger appear in it. This is what an accountant means by your accounts.
The documents are everything you have entered, including things you deliberately kept off the books. This is what you mean when you ask what a job cost.
They differ, legitimately. Reports say which one they used rather than hoping you assume.
Financial — from the journal
| Report | Answers |
|---|---|
| Profit & loss | Income less expenses over a period, by account |
| Balance sheet | What the project owns and owes on one date |
| Trial balance | Every account with its debits and credits — the health check |
| General ledger | Every posting, account by account, with a running balance |
Receivables and payables
| Report | Answers |
|---|---|
| Who owes you | Outstanding invoices by customer, bucketed by how late |
| What you owe | The same for bills |
| Customer statement | Everything invoiced and paid for one contact, with a running balance — and it can be emailed |
| 1099 totals | Paid to each subcontractor in the period, for year-end |
Project
| Report | Answers |
|---|---|
| Project profitability | Billed against cost, with the budget beside it |
| Spend by category | Where the money went, biggest first |
| Spend by supplier | What each vendor or sub has cost |
| Budget vs actual | Each budgeted account against what it spent |
| Cost by event | What each pour, shift or show night cost against its budget |
| Time worked | Hours by person, billable and not, billed and not |
| Income and cost by class | Phases or cost codes side by side |
| Money in and out | Month by month cash movement |
| Everything outstanding | Every unsettled document in both directions |
Every report can
- be run over any date range, with one-click presets
- be exported as CSV — with real numbers, not formatted text, so a spreadsheet can total them
- be printed on a clean layout with the navigation stripped out
- be saved with its filters, so the one you always look at is one click
The two that check the others
Trial balance should always say Balanced. If it does not, something is wrong and every other report is suspect.
Settings → Check the books re-derives every document balance from its payments and proves the journal balances to the cent. It should always find nothing — which is exactly why being able to run it yourself is worth something.
Still stuck? Contact support and we'll get back to you as soon as possible.
