Skip to content

Trial balance

Who can do this

View Books to see it. Post Journals to import a trial balance or start a journal.

The trial balance lists every account's balance on one day, debits beside credits. The two totals are always the same: it's the first thing an accountant checks, and where they make their adjustments. Open it from Accounting › Trial balance, next to Chart of accounts.

What you see

Accounts are grouped the way the chart of accounts groups them (assets, liabilities, equity, revenue, expenses), each group with its own totals, then the grand total. Across the top:

  • As at: the day. It starts on today, in your business's time zone (Settings › General).
  • Basis: Accrual or Cash. It starts on your books' own basis (Settings › Books).
  • Hide zero balances: ticked to start with, so you see only accounts with something in them. Untick it to see every open account. BaseCloud remembers your choice in this browser.

An account you've archived still shows when it has a balance on the day, marked Archived.

What each balance covers:

  • Balance-sheet accounts (assets, liabilities and equity) show everything since your books started: your opening balances plus everything posted since.
  • Income and expense accounts show the financial year the day falls in, from the day after your financial year end up to the day you picked.
  • Earlier years' profit is in Retained Earnings. You don't post a closing entry at year end. See Year end.

Click an account to see its entries, from the start of the financial year up to that day, on the same basis. They add up to the balance you clicked. Back brings you to the trial balance on the same day.

If debits and credits ever differ, a warning above the table says by how much. That shouldn't happen: check your opening balances and recent journals, or contact BaseCloud support.

On a day before your books start there's nothing to show. The day before they start is your opening balances.

Import a trial balance

Your accountant's trial balance, or your old system's, comes in the same way it does when you start your books: click Import a trial balance, then Paste a trial balance (copied from a spreadsheet) or Choose a CSV file. Each row is matched to an account by its code, then by its name.

What happens next depends on the day in As at:

  • The day before your books start: that's your opening balances. Click Change opening balances: Settings › Books opens with the amounts filled in, and you check them and save. See Opening balances.
  • Any later day: BaseCloud sets your trial balance against your books on that day and lists every account that differs. Click Open the adjusting journal: a new manual journal opens, dated that day, with a line for each difference. Check it, add or change lines if you like, and post it. Nothing changes until you do. After posting, Back brings you to the trial balance, so you can see that it now agrees.

A few things to know about the comparison:

  • An account your trial balance doesn't list is taken to have no balance on that day, as a trial balance lists every account with one. So every row has to match an account in your chart: add any account that's missing, or take the row out, then import again.
  • Accounts Receivable only changes through invoices, credit notes and payments, and an archived account must be restored first, so a difference on either is listed apart, with why, and left out of the journal.
  • A bank account or credit card is listed apart too, with Reconcile the bank account instead. Its difference is nearly always statement lines you haven't reconciled yet: a journal for it would count that money a second time once you do. Reconcile the account to the same day, then import again.
  • If your trial balance's debits and credits don't agree, or an account above takes part of the difference, the journal is out of balance by that much, and the screen says so. Add a line for it before you post.
  • The day must be after your lock date.
  • The comparison is on the accrual basis, as a trial balance from an accountant or another system is. On the Cash basis, Import a trial balance isn't offered and the page says so: switch Basis to Accrual to import.
  • If nothing differs, it says your books agree.

The Trial balance report card on the Reports page imports the same way, on the card's day. See Books reports.

Start a journal

New journal opens a new manual journal for any other adjustment. After you post it, Back brings you to the trial balance.

Download and print

Download CSV saves the trial balance as shown (the day, the basis, and the accounts Hide zero balances leaves in) with plain numbers a spreadsheet can add up. Print prints it, or saves it as a PDF from the print window, headed with your business, the day, the basis and the currency.

The trial balance on the Reports page

The Trial balance report card shows the same figures on a dashboard, and can set a day beside earlier month ends or year ends. See Books reports. This page is where you work on the trial balance; the card is for watching it.