Understanding the Trial Balance in Simple Books

Introduction

A Trial Balance brings every active account balance into one report, placing debit balances in one column and credit balances in another. In Simple Books, it is a journal-based accounting report: it reads the postings created from saved invoices, bills, expenses and mileage claims rather than adding up the cards or statuses on operational pages.

This guide explains the Trial Balance exactly as it is currently implemented, including how account balances and report totals are calculated, how to trace them through the General Ledger, and which present limitations can make a balanced report incomplete or unsuitable as evidence that every record is correct. It is general product guidance, not accounting or tax advice.

What is a Trial Balance?

A Trial Balance is a list of ledger accounts and their closing debit or credit balances. Its main arithmetic check is that the total of the debit-balance column equals the total of the credit-balance column.

The Simple Books report displays Account Code, Account Name, Debit and Credit. Above the table it shows Total Debits, Total Credits, their absolute Difference, and a status. When the difference is zero, the status is Balanced. With no journals, the page says No data rather than presenting an empty report as a meaningful balanced result.

A balanced Trial Balance is an arithmetic check, not proof that the bookkeeping is correct. Equal totals cannot confirm that a transaction has the right date, amount, account, category, VAT treatment or business purpose. For the principles behind the postings, read What is double-entry bookkeeping?.

Why businesses use a Trial Balance

A Trial Balance gives a compact view of the closing balances produced by the ledger. It can help a business:

check that debit and credit closing balances agree overall;
review which accounts have journal activity;
spot an unexpected debit or credit balance before relying on other reports;
open the detailed General Ledger for an account that needs investigation; and
understand the account totals that feed Profit & Loss and the Balance Sheet.

It is not a list of outstanding operational tasks. Paid, Unpaid, Draft, Submitted and Approved statuses can affect workflow pages without changing the journals used by this report.

How Simple Books creates the Trial Balance

Simple Books first creates or replaces a separate journal when an invoice, bill, expense or mileage claim is saved or updated. Each journal has a date, source type, source identifier, description and at least two account lines. Every line contains one account code and a non-zero debit or credit amount. The journal validator requires recognised account codes, finite non-negative values with no more than two decimal places, and exactly equal total debits and credits.

The Trial Balance loads the authenticated user’s saved journal documents. It validates every loaded journal before calculating anything. It then visits every journal line and, for each account code, accumulates two values:

Account debits = all debit postings to that account added together.
Account credits = all credit postings to that account added together.
Account balance = accumulated debits minus accumulated credits.

If the account balance is positive, its absolute amount appears in the Debit column. If it is negative, the absolute amount appears in the Credit column. A zero closing balance appears in neither money column, although the account can remain listed because it had journal activity. Rows are ordered by account code.

Finally, Simple Books adds the displayed debit closing balances to produce Total Debits and adds the displayed credit closing balances to produce Total Credits. Difference is the absolute value of Total Debits minus Total Credits. Values are rounded to two decimal places during journal creation and accumulation and displayed as GBP.

How source records generate ledger entries

The Trial Balance is generated from General Ledger postings, not directly from invoice, bill, expense or mileage collections. The current source-to-journal rules are:

Sales invoice: debit 1100 Trade Receivables for the gross total, credit 4000 Sales Revenue for the net amount, and credit 2100 VAT Output when VAT is greater than zero. An invoice with active line items can create separate Sales Revenue lines, but they all use account 4000.
Supplier bill: debit the category-mapped expense account for the net amount, debit 1200 VAT Input when VAT is greater than zero, and credit 2000 Trade Payables for the gross total.
Business expense: debit the category-mapped expense account for the net amount, debit 1200 VAT Input when VAT is greater than zero, and credit 2200 Employee Reimbursements Payable for the gross amount.
Mileage claim: debit 5200 Travel & Mileage and credit 2200 Employee Reimbursements Payable for the claim amount. The amount must agree with miles multiplied by the rate when both are supplied. The current mileage journal has no VAT line.

Supported bill and expense categories map to Travel & Mileage, Utilities, Professional Fees, or Software & Subscriptions. An unmatched category falls back to General Expenses. Editing and saving a source replaces its deterministic linked journal with values based on the update.

Accounts included in the report

The current chart of accounts contains:

Assets: 1000 Bank, 1100 Trade Receivables and 1200 VAT Input.
Liabilities: 2000 Trade Payables, 2100 VAT Output and 2200 Employee Reimbursements Payable.
Equity: 3000 Owner’s Equity.
Income: 4000 Sales Revenue.
Expenses: 5000 General Expenses, 5200 Travel & Mileage, 5300 Utilities, 5400 Professional Fees and 5500 Software & Subscriptions.

The Trial Balance lists only accounts encountered in the loaded journal lines; it does not print every unused chart account with £0.00. The invoice, bill, expense and mileage builders do not currently post to Bank or directly to Owner’s Equity, so those accounts will not appear unless a stored journal from another implemented posting path contains activity. The current product has no user-facing manual-journal workflow.

Debit and credit balances explained

Debit does not simply mean money leaving the business, and credit does not simply mean money arriving. They are the two sides of an account. Under the current postings, assets and expenses commonly build debit balances, while liabilities, equity and income commonly build credit balances.

For example, saving a £120 invoice can give Trade Receivables a £120 debit balance, while its £100 net value gives Sales Revenue a £100 credit balance and its £20 VAT gives VAT Output a £20 credit balance. If an account received both debits and credits, the Trial Balance shows only the net closing side: £500 of debits and £125 of credits becomes a £375 debit balance.

This netting is why Total Debits and Total Credits are totals of closing account balances, not totals of every debit and every credit line posted during the period.

Why the Trial Balance should balance

Every valid journal contributes the same amount to debit postings as it contributes to credit postings. When all account balances are netted and separated into debit and credit columns, those equal journal sides should still produce equal closing-balance totals.

Simple Books also validates each journal before aggregation. A journal must contain at least two valid non-zero lines, no line can contain both a debit and a credit, and the journal’s total debits must equal its total credits. This makes an out-of-balance result unlikely for journals created by the current builders.

Balance is necessary but not sufficient. A £100 debit to the wrong expense account and a £100 credit to a payable still balance. A duplicated journal can balance. A missing journal leaves both sides out and can also leave the remaining Trial Balance balanced.

Common reasons a Trial Balance does not balance

Under the current implementation, malformed or unbalanced stored journal data is rejected before a Trial Balance is shown. The page displays Unable to calculate and does not display partial account totals. A journal can fail validation because it has an unknown account code, a missing date, fewer than two lines, a zero-only line, negative or non-finite values, more than two decimal places, both a debit and credit on one line, or unequal journal totals.

The report view supports an Out of balance status if calculated closing totals differ, but the normal calculation validates journals first. Therefore, seeing an error is the more likely current result of invalid stored journal data; seeing Out of balance would indicate an unexpected inconsistency in the calculated report data and should be investigated.

Other problems can make the report wrong or incomplete without making its two columns unequal:

a source record was saved but its ledger posting failed, leaving no journal in the report;
the same business event was recorded more than once, creating multiple balanced journals;
a valid journal used the wrong date, value, VAT treatment or expense category; or
a source was deleted while its existing journal remained, because current delete workflows do not post a reversal or remove that journal.

Relationship to the General Ledger

The General Ledger and Trial Balance use the same saved journals and the same account rules. The Trial Balance summarises each account’s net closing balance. The General Ledger expands one account into its individual journal postings, ordered by date, and calculates a running balance by adding debits and subtracting credits.

Each Trial Balance account code is a link to that account in the General Ledger. Use it to explain a balance: for example, open 1100 Trade Receivables to see the invoice debits behind the closing amount. The General Ledger has optional inclusive Date From and Date To filters; the current Trial Balance has no date filter and uses all journals loaded for the user. A filtered General Ledger closing balance may therefore differ from the unfiltered Trial Balance row.

Relationship to the Profit & Loss Statement

The Profit & Loss Statement builds account totals from journals for its optional date range and selects only Income and Expense accounts. It calculates income as credits minus debits, expenses as debits minus credits, and net profit or loss as total income minus total expenses.

In the Trial Balance, Sales Revenue normally appears as a credit balance and expense accounts normally appear as debit balances. Profit & Loss turns those balances into its income and expense rows. Trade Receivables, Trade Payables, Employee Reimbursements Payable, VAT Input and VAT Output are excluded from Profit & Loss because they are asset or liability accounts.

The current Profit & Loss page can be date-filtered, while the Trial Balance cannot. Compare them only when the underlying journal scope is equivalent.

Relationship to the Balance Sheet

The Balance Sheet also starts from the journals and can include them up to an optional inclusive As at date. It presents asset balances on a debit-oriented basis and liability and equity balances on a credit-oriented basis.

Income and expense Trial Balance accounts are not printed directly on the Balance Sheet. Simple Books calculates their Profit & Loss result for the same set of journals and adds that result to displayed equity as Current Year Profit or Current Year Loss. The Balance Sheet then checks whether total assets equal total liabilities plus total equity.

Because its As at filter can restrict the journal set, a dated Balance Sheet need not match an unfiltered Trial Balance account-for-account.

Worked examples

Invoice and supplier bill

A consultant saves a £120 sales invoice made up of £100 net and £20 VAT. Simple Books debits Trade Receivables £120, credits Sales Revenue £100 and credits VAT Output £20. The consultant also saves a £60 Utilities bill made up of £50 net and £10 VAT. That journal debits Utilities £50, debits VAT Input £10 and credits Trade Payables £60.

The Trial Balance now shows debit balances of £120 Trade Receivables, £10 VAT Input and £50 Utilities: Total Debits £180. It shows credit balances of £60 Trade Payables, £20 VAT Output and £100 Sales Revenue: Total Credits £180. Difference is £0.00 and the report is Balanced.

Expense and mileage accumulated in one payable

The business records a £30 expense made up of £25 net General Expenses and £5 VAT, then records 10 business miles at £0.55, a £5.50 claim. The expense debits General Expenses £25 and VAT Input £5 and credits Employee Reimbursements Payable £30. Mileage debits Travel & Mileage £5.50 and credits the same payable £5.50.

The Trial Balance accumulates the two credits to 2200 Employee Reimbursements Payable and shows one £35.50 credit balance. It does not create separate reimbursement accounts for the two records.

Opposing postings net within an account

If an account has £500 of debit postings and £125 of credit postings across valid journals, its closing balance is £375 debit. The Trial Balance shows £375 in that account’s Debit column, not £500 debit and £125 credit. The General Ledger remains the place to see both sides and the running balance.

Current implementation limitations

No Trial Balance date filter: the report uses all journals loaded for the authenticated user. Profit & Loss, the General Ledger and the Balance Sheet have their own date controls.
Status does not post settlement: marking an invoice, bill or expense Paid changes operational status only. It does not post Bank or clear Trade Receivables, Trade Payables or Employee Reimbursements Payable.
Bank and Owner’s Equity are not used by the four current source builders: the chart contains them, but saving invoices, bills, expenses and mileage does not post to them.
No manual journals: there is no current user-facing workflow for posting a manual journal or an opening balance.
Deletion does not reverse: deleting an invoice, bill, expense or mileage source does not currently create a reversal or delete its existing journal, so the accounting reports can retain that posting.
Ledger writes can fail after a source is saved: the operational record can remain while its journal is absent, leaving reports incomplete even though the displayed Trial Balance balances.
No partial result on invalid data: one malformed loaded journal makes the Trial Balance unavailable rather than being silently omitted.
Only active accounts are shown: unused chart accounts are not listed with zero balances.

Common mistakes

Assuming balanced means correct. Review dates, values, accounts, categories and VAT treatment as well as the two totals.
Reading debit as money out and credit as money in. The meaning depends on the account type and transaction.
Adding journal movements instead of closing balances. The report nets debits and credits within each account before totalling its two columns.
Expecting every chart account to appear. Only accounts encountered in loaded journal lines are listed.
Comparing a dated report with the unfiltered Trial Balance. Align the journal scope before investigating a difference.
Expecting Paid status to clear a balance. Current status actions do not create settlement journals.
Deleting a source to correct the ledger. Current deletion does not reverse or remove the existing journal.
Ignoring a posting warning. A saved source without its journal will not appear in the Trial Balance.
Recording the same cost as both a bill and an expense. Both records can create their own balanced journal and duplicate the accounting effect.

Summary

The Simple Books Trial Balance is a summary of General Ledger postings. It validates every loaded journal, accumulates debits and credits by account, calculates each balance as debits minus credits, places the net balance in one column, and totals the debit and credit closing balances. Equal totals are expected because every accepted journal is balanced.

Use the linked General Ledger to investigate the postings behind a balance, Profit & Loss to review income and expenses for a chosen period, and the Balance Sheet to review assets, liabilities and equity as at a date. Remember the present boundaries: the Trial Balance has no date filter, status actions do not post payments, current source deletion does not reverse journals, and a missing but balanced-out ledger posting can leave the report incomplete without creating a difference.