Awditify Municipal

Municipal finance

PSAB financial reporting, straight off your ledger

The statutory reporting layer. Funds, grants and the full PSAB statement set are generated from live ledger data, with per-report settings a treasurer controls rather than a consultant.

  • 19 staff screens
  • 13 statements and schedules
  • PS 3410 grant tracking built in
PSAB statement of financial position showing assets, liabilities, net debt and accumulated surplus
Thirteen PSAB statements and schedules, generated from live ledger data.

Why it matters

Year-end stops being an assembly job

Because every module posted to one ledger, the statement set is generated rather than compiled. Funds are structural, grants recognise revenue as eligible spending happens, and each report carries settings that match how your municipality actually reports.

  • 13

    Statements and schedules

  • 8

    PSAB standards covered

  • 19

    Screens across the module

  • 14

    Municipal custom report data sources

  • Thirteen statements, one click each

    Financial Position, Operations, Change in Net Debt, Cash Flow, fund balances, reserve continuity, budget versus actual, debt, deferred revenue, grants and segments.

  • Settings a treasurer controls

    Segment basis, deferred revenue source and long-term debt source are saved per report, so the output matches your reporting rather than a fixed template.

  • Grants that recognise correctly

    Eligible expense accounts drive automatic revenue recognition against the deferred balance, so the split reflects what was actually spent.

  • Funds without the workaround

    Accounts are assigned to funds with bulk actions, and a restate-history option re-attributes prior activity when an account moves fund.

How it works

What the module covers

  1. The statements

    The whole statutory set, off the ledger

  2. Funds

    Fund accounting that is structural, not cosmetic

  3. Grants

    PS 3410 transfers that recognise as you spend

  4. Custom reports

    Build your own over live municipal data

The statements

The whole statutory set, off the ledger

Every statement carries its own filter and its own saved settings panel, so the output matches how your municipality reports rather than a generic template.

Segment disclosure report showing revenues, expenses and surplus by municipal segment
PS 2700 segment disclosure, driven by fund assignments or a custom segment map.
  • Segment disclosure settings. Segment basis is either your current fund assignments, or a custom segment map with a named bucket for anything unmapped.

  • Deferred revenue settings. Source the schedule from GL deferred-revenue accounts, from the grant-tracking section, or from a manual continuity schedule.

  • Long-term debt settings. Source from GL debt accounts, a manual loan schedule, or GL plus manual rows. Manual rows capture account number, line or loan name, fund, opening, additions, reductions, closing, interest, rate, maturity and notes.

ReportStandardFilterContent
Statement of Financial PositionPS 1201As atAssets, liabilities, net debt, accumulated surplus
Statement of OperationsPS 1201Date rangeRevenues, expenses, annual surplus or deficit
Statement of Change in Net DebtPS 1201Date rangeAnnual surplus, non-financial asset changes, net debt movement
Statement of Cash FlowPS 1201Date rangeOperating, capital, investing and financing cash movement
Fund Balance SummaryPS 3050As atBalances across operating, reserve, restricted and trust funds
Fund Balance DetailPS 3050As at plus fundAccount-level fund balance detail
Reserve Fund ContinuityPS 3050Date rangeOpening, additions, reductions and closing reserve balances
Budget vs Actual (Operating)Fiscal yearOperating budget against actual revenue and expense
Budget vs Actual (Capital)Fiscal yearCapital budget against actual capital activity
Long-Term Debt SchedulePS 3230Date rangeOpening debt, additions, repayments, closing
Deferred Revenue SchedulePS 3100Date rangeDeferred revenue additions, recognition and closing
Grant Continuity SchedulePS 3410Date rangeGrant receipts, revenue recognition and deferred balances by grant
Segment DisclosurePS 2700Date rangeRevenues, expenses and surplus by municipal segment

Also included

  • Saved per-report settings
  • As-at and date-range filters
  • Fund-scoped detail
  • Custom segment map

Funds

Fund accounting that is structural, not cosmetic

Funds are structural, not a reporting afterthought. Chart-of-accounts accounts are assigned to funds, and historical activity can be restated when an account moves.

Fund accounting screen showing funds with code, type, balance, budget and year-to-date revenue and expense
Funds with their assigned accounts, balances and over-budget flags.
  • Fund register. Fund code, fund type, fund name, description and an active flag.

  • Account assignment. An assignable-accounts picker with search, bulk assign and bulk unassign, plus a restate history option that re-attributes historical activity when an account changes fund, so prior-period fund balances do not silently break.

  • Funds summary. Balance, budget, year-to-date revenue, year-to-date expense and an over-budget count per fund.

  • Fund detail. The accounts in the fund with number, name, type and status, recent activity with date, description, account, debit and credit, and the grants held in that fund with grant number, awarded amount and end date.

  • Budget management. A municipal fund-scoped read of an active budget showing fund-level budget against actual with over-budget flags. Budget authoring itself happens in the platform’s main Budgets module.

Also included

  • Operating, reserve, restricted, trust
  • Bulk assign accounts
  • Restate history
  • Over-budget flags

Grants

PS 3410 transfers that recognise as you spend

Government transfers with eligible-expense matching, so revenue recognition against the deferred balance happens as the money is actually spent.

Grant tracking screen listing grants with source, category, fund, awarded, received, spent and deferred amounts
Awarded against received, spent and deferred, per grant.
  • What a grant carries. Grant number, source of federal, provincial, municipal or other, name, program, granting agency, agreement date, total awarded, start and end dates, PS 3410 category, fund, receivable account, bank account, deferred revenue account, revenue account, a list of eligible expense accounts, and purpose.

  • Instalments. Scheduled date and amount against received date and amount with a status, and a receive-instalment action taking received date, amount and bank account that posts to the GL.

  • Expenditures. Date, account, description, amount, whether the expenditure met grant conditions, and the revenue recognised as a result. Expenditures can be reversed.

  • Condition matching. The eligible expense account list drives automatic revenue recognition against the deferred balance, so the deferred and recognised split reflects actual eligible spending.

  • Reporting. A PS 3410 report per grant, a grants dashboard summarising the portfolio, and the Grant Continuity Schedule showing receipts, recognition and deferred balances by grant across a date range.

Also included

  • Federal and provincial sources
  • Deferred revenue accounts
  • Reversible expenditures
  • Portfolio dashboard

Custom reports

Build your own over live municipal data

Fourteen municipal data sources are registered in the platform’s custom report builder, each gated on its module entitlement.

Custom report builder showing municipal data sources available for reporting
Municipal data sources sit alongside bookkeeping sources in the same builder.
  • The data sources. Tax notices, tax arrears, tax charges, tax collections, property units, property owners, unified ledger, AR aging, tax certificates, payment plans, tax exemptions, tax credits, assessment roll and funds.

  • The same builder. These sit alongside your bookkeeping data sources in one report builder, so a municipality builds municipal reports the same way it builds any other report, with scheduled delivery where that is enabled.

  • Gated by entitlement. A data source only appears if the plan carries the module it belongs to, so a municipality without Utilities never sees utility data sources.

Also included

  • Unified ledger
  • AR aging
  • Assessment roll
  • Funds

Questions

PSAB reporting questions

Talk to our team

Generated from live ledger data. Because every municipal module posts real journal entries to the same chart of accounts, the statements read from the ledger rather than from a separate reporting file that has to be kept in step.