Settings ▸ Accounting ▸ Reports
Settings ▸ Accounting ▸ Reports is the read-only surface for your firm’s core financial reports plus a click-through GL drill-down. All reports run against your posted journal entries — drafts and reversed entries are excluded.
Reports at a glance
Section titled “Reports at a glance”| Report | Scope | Use case |
|---|---|---|
| Trial Balance | Date range | Audit cross-check: every account’s DR + CR totals, balanced view |
| Balance Sheet | As of a date | Assets = Liabilities + Equity at a point in time |
| Income Statement | Date range | Revenue minus Expenses = Net Income for the period |
| Trust Listing | As of a date | Client trust money held, reconciled to the trust bank (LSO By-Law 9) |
| Trust Ledger | Date range | Consolidated chronological trust transactions, per trust account |
| Bank Journals | Date range | Per-bank cash book — deposits, withdrawals, running balance |
| Tax Liability | As of a date | Sales tax owed, grouped by collecting agency |
| GL Drill-Down | Account + range | Per-account journal-line history with running balance |
Period selector
Section titled “Period selector”Most reports use a date range with quick-button presets (Trial Balance, Income Statement, Trust Ledger, Bank Journals, GL Drill-Down):
| Button | Range |
|---|---|
| MTD | Month-to-date through today |
| Last Month | Full prior calendar month |
| QTD | Quarter-to-date through today |
| YTD | Calendar year-to-date |
| This Fiscal Year | Current fiscal year through today |
| Last Fiscal Year | Full prior fiscal year |
| This Calendar Year | Jan 1 through Dec 31 of current year |
| Last Calendar Year | Jan 1 through Dec 31 of prior year |
| Custom | Any From / To picked from the date inputs |
Fiscal-year buttons read from the org’s fiscal year-end (set in Settings ▸ General; default Dec 31). For orgs that haven’t set a custom fiscal year, “This Fiscal Year” and “This Calendar Year” return identical ranges.
The Balance Sheet, Trust Listing, and Tax Liability use as-of dates instead of ranges:
| Button | As-of date |
|---|---|
| As of today | Today |
| Last month-end | The most recent month-end |
| Last fiscal year-end | The most recent past fiscal year-end |
| Custom | Any single date picked from the input |
Trial Balance
Section titled “Trial Balance”Lists every account that posted activity in the period:
- Code · Account · Type — the chart row
- Debit · Credit — period totals on each side
A footer row totals all debits + credits. The report is balanced when DR = CR (you’ll see a green ✓ Balanced indicator). An out-of-balance report indicates a posting bug — escalate to the Athenty team if you see this; the database constraints should make it impossible.
Drill-through: click any account row to open the GL Drill-Down for that account, with the same period preserved.
Balance Sheet
Section titled “Balance Sheet”Three sections (Assets / Liabilities / Equity) with subtotals:
- Assets — every asset account with non-zero balance as of the date
- Liabilities — payables + client trust liabilities
- Equity — paid-in capital, retained earnings, plus a synthetic Net earnings (current period) line that sums revenue minus expenses for the open period
A footer line totals Liabilities + Equity. The accounting equation must hold: Assets = Liabilities + Equity. The green ✓ Balanced indicator confirms.
Drill-through: click any account row to open the GL Drill-Down for that account, ending on the as-of date.
Income Statement
Section titled “Income Statement”Two sections with totals:
- Revenue — service revenue, FX gains, miscellaneous income
- Expenses — disbursements, operating expenses
A footer line shows Net Income = Revenue − Expenses. Positive net income renders in green; negative (a net loss) renders in red.
Drill-through: same as TB and BS — click any account row.
Trust Listing
Section titled “Trust Listing”The client trust listing required by LSO By-Law 9 — a point-in-time statement of how much trust money the firm holds, structured so it reconciles to the trust bank account. Choose an as-of date, then a pivot:
| Pivot | One row per | Use case |
|---|---|---|
| All | Per-client trust-liability account | The literal By-Law 9 listing; drill-through enabled |
| By client | Client (per currency) | Quick “what do we hold for whom” view |
| By matter | Matter (+ its client) | Tie trust money to specific files; an (unallocated) row surfaces trust not yet attributed to a matter |
The grand total is identical across all three pivots — they are the same trust pool grouped differently, which is itself an audit check.
The footer compares total client trust liability to total trust bank assets (the 1100-X trust bank GLs):
- Green ✓ Reconciled — the two tie; By-Law 9 is satisfied.
- Red ⚠ Not reconciled — a variance exists (trust shortfall or surplus). The report shows the exact difference so it can be investigated; it is surfaced, never hidden.
A client showing a negative balance (red) means that client’s trust ledger is overdrawn — a By-Law 9 violation that needs immediate attention.
Drill-through: on the All pivot, click any row to open the GL Drill-Down for that client’s trust-liability account.
Trust Ledger
Section titled “Trust Ledger”The consolidated transaction trail of every trust receipt and disbursement over a period, in date order with a running balance. It is the same LSO By-Law 9 audit trail as the matter Trust tab and the reconciliation export — identical to the cent — rolled up to two scopes:
| Scope | Shows |
|---|---|
| All trust accounts | Every active trust account, firm-wide |
| By client | Only the selected client’s matters (pick the client) |
A running balance cannot mix currencies and each trust account is single-currency, so the report is sectioned per trust account — each section has its own opening balance, chronological lines, and closing balance — followed by grand totals by currency. A CAD trust account and a USD trust account total separately; they are never summed into one number.
CSV and PDF exports follow the same sectioned shape. The PDF carries prepared-by / reviewed-by signature lines for LSO audit filing, matching the single-account reconciliation ledger PDF.
Trust Ledger vs Trust Listing: the Listing is a point-in-time balance per client, sourced from the GL so it ties to the Balance Sheet. The Ledger is the transaction-by-transaction record, sourced from the operational trust ledger so it matches the matter Trust tab and reconciliation export exactly. Different question, different source — both reconcile.
Bank Journals
Section titled “Bank Journals”The per-bank cash book — the PC Law “Bank Journal” form. Every posting that moved through a bank account, in date order, split into Deposits and Withdrawals columns with a running balance. Choose a scope:
| Scope | Shows |
|---|---|
| All bank accounts | Every bank account (operating + trust) |
| Operating accounts | Only the firm’s own operating banks |
| Trust accounts | Only trust banks |
Sectioned per bank account — opening balance, cash-book lines, period deposit/withdrawal totals, closing balance — followed by grand totals by currency.
Why a separate report from the Trust Ledger? The Trust Ledger is the trust audit trail (operational trust ledger source). The Bank Journal is the cash book: it is sourced from the General Ledger, so it captures every movement through the bank — operating expenses, accounts payable, inter-account transfers — not only trust activity. Each section’s closing balance ties to the Trial Balance / Balance Sheet line for that bank GL (and, for a trust bank, to the Trust Listing’s trust-bank-assets total).
CSV and PDF exports follow the same sectioned cash-book shape.
Tax Liability
Section titled “Tax Liability”How much sales tax the firm owes, grouped by the collecting agency, as of a date. Each tax rate maps to a GL account (a Tax Payable liability, or an Input Tax Credit receivable). The report sums those accounts’ posted balances as of the date and groups them by each rate’s agency.
Per agency it lists each tax GL account, the rates feeding it (code + percentage), and the account balance; an agency net liability subtotals each agency. A grand total sums all distinct tax accounts and ties to the Trial Balance tax-account lines.
Rates with no agency configured group under (Unassigned agency) — set the agency field on the rate (Settings ▸ Accounting ▸ Tax rates) so liabilities file cleanly per authority. Inactive rates are included (a deactivated rate may still carry an unremitted balance).
Grouping is by the standalone tax-rate agency field. When tax-rate groups ship, the grouping switches to groups; the underlying account balances are unchanged, so the totals stay stable.
GL Drill-Down
Section titled “GL Drill-Down”Per-account journal-line history with running balance. Pick an account from the dropdown OR arrive via drill-through from another report.
The view collapses by journal entry: one row per entry showing date, description, total DR / CR, and running balance after the entry. Click the chevron to expand each entry into its individual lines.
Opening + closing balances bookend the table. The running-balance column uses accounting-normal sign: assets and expenses are positive when DR > CR; liabilities, equity, and revenue are positive when CR > DR.
Exporting
Section titled “Exporting”Every report renders Download CSV and Download PDF buttons next to the period selector (the GL Drill-Down is CSV-only by design — its line-by-line shape is best consumed as data, not narrative).
CSV exports are flat tabular files suitable for spreadsheet import. PDF exports are formatted statements with the firm’s name in the header, ready to send to your accountant or file as part of monthly close.
Audit semantics
Section titled “Audit semantics”- Reports include posted journal entries only. Drafts and reversed entries are excluded.
- Reversed entries are removed from the totals (they offset against their original); both sides remain visible in the Journal Entries viewer for traceability.
- The Income Statement’s Net Income flows into the Balance Sheet’s Equity section as Net earnings (current period) until period close formally moves it to Retained Earnings.
Troubleshooting
Section titled “Troubleshooting”| Symptom | Likely cause |
|---|---|
| ”No activity in this period” | No posted entries in the selected range. Pick a wider range or post some activity. |
| Out-of-balance Trial Balance | Database posting bug — escalate. |
| Out-of-balance Balance Sheet | Same — DR=CR is enforced at write time, so a balanced TB implies a balanced BS. |
| Trust Listing “Not reconciled” | Client trust liability ≠ trust bank assets. A real By-Law 9 trust shortfall/surplus — investigate the variance shown; do not ignore. |
| Trust Listing total differs from Balance Sheet trust liability | They should match exactly (same GL source). If not, escalate. |
| Trust Ledger closing ≠ Trust Listing balance for a client | Listing is GL-sourced, Ledger is operational-ledger-sourced; small gaps mean an unposted GL backfill — run the GL backfill, then they tie. |
| Trust Ledger “By client” empty | The selected client has no matters with trust activity in the period. |
| Bank Journal closing ≠ Trial Balance bank line | They are the same GL source and must match. If not, escalate. |
| Bank account missing from Bank Journals | The bank account has no linked GL account yet, or no activity and a zero opening balance in the period. |
| Tax shows under “(Unassigned agency)“ | The tax rate has no agency set — edit it under Settings ▸ Accounting ▸ Tax rates. |
| Tax Liability grand total ≠ Trial Balance tax accounts | Same GL source; must tie. If not, escalate. |
| GL Drill-Down shows fewer lines than expected | Reversed entries are excluded from the running balance but listed in the Journal Entries viewer. |
| Custom-range CSV / PDF won’t download | Check the auth on your session — these endpoints require admin role. |