Excel Business Tax Return Workpapers Preparation Templates

Document Sample
Excel Business Tax Return Workpapers Preparation Templates Powered By Docstoc
					u Content Update Log
u Electronic Workpapers
                                                                                                                                                                                              as @ 2/2/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




        19e336ef-ada8-4689-8ff1-9e6ac491e500.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: Excel Business Tax Return Workpapers Preparation Templates document sample