Skip to main content

Blog

Working Papers Automation: Complete Guide for Australian Accountants

How to automate working papers creation for tax returns, BAS, and financial statements, so the papers arrive drafted and your time goes into review.

working papers automation, tax return working papers, accounting automation, div7a automation

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 slot

Connect 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)

  1. Choose platform

    • Evaluate MyLedger and alternatives
    • Check compatibility with your software
    • Review security and compliance
  2. Connect data sources

    • Link accounting software
    • Connect authorised ATO data through Fedix's DSP integration
    • Import client list
  3. Configure initial settings

    • Set up account mapping preferences
    • Define calculation methods
    • Configure report formats

Phase 2: Training (Weeks 2-3)

  1. Process 10-15 test clients

    • AI learns your patterns
    • Review and correct initial outputs
    • Refine account mappings
  2. Compare outputs

    • Run parallel with manual working papers
    • Verify calculations
    • Check for edge cases
  3. Build confidence

    • Start with simple clients
    • Progress to complex scenarios
    • Document AI strengths/limitations

Phase 3: Production (Month 2+)

  1. Roll out to all clients

    • Batch by complexity
    • Monitor quality
    • Continue refinement
  2. Optimise workflows

    • Eliminate redundant manual steps
    • Train team on review process
    • Update practice procedures
  3. 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:

  1. Baseline it. Pull your actual hours on working papers for the last financial year, and your rework rate.
  2. Run a batch. Put a representative sample of clients through the automated workflow — including the messy ones.
  3. 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:

  1. Download Excel working paper templates (or start building your own)
  2. Map your 10 most common account codes
  3. Create one automated reconciliation
  4. Test with 3 clients
  5. Expand gradually

If you want AI automation:

  1. Request a demo
  2. Connect your accounting software
  3. Process 5 test clients
  4. Review outputs and refine
  5. 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.

Two ways to start.

Start on a published monthly price. Or take the whole transformation: we migrate your data, rebuild your workflows and train every person in your firm.

Starter

From A$199 + GST / month

For solo practitioners and small teams. Month-to-month, no minimum term. Includes Practice Manager, MyLedger and FediPilot, and four-week onboarding. 14 days free. Card required; your plan is charged on day 14 unless you cancel before then.

Every plan, one price

From A$199

Four plans, priced by the clients on your ATO list, with four onboarding sessions included.

Once you have subscribed, you can download FediPilot for Windows from your Fedix dashboard and sign in with your Fedix account. FediPilot runs on your own ChatGPT or Claude plan, which Fedix does not supply and does not mark up. Training sessions are included and can be booked at any time; they are not a precondition.

30-minute video call with the Fedix founder. Opens in a new tab - pick a time, no account needed.


Related Articles

Stay Updated

Get tips, updates, and industry insights

We email product updates and practice insights. Unsubscribe any time. Privacy Policy