Workpapers in HandiLedger Account Ranges and Cell References
Workpapers: Account Ranges and Cell References
The following document lists the available work papers together with their associated
[Tabs] = Form appears in the tab listed
[Alias Range] = Form will be output if any of the alias ranges listed in association with the form are posted to
[Cell Ref] = The alias range associated with a pre-selected X-ref field (note: not all forms have a pre-selected X-ref field)
Job Management Tab
A1 [Matters for Attention of Partner/Principal]
A2 [Items Carried Forward]
A3 [Preparation Guide]
A4 [Accounting Checklist]
A5 [Review Points]
A6 [Queries]
A7 [Notes and Comments]
A8 [Budget]
A9 [Job Tracking & Completion Review & Analysis]
A10 [Matters for Attention of Client]
Tax Tab
C5 [Franking Account and Dividends Paid] , this form is only applicable to Company Tax Tab
C10 [Tax Effect Accounting]
C15 [Losses Carried Forward]
C20 [Income Tax Reconciliation]
C30 [Investment Allowance]
Journal Tab
EJ1 [Journal]
EJ2 [Reversing Journal]
EJ3 [Client Adjustment Journals]
Other Tab
F20 [Livestock Trading Account
Summaries Tab
G10 [Fixed Assets and Depreciation]
G20 [Investments]- AJ
M30 [Revenue Summary]
M35 [Sales and Trading Account Summary]
N20 [Expenses]
N45 [Motor Vehicle Expenses]
Rates Tab
MVR [Motor Vehicle Rates]
TR [Tax Rates]
Other Tab
G25 [Other Non-Current Assets]
G30 [Sale/Purchase of Business or Property]
G31 [Division 7A - Interest and Minimum Repayment Calculator]
H6 [Credit Card Dissection]
H20 [Leases]
N56 [Payroll Tax]
N75 [Superannuation and Workcover]
N56 [Payroll Tax]
Account Driven No Tab
F5 [Accounts Receivable] [Alias Range]: CaTrade; CaProvDD; CaBills; CaAssetsTrust; CaProvDefAsTr; CaListedGovStock; CaListedDeb; CaListedShares; CaListedShareOpt;CaUnlistedSh;CaProvDimShares; CaUnlistedGovSt; CaUnlistedDeb; CaUnlistedShareOp; CaProvDimShOp; CaOtherInv; CaLandAq; CaLandDev; CaLandRates; CaShortDep;CaFITB [Cell Ref] E47 CaTrade F85 CaProvDD
F10 [Bank] [Alias Range] CaBank
F15 [Inventory and WIP] [Alias Range] CaManWIP; CaTradWIP; CaTradFinGoods; CaPpStock; CaFinGoodCost;CaFinGoodNRV;CaTradRaw; CaManRawMat; CaLive; NcaRawMat; NcaWIP; NcaFinGoodCost; NcaFinGoodsVal
F25 [Other Current Assets] [Alias Range] CaOther1; CaOther2 [Cell Ref] C57 CaOther1; CaOther2
F30 [Prepayments] [Alias Range] CaPrep [Cell Ref] F20 CaPrep
F31 [Prepayments - Commercial Bills] [Alias Range] CaPrep [Cell Ref]
F16 CaPrep G5 [Borrowing Costs] [Alias Range] CaLoanDir; CaLoanShar; CaLoanHC; CaLoanOtherRelCo; NcaLoanDir; NcaLoanShar; NcaLoanHC; NcaLoanOtherRelCo; NcaLoanOtherPer; ExpBorrCosts; 1545; 1780
G15 [Intangibles / Blackhole Expenses] [Alias Range] NcaGood-NcaOtherIntAmortB; NcaPrelim; NcaPrelimAmort; ExpAmortNPP; ExpAmortPP
H5 [Accounts Payable] [Alias Range] ClUnTrade; CLSecTradeCr; ClSundry; ClUnBills; ClUnOtherCred; ClUnDeb;ClUnTrustLiab; ClSecBankOdraft; ClSecBills; ClSecOtherCr; ClSecDeb; ClSecTrustLiab; ClSecDiv; ClSecSundryProv; ClTrustProv; ClAdvancePay;ClTrustOther; 2012 [Cell Ref]
F61 ClSundry 2013 [Cell Ref]
F76 ClSundry
H10 [Hire Purchase] [Alias Range] ClUnOtherLoan: ClUnUnexpInt; ClSecOtherLoans2; ClSecUnexpInt; NclUnOtherLoans; NclUnUexpInt; NclSecOtherLoan1; NclSecUnexpInt
H25 [Loans] [Alias Range] ClUnBank; ClUnOtherLoans-ClUnOtherLoan; ClSecBankLoan; ClSecOtherLoans1; NclUnBank; NclUnOtherLoans;NclUnLoanHC-NclUnOther; NclSecBankLoan; NclSecLoanHC-NclSecOtherLoan2
H30 [Other Liabilities] [Alias Range] NclUnDeb; NclUnTrust; NclSecDeb; NclSecTrustLiab; NclDeferredTax-NclTrustOther
H35 [Provisions - Taxation] [Alias Range] ClTaxLiab [Cell Ref]
D30 ClTaxLiab
H40 [Provisions - Leave] [Alias Range] ClEmpEnt; NclEmpEnt [Cell Ref]
G32 ClEmpEnt
L61 NclEmpEnt
J5 [Annual BAS Summary] [Alias Range] ClGST; ClOtherTaxLiabs [Cell Ref]
F26 ClGST
J10 [BAS Monthly or Quarterly Reconciliation] [Alias Range] ClGST; ClOtherTaxLiabs [Cell Ref]
O70 ClGST
J20 [GST Reconciliation] [Alias Range] ClGST
J21 [GST Reconciliation-Quick Method] [Alias Range] ClGST
K5 [Capital] [Alias Range] - Company EqShareCap [Alias Range] - Sole trader/Partnership CapAll [Alias Range] - Trust TCont
K10 [Reserves] [Alias Range] - This form is only applicable to Company EqReserves
M5 [Distributions] [Alias Range] RevDistPartnership; RevDistTrust; RevDistPshipNPP; RevDistTrustNPP
M10 [Dividends] [Alias Range] - This form is only applicable to Company RevDividends; RevUnDividends [Cell Ref]
H45 RevDividends
G45 RevUnDividends
M15 [Interest Received] [Alias Range] RevInterest [Cell Ref]
F37 RevInterest
M20 [Other Income] [Alias Range] RevSales; RevForeignIncome; RevForExch; RevAssetSale; RevRoyalty; RevGovSubsidy; RevPPsNPP; REvRpsNpp; RevHire;RevLease; RevAGIPsNpp; RevFBT; RevNoAbnNPP; RevVolAgreementNPP; RevLabourHireNPP; RevNonOperating;RevOther
M25 [Rental Property] [Alias Range] RevRental; RevRent
N5 [Accountancy] [Alias Range] 1510; ExpAudit; ExpAuditOther [Cell Ref]
C21 1510
C36 ExpAudit
C64 ExpAuditOther
N10 [Donations] [Alias Range] 1645
[Cell Ref]
C44 1645
N15 [Entertainment Expenses] [Alias Range] 1660
[Cell Ref]
O40 1660
N25 [Fines and Penalties] [Alias Range] 1690
[Cell Ref]
C33 1690
N30 [Insurance] [Alias Range] 1060; 1860; 1368; 1755; 1987
N35 [Interest Apportionment] [Tabs]: Other Tab
N40 [Legal Fees] [Alias Range] 1780
[Cell Ref]
C45 1780
N60 [Repairs and Maintenance] [Alias Range] ExpRepairsPP; ExpRepairsNpp; 1430; 1870
N65 [Service Fees] [Alias Range] 1440; 1905
N70 [Subscriptions] [Alias Range] 1765; 1925
N80 [Wages] [Alias Range] ExpSalaryManDirLab; ExpSalaryTradDirLab; ExpSalaryCasualPP; ExpSalaryCommPP; ExpSalaryPP; ExpSalaryCasualNPP; ExpSalaryCommNPP; ExpSalaryDirFees; ExpSalaryDirSal; ExpSalaryNPP; ExpSalaryAssNPP; ExpSalaryWages