Effective tracking and journaling let you record each capital‑gain transaction, calculate the net gain, and prove eligibility for the Australian pension exemption. Use a simple spreadsheet or dedicated app, keep supporting documents, and review quarterly to stay compliant.
Understanding the CGT Pension Exemption
The Australian government allows a pension income test exemption if your net capital gains stay below a set threshold. This threshold is reviewed each financial year and applies to assets sold after you turn 60. Knowing the exact limit helps you plan your investment sales.
For beginners, the key is to differentiate between capital gains that are taxable and those that can be offset by losses. Only the net gain after offsets counts toward the exemption limit.
Core Principles of Tracking and Journaling
Accurate records start with a clear naming convention for each asset. Include the purchase date, acquisition cost, sale date, sale proceeds, and any associated costs such as stamp duty or broker fees.
Every entry should also note the purpose of the asset – whether it is an investment, a personal use asset, or a business‑related purchase – because this affects how the gain is treated.
Step‑by‑Step Setup
- Gather all purchase and sale documents, including contracts, statements, and receipts.
- Create a master ledger – a spreadsheet works well – with columns for Asset, Purchase Date, Sale Date, Cost Base, Proceeds, Fees, Net Gain, and Notes.
- Enter each transaction as soon as it occurs. Use consistent date formats (DD/MM/YYYY) and currency symbols.
- Calculate the net gain for each asset by subtracting the total cost base (including fees) from the sale proceeds.
- At the end of each quarter, sum all net gains and compare the total to the current exemption threshold.
- Store digital copies of all supporting documents in a cloud folder labeled by year and asset type.
Following these steps ensures you have a ready‑to‑submit audit trail if the ATO requests proof of your exemption claim.
Tools & Templates
Several options exist for maintaining your journal. Choose the one that matches your comfort level and budget.
| Feature | Cost | Ease of Use |
|---|---|---|
| Spreadsheet (Excel/Google Sheets) | Free‑to‑low | High – customizable |
| Accounting software (Xero, QuickBooks) | Subscription | Medium – requires setup |
| Dedicated CGT app (e.g., Capital Gains Tracker) | One‑time or subscription | High – built‑in formulas |
If you prefer a no‑cost solution, start with a Google Sheet and use the template provided in the appendix. For those who already use accounting software, enable the capital gains module to automate calculations.
Ongoing Maintenance Tips
- Review your journal after every major market move or portfolio rebalance.
- Set calendar reminders for quarterly checks.
- Keep a separate folder for any capital‑loss carry‑forwards, as they can reduce future gains.
Staying disciplined with these habits reduces the risk of missing the exemption threshold and saves time during tax time.
Frequently Asked Questions
What records are required for the CGT pension exemption?
You need purchase contracts, sale agreements, broker statements, and receipts for any costs that form part of the cost base. Digital copies stored securely are acceptable to the ATO.
How often should I update my journal?
Update it as soon as a transaction occurs, and perform a full review at least once each quarter to ensure the net gain stays within the exemption limit.
Can I use a simple spreadsheet instead of professional software?
Yes. A well‑structured spreadsheet can meet all reporting requirements if you include the necessary columns and retain supporting documents.