Month-end pack from the trial balance
“turn my client's month-end trial balance into a month-end pack: give each account its pack section and line from our mapping for this client and total each line, split the trade creditors account (the one account our mapping puts on the creditors line; PAYE and other payables keep their own lines) by the supplier group on the aged payables, with any gap to that account as its own line, and list the accounts the mapping does not cover. Show amounts as positive numbers the way a pack reads them: credit minus debit for sales, liabilities and equity, debit minus credit for costs and assets. The creditors line shows only the supplier groups and the gap, never the trial balance creditors total beside them”
Turn my client's Xero Trial Balance into a month-end pack: give each account its pack section and line from Client month-end pack mapping for this client and total each line, split the trade creditors account (the one account our mapping puts on the creditors line; PAYE and other payables keep their own lines) by the supplier group on Xero Aged Payables Summary, with any gap to that account as its own line, and list the accounts the mapping does not cover. Show amounts as positive numbers the way a pack reads them: credit minus debit for sales, liabilities and equity, debit minus credit for costs and assets. The creditors line shows only the supplier groups and the gap, never the trial balance creditors total beside them
What the agent built
6 steps, each one an ordinary Mammoth step you can open and change.
- FileXero Trial BalanceCSV export · 30 rows
- FileClient month-end pack mappingCSV export · 29 rows
- FileXero Aged Payables SummaryCSV export · 10 rows
- StepPrepare trial balance rowsStep 1
- StepPrepare mapping rowsStep 2
- StepTotal payables by supplier groupStep 3
- JoinAdd pack mapping29 of 30 paired
- JoinAdd supplier group totals30 of 30 paired
- StepBuild month-end pack linesStep 6
- ResultClient Month-End Pack32 rows
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 32 rows.
- Download Xero Trial Balance sample (30 rows)Xero: Accounting > Reports > Trial Balance > Export
- Download Client month-end pack mapping sample (29 rows)Client pack mapping spreadsheet maintained by the firm
- Download Xero Aged Payables Summary sample (10 rows)Xero: Accounting > Reports > Aged Payables Summary > Export, with the firm's Group column added
What you get back
The result of that run, the rows to look at first.
| Pack Section | Pack Line | Amount | Account Code | Account |
|---|---|---|---|---|
| Cost of sales | Packaging materials | 4,200 | · | · |
| Cost of sales | Project delivery costs | 16,000 | · | · |
| Current assets | Bank | 19,500 | · | · |
| Current assets | Trade debtors | 28,500 | · | · |
| Current assets | VAT control | 6,300 | · | · |
| Current liabilities | Accruals | 5,400 | · | · |
| Current liabilities | Gap to trade creditors | 1,250 | · | · |
| Current liabilities | PAYE payable | 3,900 | · | · |
| Current liabilities | ingredients and packaging suppliers | 15,000 | · | · |
| Current liabilities | other suppliers | 10,500 | · | · |
| Equity | Retained earnings | 20,050 | · | · |
| Equity | Share capital | 50,000 | · | · |
How it works
How to use the Client Month-End Pack workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Client Month-End Pack: questions
How do you turn a trial balance into a month-end reporting pack?
What export should I use?
What happens to rows that do not match the mapping?
How do I change the rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Schedules, commissions, costing and margins, worked out the same way from every new export.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- RFM segmentsEvery customer scored 1-5 on recency, frequency and spend, with a segmentSee the workflow Template
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template