Skip to content
Workflow · Match two lists · Opening soon

Depreciation schedule checked against Xero or QuickBooks

Export your fixed asset register and the depreciation account transactions from Xero (or QuickBooks' Transaction Detail by Account report), upload both and say the check in words. Mammoth builds the month by month straight line schedule for each asset type, charging a sold asset up to its disposal month, and compares each month's charge with what was posted: agrees, posted too high, posted too low or not posted.

Early access opens shortly. Check back soon.

Someone typed

“build a month by month straight line depreciation schedule from our fixed asset register for the 6 months to 31 october 2026, with opening accumulated depreciation, the month's charge and closing accumulated depreciation for each asset type, and compare each month's charge with the depreciation xero posted, showing months that agree, were posted too high, posted too low or not posted, where a sold asset is charged up to its disposal month and its accumulated depreciation leaves the opening and closing balances from the month after”

The agent read it as

Build a month by month straight line depreciation schedule from our Fixed asset register for the 6 months to 31 october 2026, with opening accumulated depreciation, the month's charge and closing accumulated depreciation for each asset type, and compare each month's charge with the depreciation Depreciation posted in Xero, showing months that agree, were posted too high, posted too low or not posted, where a sold asset is charged up to its disposal month and its accumulated depreciation leaves the opening and closing balances from the month after, with full charge in purchase month.

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Fixed asset register
    CSV export · 10 rows
  2. File
    Depreciation posted in Xero
    CSV export · 17 rows
  3. Step
    Build asset type schedule
    Step 1
  4. Step
    Total Xero charges by month
    Step 2
  5. Join
    Add Xero charges
    17 of 18 paired
  6. Step
    Compare monthly charges
    Step 4
  7. Result
    Monthly Depreciation Comparison
    18 rows · 4 flagged
  8. Schedule
    Runs when you say
    Proposed

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

What you get back

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

Monthly Depreciation ComparisonSample data18 rows
14 agrees2 posted too high1 posted too low1 not posted
MonthAsset typeOpening accumulated depreciationMonth's chargeClosing accumulated depreciationDepreciation posted in XeroDifferenceStatus
2026-07-31Office Equipment2,9501003,0500-100Not posted
2026-06-30Computer Equipment4,2002504,450200-50Posted too low
2026-09-30Motor Vehicles17,55075018,3001,150400Posted too high
2026-10-31Motor Vehicles18,30075019,0501,150400Posted too high
2026-05-31Computer Equipment4,0002004,2002000Agrees
2026-05-31Motor Vehicles26,5501,15027,7001,1500Agrees
2026-05-31Office Equipment2,7501002,8501000Agrees
2026-06-30Motor Vehicles27,7001,15028,8501,1500Agrees
2026-06-30Office Equipment2,8501002,9501000Agrees
2026-07-31Computer Equipment4,4502504,7002500Agrees
2026-07-31Motor Vehicles28,8501,15030,0001,1500Agrees
2026-08-31Computer Equipment4,7002504,9502500Agrees
18 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Monthly Depreciation Comparison 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.

Monthly Depreciation Comparison: questions

How do you check a depreciation schedule against Xero or QuickBooks?
Export your fixed asset register and the depreciation account transactions from Xero (or QuickBooks' Transaction Detail by Account report), upload both and say the check in words. Mammoth builds the month by month straight line schedule for each asset type, charging a sold asset up to its disposal month, and compares each month's charge with what was posted: agrees, posted too high, posted too low or not posted.
Which export file should you use?
Use the export that contains the posted depreciation amounts for the period you want to check. You also need the fixed asset register export with the asset details and dates used for the schedule.
What happens to rows that do not match?
Rows that do not match are not dropped. They stay in the result and are marked so you can see which months or assets agree, are too high, too low, or have no posted amount.
How do you change the rules?
You change the rules in words, such as the date range, how to treat sold assets, and whether the purchase month gets a full charge. You can then rerun the workflow with the updated instructions.

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.