Balance sheet
Purpose
- See what the company owns, owes, and has as equity at a date. Assets should equal liabilities plus equity.
- The report reads the books. It does not post journals.
Menu path
- Financial Report → Balance Sheet.
Assistant
- No balance-sheet wizard. Ask “how to print the balance sheet” for this chapter.
- Can I pay this is cash on hand, not this statement. See Ask the books.
Print the balance sheet
- Financial Report → Balance Sheet.
- Choose Report Period:
- This Month vs Last Month — month to date and last month.
- This Year — year to date.
- This Year vs Last Year — this year and last year.
- Comparison - Monthly ( 12 month ) — twelve months.
- Comparison - Quarterly ( 4 quarter ) — four quarters.
- Set Date (as-at). Balances are cumulative to that date, not a profit-and-loss slice.
- Optional Financial Year for a closed year. See Year-end closing.
- Optional Include Zero Balance Account.
- Optional Project.
- Click Search.
- Expand All Sub Account / Collapse All Sub Account.
- Click an amount. A parent account opens drill-down for the accounts under it.
- On the drill-down, tick Show Month To Date Total if you want month totals, set the project if needed, and Search.
- Clicking the description shows Please click on the amount to drill down.
- Print PDF: Main Account Only or Includes Sub Account. Excel export uses the same two choices.
Control accounts and retained earnings
- Trade debtors (control) — past and current sales invoices, after opening-balance Save. Customer detail is Sales Ledger and aging.
- Trade creditors (control) — purchase invoices, after the same generate Save. Supplier detail is Purchase Ledger and aging.
- Stock — Maintain Stock Value, not a typed quantity on the product card.
- Fixed assets — cost and accumulated depreciation. See Fixed asset setup and Depreciation journal.
- Retained earnings — opening retained earnings plus profit up to the column, including stock movement. You do not type this month’s profit onto the balance sheet.
- Typing an amount into a red control account on Maintain Opening Balance fights the generate step. Leave those rows for past invoices and stock value.
- A project balance sheet is only the postings tagged with that project. The company total is the report with Project cleared.
If something goes wrong
- Please setup Retain Earning. Create an active Retain Earning sub-account on the chart of accounts, then Search again.
- Assets do not equal liabilities plus equity. Run Trial Balance. Fix the one-sided posting, then return here.
- Debtors, creditors, or stock look empty. Generate opening balance after past invoices and stock value.
- Net book value is stale. Post depreciation, then Search again.
- Drill-down will not open. Click the amount. Expand sub-accounts with the plus icon when you only need the children on this page.