Get documents about "Examples of Memorandum Letter - Excel
W
Description
Examples of Memorandum Letter document sample
Document Sample
u Content Update Log
u Electronic Workpapers
as @ 11/15/2010
Content Release Document Title Section Document Type Description of changes Type of Update
Update No. Date
78 Nov-10 Business Forward Issue 48 Knowledge Base Other Business Advisory Newsletter for providing to clients, Issue 48 Addition
78 Nov-10 Deletion of Client Checklist Administration Checklist Point 8 updated Enhancement
78 Nov-10 Dividend Electronic Workpapers Compliance Form See Electronic Workpapers sheet for log of changes Enhancement
78 Nov-10 Electronic Workpapers Compliance Form See Electronic Workpapers sheet for log of changes Enhancement
78 Nov-10 Electronic Workpapers - Administrator Setup Compliance Guide Updated to reflect changes made to the general workpapers Enhancement
78 Nov-10 Electronic Workpapers - Administrator Setup (Static) Compliance Guide Guide for the administrator to set up the general workpapers (static Addition
version) for the firm
78 Nov-10 Electronic Workpapers - Client Setup Compliance Guide Updated to reflect changes made to the general workpapers Enhancement
78 Nov-10 Electronic Workpapers - Client Setup (Static) Compliance Guide Guide to setting up the general workpapers (static version) to prepare Addition
financial statements for a client
78 Nov-10 Electronic Workpapers - Functionality Compliance Guide Updated to reflect changes made to the general workpapers Enhancement
78 Nov-10 Electronic Workpapers - Functionality (Static) Compliance Guide Guide to functionality in the general workpapers (static version) Addition
78 Nov-10 Electronic Workpapers Static Compliance Form See Electronic Workpapers sheet for log of changes Enhancement
78 Nov-10 GST Private Use Adjustments Compliance Form Updated for tax changes and reformatted Enhancement
78 Nov-10 Rates and Thresholds Table Knowledge Base Guide ACC figures and income tax table updated, note added to FBT Enhancement
78 Nov-10 Rental Deductibility Table FAQ Report Updated for depreciation Enhancement
78 Nov-10 Understanding the Provisional Tax System FAQ Report Updated for tax changes Enhancement
78 Nov-10 Vehicle - Buy vs Lease vs HP Asset Analysis FAQ Form Updated for tax changes Enhancement
78 Nov-10 Working for Families Tax Credit Guide Compliance Guide Updated for joint custody arrangements Enhancement
78 Nov-10 Working for Families Tax Credits Calculation Compliance Procedure Updated for joint custody arrangements Enhancement
77 Oct-10 Business Forward Newsletter Guide Business Advisory Guide Replaced by Newsletter Guide Deletion
77 Oct-10 Newsletter Guide Compliance Guide Guide to publishing our compliance and business advisory newsletters Addition
to clients
77 Oct-10 Newsletters - Business Forward Business Advisory Procedure Link to guide updated Enhancement
77 Oct-10 Newsletters - Wilco Compliance Procedure Link to guide updated Enhancement
77 Oct-10 Summary of Key Provisions Compliance Form Updated trustees' powers Enhancement
77 Oct-10 Trust Administration - Annual Gifting Compliance Sub Procedure Fixed broken hyperlinks Enhancement
77 Oct-10 Trust Administration - Risk Review Compliance Procedure Links to examples added Enhancement
77 Oct-10 Trust Administration Risk Summary Compliance Form Added points 3, 9 and 10. Amended point 7 Enhancement
77 Oct-10 Trust Register Compliance Form Added assets and insurances registers; updated summary of key Enhancement
provisions, register of trustees and header page
77 Oct-10 Trust Risk Review - Letter to Client following Review Compliance Letter Updated to make editing easier Enhancement
77 Oct-10 Trust Risk Review - Letter to Solicitors with Review Results Compliance Letter Updated to make editing easier Enhancement
77 Oct-10 Trust Risk Review - Sample Letter to Client Post Review Compliance Example Example of a letter to a client with trust risk review results Addition
77 Oct-10 Trust Risk Review - Sample Letter to Solicitors Post Review Compliance Example Example of a letter to a solicitor with trust risk review results Addition
77 Oct-10 Trusts - Annual Minute Compliance Form Note added re beneficiaries Enhancement
77 Oct-10 Trusts - Borrowing Money Compliance Form Note added re beneficiaries Enhancement
77 Oct-10 Trusts - Income Distribution Minute Compliance Form Note added re beneficiaries Enhancement
77 Oct-10 Trusts - Investment Minute Compliance Form Note added re beneficiaries Enhancement
77 Oct-10 Wilco Guide Compliance Guide Replaced by Newsletter Guide Deletion
77 Oct-10 Wilco LAQC Special Alert October 2010 Knowledge Other Compliance Newsletter for providing to clients, special alert edition on Addition
Base/Wilco LAQC, October 2010
77 Oct-10 Wilco LAQC Special Alert October 2010 text only Knowledge Other Compliance Newsletter for providing to clients, special alert edition on Addition
Base/Wilco LAQC October 2010, text only version
cbf0b01b-f1ef-42bd-95bf-7614cb552b28.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
Related docs
