Skip to content

Books reports

Your books' reports are report cards on the Reports page, beside every other card. Put them on any dashboard, next to your sales and pipeline cards, and change their dates with the dashboard's date range.

The Books dashboard

When your books are switched on, BaseCloud makes a Books dashboard on the Reports page: your management accounts, with the cards most owners read.

Card on the dashboard What it is
Key figures Cash in bank, received not yet banked, what customers owe, income, expenses, net profit and sales tax owed.
Profit and loss by month A Profit and loss with a column for each month.
Balance sheet Compared with your last financial year end.
Owed to you Aged receivables as at the end of the dates.
Cash summary Money in and out.
Sales tax Tax by rate, for your return.
Income and expenses The profit and loss as a trend chart.

To open it from Accounting, click Reports at the end of the tab row (Sales, Bank accounts, Journals, Chart of accounts, Reports). It needs Reports Access. If the Books dashboard was deleted, clicking Reports makes it again. It's an ordinary dashboard: move, add or remove cards as you like.

The cards

To add a card yourself: on Reports, add a card, open the Books group and pick a card. The Books group shows only when your books are on and you may see them (View Books, in user rights). A books card on a shared dashboard shows You don't have access to this report. to anyone without View Books.

Card What it shows
Profit and loss Trading income, cost of sales, gross profit, other income, operating expenses and net profit for the date range. Columns by month, quarter or the options of a line field, comparisons, filters by your quote, invoice and line fields, an account filter and a % of income column: see Shape the profit and loss. As a Trend chart, income, expenses and net profit for each week or month; as a Net profit chart, net profit per period.
Balance sheet What the business owns (bank, current and fixed assets), what it owes, and equity, on one day (see Which day an as-at card shows), optionally beside earlier month ends or year ends.
Trial balance Every account's balance on one day, as a debit or a credit, optionally beside earlier month ends or year ends.
Account transactions Every line posted to the accounts you pick (or all of them) in the date range, with opening balances, a running balance and closing balances. Replaces the General ledger card. See The Account transactions card.
Cash summary The money in your bank accounts (and received but not yet banked) at the start of the dates, what came in and went out, grouped by where it came from or went to (customers, other income, costs and expenses, sales tax, assets, loans), and the money at the end. It counts money as it moved, so it reads the same on either basis. It can be compared with earlier periods as the profit and loss is.
Bank reconciliation One bank account's statement balance set against your books. Pick the account in the card's settings. See The bank reconciliation report.
Check your move After a move from Xero, QuickBooks or Sage: your old books set against BaseCloud's on the day before your books start, account by account and customer by customer. It ignores the date range.

Amounts in (brackets) are negative.

Aged receivables, sales tax and key figures

Three cards your books feed are in the Sales & Accounting group, because they work with your books on or off. See the card reference.

  • Aged receivables: what each customer owes, by how long past due (Current, 1–30, 31–60, 61–90 days and Older) or by invoice date. Each invoice counts what it still owes after part payments and credit notes. A Credit not yet used row (overpayments and credit notes not used yet) is taken off Owed on invoices, so each customer's total agrees with their statement. Set it as at today or as at the end of the date range (the Owed to you card on the Books dashboard is as at the end of the dates). With your books on, a note says when Accounts Receivable in your books holds a different amount from the invoices. It reads your invoices, so it needs View Invoices.
  • Sales tax: with your books on, and for someone with View Books, it's your books' full sales tax report, by tax rate and by each rate's parts (state, county, city), with a sales summary for your return, on the basis you pick. See Sales tax and VAT. It can also show the tax by period. Without books, or without View Books, it adds up the tax on your invoices instead.
  • Key figures: pick any of cash in bank, money Received, not yet banked (in Undeposited Funds), income, expenses, net profit and sales tax owed, beside invoice figures such as what's outstanding and overdue. The books figures show only while your books are on and to someone with View Books.

Which day an as-at card shows

Balance sheet, Trial balance, Bank reconciliation, and Aged receivables set as at the end of the date range, show one day: the last day of the date range, or today when that day is still to come. So on This Month they show today, not the end of the month. The line under the card's name says which day.

A date range that ends before your books' start date shows nothing, and the card says why.

Cash or accrual

Each card's settings have a Basis: The books' setting (the basis chosen in Settings › Books), Accrual (when invoiced) or Cash (when paid). Anyone looking at a card can also switch it between Accrual and Cash, and pick a comparison on a profit and loss or balance sheet, just for themselves: their switch changes only what they see. To change it for everyone, change the card's settings.

  • Accrual (when invoiced): a sale counts on the invoice date, paid or not. This is how the books post.
  • Cash (when paid): a sale counts when it's paid, in proportion. An invoice for $1,100 ($1,000 plus $100 tax) that is half paid in April shows $500 of the sale and $50 of the tax in April; the rest counts when the rest is paid. Money a customer paid earlier, before there was an invoice, counts on the day it's applied to the invoice, so a month you've already reported never changes afterwards. A credit note's credit isn't money moving, so it doesn't count. This is also the payments basis for sales tax and VAT.

Money that's already money (payments, bank transactions, manual journals, opening balances) counts on its own date on either basis, except a manual journal with Show on cash-basis reports unticked (an accrual, say), which the cash basis leaves out, with its reversal. The Account transactions card is always as posted.

Invoices that were open when your books started

An invoice dated before your start date is part of your opening balances. On the cash basis, when it's paid on or after your start date, the money counts as income and sales tax in the period it came in, as it would have in your old system: BaseCloud spreads the payment over the invoice's own lines and tax. The other side is Retained Earnings, where your earlier years' profit already held that sale on the accrual basis. Money paid on it before the start date was in your old system and doesn't count again.

Credit used across the start date works the same way: a credit note made after the start date and used on an invoice from before it takes that invoice's balance out of what customers owe on the cash basis, and the other way round.

The accrual basis doesn't change: those sales were earned before your books started.

Shape the profit and loss

A Profit and loss card's settings shape it the way you'd shape one in Xero or QuickBooks.

Setting What it does
Columns One total (the default); a column for each month; a column for each quarter, quarters of your financial year (with a June year end, July to September comes first); or a column for each option of a line field you pick (a single-choice field such as a department, a location or a job type), in the order of its options, with a No value column for everything else and a Total. No value holds every line with no option, bank transactions and journals too, so the columns always add up to the total. Month, quarter and option columns show up to 24 side by side.
Compare with Nothing, The same days in earlier months, The same days in earlier quarters, The same days in earlier years or The days just before, and how many, 1 to 12. Each comparison is a column of its own. See Compare with earlier periods. Comparisons aren't shown with month, quarter or option columns.
Show the change With a comparison: a Change and Change % column beside the dates' own, against the first earlier column. Income going up and costs going down show in green, the other way in red.
Show the average With two or more earlier columns: an Average of them, after them. Handy for "is this month above our usual?"
Accounts Show only the accounts you pick, or whole kinds of account (income, cost of sales, expenses, depreciation and so on). Leave it empty to show every account. The totals are of the accounts shown, so gross and net profit add up what's on the card, and a note under it says so.
% of income Adds a % of income column beside each amount column: each line as a share of your income for that column, to one decimal place. It's always a share of all your income, even when the card shows only some accounts. Blank when there was no income.
Hide lines with nothing on them On unless you turn it off: accounts with nothing in any column are left out, and so are option columns with nothing in them.
Basis The books' setting, Accrual (when invoiced) or Cash (when paid). See Cash or accrual.
Filter Narrow the report by any of your quote and invoice fields or line fields, a line's item code, or words in a line's description: see Filter a books report. With a column for each option, every column is narrowed the same way.

The Trend chart and Net profit chart follow the basis, the filters and the accounts you pick too.

Click an amount in an option's column to open the lines behind it: Account transactions, with the card's filters and that option (or No value) already set.

Filter a books report

The Profit and loss, Account transactions and Sales tax cards can be filtered by your fields, like any other card (see Filter a card):

  • A line field, such as a department or a job type: only the lines that hold it.
  • A quote or invoice field, such as a purchase order number: only the lines of the documents that hold it.
  • Item code or Line description: only the lines with that code, or with those words in their description.

Every journal line of an invoice or credit note reads its fields from the invoice line it came from, so a field you change on an invoice, even a paid one, shows in the reports straight away. Bank transactions and journals have no fields: a filter for a value leaves them out (a filtered profit and loss shows your income only), while Leave out and (No value) keep them. Balances on a filtered Account transactions card are of the filtered lines. The Balance sheet, Trial balance and Cash summary aren't filtered: they are the whole books.

Compare with earlier periods

A Profit and loss or Cash summary compares the card's dates with earlier ones, each in a column of its own:

  • The same days in earlier months: November 1 to 15 beside October 1 to 15, September 1 to 15 and so on. This is the one for a Month to date dashboard: halfway through the month you see the same half of each month before. A whole month is compared with whole months (November with October, all 31 days of it).
  • The same days in earlier quarters: Quarter to date, October 1 to November 15, beside July 1 to August 15, April 1 to May 15 and so on.
  • The same days in earlier years: November 1 to 15, 2026 beside November 1 to 15, 2025.
  • The days just before: March is compared with February (whole months with whole months), a quarter with the quarter before, any other range with the same number of days just before it. Use it for a rolling range such as Last 30 days.

Where a month is shorter, the day moves to its last: March 30 compared with the month before is February 28. Each earlier column is worked out from the card's own dates, so the 30th stays the 30th in January.

Turn on Show the change for a Change and Change % column right after the dates' own, against the first earlier column, and Show the average for the Average of the earlier columns. Neither opens anything when you click it: click an amount in a dated column to see the entries behind it.

Compare the balance sheet and trial balance

A Balance sheet or Trial balance is a single day, so it compares with earlier days:

  • The same day in earlier months: as at November 15, beside October 15, September 15 and so on (a month's last day stays a month's last day).
  • Previous month ends: as at November 11, beside October 31, September 30 and so on.
  • Previous financial year ends: beside the end of each earlier financial year (with a December year end, as at November 11, 2026: December 31, 2025, December 31, 2024 and so on; with a February year end, as many South African businesses have, the end of each earlier February).

Pick how many, 1 to 12. On a trial balance each day gets its own debit and credit columns. Hide lines with nothing on them works as on the profit and loss.

Show the change and Show the average work as on the profit and loss, without the colours: more money owed to you isn't plainly good or bad. On a trial balance, the Change is a debit and credit of its own: how far each balance moved since the first earlier day, on the side it moved to. A trial balance has no average.

The Account transactions card

The Account transactions card lists what posted to your accounts in the date range, for your accountant or for checking an account line by line. It replaces the General ledger card: a General ledger card you had was moved to it, showing the same account (or every account).

Setting What it does
Accounts One account, several, or none for every account.
Client Only the lines for one client (a customer's invoices, credit notes and payments). Balances are then of those lines only.
Filter Only the lines that match the card's filters (your quote, invoice and line fields, item codes, line descriptions). Balances are then of those lines only. See Filter a books report.

For each account, in the order of your chart of accounts, it shows the Opening balance, each line (date, journal number, where it came from, description, customer, debit, credit and a running balance), and the Closing balance, with a Total of debits and credits at the end. Show it as a Report, or as a Table of the lines alone.

Long lists come in pages of up to 500 lines, with a note such as Lines 1–500 of 2,340; there's no limit to how many lines it can go through. Download as CSV from the card's menu gives every line that matches, in one file, not just the page you're on. Click a line to open its journal.

It's always as posted (the accrual basis). To see one account on the cash basis, open the account itself: see Account transactions below.

Financial year dates

While your books are on, the Reports page's date range also offers This Financial Year, Last Financial Year and Financial Year to Date, worked out from your financial year end, as well as Month to Date, Quarter to Date and Year to Date.

Trial balance

The Trial balance card shows every account's balance on one day, as a debit or a credit. Total debits always equal total credits. What each balance covers:

  • Balance-sheet accounts (assets, liabilities and equity) show everything since the beginning: your opening balances plus everything posted since.
  • Income and expense accounts show the current financial year only, from the day after your financial year end up to that day.
  • Earlier years' profit is added into Retained Earnings. You don't post a closing entry at year end; the report works it out. The balance sheet does the same, and shows this year's profit as Current year earnings. An account's own page (click it) follows the same rule, so it agrees with the trial balance. See Year end.

For example, with a December 31 year end, a trial balance as at March 31, 2027 shows Service Revenue for January 1 to March 31, 2027. Everything you earned in 2026 is in Retained Earnings.

If debits and credits ever differ, the card says so under the report. That shouldn't happen. Contact BaseCloud support if you see it.

The bank reconciliation report

The Bank reconciliation card proves a bank account in your books against its statement, the way an accountant asks for at month end and year end. For the account you pick, on one day, it shows:

  1. Balance on the bank statement.
  2. Less: on the statement, not yet in your books: each statement line you haven't reconciled yet.
  3. Less: on the statement, marked as needing nothing: lines you ignored, when there are any.
  4. Plus: in your books, not on the statement: payments and other entries in your books that the bank hasn't shown yet (a deposit made on the last day, a check not yet cashed).
  5. Balance your books should show, then Balance your books show.
  6. Difference to look into: zero when everything is accounted for.

Notes under it explain a difference: usually a deposit dated a day or two after the bank line it was matched to; lines missing or brought in twice, when the balance your bank gave doesn't match the lines; or a different balance when your books started, which you can fix from the bank account's page. Each list shows up to 500 items; the totals include them all. See Bank reconciliation.

From a books card's menu:

  • Print or save as PDF prints the report as an accountant would lay it out: your business name, the report, its dates, its basis, the currency and when it was made at the top, the notes underneath. Choose Save as PDF in your browser's print box to make a PDF to send.
  • Download as CSV gives the same heading lines, a blank line, then the report. Amounts are plain numbers so a spreadsheet can add them up.
  • Download every line (on an Account transactions card): the card shows its lines a page at a time; this downloads every line for its accounts, client and filters, for the dates.

See what's behind a figure

Click an account's name or amount on a books card to open that account's transactions in Accounting, on the dates the figure covers and on the card's basis. On a cash-basis card it opens the account on the Cash basis, so its lines add up to the figure you clicked. Back to the report, above the page's title, takes you back to the dashboard.

  • On Sales tax, click a tax rate (or No tax rate) to list the lines behind it.
  • On Aged receivables, click a customer to open their invoices. This needs View Invoices; without it, the customer's name isn't a link.
  • On an Account transactions card, click a line to open its journal.

If you only see some clients (your own, or your team's through Client Filter Rules), the books name only the clients you can see on the Clients page. Aged receivables adds everyone else's balance up on one Other clients row, so the totals are still the account's, and a line for a client you can't see says Another client: on a card, in an account's transactions, in a journal and in a download.

Account transactions

This is an account's own page, not the card. Click any account, on a books card or in the chart of accounts, to see what posted to it between two dates (From and To). With no dates picked, it shows this financial year to today. Basis picks Accrual basis (the default, as the books post) or Cash basis. You get:

  • the opening balance on the From date,
  • each line: date, journal number, its Source (an invoice or credit note by its number, a payment, a manual journal, opening balances), the customer, a description, and the debit or credit,
  • a running balance after each line, and the closing balance on the To date.

On the accrual basis, Search finds lines by words or a journal number, long lists come in pages, and Download CSV downloads every line for the dates.

Balances are debits less credits. An amount in (brackets) is a credit balance, as accountants write it: income, what you owe, and your equity normally show in brackets.

An income or expense account starts each financial year at zero, as on the trial balance; Retained Earnings carries the earlier years' profit.

On the Cash basis, an invoice or credit note counts on the days its money was paid or applied, as on a cash-basis report card. Those lines have no journal number of their own (the Journal column shows a dash); click the Source to open the invoice or credit note. When the dates hold more lines than one page, a note says so: pick a shorter range.

Click a journal number to open the whole journal. Click the Source to open what it came from: an invoice, credit note or payment opens its client's Accounting tab, if you have View Invoices; a bank transaction opens its bank account.

Journals

Accounting › Journals lists every journal, newest first, with its number, date, source, description and total. Filter by From, To and Source (invoices, credit notes, payments, bank transactions, manual journals, opening balances, opening balance changes), or type words or a journal number in Search. Older journals load as you scroll.

Opening balance changes are the small journals that move a customer's opening Accounts Receivable when an invoice, credit note or payment dated before your start date is added, changed, voided or paid. See Opening balances.

A journal marked Reversal cancels an earlier one; one marked Reversed has been cancelled by a later one. See How invoices post.

Open a journal to see its lines (account, description, contact, debit, credit), a link to what it came from, and links to the journal it reverses or that reverses it. Opened from an account, the path above its title leads back to that account on the same dates. A manual journal has Copy and Reverse buttons. See Manual journals.

What the books' reports don't do yet

  • No budgets to compare with, and no cash-flow statement in the accountant's form (the Cash summary shows money in and out).
  • One currency. Your books are kept in one currency; money received in another currency isn't in them.
  • No bills, so no aged payables report. Accounts Payable holds only what you type in or post by hand.

See What Books does today, and what it doesn't yet.