By Fedix team • • 8 min read
If you're still creating working papers manually in Excel for every client, a serious share of your production time is going into work that should be automated. Here's how Australian practices are automating working papers creation.
The Working Papers Problem
Time Breakdown: Manual Working Papers
For a typical company tax return, the manual build is:
- Ledger to return reconciliation
- BAS/GST reconciliation
- Div7a loan calculations
- Depreciation schedules
- MYR records
- Director fees/dividends
Six separate constructions, every one of them rebuilt from scratch, for every company client, every year. We do not publish invented per-task minutes -- pull your own from last year's timesheets and multiply by the number of company returns you do. Whatever that number is, it is the size of the prize.
The Multiplied Cost
Every hour on working papers:
- Is non-billable overhead
- Takes time from advisory work
- Creates review bottlenecks
- Introduces copy-paste errors
- Requires double-checking
What Should Be Automated
1. Ledger to Tax Return Reconciliation
Manual process:
- Export P&L from accounting software
- Copy to Excel template
- Map accounts to tax return lines
- Calculate adjustments
- Check balancing
Automated process:
- Accounting software exports to working papers template
- Auto-mapping based on account codes
- Adjustments calculated automatically
- Real-time balance checking
What changes: the mapping and the adjustments stop being retyped, and the balance check is continuous rather than a step you remember to do at the end.
2. BAS/GST Reconciliation
Manual process:
- Pull GST collected/paid from ledger
- Compare to BAS lodged
- Identify discrepancies
- Calculate reconciliation adjustments
- Document in working papers
Automated process:
- GST is matched against the ATO's records
- The result is summarised for you, ready to carry into your own lodgement software
What changes: GST is matched against the ATO's records rather than a spreadsheet someone maintained, and the summary behind your BAS is ready for your review.
3. Div7a Loan Calculations
Manual process:
- Track opening balance
- Calculate minimum yearly repayment
- Apply benchmark interest rate
- Calculate interest expense/income
- Prepare loan journals
- Update loan register
Automated process:
- Division 7A schedules drafted for your review
What changes: the Division 7A schedule arrives drafted, and your time goes into reviewing it rather than rebuilding it each year.
4. Depreciation Schedules
Manual process:
- Track asset register
- Calculate depreciation method
- Apply diminishing value/prime cost
- Handle disposal calculations
- Update asset register
- Prepare depn journals
Automated process:
- Integrated asset register
- Auto-calculation of depreciation
- Automatic disposal tracking
- Journal auto-generation
- Pooling calculations
What changes: depreciation and amortisation workings arrive drafted for your review rather than being re-keyed.
5. Director Fees and Dividends
Manual process:
- Calculate appropriate director fees
- Prepare fee journals
- Calculate franking credits
- Prepare dividend journals
- Check div7a implications
- Update working papers
Automated process:
- Auto-generate fee journals
- Auto-calculate franking
- Integrate with div7a tracking
- Generate complete working paper
What changes: franking and the div7a interaction are calculated alongside the journals rather than checked separately afterwards.
Automation Approaches
Level 1: Excel Template Automation (DIY)
Tools: Excel, formulas, data connections
What you can automate:
- Data imports from accounting software
- Calculation automation with formulas
- Template standardisation
- Some data validation
Pros:
- Low/no cost
- Full control
- Works with any accounting software
Cons:
- Initial setup time
- Breaks when formats change
- Limited to Excel capabilities
- Still requires manual data updates
Best for: Practices wanting quick wins
Level 2: Practice Management Integration
Tools: for example Xero Workpapers, powered by BGL
What you can automate:
- Compliance work across clients, staff, reporting and tax in one connected experience
Pros:
- One connected experience for compliance work
Cons:
- Check current pricing, and which accounting software each tool works with, with each vendor
Best for: Practices with a consistent software stack
Level 3: AI-Powered Full Automation
Tools: MyLedger (Fedix), emerging AI tools
What you can automate:
- Division 7A schedules, depreciation and amortisation workings, and tax adjustment papers, drafted for your review
Pros:
- Working papers arrive drafted, so your time goes into review rather than build
- Bank statements, PDFs, Excel files and screenshots turned into a drafted ledger
- Learns your coding patterns
- Calculations are prepared for you to check
Cons:
- Newer technology
- Requires initial training period
- May need review of AI decisions initially
Best for: Practices wanting maximum automation
Implementation Guide: Excel Template Automation
If you're starting from scratch, here's how to build automated working paper templates:
Step 1: Create Master Templates (Week 1)
Individual tax return template:
- Income reconciliation sheet
- Deduction categories
- Offset calculations
- CGT schedule
- Rental property schedule
Company tax return template:
- P&L reconciliation
- Balance sheet reconciliation
- Div7a tracking
- Franking account
- Loss recoupment
Step 2: Add Data Connections (Week 2)
Ready to transform your practice?
Built and run every day by Tax7, an Australian accounting practice. Fedix prepares the work - you review and sign.
Book a 30-min practice review (opens the Fedix booking page in a new tab)Prefer to write? Contact us about a demo instead of booking a slotConnect to accounting software:
- Use CSV exports if no API
- Power Query in Excel for automatic refresh
- Map account codes to template sections
- Set up refresh schedule
Step 3: Build Calculation Logic (Week 3)
Automate calculations:
- Tax depreciation formulas
- Div7a minimum repayments
- Franking credit calculations
- BAS reconciliation logic
- Adjustment calculations
Step 4: Add Validation Checks (Week 4)
Error detection:
- Balance checks (debits = credits)
- Ratio checks (flags unusual amounts)
- Completeness checks (all required fields filled)
- Cross-reference checks (ledger to return balancing)
Step 5: Test and Refine (Week 5-6)
- Test with 5-10 real clients
- Compare to manual working papers
- Fix errors and edge cases
- Document usage instructions
Time investment: building your own templates is a real project, not an afternoon -- budget for it properly, and track the hours as you go so you can work out your own payback against the hours you save.
Implementation Guide: AI-Powered Automation
For practices ready to adopt AI tools:
Phase 1: Setup (Week 1)
-
Choose platform
- Evaluate MyLedger and alternatives
- Check compatibility with your software
- Review security and compliance
-
Connect data sources
- Link accounting software
- Connect authorised ATO data through Fedix's DSP integration
- Import client list
-
Configure initial settings
- Set up account mapping preferences
- Define calculation methods
- Configure report formats
Phase 2: Training (Weeks 2-3)
-
Process 10-15 test clients
- AI learns your patterns
- Review and correct initial outputs
- Refine account mappings
-
Compare outputs
- Run parallel with manual working papers
- Verify calculations
- Check for edge cases
-
Build confidence
- Start with simple clients
- Progress to complex scenarios
- Document AI strengths/limitations
Phase 3: Production (Month 2+)
-
Roll out to all clients
- Batch by complexity
- Monitor quality
- Continue refinement
-
Optimise workflows
- Eliminate redundant manual steps
- Train team on review process
- Update practice procedures
-
Measure results
- Track time savings
- Monitor error rates
- Calculate ROI
Time investment: allow a few days to set your templates up properly.
Working Out Your Own Numbers
We do not publish invented case-study figures. Work out your own, from your own timesheets:
- Baseline it. Pull your actual hours on working papers for the last financial year, and your rework rate.
- Run a batch. Put a representative sample of clients through the automated workflow — including the messy ones.
- Compare. Hours per client before vs after, and how much of the reviewer's time went to genuine judgement calls rather than construction.
What automation reliably changes is where the hours go: away from building the paper, toward reviewing it. How large that shift is depends on your client mix, source-data quality and how consistently your team codes.
Quality Control with Automation
Common Concerns
"What if the automation makes mistakes?"
- Start with simple clients and verify outputs
- Run parallel with manual for first 10-20 clients
- Build review checklist for automated outputs
- Every pre-coded line is still yours to review and approve
"How do I know what to review?"
- Focus review on unusual amounts/ratios
- Check system-flagged items
- Spot-check calculations periodically
- Review edge cases more thoroughly
"What about professional judgement?"
- Automation handles calculations and data flow
- You still apply judgement on treatments
- Complex issues still require professional assessment
- Think of automation as smart assistant, not replacement
Review Checklist for Automated Working Papers
☑ Balance checks passed (ledger to return) ☑ Unusual items flagged and reviewed ☑ All required sections completed ☑ Cross-references correct ☑ Prior year comparison reasonable ☑ Complex calculations verified (div7a, depn) ☑ Professional judgement applied where needed
The checklist is the same either way. What changes is that with automation you are checking a paper someone else built rather than building it yourself -- time one of each in your own practice if you want the comparison in your own numbers.
Getting Started This Week
If you want DIY automation:
- Download Excel working paper templates (or start building your own)
- Map your 10 most common account codes
- Create one automated reconciliation
- Test with 3 clients
- Expand gradually
If you want AI automation:
- Request a demo
- Connect your accounting software
- Process 5 test clients
- Review outputs and refine
- Roll out to production
Either way:
- Start small (5-10 clients)
- Run parallel with manual initially
- Measure time savings
- Expand based on results
The Automation Mindset Shift
Old thinking: "Working papers are just part of the job" New thinking: "Any repeated calculation should be automated"
Old workflow: Accountant creates everything manually New workflow: Automation generates, accountant reviews and applies judgement
Old skill: Fast at Excel and data entry New skill: Knowing what to review and when to override automation
The practices that do well aren't working harder—they're automating smarter and focusing their expertise where it actually adds value.
Ready to automate your working papers? Book a walkthrough of MyLedger's automated working papers and see how it handles your actual client data. Division 7A schedules, depreciation and amortisation workings, and tax adjustment papers, all drafted for your review.
Updated 16 November 2026 to reflect current rates and rules.