trial-balance-generator
Aggregate all posted journal entries for an accounting period into a structured trial balance. The trial balance is the foundation for financial statement preparation — every financial statement line is derived from it.
Inputs
- period-record — Accounting period record — defines the range the trial balance covers.
- period_id — Accounting period ID, e.g. 2025-12
- period
- journals_folder — scanned for posted JEs
- current_period_id — Current period id used to side-by-side trial balance with current and prior period, variance column
- prior_period_id — Prior period id used to side-by-side trial balance with current and prior period, variance column
- period_id — Period id used to check that total debits equal total credits; flag imbalances and draft JEs
How you ask
- Prepare period-end management accounts
- Generate financial statements
- Validate GL integrity
Outputs
- comparative-trial-balance (markdown)
- trial-balance (markdown)
- validation-report (markdown)
Levelbeginner
Inputdata
Outputspreadsheet
Setup[none]
Roles[Finance Manager]