finance

financial-statement-generator

Assembles the four IFRS financial statements from a signed-off trial balance in Google Sheets and Google Docs.

Assemble IFRS-compliant financial statements from a signed-off trial balance. Produces all four primary statements with prior-period comparatives. Source of truth for management accounts, board reporting, and statutory filing.

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

What it needs

trial_balance — must be status: signed-off
prior_trial_balance — Prior period TB for comparatives
trial_balance
prior_trial_balance
current_sofp
prior_sofp — Prior period SOFP for working capital movement calculation
income_statement
prior_sofp

What you get

(four files)
cash-flow-statement (markdown)
income-statement (markdown)
soce (markdown)
sofp (markdown)
statements-pack (markdown)

Ask it like this

period-end financial statements
management accounts
statutory accounts pack
trial balance to statements.