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.

Before you start


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.

Next