← All skills & workflows

finance

trial-balance-generator

Aggregates all posted journal entries for a period into a trial balance — opening balances, period movements, and closing balances per account.

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.

Difficulty
beginner
Input
data
Output
spreadsheet
Needs
none
Used by
Finance Manager

What it needs

  • period_id — Accounting period ID, e.g. 2025-12
  • period
  • journals_folder — scanned for posted JEs
  • current_period_id
  • prior_period_id
  • period_id

What you get

  • comparative-trial-balance (markdown)
  • trial-balance (markdown)
  • validation-report (markdown)

Ask it like this

  • prepare period-end management accounts
  • generate financial statements
  • validate GL integrity
  • accounting methodology