Understanding the Balance Sheet in Simple Books

Introduction

The Balance Sheet in Simple Books summarises Asset, Liability and Equity account balances from accounting journals, then includes the Profit & Loss result in displayed equity. Unlike Profit & Loss, which measures performance over a selected period, the Balance Sheet is cumulative up to an optional As at date.

This guide documents the current implementation only: the available accounts, balance orientations, current-year result, accounting equation, date behaviour, report links and present limitations. For the journal postings behind each source, use the double-entry bookkeeping guide rather than repeating every journal rule here. This is general product guidance, not accounting or tax advice.

What a Balance Sheet is

A Balance Sheet is a statement of financial position. It organises balances into Assets, Liabilities and Equity and checks whether the accounting equation holds:

Assets = Liabilities + Equity.

The current Simple Books page shows summary cards for Total Assets, Total Liabilities, Total Equity and Status. The statement then lists non-zero account balances under Assets, Liabilities and Equity, shows Current Year Profit or Current Year Loss, and compares Total Assets with Total Liabilities and Equity.

When the rounded difference is zero, the status is Balanced. With no journals on or before the reporting date, the page shows No data rather than treating an empty statement as meaningful.

Why businesses use a Balance Sheet

The Balance Sheet provides a compact view of the journal-based financial position. In the current report, it can help a business:

review amounts due from customers and owed to suppliers or claimants;
see VAT Input and VAT Output balances separately;
review any posted Bank or Owner’s Equity balance;
see how the current Profit & Loss result affects total equity;
check Assets against Liabilities plus Equity; and
open the General Ledger for the postings behind an account balance.

A balanced statement does not prove that all transactions, dates, amounts, categories or VAT treatments are correct. It shows the result of the journals that successfully exist.

How Simple Books calculates the Balance Sheet

Simple Books loads the authenticated user’s journal documents, validates the complete loaded set, applies the optional As at date, and builds Trial Balance-style debit and credit totals for every account in the remaining journals.

It selects accounts by their current chart type and applies these formulas:

Asset amount = account debits − account credits.
Liability amount = account credits − account debits.
Equity account amount = account credits − account debits.
Total Assets = sum of displayed Asset account amounts.
Total Liabilities = sum of displayed Liability account amounts.
Total Equity = displayed Equity account amounts + Current Year Profit or Loss.
Difference = Total Assets − Total Liabilities and Equity.

Rows with a zero calculated amount are omitted and the remaining rows are ordered by account code. Positive values display in GBP. An abnormal negative account amount is shown in accounting parentheses. Income and Expense accounts are not listed directly; they feed the current-year result described below.

Asset accounts currently included

The current chart contains three Asset accounts:

1000 Bank: intended for money held by the business. The current invoice, bill, expense and mileage journal builders do not post to Bank, so Paid status does not create or change this balance.
1100 Trade Receivables: invoices debit this account for their gross total, representing the amount recorded as due from customers.
1200 VAT Input: bills and ordinary expenses debit this account for VAT greater than zero. Mileage journals have no VAT line.

Assets are debit-oriented in this report: debits minus credits. An account appears only when the filtered journals produce a non-zero amount. Bank therefore remains absent unless a valid stored journal posts to it; there is currently no user-facing Bank transaction or manual-journal workflow that creates such a posting.

Liability accounts currently included

The current Liability accounts are:

2000 Trade Payables: supplier bill journals credit the gross bill total.
2100 VAT Output: sales invoice journals credit VAT greater than zero.
2200 Employee Reimbursements Payable: ordinary expenses credit their gross amount and mileage claims credit their full claim amount.

Liabilities are credit-oriented: credits minus debits. Under the current workflows, marking an invoice, bill or expense Paid changes operational status only. It does not post Bank or add a clearing debit to Trade Payables or Employee Reimbursements Payable, and it does not add a clearing credit to Trade Receivables.

Equity accounts currently included

The current chart contains one Equity account: 3000 Owner’s Equity. Its statement amount is credits minus debits, the same orientation used for Liabilities.

The current invoice, bill, expense and mileage builders do not post directly to Owner’s Equity. The report can display the account when a valid loaded journal contains a non-zero posting, but the current product has no user-facing manual-journal, capital-introduction or opening-balance workflow to create one.

Current Year Profit or Loss is shown as a separate line in the Equity section. It is not stored as a journal posting to account 3000 and is not included in the Equity account row itself.

Current Year Profit or Loss calculation

For the same journals included by the Balance Sheet As at date, Simple Books runs the Profit & Loss calculation. It selects Income and Expense accounts, calculates Total Income and Total Expenses, and applies:

Current Year Profit or Loss = Total Income − Total Expenses.

A positive result is labelled Current Year Profit. A negative result is labelled Current Year Loss and displayed as an absolute amount, while its negative numeric value reduces Total Equity. A zero result is labelled Current Year Profit in the Balance Sheet view.

The Current Year Profit or Loss label links directly to the Profit & Loss report page. That page does not automatically inherit the Balance Sheet As at date, so enter a matching Date To and leave Date From blank when you want to reconcile the same cumulative journal set.

The accounting equation

After calculating its rows and current-year result, Simple Books totals:

Total Equity = direct Equity account total + current-year result.
Total Liabilities and Equity = Total Liabilities + Total Equity.
Difference = Total Assets − Total Liabilities and Equity.

If Difference rounds to £0.00, the report status is Balanced and says Assets equal liabilities plus equity. Otherwise, it reports Out of balance.

Balanced does not mean complete or correct. An omitted journal removes equal debits and credits, a duplicated balanced journal adds equal sides, and a posting to the wrong recognised accounts can still leave the equation intact.

Relationship to the Trial Balance

The Trial Balance calculation is the Balance Sheet’s starting point. Simple Books accumulates every debit and credit by account from the As at journal set. The Balance Sheet then selects Asset, Liability and Equity account types and changes the presentation orientation by type.

For an Asset, the Balance Sheet amount is the Trial Balance-style debits-minus-credits balance. For a Liability or Equity account, it reverses that sign to credits minus debits so an ordinary credit balance displays positively. Income and Expense balances are brought together through Current Year Profit or Loss rather than shown as statement rows.

The current Trial Balance has no date filter. A dated Balance Sheet can therefore use fewer journals, so compare the two only when the underlying journal scope is equivalent.

Relationship to the General Ledger

The General Ledger shows the individual journal lines behind one account. Every displayed Asset, Liability and direct Equity account on the Balance Sheet is an account-code link to the General Ledger, using a query such as ?account=1100.

Use that link to investigate the dates, references, descriptions, debits, credits and running balance behind a Balance Sheet row. To compare with a dated Balance Sheet, leave General Ledger Date From blank and set Date To to the same As at date. This includes journals from the beginning of the available data through the reporting date.

The Current Year Profit or Loss line is different: it links to Profit & Loss, because it is a calculated combination of Income and Expense accounts rather than a direct balance in one ledger account.

Relationship to the Profit & Loss Statement

The Profit & Loss Statement and Balance Sheet use the same journal data but present different account types. Profit & Loss displays Income and Expense account totals for its reporting period. The Balance Sheet displays Asset, Liability and Equity accounts and adds the P&L net result to Total Equity.

To compare the same cumulative data, set Profit & Loss Date To to the Balance Sheet As at date and leave Profit & Loss Date From blank. A P&L with a later Date From reports movement within that shorter period and will not equal the cumulative current-year result shown by the Balance Sheet implementation.

The current P&L report calculates one net result and has no separate cost-of-sales or gross-profit subtotal. The Balance Sheet uses that exact implemented net result.

As at date filtering behaviour

The optional As at field is an inclusive upper date boundary. A journal dated on or before the selected date is included; a journal after it is excluded. With the field blank, Simple Books uses all loaded journals and reports the latest included journal date as the reporting date.

After changing As at, select Refresh. An invalid value shows Check date, leaves the statement totals blank and asks for a valid reporting date. Journal dates use their written YYYY-MM-DD calendar date without timezone shifting.

Before applying the chosen date, Simple Books validates every loaded journal and verifies every journal calendar date. An invalid journal after the selected As at date still makes the report unavailable, preventing the filter from hiding malformed data and producing partial totals.

If no journals exist on or before the selected date, the page shows No data. There is no Date From control: the statement is cumulative from the beginning of the available journal data through As at.

Worked examples

Sales invoice

A consultant saves an invoice for £100 net plus £20 VAT, total £120. The Balance Sheet shows £120 Trade Receivables under Assets and £20 VAT Output under Liabilities. The £100 Sales Revenue is not listed directly; it produces £100 Current Year Profit in Equity. Assets of £120 equal £20 Liabilities plus £100 Equity.

Supplier bill

The business saves a Software bill for £200 net plus £40 VAT, total £240. VAT Input adds £40 to Assets, Trade Payables adds £240 to Liabilities, and the £200 software expense produces a £200 Current Year Loss that reduces Equity. The equation is £40 Assets = £240 Liabilities + minus £200 Equity.

Business expense

A director records a Utilities expense for £50 net plus £10 VAT, gross £60. VAT Input adds £10 to Assets, Employee Reimbursements Payable adds £60 to Liabilities, and the £50 expense reduces the current-year result by £50. Marking it Paid does not add a Bank credit or clear the £60 liability in the current implementation.

Mileage claim

A £45 mileage claim creates no VAT asset. It adds £45 to Employee Reimbursements Payable and £45 to Travel & Mileage expense, reducing Current Year Profit—or increasing Current Year Loss—by £45. With no other activity, £0 Assets equals £45 Liabilities plus minus £45 Equity.

Current Year Profit affects Total Equity

Suppose the journal set contains £500 Sales Revenue and £345 of combined bill, expense and mileage costs, with no direct Owner’s Equity posting. Current Year Profit is £155 and Total Equity is £155. If a valid direct Owner’s Equity credit of £1,000 also existed in the loaded journals, Total Equity would be £1,155. The current product has no user-facing workflow to create that capital or opening journal.

Changing the As at date

An invoice for £100 net plus £20 VAT is dated 10 July, and a £60 Utilities bill made up of £50 net plus £10 VAT is dated 15 July. As at 10 July, the report shows £120 Trade Receivables, £20 VAT Output and £100 Current Year Profit. As at 15 July, it also includes £10 VAT Input, £60 Trade Payables and the £50 expense, so Current Year Profit falls to £50. The later date changes the cumulative journal set; it does not alter either saved journal.

Common mistakes

Treating the Balance Sheet as a period-only report. As at is cumulative from the beginning of available journals.
Expecting Sales Revenue or expense accounts as direct rows. They feed Current Year Profit or Loss.
Assuming VAT is part of revenue or expense on this report. VAT Input is an Asset and VAT Output is a Liability.
Expecting Paid status to clear balances. Current status actions do not post Bank or settlement entries.
Expecting Bank or Owner’s Equity to appear automatically. The four current source builders do not post to them.
Comparing a dated Balance Sheet with an all-time Trial Balance or a shorter-period P&L. Align the journal scope first.
Assuming balanced means correct. Equal sides cannot detect every omission, duplicate or wrong account choice.
Deleting a source to reverse its accounting. Current delete workflows do not reverse or remove the linked journal.
Ignoring a ledger-posting warning. A saved source whose journal write failed is absent from the Balance Sheet.

Current implementation limitations

No payment journals: Paid status does not post Bank or clear Trade Receivables, Trade Payables or Employee Reimbursements Payable.
No manual journals or opening balances: the current user interface cannot post capital, opening Bank, retained balances or adjustments.
Bank and Owner’s Equity are unused by current source builders: they exist in the chart but invoices, bills, expenses and mileage do not post to them.
Deletion does not reverse journals: deleting a source record does not currently create a reversal or remove its linked journal, so balances can remain.
A journal write can fail after its source is saved: an operational record can exist while its accounting effect is absent.
No historical comparative columns: the report displays one As at statement rather than side-by-side dates.
No Balance Sheet export or print control: the current page only displays the statement.
No fixed-asset, inventory, loan, accrual, retained-earnings or other extended accounts in the default chart: only the listed current Asset, Liability and Equity accounts are available to the live report.
No partial result for malformed data: one invalid loaded journal or journal date makes the report unavailable, even if it falls after As at.

Summary

The Simple Books Balance Sheet validates the user’s journals, includes them cumulatively through an optional As at date, and turns their Trial Balance totals into debit-oriented Assets and credit-oriented Liabilities and Equity. The current chart includes Bank, Trade Receivables and VAT Input as Assets; Trade Payables, VAT Output and Employee Reimbursements Payable as Liabilities; and Owner’s Equity as the direct Equity account.

Profit & Loss supplies the Current Year Profit or Loss added to Total Equity, and the report checks Total Assets against Total Liabilities plus Equity. Use each account-code link to inspect the General Ledger, align report dates before comparing figures, and remember the current boundaries around payments, manual and opening journals, deletion, failed writes, comparisons and export.