Upgrading a spreadsheet tax record

A workbook that grows one wide sheet per financial year has a specific failure mode: nothing persists across sheets except by copy-paste. An asset bought in one year has no representation in the next. A capital loss carried forward exists only if someone remembers to retype it. Columns drift as categories are added, so formula ranges silently stop covering the rows beneath them.

The fix is to stop organising by year and start organising by entity. Five narrow sheets, each with a stable row identity, where the year becomes a column rather than a tab.

Column names below are suggestions, but the keys matter: asset_id is what makes a device traceable, and label is what makes lodgment mechanical.

This is the test of whether the system works: pick a device bought three years ago and try to answer "what did I claim, on what basis, and where is the proof?" in under two minutes.

For someone who buys hardware regularly, this single rule removes most of the judgement — and most of the error. The test is the item's cost, not the work-related portion. A $1,890 laptop used 70% for work is a $1,890 asset.

Commissioner's effective lives, common items

This is the table that makes lodgment mechanical. Put the label on the row when you enter the expense — while you still remember why you bought it — and the return becomes a series of filtered sums.

Deductions

D11 (foreign pension UPP), D13 (project pool) and D14 (forestry managed investment scheme) exist but rarely apply to a salaried investor.

Income

Item numbers are from the paper return. myTax presents the same questions under plain-language section headings rather than numbers — the mapping is one-to-one, and the numbers remain the stable way to label a spreadsheet row.

Written evidence from the supplier must show five things. A row in your spreadsheet is not evidence of the expense — it is evidence of your calculation, which is a separate requirement.

Where receipts can be skipped

• Total work-related expenses of $300 or less — no written evidence needed, but you must still have spent the money and be able to explain the calculation. Cross $300 and you need evidence for the whole amount. Car, travel allowance and meal allowance claims sit outside this rule.
• Total laundry of $150 or less
• Small expense and hard-to-get receipt exceptions, in defined circumstances

File naming

One convention, applied without exception, is worth more than a clever folder tree:

evidence/
  2025-26/
    A-2026-014-invoice.pdf          ← asset, keyed to the register
    D5-2026-03-14-telco-invoice.pdf ← expense, keyed by label + date
    statements/
      annual-tax-statement-*.pdf
    hours-log-2025-26.xlsx

Digital copies are explicitly accepted, including photographs of paper receipts, provided they are true and clear copies. Records must be in English where the expense was incurred in Australia.

The retention clock is longer than five years

Most people hold "five years" in their head. That is the general rule, but two exceptions matter enormously for a workbook full of devices and shares:

This is why the keep_until column exists in the register. Without it, you are guessing — and the instinct to tidy up old files runs directly against a twenty-year obligation.

So — is iCloud still the right home?

Yes, keep it — but stop treating sync as backup. The ATO's own position is permissive: records may be kept in paper or electronic format, you may use any electronic device or app, and digital copies including photographs are recognised. It then adds one instruction, which is the whole answer to this question: back up your electronic records regularly.

iCloud Drive is a sync service. It propagates every change, including the bad ones. A corrupted workbook, an accidental deletion or a bad formula overwrite replicates to every device you own within seconds — and the "backup" you thought you had is now the same broken file. Sync protects against losing a laptop. It does not protect against losing the data.

The failure mode of any tax workbook is a burst of activity in October reconstructing nine months of memory. These are the only recurring commitments the system needs.

You do not need to rebuild history. You need the current position to be correct and the trail to be recoverable.

1. Create the five sheets empty, in a copy of the workbook. Leave the year tabs untouched as the historical record.
2. Populate assets from the past years' equipment rows. Every item over $300 gets a row, backdated, with its real purchase date and cost. This is the bulk of the work and it is done once.
3. Back-fill depreciation from each asset's purchase date to the current year. Where the original claim was wrong, record what should have happened — the corrected schedule is what the current year's opening values depend on.
4. Record NOA dates in year for every year still potentially open. This tells you which corrections can still be lodged and which are historical only.
5. Enter carried-forward capital losses as recorded in the lodged returns — not as calculated in the old sheets. If the two differ, the lodged figure is what exists.
6. Start the current year clean in the new structure. Do not maintain both shapes in parallel past one year.
7. Snapshot the old workbook read-only and keep it for the full retention period. It is the evidence of what you previously filed.