Balance Sheet

The balance sheet shows what you own, owe, and are worth at a point in time — the As of date sets the snapshot. DayZero groups accounts into current and non-current sections and checks that Assets = Liabilities + Equity live.

Key capabilities

• As of date picker with Today, Month End, Quarter End, and Year End presets
• Group by Total (single snapshot), Month, Quarter, or Year for side-by-side period columns
• Runs on Accrual books (default) or Cash books, switched in the sidebar
• Three top-level sections — Assets, Liabilities, Equity — split into meaningful subsections
• Subsections: Current Assets, Non-Current Assets, Transfers Between Accounts; Current/Non-Current Liabilities; Retained Earnings and Equity (with an "Other" bucket as a fallback)
• Parent accounts roll up their child accounts with a Total line; Show account details adds D / C (Debit / Credit) and Sort Code columns
• Live A = L + E validation card with an out-of-balance amount when it doesn't tie
• Expand any account for a counterparty breakdown of activity (with entry counts and % of the account)
• Click a counterparty to drill into its transactions; click an amount to open the full ledger statement
• Hide Empty Rows toggle (on by default) to focus on accounts with balances
• Comparative report shortcut to the Report Library
• AI Analysis panel for ratios and imbalances, with copy-to-clipboard
• Excel export of every section

How it works

DayZero rolls every ledger balance as of your As of date into its section, derives whether each is naturally a debit or credit, and checks that total assets equal total liabilities plus equity.

flowchart TD
  ledgers["Ledger balances (as of date)"] --> classify["Classify by sub-type"]
  classify --> assets["Assets"]
  classify --> liab["Liabilities"]
  classify --> eq["Equity"]
  assets --> check{"Assets = Liabilities + Equity?"}
  liab --> check
  eq --> check
  check -->|"Yes"| ok["Balances"]
  check -->|"No"| warn["Out of balance by ..."]

How to use it

1. Open Balance Sheet and set the As of date (or pick a preset pill) — it determines the snapshot for all balances.
2. Review Assets, Liabilities, and Equity, each broken into current/non-current subsections with a balance per account. Choose Group by Month, Quarter, or Year for period columns: the sheet then ends at your as-of date and reaches back 12 months, 8 quarters, or 3 years, and a Date Range control lets you move the first column.
3. Check the A = L + E card at the bottom — a green check means the books balance; otherwise it shows the out-of-balance amount.
4. Expand an account row for its counterparty breakdown, then click a counterparty to drill into transactions.
5. Click an account amount to open the ledger statement modal for that account (in period columns, up to that period end).
6. Untick Hide Empty Rows to show zero-balance accounts; tick Show account details (Total view) for D / C and Sort Code.
7. Open AI Analysis for a narrative on ratios and unusual balances, and click Excel to export.

Pro tips

• If the balance check is off, look for unposted journal entries, a misclassified account, or a transaction dated outside your expected period.
• Use the counterparty breakdown on large liability accounts (like Accounts Payable) to see which vendors make up the balance.
• The ledger statement modal is the fastest way to audit how an account got to its current balance — open it straight from the amount.
• For variance or common-size columns, use Comparative report or run the Comparative or Monthly Balance Sheet from the Report Library (CFO Advisory Suite add-on).
• Retained Earnings plus current-year earnings should reconcile to the Net Income on your income statement for the same period.

In-depth guide

Report structure and subsections

Each top-level section is split into subsections based on the account's sub-type, so current items sit apart from long-term ones. Anything that doesn't match a known subsection falls into an "Other" bucket so nothing is dropped.

Columns and debit/credit logic

Every account row shows its Name and Amount. With Show account details on, two more columns appear.

How figures are computed and the balance check

• Balances are double-entry ledger balances as of the As of date: accrual by default. On Cash books receivables and payables net to zero and revenue/expense are recognized when paid; a pill beside the date shows the basis and View unapplied payments lists unmatched receipts and payments.
• The footer card shows Total Assets = Liabilities + Equity and verifies the equation.
• If the difference is more than a rounding tolerance, it shows the exact out-of-balance amount with a warning icon; otherwise it confirms the sheet balances.

Drill-down and ledger statements

• Expand an account to load its counterparty breakdown — activity from January 1 of the As of year through the As of date (or the column range in period view), with an entry-count badge and percentage of the account for each counterparty.
• Click a counterparty to open the transaction drill-down.
• Click an account amount to open the ledger statement modal (the synthetic current-year-earnings line is informational and not clickable).
• Recategorizing or editing from these modals refreshes the sheet.

Comparison periods and exports

• Total is a single snapshot; Month, Quarter, or Year show one balance column per period, without variance or common-size columns.
• For period-over-period variance or common-size (% of total), run Comparative Balance Sheet or Monthly Balance Sheet from the Report Library.
• The Excel button exports all sections as currently shown (including period columns).