Get documents about "Constitution Template Nz u Content
Description
Constitution Template Nz document sample
Document Sample
u Content Update Log
u Electronic Workpapers
as @ 1/8/2011
Content Release Document Title Section Document Type Description of changes Type of Update
Update No. Date
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
d3528eb7-9171-456a-a984-373916ac5ef8.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
