Reporting
Balance Sheet
The Balance Sheet is a point-in-time snapshot of what you own and what you owe. Unlike the Profit & Loss, which covers a period, the balance sheet is reported as of a single date. The consolidated version combines balances across your entities/properties into one statement.
What it shows
The statement is organized straight from your chart of accounts into the three classic sections, each with subtotals:
- Assets — bank/cash accounts, accounts receivable, prepaids, fixed assets, etc.
- Liabilities — accounts payable, security deposits held, loans and other obligations.
- Equity — owner equity plus Net Income.
Net Income is computed from the P&L for the fiscal year (Jan 1 through your as-of date) and carried into equity, so the balance sheet's net income always matches the Profit & Loss. Assets should equal Liabilities + Equity.
Important
The report includes inactive accounts that still carry a balance in the period. A deactivated account with ledger history keeps appearing so assets and liabilities aren't understated — and so the accrual balance sheet still balances.
Note
On a cash basis balance sheet, A/R and A/P are zeroed out and a small Cash Basis Adjustment line is added to equity so the statement still balances — the same approach QuickBooks uses.
Set the date
- Open Reports and choose Balance Sheet Consolidated.
- Set the as-of date — the report shows balances as of that day (defaults to today).
- Choose the accounting method — accrual (default) or cash.
The report re-runs automatically when you change a filter.
Compare periods
Open the Compare options to add side-by-side columns:
- Previous year
- Previous period
- Custom period
You can also show dollar change and percent change between columns.
Split and filter by dimension
Narrow the statement — or break it into columns — by tenant, program, property or unit via Display columns by and the dimension filters. Comparisons are disabled while column-splitting.
Drill down
Click an account line to open the Transaction report and see the transactions behind the balance.
Export, share & email
From the toolbar you can export to PDF, Excel or CSV, print, share a secure no-login link, email the report, schedule recurring delivery, and save a saved view.