Reporting and close templatesAutomate your month-end management pack from Xero
On working day 8 Modern pulls the closed numbers from Xero, fills your management pack template in Excel, refreshes every chart and drafts the commentary, ready for the finance lead to review.
TriggerWorking day 8
Steps5 steps, from trigger to sign-off
ControlFinance lead approves the pack before it is sent
Free to start. No card needed.
Working day 8The instruction
“On working day 8, once the period is locked in Xero, pull the P&L, balance sheet and cash flow for the month and year to date, against budget and last year. Fill our management pack template in Excel and refresh the KPIs and charts. Draft two paragraphs of commentary on the biggest movements and send the pack to the finance lead to approve before it goes to the leadership team.”
Works with every major ERP
- +100 more
How it runs
5 steps from trigger to sign-off
- 01
Check the period is closed
Confirms the month is locked in Xero and the bank accounts are reconciled.
Xero - 02
Pull the numbers
Reads the P&L, balance sheet and cash flow against budget and last year.
Xero - 03
Fill the pack
Updates every tab, KPI and chart in your existing template.
Microsoft Excel - 04
Draft the commentary
Explains the biggest movements in plain English, with the numbers behind them.
Modern - 05
Approve and send
The finance lead edits and approves, then Modern sends the pack to the leadership team.
Microsoft Excel
Replaces management reporting software
Still paying for management reporting?
This template does the job of Fathom and Syft Analytics inside Modern. Run the stack audit to see what you could cancel across your whole finance stack.
Related templates
More reporting and close automations
- Replaces FathomWorking day 5
Reporting and close
Write budget versus actual commentary
Compares NetSuite actuals with budget, finds the transactions behind each material variance and drafts the commentary in Excel.
5 stepsUse template → - Working day 4
Reporting and close
Post overhead allocation journals
Reads allocation drivers from Excel, splits shared overheads across departments and drafts the journals in Sage for approval.
4 stepsUse template → 
Last working day of the monthReporting and close
Post accruals and release prepayments
Finds costs with no bill yet, proposes accruals, releases prepayments on schedule and drafts the journals in Xero for approval.
4 stepsUse template →
FAQs
Build the month-end management pack: FAQs
Can’t find what you’re looking for? Send us a message and a person on the team will answer.
No. Modern fills the Excel or Google Sheets pack you already use, so the layout your board knows stays the same.
Yes. Modern pulls each entity, converts currencies at the rates you set and eliminates intercompany balances before filling the pack.
Yes. Modern builds the same pack from QuickBooks, NetSuite, Sage or Xero.