Working Papers Automation: Complete Guide for Australian Accountants

# Working Papers Automation: Complete Guide for Australian Accountants 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:** - Direct ATO integration pulls lodged BAS - Auto-reconcile against ledger - Flag discrepancies automatically - Generate reconciliation working paper **What changes:** the lodged BAS comes from the ATO rather than from a spreadsheet someone maintained, and discrepancies are flagged for you instead of being hunted for. ### 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:** - System tracks loan balances automatically - Auto-applies current benchmark rate - Calculates minimum repayments - Generates journals automatically - Updates MYR records **What changes:** the loan balance carries forward on its own, the benchmark rate is applied for you, and the MYR falls out of the calculation instead of being rebuilt 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:** the asset register stays live rather than being re-keyed, and disposals and pooling are handled in the same place as the journals. ### 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:** - Recommend reasonable fees based on profit - 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 (20-40 hours) - Breaks when formats change - Limited to Excel capabilities - Still requires manual data updates **Best for:** Small practices (< 30 clients) wanting quick wins ### Level 2: Practice Management Integration **Tools:** Xero Tax, Class Super, TaxLab **What you can automate:** - Basic ledger-to-return mapping - Some standard working papers - Data flow between systems - Document storage **Pros:** - Professional working papers - Decent automation - Good for simple returns **Cons:** - Priced as a practice subscription -- check current pricing with each vendor - Limited to specific accounting software - Basic automation only - Manual setup per client **Best for:** Medium practices (30-150 clients) with consistent software stack ### Level 3: AI-Powered Full Automation **Tools:** MyLedger (Fedix), emerging AI tools **What you can automate:** - Complete working papers generation - Intelligent data mapping - Complex calculations (div7a, depreciation) - Cross-referencing and validation - Anomaly detection **Pros:** - Working papers arrive drafted, so your time goes into review rather than build - Works with any source data - Learns and improves - 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) **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 to ATO (for BAS/activity statements) - 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 - AI learns from corrections **"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 judgment?"** - Automation handles calculations and data flow - You still apply judgment 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 judgment 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](/contact) 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 judgment **Old skill:** Fast at Excel and data entry **New skill:** Knowing what to review and when to override automation The practices winning in 2024 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](/contact) and see how it handles your actual client data. Generate div7a, depreciation, BAS reconciliation, and more—automatically.