Skip to content
Workflow · Calculate · Opening soon

Month-end pack from the trial balance

Export the trial balance from Xero, QuickBooks or Sage and upload it with the client's pack mapping and the aged payables export. Mammoth gives each account its pack section and line, totals each line, splits the trade creditors account by supplier group with any gap to the trial balance on its own line, and lists the accounts the mapping does not cover.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    Xero Trial Balance
    CSV export · 30 rows
  2. File
    Client month-end pack mapping
    CSV export · 29 rows
  3. File
    Xero Aged Payables Summary
    CSV export · 10 rows
  4. Step
    Prepare trial balance rows
    Step 1
  5. Step
    Prepare mapping rows
    Step 2
  6. Step
    Total payables by supplier group
    Step 3
  7. Join
    Add pack mapping
    29 of 30 paired
  8. Join
    Add supplier group totals
    30 of 30 paired
  9. Step
    Build month-end pack lines
    Step 6
  10. Result
    Client Month-End Pack
    32 rows
  11. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 32 rows.

What you get back

The result of that run, the rows to look at first.

Client Month-End PackSample data32 rows
Pack SectionPack LineAmountAccount CodeAccount
Cost of salesPackaging materials4,200··
Cost of salesProject delivery costs16,000··
Current assetsBank19,500··
Current assetsTrade debtors28,500··
Current assetsVAT control6,300··
Current liabilitiesAccruals5,400··
Current liabilitiesGap to trade creditors1,250··
Current liabilitiesPAYE payable3,900··
Current liabilitiesingredients and packaging suppliers15,000··
Current liabilitiesother suppliers10,500··
EquityRetained earnings20,050··
EquityShare capital50,000··
32 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Client Month-End Pack workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export the trial balance from Xero, QuickBooks or Sage and upload it with the client's pack mapping and the aged payables export. Mammoth gives each account its pack section and line, totals each line, splits the trade creditors account by supplier group with any gap to the trial balance on its own line, and lists the accounts the mapping does not cover.
What export should I use?
Use a trial balance export from Xero, QuickBooks, or Sage. If you need the creditors split, also use the aged payables export for the same period.
What happens to rows that do not match the mapping?
They stay out of the mapped pack lines and are listed as unmapped accounts. You can review them and decide where they should go.
How do I change the rules?
Add the new account to the client's mapping sheet and rerun next month. Say in words if the creditors split should use another supplier grouping, or how the gap line should read.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.

Workflows like this

Schedules, commissions, costing and margins, worked out the same way from every new export.

All calculate workflows →