Workpaper Reference

Australia Workpapers

Bank Reconciliation workpaper (BRC)How BRC matches bank statements to GL accounts, and how the closing balance is picked from the statement.
Account Receivables workpaper (ACR)How Account Receivables is populated from an Aged Receivables report or a client PDF, with and without a separate GST column.
Accounts Payable workpaper (ACP)How Accounts Payable is populated from an Aged Payables report or a client PDF, including handwritten reports.
Prepayments workpaper (PPM)How PPM is populated from an invoice, and how the system prompts for a prepayment calculation from the GL when no invoice is available.
Accountancy Fees workpaper (ACT)How Accountancy Fees is built line by line from invoices or credit notes, and the specific exclusions that need human review.
GST Reconciliation, Accruals workpaper (GRC)How GRC reconciles quarterly GST reports against lodged BAS figures, on an accruals basis.
Salary & Superannuation Reconciliations (WRC)How WRC cross-checks payroll, GL, and lodged BAS/STP figures month by month.
Investment Schedule workpaper (IIC)How each share holding is tracked year on year, including reinvestment, disposals, and the capital gain/loss classification.
Borrowing Costs workpaper (BCN) How each loan's borrowing costs are tracked separately, carried forward or freshly extracted from the finance invoice, and amortised.
GST Reconciliation, Cash workpaper (GRCC)The cash-basis equivalent of GRC, including the debtors/creditors GST adjustment specific to cash-basis clients.
Formation Cost workpaper (FCO)How Formation Cost is extracted from the setup invoice and amortised, including the case where amortisation began in an earlier year.
Rental Summary workpaper (RSS)How RSS is populated month by month from a property manager report, or annually from the Trial Balance, plus the depreciation figures from a BMT schedule.
Inter Entity Loan Reconciliation workpaper (IRN)How IRN matches a related-party loan between the client's own Trial Balance and the related party's, and the sign convention used to normalise both sides.
Hire Purchase & Lease Summary workpaper (HPSA)How HPSA extracts finance document terms, and how the interest rate is derived using a Goal Seek calculation rather than read directly.
Hire Purchase & Lease Schedule workpaper (LSC)How LSC splits an HPSA-tracked liability into its current and non-current portions from the Trial Balance.
Division 7A, [Year] Calculation workpaper (D7L-XX)The per-year Division 7A loan calculation, including the minimum-repayment logic and its exceptions for credit-balance loans.
Employee Contribution Schedule workpaper (EMC)How EMC carries forward a motor vehicle's FBT details year on year, and the fields that always require human input.
Capital Gain workpaper (CG)How CG determines whether a settlement statement relates to a purchase or a sale, then builds out the cost base from each side's costs.
Livestock Reconciliation workpaper (LST)How LST tracks livestock numbers and values by category, sourced from prior-year published financials and current-year GL detail.
Stock on Hand workpaper (CLS)How Stock on Hand is populated from an Inventory Item Summary, a client-provided document, and the separate Work in Progress section.
Bank Loans workpaper (BLC)How BLC matches a bank loan statement to the correct GL account, and the major-bank keyword list used to find it.
Fixed Assets workpaper (FIA)How FIA is built by asset category from the Depreciation Schedule, and the specific rules for additions and disposals, including motor vehicles above and below the ATO cost limit.
Other Income workpaper (OTI)How Other Income sweeps up any income account not already covered by a dedicated workpaper.
Other Expenses workpaper (OTE)How Other Expenses groups multiple Xero account codes under a single Zato parent code, with a worked example.
Other Assets workpaper (OTA)How Other Assets sweeps up any asset account not already covered by a dedicated workpaper.
Other Liabilities workpaper (OTL)How Other Liabilities groups accounts by parent code, and further splits by individual name where the parent code represents more than one person.
Superannuation Payable workpaper (SPP)How SPP tracks superannuation payable by quarter, including the fixed 28-day due date rule.
Taxable Income Calculation – Partnership workpaper (TTC)How TTC reconciles a partnership's accounting profit to taxable income and distributes both between the partners.
Trust Tax Reconciliation workpaper (TSA)How TSA reconciles a trust's accounting profit to taxable income and distributes both between beneficiaries.
ATO Prefills workpaperHow the ATO Prefills workpaper captures the information the ATO provides for each individual, and passes it to the other ITR workpapers.
Rental Property workpaperHow the Rental Property workpaper calculates each property's net rental result and allocates it to the owners.
CGT Property/Business workpaperHow the CGT Property/Business workpaper calculates the capital gain or loss on disposing of a property or business asset.
Sole Trader Business (ABN 1) workpaperHow the ABN 1 workpaper calculates a sole trader's net business profit or loss from GST-inclusive income and expenses.
Deductions workpaperHow the Deductions workpaper calculates each D1–D15 deduction category and Total Deductions.
Interest Income (Client Information) workpaperHow to record interest income and TFN withholding provided by the client that is not already in ATO Prefills.
Dividend Income workpaperHow the Dividend Income workpaper combines dividends from ATO Prefills, related entities and the client, and checks franking credits.
Trust Income workpaperHow the Trust Income workpaper records the taxable, tax credit and non-taxable parts of each trust distribution.
CGT Summary workpaperHow the CGT Summary combines all capital gains and losses, applies losses, discounts and concessions, and calculates the net capital gain.
Individual Tax Return Summary workpaperHow the ITR Summary brings every ITR workpaper together and calculates the amount payable or refundable.
Accounting Fees workpaperHow the Accounting Fees workpaper records accounting and tax fees, allocates them to each entity or individual, and feeds D10.
Other Client Info workpaperHow to record client-provided income that does not come from ATO Prefills or another dedicated workpaper.
Client Files: What Comes Through and What to Upload (AU)Which files arrive automatically from each integration, and what to upload when it is not connected.