Docstoc

Examples of Memorandum Letter - Excel

Document Sample
Examples of Memorandum Letter - Excel Powered By Docstoc
					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

				
DOCUMENT INFO
Description: Examples of Memorandum Letter document sample