Skip to content

SPEC-012: Fixed asset reconciliation ​

APPROVED 2026-10-08 by the Product Owner (goal: market readiness).

Built state (2026-11-02, issue #223): slice 1 (S1 to S9, S11) is built as fixed_assets_check (PR #232), and S12 to S14, added from the Product Owner's real-data run on FEAW, are built (PRs #233 and #234). Tested by scenario name in tests/rules/fixed-assets.test.ts, tests/xero/fixed-assets.test.ts, tests/mcp/fixed-assets-tools.test.ts and tests/present/fixed-assets.test.ts. S10 (correction through an approval card) is a later slice and is not built.

Business intent ​

At year end the accountant or the owner has to be sure that Xero's fixed asset register agrees with the fixed asset balances in the ledger, that capital purchases have not been expensed (and the reverse), and that depreciation has been run. A mismatch distorts profit, Corporation Tax and the accounts. Today nobody watches this between year ends. This slice is a read-only check that shows the gap early, with evidence, so Rob can decide the coding.

User story ​

When I ask whether the fixed assets are right for a company and period, I want the register compared with the balance sheet, any capital-looking purchases coded to expenses (and the reverse) listed with evidence, and whether depreciation has been run, so I know what to put to Rob before year end.

Scope (slice 1, read-only) ​

  • Read Xero's fixed asset register (Xero Assets API): registered assets with cost, accumulated depreciation, book value, and the asset type each belongs to. Asset types name the fixed asset (cost), accumulated depreciation and depreciation expense accounts.
  • Read the balance sheet at the period end for those cost and accumulated depreciation accounts.
  • Compare, per asset type and in total, in integer pence: register cost vs cost account balance; register accumulated depreciation vs accumulated depreciation account balance. Any difference is reported with its sign and the accounts involved.
  • Flag possible capital purchases coded to expense accounts: bills and bank transactions in the period at or above the threshold (QD-36: £500 per company, a flag level only) on accounts that are not fixed asset accounts, where the account, supplier or description suggests equipment (computers, furniture, vehicles, machinery). Show date, supplier, gross and net, account, and the evidence for the flag.
  • Flag the reverse: postings to fixed asset cost accounts below the threshold, or items that look like running costs (repairs, subscriptions, software licences), as possible expenses coded as assets.
  • Flag registered assets not in the ledger (no matching cost posting), and cost-account postings with no register entry.
  • Report depreciation for the period: assets with depreciation posted, assets with none although the policy says they should, and the last period run.
  • Summarise first: headline, then differences, flags, depreciation status.
  • All figures come from code in src/rules/, never from a language model. Money is integer pence (ADR 0025).

Out of scope ​

  • Any write: registering, disposing, depreciating, recoding, journals. A later slice (S10 below, not built in slice 1) may propose corrections through an approval card under ADR 0016 guards.
  • Entering a depreciation policy by hand: the policy is read from Xero's fixed asset settings (QD-38).
  • Deciding capitalisation policy or capital allowances (annual investment allowance, writing down allowances). Corporation Tax is post-MVP (CAP-02.4).
  • Running depreciation (Xero does this in its own UI).
  • Companies without Xero fixed assets enabled: reported as "not set up".
  • Non-GBP, foreign currency assets (the register itself). Foreign-currency purchases are read: see S14.

Integration sketch ​

Existing scopes (src/xero/session.ts) cover accounts, invoices, bank transactions and settings but not assets or the balance sheet. Needs:

  • New scope assets.read (Xero Assets API, GET /assets.xro/1.0/Assets, /AssetTypes, /Settings). A reconnect per entity is needed. Fixed assets needs a Xero plan that includes it (FEAW is on Comprehensive; check WealthTechPros). Verify the exact scope name in Xero's developer portal before build; Xero has changed scope names in 2026.
  • New scope accounting.reports.balancesheet.read for GET /Reports/BalanceSheet, already planned in docs/plans/management-reporting.md. Do both in one reconnect with that plan (and with the scopes SPEC-013 may add). The trial balance scope is an alternative if the balance sheet report is awkward by account.
  • Depreciation policy comes from Xero (QD-38). The check reads each company's asset types, depreciation method and rate, and the asset, accumulated depreciation and expense accounts from Xero's fixed asset settings via the Assets API. If none are set up it says so and asks the owner or accountant; it never invents a policy.
  • Xero's Assets API reads the register but has no endpoint to run depreciation, so slice 1 infers "run" from depreciation postings and the register's accumulated depreciation, and says so.
  • src/xero/ fetches; src/rules/ compares (pure); src/mcp/ presents.

MCP tools sketch ​

ToolReturns
fixed_assets_checkFor one entity and period end: register vs balance sheet by asset type, capital-vs-expense flags with evidence, depreciation status. Read-only

Tool replies start with a summary built by code (SPEC-011 conventions).

Scenarios ​

S1: Register agrees with the balance sheet ​

Given a Xero register with assets of cost £4,200.00 and accumulated depreciation £700.00 under asset type "Computer equipment" And the cost account balance is £4,200.00 and accumulated depreciation £700.00 at the period end When the check runs Then both comparisons show a difference of £0.00 and the headline says the register agrees

S2: Cost differs ​

Given the register cost for "Computer equipment" is £4,200.00 and the cost account balance is £5,000.00 When the check runs Then the difference of £800.00 (ledger higher) is shown with both accounts And no figure is calculated by a model

S3: Accumulated depreciation differs ​

Given register accumulated depreciation £700.00 and ledger £400.00 When the check runs Then a difference of £300.00 (register higher) is shown, with the last period depreciation was posted

S4: Capital purchase coded to an expense account ​

Given the threshold is £500.00 And a £1,299.00 bill from a computer supplier coded to "Office Expenses" in the period When the check runs Then it is listed as a possible capital purchase with date, supplier, gross, net, account and why it was flagged And it is not changed

S5: Below the threshold is not flagged ​

Given the threshold is £500.00 and a £120.00 keyboard coded to "Office Expenses" When the check runs Then it is not flagged

S6: Expense coded as an asset ​

Given a £60.00 software subscription posted to a fixed asset cost account When the check runs Then it is listed as a possible expense coded as an asset, with the evidence

S7: Asset in the register but not in the ledger ​

Given a registered asset with cost £900.00 and no posting to its cost account in or before the period When the check runs Then the asset is listed as "in register, not in ledger"

S8: Depreciation not run ​

Given registered assets with a depreciation rate and no depreciation posted for the period When the check runs Then they are listed as "no depreciation for the period" with the last period posted

S9: Fixed assets not set up, or scope missing ​

Given the entity has no fixed assets in Xero, or has not granted the new scopes When the check runs Then it says "not set up" or tells the owner to reconnect Xero, and checks nothing rather than reporting a clean result

S10 (later slice, not slice 1): Correction through an approval card ​

Given the check flagged a capital purchase coded to an expense account When the owner asks to fix it Then a preview (reclassification journal) is shown in an approval card And only the owner's Approve makes the write, under ADR 0016/0017 guards, with the reason logged

S11: Companies are isolated ​

Given two companies connected When the check runs for one Then only that entity's register and ledger are read (CLAUDE.md rule 4)

S12: Fixed asset lines on the balance sheet with no register entries (Product Owner, 2026-10-08, real-data check) ​

Given the balance sheet's Fixed Assets section shows Buildings £6,611.00, Office Equipment £14,318.09, "Less Accumulated Depreciation on Office Equipment" £1,907.59 and "Loan to Get My Books Ltd" £52.00 And no register asset type uses any of those accounts When the check runs Then each is listed as "on the balance sheet but not in the register" with its balance, saying whether it is a cost or accumulated depreciation And "Loan to Get My Books Ltd", whose account type in the chart is not a fixed asset, is also flagged "probably not a fixed asset: check its account type" And an account whose type is not in the chart is listed but not flagged, and accounts that are zero or used by a register asset type are not listed And the headline does not say the register agrees without mentioning them

S13: Manual journals on asset accounts are read and listed (Product Owner, 2026-10-08, real-data check) ​

Given posted manual journals dated in the period with lines on a fixed asset cost or accumulated depreciation account, for example "Transfer of office equipment" debiting Office Equipment £1,200.00 And a draft or voided journal on the same account When the check runs Then only the posted journals are listed under "Manual journals on asset accounts" with date, narration, account, whether it is cost or accumulated depreciation, and the amount as a debit or credit And the range read is stated (the period only: journals before the period are not read) And a journal debit to a cost account counts as a posting when matching registered assets, so an asset bought by journal is not reported as "in register, not in ledger" And a journal debit that matches no asset is only listed, not reported as a purchase missing from the register And if Xero refuses the manual journals read, the check says journals were not read rather than failing

S14: Foreign-currency purchases are converted, not skipped (Product Owner, 2026-10-08, real-data check) ​

Given a bill or spend money in USD whose own CurrencyRate is 1.25 (USD per £1), with a line of USD 1,000.00 coded to an expense account with an equipment supplier When the check runs Then the line is converted to GBP pence as amount divided by rate (£800.00) using integer arithmetic, the £500 threshold and the asset-account matching are applied to the GBP figure, and the flag shows the original currency amount and the rate And the reply says how many purchases were converted, by currency And a foreign-currency document with no usable rate is not converted, and is counted as skipped

Decisions (all closed 2026-10-08) ​

  • QD-36: capitalisation threshold £500, one figure per company, a flag level only. Rob to confirm if he disagrees.
  • QD-37: assets.read and the balance sheet report scope approved; one reconnect per company.
  • QD-38: policy and accounts are read from Xero's fixed asset settings; if none, say so and ask the owner or accountant.