"Excel Payroll Tax Return Workpapers Preparation Templates - Excel"
u Content Update Log u Electronic Workpapers as @ 2/3/2011 Content Release Document Title Section Document Type Description of changes Type of Update Update No. Date 82 Jan-11 Business Fitness Coaching Library Business Advisory Form Link added, 5.36b; broken hyperlink fixed, 21.14 Enhancement 82 Jan-11 Business Fitness Forum Administration Procedure No longer required Deletion 82 Jan-11 Business Forward Issue 50 Knowledge Base Other Business Advisory Newsletter for providing to clients, Issue 50 Addition 82 Jan-11 Company Administration Review Checklist Compliance Checklist Document type corrected Enhancement 82 Jan-11 Debtors Days Outstanding Calculator Business Advisory Form Form to give a client to calculate cashflow improvements in relation to Addition improved debtor management 82 Jan-11 Fund Raising by Private or Non Listed Public Companies Business Advisory Report Not relevant to New Zealand Deletion 82 Jan-11 Fund Raising by Private or Non Listed Public Companies PPT Business Advisory Presentation Not relevant to New Zealand Deletion 82 Jan-11 WebPractice - Newsletters Administration Procedure No longer required Deletion 81 Dec-10 Accounting Systems Evaluation Business Advisory Procedure Keywords updated Enhancement 81 Dec-10 Balance Dates for Kiwifruit Orchardists FAQ Procedure Frequently asked question from clients on IRD public consultation on Addition industry specific balance dates for kiwifruit orchardists 81 Dec-10 Balance Dates for Kiwifruit Orchardists Report FAQ Report Report on IRD public consultation on industry specific balance dates for Addition kiwifruit orchardists 81 Dec-10 Balance Dates for Kiwifruit Orchardists Script FAQ Script Script to advise clients on IRD public consultation on industry specific Addition balance dates for kiwifruit orchardists 81 Dec-10 BNI New Zealand Professional Bodies & Weblink Link to BNI NZ, a business and professional networking organisation Addition Govt Depts 81 Dec-10 Business Forward Issue 49 Knowledge Base Other Business Advisory Newsletter for providing to clients, Issue 49 Addition 81 Dec-10 Company Administration - Review Compliance Sub Procedure Updated link to engagement letter Enhancement 81 Dec-10 Company Administration Review - Engagement Letter Compliance Letter Engagement letter to a client for our annual company administration Addition review service 81 Dec-10 Company Administration Service Review Compliance Letter Replaced by Company Administration Review - Engagement Letter Deletion 81 Dec-10 Engagement Letter Compliance Letter Formatting adjustment Enhancement 81 Dec-10 Engagement Letter - Trust Risk Review Compliance Letter Minor text changes Enhancement 81 Dec-10 Income Equalisation Deposit & Refund Adverse Event letter Compliance Letter Letter to IRD to deposit and request immediate refund in the case of an Addition adverse event 81 Dec-10 Income Equalisation Deposit (IED) Scheme Compliance Guide Updated for tax changes Enhancement 81 Dec-10 Income Equalisation Deposit letter Compliance Letter Updated address Enhancement 81 Dec-10 Income Equalisation Deposit Scheme Compliance Procedure New step 8 and links added to IR155 and new letter Enhancement 81 Dec-10 Income Equalisation Deposit Scheme Cost Benefit Calculator Compliance Form Updated for tax changes and reformatted Enhancement 81 Dec-10 Institute of Directors NZ Professional Bodies & Weblink Link to the Institute of Directors in New Zealand (Inc) Addition Govt Depts 81 Dec-10 NZ Chamber of Commerce - Public Holidays Industry Resources Weblink See Department of Labour site NZ public holiday dates 2010-2013 in Deletion general links 81 Dec-10 Public Holidays and Closedown Periods FAQ Procedure Updated links for public holidays and Department of Labour advice on Enhancement close down periods 81 Dec-10 Public Holidays Script FAQ Script Updated for 2011 Enhancement 81 Dec-10 Small Business Tax Simplification Industry Resources Weblink Link to more information on report by NZICA and Tax Management NZ Addition proposing tax simplification for small business 81 Dec-10 Trust Administration - Set Up Compliance Sub Procedure Hyperlinks fixed Enhancement 81 Dec-10 TSB Bank Weblink Link to TSB Addition 87220fbc-c6e9-4e8b-80d5-dbee3068993c.xls Page 2 of 5 Content Release Date Sheet Name Cell Reference Release Notes Update No. 78 Nov-10 Changes to Electronic Workpapers (Integrated and Static) 78 Nov-10 A1 tax calculations Added functionality to A1 to allow account names and values to pull in based on account codes as in B1 (Integrated only) 78 Nov-10 A1 tax calculations K39 Added taxable income subtotal 78 Nov-10 A1 tax calculations B46 Updated text at row 46 to "losses brought forward" 78 Nov-10 A1 tax calculations K49 Updated formatting to 2 dp 78 Nov-10 A1 tax calculations Added checkbox to bottom of A1 sheet to prevent sheet automatically reprotecting (integrated only) 78 Nov-10 A2 trust distribution O36 Updated formula in O36 to include non-FIF income (overseas) in gross trustee income 78 Nov-10 A2 tax planning N35 Updated formula at N35 to be the sum of the row 78 Nov-10 adj sheet B65,B35 Added formulas to text to clarify whether clients are to add or subtract figures on their gst returns 78 Nov-10 adj sheet H74 Reformatted cell H74 to 2 decimal places 78 Nov-10 B1 review summary Updated formula to show items as reconciled if within $1 78 Nov-10 B1 review summary unmerged columns for prepared by and reviewed by to allow for word wrapping 78 Nov-10 B1 review summary G127 Updated formula on B1 to show Dividends net of imputation credits 78 Nov-10 B1 review summary links added to P2.1-5 in current and non-current liabilities section 78 Nov-10 B1 review summary links added to N6-10 in current accounts and advances section 78 Nov-10 Moved narrations to narration column rather than underneath journal entries for automatically created journals D1 wp journals (integrated only) 78 Nov-10 D1 wp journals Updated narrations for automatic journals to use balance date from work bench (integrated only) 78 Nov-10 D2 GST exclusive journals, New journal sheets added for GST inclusive and GST exclusive journals. GST inclusive journals calculate GST D3 GST inclusive journals automatically based on GST indicator in accounting database (integrated only) 78 Nov-10 D1 wp journals, D2 GST exclusive journals, D3 GST inclusive journals Journal numbering system updated to differentiate between three different journal workpapers (integrated only) 78 Nov-10 D1 wp journals, D2 GST exclusive journals, D3 GST Due to update of CSV file requirements for MYOB AO - column for ext_perd (period) is now populated by work inclusive journals papers. (integrated only) 78 Nov-10 D4 trial balance Added note on Trial Balance, informing user if no P & L data exists (integrated only) 78 Nov-10 D4 trial balance D2 trial balance renamed to D4 trial balance 78 Nov-10 F1 bank rec N3 Adjusted column width for F1 cheat sheet to accommodate date 78 Nov-10 G1 farming G1 - farming sheet added. Includes dairy company split off. 78 Nov-10 G2 other current assets Rows 49-57 Added 9 more rows to other current assets section 78 Nov-10 General Button added to link back to B1 on all sheets 78 Nov-10 General Header image removed from each sheet and replaced by plain text formula 78 Nov-10 General Updated import data select statement to remove leading space from account codes (integrated only) 78 Nov-10 General Updated functionality to prevent COA sheet from appearing when refresh button clicked (integrated only) 78 Nov-10 K other assets K current assets worksheet added 78 Nov-10 L1 GST rec L42,L43 Updated formulas at L42,L43 to include values from F1 - F5 78 Nov-10 L1 GST rec Unlocked all relevant cells in adjustment section of L1 78 Nov-10 L1 GST rec Reformatted cheat sheet to show all data when rows hidden 78 Nov-10 L1 GST rec L106 Updated ledger total to calculate independently of B1 (integrated only) 78 Nov-10 L2 GST period variances Reduced variance from $100 to $20 before L2 variance is visible 78 Nov-10 M1 accounts payable Updated print area to include total row 78 Nov-10 N1 - N10 current account Text added to B30 “Salary/Distribution/Profit share” 78 Nov-10 N1 - N10 current account B12, B33 Text updated from less funds intro to plus funds into and from plus drawings to less drawings 78 Nov-10 M2 other current liabilities New M2 worksheet added for other current liabilities 78 Nov-10 O term loans lead sheet Lead sheet added for term loans 78 Nov-10 O6-10 term loan 5 more term loan sheets added 78 Nov-10 O1-10 term loan Section added to calculate private and business portion 78 Nov-10 O1-10 term loan J9 Updated formatting at J9 Electronic Workpapers.xls and Electronic Workpapers Farmers.xls Page 3 of 5 Content Release Date Sheet Name Cell Reference Release Notes Update No. 78 Nov-10 O1-10 term loan Added ability to have 12, 26 or 52 pay periods in a year 78 Nov-10 P hire purchases lead sheet Lead sheet added for hire purchases 78 Nov-10 P1.1-5 hire purchase Sheet numbers updated from P1-5 to P1.1-5 78 Nov-10 P1.1-5 hire purchase Updated Vlookup formulas to search for exact date matches only 78 Nov-10 P1.1-5 hire purchase B21 Updated formula at B21 from + 366 to + 365 78 Nov-10 P2.1-5 HP liability J15 Updated comment to show method of using autosum on protected sheet (alt =) 78 Nov-10 P2.1-5 HP liability Added goal seek button 78 Nov-10 Q3 ICA rec IT L61 Updated formula in L61 to be minus L58 78 Nov-10 Q3 ICA rec IT I20,I21 Protection removed from cells I20,I21 and comment added regarding non-standard balance dates 78 Nov-10 Q3 ICA rec IT Removed comment about entering ICA opening balance as a negative 78 Nov-10 Q3 ICA rec IT L32,J32 Removed -1 from formula in other debits line 78 Nov-10 Q3 ICA rec IT F39 text updated to remove "excluding those for LAQC & attributed to shareholders" 78 Nov-10 Q3 ICA rec RE row 42 Loss carried forward line added back 78 Nov-10 Q4 continuity of shareholding Continuity of shareholding reinstated 78 Nov-10 R other liabilities R current liabilities worksheet added 78 Nov-10 T2 other income First (orange) row of each Other Income box is now unprotected 78 Nov-10 U1 wages Updated formula for months to account for non-standard balance dates 78 Nov-10 V1 expenses row 31 Row added in entertainment section to allow for 100% deductible entertainment expenses 78 Nov-10 Entertainment section amended to reflect the fact that GST adjustments are not tax deductible + amended formula V1 expenses for GST adjustment 78 Nov-10 V3.1-10 interest on CA E49 Updated formula at E49 to include 4th quarter 78 Nov-10 V3.1-10 interest on CA Updated formula at L17 from =IF(L33<0,L33,0) to =IF(L33<0,-L33,0) 78 Nov-10 V3.1-10 interest on CA L22, L34 Updated formula to =IF(intAsCalc<5000,0,ROUND(intAsCalc * rwtRate,2)) if RWT is selected 78 Nov-10 V4 private use Updated formatting of 2nd vehicle calculation section 78 Nov-10 work bench Tick boxes added to compilation section 78 Nov-10 work bench Shading removed from name and ird no. fields on workbench (integrated only) 78 Nov-10 work bench Added functionality to fit screen button to put buttons back in correct position if out of place 78 Nov-10 Changes to Dividend Electronic Workpapers 78 Nov-10 ICA retained earnings + ICA income tax paid Replaced with sheets as updated in general workpapers 78 Nov-10 Solvency Cert 30% B31 Formula updated to get date from datelast range on header sheet 78 Nov-10 Sheets being forwarded to clients Business Fitness NZ footer removed 73.1 Sep-10 Changes to Electronic Workpapers Livestock 73.1 Sep-10 Sheep, Beef Cattle, Dairy AK22/23 Formula amended Friesian, Dairy Jersey, Red Deer, Wapiti Elk & Co, Goats Meat, Goats Dairy (WAC) 73.1 Sep-10 HP sheets Minor adjustment 73 Sep-10 Changes to Electronic Workpapers Livestock 73 Sep-10 Functionality added to import last year's closing values and quantities, create closing and revaluation journals 73 Sep-10 Setup Setup sheet added for inputting of GL codes required for new functionality 73 Sep-10 Journal Journal sheet added to allow for automatic journal creation and export of CSV files for importing into accounting system 73 Sep-10 HP Deer, HP Sheep, HP High Priced Livestock sheets redeveloped + message incorporated into WAC sheets informing user if values are Cattle high priced 70 Aug-10 Changes to Electronic Workpapers Livestock 70 Aug-10 Sheep, Beef Cattle (WAC) AK22 Formula amended Electronic Workpapers.xls and Electronic Workpapers Farmers.xls Page 4 of 5 Content Release Date Sheet Name Cell Reference Release Notes Update No. 70 Aug-10 Dairy Friesian, Dairy Jersey, AK23 Formula amended Red Deer, Wapiti Elk & Co, Goats Meat, Goats Dairy (WAC) 68 Jul-10 Changes to Electronic Workpapers Livestock 68 Jul-10 Print macros adjusted 68 Jul-10 Year cell unlocked on all sheets 68 Jul-10 Dairy (Friesian & Jersey) AN23 BRG calculation adjusted WAC 68 Jul-10 Beef WAC AN22 BRG calculation adjusted 68 Jul-10 Changes to Dividend Electronic Workpapers 68 Jul-10 Divi Calc 30% F24 Formula at F24 updated 68 Jul-10 H63 Formula at H63 updated 68 Jul-10 K20 Formula at K20 updated 68 Jul-10 K21 Formula at K21 updated 68 Jul-10 F15 Updated to link to L36 on ICA ITP 68 Jul-10 Divi Calc 33% H63 Formula at H63 updated 68 Jul-10 ICA Income Tax Paid Row 7 Question added regarding what year dividend is for. Reconciliation section conditionally hidden based on this. (change not yet reflected in main Electronic Workpapers) 68 Jul-10 J10 & L10 Comment removed (change not yet reflected in main Electronic Workpapers) 68 Jul-10 Other debits section - updated values to +ve values (change not yet reflected in main Electronic Workpapers) 68 Jul-10 J12 Hidden formula added to calculate balance of 33% imputation credits (change not yet reflected in main Electronic Workpapers) 68 Jul-10 J29:L30 Formula updated to refer to hidden formula at J12 (change not yet reflected in main Electronic Workpapers) 68 Jul-10 ICA Retained Earnings L50 Formula updated to check if retained earnings balance > 0 (change not yet reflected in main Electronic Workpapers) 68 Jul-10 Solvency Cert 30% column widened for distribution figures 68 Jul-10 Solvency Cert 33% column widened for distribution figures Electronic Workpapers.xls and Electronic Workpapers Farmers.xls Page 5 of 5