Workpaper data sources overview

Quick reference table showing which data source feeds each workpaper.

Every workpaper draws from one or more data sources. This table shows what feeds each workpaper, so when something looks wrong you know exactly where to check.

CodeWorkpaperPrimary data sourceType
ACRAccounts ReceivableAged Receivables Summary (Xero)Auto
BRCBank ReconciliationBank Statement / Xero Reconciliation SummaryAuto
FIAFixed AssetsDepreciation Schedule (Xero)Auto
OASOther AssetsCurrent year GL DetailsAuto
PPMPrepaymentsCurrent year GL DetailsAuto
SOHStock on HandCurrent year GL DetailsAuto + manual
Work in Progress (WIP)Work in ProgressCurrent year GL DetailsAuto + manual
OCAOther Current AssetsCurrent year GL DetailsAuto
IISInvestment SharesManual entryManual
OINInvestment Fixed InterestManual entryManual
ACPAccounts PayableAged Payable Summary (Xero)Auto
OCLOther Current LiabilitiesCurrent year GL DetailsAuto
HPLHire Purchase (HP) LiabilityManual entry (requires remapping)Manual
TLNTerm LoanManual entry (requires remapping)Manual
RLPRelated PartiesCurrent year GL DetailsAuto
OICOther IncomeCurrent year GL + manual FBT sectionMixed
SRCSales ReconciliationGRC, ACR, FIA workpapers + current year GLMixed
IICInvestment IncomeMostly manual entryManual
RESResidential RentCurrent year GL (income), manual (expenses)Mixed
ACCAccident Compensation LevyACC invoicesAuto
ACTAccountancyAccountancy invoicesAuto
EXPExpense AnalysisCurrent year GL DetailsAuto
HOMHome OfficeHome Office information in Source DocsAuto
WRCWages ReconciliationWages GL + PAYE Return Summary (IRD)Auto
ENTEntertainmentCurrent year GL DetailsAuto + manual
NDENon-Deductible ExpenseCurrent year GL DetailsAuto
CACCurrent AccountsCurrent year GL (requires remapping)Auto
IOAInterest on Overdrawn Current AccountCAC workpaper + current year GLAuto
GPVGST Period VariancesGRC workpaper + GST GLAuto
GRCGST ReconciliationGST Return Summary (IRD) + GPV + Accounts Receivable (AR) + Accounts Payable (AP)Mixed
POPPurchase of Business/PropertySource Docs (requires remapping)Manual
SOPSale of Business/PropertySource Docs (requires remapping)Manual
TCPTax CalculationsTrial Balance + NDE workpaper + manualMixed
ITDTaxation DueTCP + IIC workpapers + IRD Income Tax Transaction ReportMixed
Imputation Credit Account (ICA)Imputation Credit AccountImputation Credits (IRD) + ITD + DWT SummaryMixed
IREICA to Retained Earnings ReconciliationTCP, ICA, ITD workpapers + manualMixed
SHCShareholdingCompany Extract (Companies Office)Auto

Each workpaper has its own dedicated reference article in this collection covering data extraction, section structure, manual journal behaviour, and balance logic.