Workflow · Finance close · Opening soon
Fixed asset register and depreciation
Use a fixed asset register template to track asset purchases from your exported QuickBooks file. Match each buy to your asset life schedule and account list, then calculate monthly straight-line depreciation and net book value.
Someone typed
“show the quickbooks fixed asset buys against the asset schedule, calculate monthly straight-line depreciation and net book value, and mark Status "Agrees" when it’s unique, in the right asset account, and backed by a source doc”
The agent read it as
Show my QuickBooks transaction list by date fixed asset buys against my Asset life schedule and my QuickBooks account list, calculate monthly straight-line depreciation and net book value, and mark Status "Agrees" when it’s unique, in the right asset account, and backed by a source doc.
What the agent built
6 steps, each one an ordinary Mammoth step you can open and change.
File
QuickBooks transaction list by date
CSV export · 15 rows
File
QuickBooks account list
CSV export · 8 rows
File
Asset life schedule
CSV export · 5 rows
Step
Normalize accounts
Step 1
Step
Normalize schedule
Step 2
Step
Normalize buys
Step 3
Join
Add account type
15 of 15 paired
Join
Add schedule
14 of 15 paired
Step
Work out depreciation
Step 6
Result
Asset buy check
15 rows · 1 flagged
Schedule
Runs when you say
Proposed
- FileQuickBooks transaction list by dateCSV export · 15 rows
- FileQuickBooks account listCSV export · 8 rows
- FileAsset life scheduleCSV export · 5 rows
- StepNormalize buysStep 3
- StepNormalize accountsStep 1
- StepNormalize scheduleStep 2
- JoinAdd account type15 of 15 paired
- JoinAdd schedule14 of 15 paired
- StepWork out depreciationStep 6
- ResultAsset buy check15 rows · 1 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 15 rows came out, and the join paired 15 of 15 rows; the join paired 14 of 15 rows.
- Download QuickBooks transaction list by date sample (15 rows)QuickBooks Online: Reports > Transaction List by Date > Customize to show fixed asset purchases
- Download QuickBooks account list sample (8 rows)QuickBooks Online: Reports > Account List > Export
- Download Asset life schedule sample (5 rows)QuickBooks Online fixed-asset setup sheet maintained alongside the register
What you get back
The result of that run, the rows to look at first.
Asset buy checkSample data15 rows
14 agrees1 wrong asset account
| Transaction date | Transaction type | Source doc | Transaction account | Memo | Amount | Account type | Asset class | Useful life months | Salvage value | Depreciation method | Monthly depreciation | Net book value | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-10-22 | Expense | E-7872 | Repairs and Maintenance | office furniture refurbishment | 980 | Expense | · | · | · | · | · | · | Wrong asset account |
| 2026-09-04 | Bill | A-1041 | Office Equipment | 2 height-adjustable desks for design studio | 1,890 | Fixed Asset | Office Equipment | 36 | 0 | Straight Line | 52.50 | 1,837.50 | Agrees |
| 2026-10-14 | Expense | E-7861 | Computer Equipment | replacement laptop for marketing | 2,310 | Fixed Asset | Computer Equipment | 24 | 0 | Straight Line | 96.25 | 2,213.75 | Agrees |
| 2026-09-08 | Expense | E-7782 | Computer Equipment | 2 MacBook Pro laptops for finance | 4,620 | Fixed Asset | Computer Equipment | 24 | 0 | Straight Line | 192.50 | 4,427.50 | Agrees |
| 2026-10-18 | Bill | A-1047 | Warehouse Equipment | barcode scanner and label printer | 1,365 | Fixed Asset | Warehouse Equipment | 60 | 0 | Straight Line | 22.75 | 1,342.25 | Agrees |
| 2026-10-07 | Expense | E-7844 | Furniture and Fixtures | reception lockbox and wall safe | 540 | Fixed Asset | Furniture and Fixtures | 60 | 0 | Straight Line | 9 | 531 | Agrees |
| 2026-10-27 | Expense | E-7890 | Computer Equipment | laptop sleeve and dock | 265 | Fixed Asset | Computer Equipment | 24 | 0 | Straight Line | 11.04 | 253.96 | Agrees |
| 2026-10-10 | Bill | A-1046 | Office Equipment | desk chair upgrade set | 1,125 | Fixed Asset | Office Equipment | 36 | 0 | Straight Line | 31.25 | 1,093.75 | Agrees |
| 2026-09-11 | Bill | A-1042 | Computer Equipment | 4 27-inch monitors | 980 | Fixed Asset | Computer Equipment | 24 | 0 | Straight Line | 40.83 | 939.17 | Agrees |
| 2026-09-30 | Bill | A-1044 | Vehicles | cargo van deposit | 8,500 | Fixed Asset | Vehicles | 48 | 0 | Straight Line | 177.08 | 8,322.92 | Agrees |
| 2026-10-03 | Bill | A-1045 | Office Equipment | boardroom speaker and microphone set | 760 | Fixed Asset | Office Equipment | 36 | 0 | Straight Line | 21.11 | 738.89 | Agrees |
| 2026-10-24 | Bill | A-1048 | Computer Equipment | 1 ultrawide monitor | 420 | Fixed Asset | Computer Equipment | 24 | 0 | Straight Line | 17.50 | 402.50 | Agrees |
How do you keep a fixed asset register from asset purchases with straight-line depreciation and net book value?
Export your QuickBooks transaction list, account list, and asset life schedule, then load them into the workflow. It matches each buy to the right asset account and schedule, calculates monthly straight-line depreciation, and works out net book value. Rows that match the rules are marked Agrees, and rows that do not are flagged so you can review them.
How it works
How to use the Asset buy check workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the 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.
Asset buy check: questions
What export should you use from QuickBooks?
Use a transaction export for asset purchases and an account list export. You also need your asset life schedule in a spreadsheet file so the workflow can compare each buy to the right rule.
What happens to rows that do not match?
Rows that do not match the rules are kept in the results with a status that shows why they need review. For this workflow, that can include a wrong asset account or a missing source document.
How do you change the rules in words?
Edit the rule text so it names the account types, asset life, depreciation method, and matching conditions you want. Then rerun the workflow so it applies the updated wording to the exported rows.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent
- Code transactions to GL accountsUse exported QuickBooks files to code card and bank transactions to GL accounts, apply vendor rules, and flag rows with no rule.See the workflow Built by the agent
- Deferred revenue scheduleSpread Stripe invoices over service months and track month-end deferred revenue in one workflow.See the workflow Built by the agent
- Map a chart of accounts to a new oneMap a QuickBooks trial balance to a new Xero chart of accounts, then flag unmapped, duplicate, and not mappable accounts.See the workflow Built by the agent
- 1099 vendor payments reportSee what you paid each contractor this year and flag the ones over $600 who need a 1099 and are missing a tax ID, from QuickBooks exports.See the workflow Built by the agent
- Vendor spend analysisEach supplier's spend over the last 12 months, its share, and the change on the 12 beforeSee the workflow Template