About CCH Workpaper updates
This page lists the details of new features and bug fixes in CCH Workpapers.

CCH Workpapers 2025 Workbook & ADD-IN (Version 3.1.0)
Enhancements
- [NP-2084] New integration with iFirm Workflow Tracker
- [NP-2099] New integration with iFIrm Client Accounting
- [NP-1946] Review the R Rental worksheet for changes to tax form + new R2 sheet to display values in line with new IRD tax form
- [NP-2029] A1 - create sections for timing differences and permanent differences
- [NP-1178] T1 - FBT reimbursement - update formula in column L to use 366 or 365 depending on leap year
- [NP-1823] Roll forward function for trusts - automatically show the A2t worksheet
- [NP-1977] A2t - Add column for total tax credits[
- [NP-1983] Add extra row for subvention payments to A1
- [NP-1995] T2 workpaper - the Unlisted PIE section add space for the relevant Tax Credits, like the Listed PIE Income fields.
- [NP-2011] Update turboactivate and turbofloat dlls to fix issue with network adapters on activation
- [NP-2017] B1 - add workpaper reference to header in line with other worksheets
- [NP-2027] V1 - add other expenses section and link back to B1
- [NP-2028] Legal and entertainment expenses - have separate rows on B1 for deductible and non-deductible portions
- [NP-2032] B2 reviews and A3 query - add ability to sort by sheet name
- [NP-2036] Q1 – add space to enter tax credit purchases paid to Tax Pooling intermediaries (before yearend) but not transferred to IRD yet
- [NP-2037] L1 - add ability to add more rows in L1 like other worksheets
- [NP-2043] T1 - rework Other sections to add more sense to working
- [NP-2046] A1 - update company tax calculation to include distributed ICA made to beneficiaries from A2t
-
[NP-2071] V3 – unprotect cells containing IRD rates to allow manual entry of rates for non-standard balance dates
- [NP-1950] Review of all worksheets
- All BETA version fixes and enhancements mentioned below are now available in our LIVE version.
Fixes
- [NP-2045] F - bank reconciliation lead sheet - amend formulas to correctly convert foreign currency to NZD for reconciliation with GL
- [NP-2008] Update import Excel data for MYOB AE (MAS) to populate name on Workbench on import. Currently deletes name.
- [NP-2007] MYOB AE MAS - update import to have header row so values copy correctly to D4
-
[NP-2081] Supporting docs sheet - update description for R & M Expenses to 1000

To access these updates, select the Include check box for the specific worksheet(s) on the CCH Workpapers workbench. This will download the latest version of the worksheet from the cloud. Read more...
- [NP-2003] H1 - update link to CCH iKnowConnect Decpreciation finder
- [NP-2016] Update wages summary in line with IRD format
- [NP-2019] Q1 - fix link to IRD online

CCH Workpapers 2024 Workbook & ADD-IN (Version 3.0.0)
Enhancements
- [NP-1855] Roll forward function - include settings import as option
- [NP-1933] Review of trust distribution worksheet in conjunction with the new IR6B Tax Form + new IR6B sheet added
- [NP-1939] Roll forward function - include validation points in roll forward
- [NP-1935] V3 - update to link through to the next current account workpaper in sequence i.e. V3.1 – N1.1; V3.2 – N1.2
- [NP-1946] Sharepoint integration - add option for site id instead of name to reduce permission level required for integration
- [NP-1949] C1 compilation checklist - added question for transactions provided via a platform e.g. airBnB, Uber etc
- [NP-1951] FYI integration - add year as search option
- [NP-1809] Roll forward function - allow selection of .xlsb file types
- [NP-1876] Supporting docs with sharepoint / onedrive - add disconnect button
- [NP-1878] Supporting docs - Sharepoint / Onedrive - pull through all items and sort by folder then file alphabetically
- [NP-1879] Supporting docs - drive browser - make dialog box wider + checkboxes smaller to fit more in
- [NP-1950] Review of all worksheets
- All BETA version fixes and enhancements mentioned below are now available in our LIVE version.
Fixes
- [NP-1867] Roll Forward R1 sheets - check on workbench for no# selected rather than sheets in workbook
- [NP-1868] Fix bug where updating workbook status to Complete ask for permission multiple times
- [NP-1937] Roll forward - fix error where custom sheet exists in hidden but not in workbook

To access these updates, select the Include check box for the specific worksheet(s) on the CCH Workpapers workbench. This will download the latest version of the worksheet from the cloud. Read more...
- [NP-1887] Update prescribed interest rates for fringe benefit tax on V3

To access these updates, select the Include check box for the specific worksheet(s) on the CCH Workpapers workbench. This will download the latest version of the worksheet from the cloud. Read more...
- [NP-1836] B3 checklist - add 2 additional points from Ps-1
- [NP-1837] Q3a and b - update sheets to allow for opening balance of ICs when transferred from different workpapers
- [NP-1838] T2 and A2t - updated to pull listed PIE income correctly through to T2t
- [NP-1835] A4 IR10 Benchmarking data updated

CCH Workpapers 2023 Workbook & ADD-IN (Version 2.9.0)
Enhancements
- [NP-1715] Supporting docs - give users option to embed documents from local or network drive
- [NP-1699] Sharepoint integration - allow for document library other than default
- [NP-1692] Sharepoint / onedrive integration - when searching search within current folder as opposed to across whole site
- [NP-1713] SuiteFiles integration - updated to use the Sharepoint integration including improvements
- [NP-1691] Sharepoint / onedrive integration - enable multiple pages of content to be retrieved (currently there is a limit to number of records)
- [NP-1671] Integrate with FYI for supporting docs
- [NP-1751] Tracking data - add to Xero API journal upload
- [NP-1690] Add Maori Authorities as entity type on workbench to affect tax rate on A1 and ICA recs
- [NP-1702] A4 - export IR10 data to csv to be imported into ifirm
- [NP-431] Update T2 - Listed PIE income section to split imputation credits and tax credits into separate columns
- [NP-1646] Add summary section to I2 worksheet
- [NP-1694] Add rows to B1 for T1 other sections
- [NP-1758] F1 & C1 - remove instances of "Cheques"
- [NP-1753] Add to B3 checklist (Acceptance and Continuance of client Relationships)
- [NP-1698] V1 - vehicles - add option for gst incl or excl in GL
- [NP-1711] V4 - add default row for depreciation & exclude from gst calc.
- [NP-1752] Update rates and dates & rollforward
- [NP-1735] Update help in line with new updates
- [NP-1763] L2 - turn off automatic show / hide based on L1 sheet variances
- [NP-1634] Roll forward function - add sheets based on number set on workbench of LY rather than sheets in workbook
- [NP-1771] A1 - pull through non-deductible expenses from V1
- [NP-1772] U1 - Schedular payments - add row for non-declaration rate payments (45%)
- [NP-1773] V1 - repairs and maintenance heading - update to items over $1000 (from $500)
- [NP-1774] V2a - add back missing formula in cell H74
- [NP-1775] V3 - interest on overdrawn current account - update prescribed interest rates for 2023 year
- All BETA version fixes and enhancements mentioned below are now available in our LIVE version.
Fixes
- [NP-1661] Changing status on workbench for all sheets updates job status to not started
- [NP-1687] Error when adding sheets sometimes - COM object separated
- [NP-1638] Fix macro for P2 roll forward
- [NP-1737] L1 & L2 - amended formula that pulls through debit capital adjustments from L1 to L2
- [NP-1744] Supporting docs count not updating until panel opened

Upgrade to the BETA version of the CCH Workpapers Add-in to get access to all the latest enhancements and bug fixes
Updates
- [NP-1623] SuiteFiles supporting docs error - fix error where connecting to suitefiles just hangs
- [NP-1626] SuiteFiles integration - fix issue where "&" symbol truncates url
- [NP-1624] V2 & V2a Rollforward not working & gives error

CCH Workpapers 2022 Workbook & ADD-IN (Version 2.8.0)
Enhancements
- [NP-1612] Create Interest Limitation Workbook to calculate allowed and disallowed interest deductions for residential rentals
- [NP-341] Create a new bank account lead summary sheet
- [NP1564] Add roll forward functionality to H1, N2, Q4, V1
- [NP-1460] Roll forward function - V1 - test for entries and put them into the comparative column of the current year's v1
- [Np-1490] Update worksheets for Covid-19 updates
- [NP-1489] COVID-19 Wage Subsidy Calculation Worksheets
- [NP-1511] Roll forward custom workpapers
- [NP-1548] Sharepoint integration - add field for sharepoint site name to setup sheet
- [NP-1467] Add last year comparatives for term loan lead sheets
- [NP-1565] Setup sheet - Reviewer settings - Add column for excluded sheets
- [NP-1594] Supporting docs - updated link to display friendly name of document where filepath > 255 characters
- [NP-1604] C1 compilation checklist - update for new Trust disclosure rules
- [NP-1611] R & R1 rental worksheets - update worksheets to accept allowed and disallowed interest from interest limitation workbook
- All BETA version fixes and enhancements mentioned below are now available in our LIVE version.
Fixes
- [NP-1450] Fix error when clicking Delete Journal button for journal on first row of journal sheet
- [NP-1419] Roll forward function - update sheet count on workbench when rolling forward R1 and N1 sheets

To access these updates, select the Include check box for the specific worksheet(s) on the CCH Workpapers workbench. This will download the latest version of the worksheet from the cloud. Read more...
- [NP-1569] GST adjustment sheet- update text relating to GST corrections threshold

To access these updates, select the Include check box for the specific worksheet(s) on the CCH Workpapers workbench. This will download the latest version of the worksheet from the cloud. Read more...
- [NP-1506] B3t - item added to Trust Issues section regarding where Beneficiaries are owed more than $25,000 at balance date
- [NP-1522] Q3b - ICA retained earnings - updated to capture the IRD write off in the adjustments section
- [NP-1507] A1 - fixed issue where A1 was not picking up current year losses and therefore taxable loss carried forward was not the cumulative figure
- Note: Changes have been made to both A1 and R worksheets

Upgrade to the BETA version of the CCH Workpapers Add-in to get access to all the latest enhancements and bug fixes
Updates
-
[NP-1444] Roll forward function - fix issue where last year's balance date is rolled forward
- [NP-1447] Sharepoint and SuiteFiles supporting docs integration - add search functionality

To access these updates, select the Include check box for the specific worksheet(s) on the CCH Workpapers workbench. This will download the latest version of the worksheet from the cloud. Read more...
- [NP-1445] A1 tax calculations - fix issue where cell k70 is incorrectly picking up both prior and current year residential rental losses from R worksheet
- Note: Updates have been made to both A1 and R worksheets.
- [NP-1446] V2 use of home as office - update square meter rate

To access these updates, select the Include check box for the specific worksheet(s) on the CCH Workpapers workbench. This will download the latest version of the worksheet from the cloud. Read more...
- [NP-1417] R workpaper - update formula in row 45 to include "Other" expenses
- [NP-1418] V3 worksheets - update format of In Funds column (L) to percentage from decimal

CCH Workpapers 2021 Workbook & ADD-IN (Version 2.7.0)
Enhancements
- [NP-1239] Reviewer functionality - update to have 3 password levels
- [NP1269] & [NP-1195] Add Sharepoint and SuiteFiles options to supporting docs Attach from... dialog box
- [NP-915] P2 HP Liability - update to enable entry of weekly periods.
- [Np-1167] P2 HP Liability - update to allow up to 72 month HP
- [NP-1137] O Term Loan slead sheet - add column for accrued interest
- [NP-1096] P2 HP Liability - include extra payments column in roll forward functionality
- [NP-1172] Q1 Taxation Due - give option to pull values directly from T2 when entity is a trust
- [NP-1205] Add version numbers to sheets so users can identify when they have added with old addin and need to update
- [NP-1206] B1 Review Summary- add dropdowns to status column to allow manual updates with warning messages
- [NP-1218] Update sheets for loss carry-back scheme: A1:row116, A2:rows25&65, C1:rows104:110 , Q3a:rows44&89, Q3b:row20
- [NP-1250] Q4 Continuity of Shareholding - update note regarding shareholder continuity to remove confusion
- [NP-1263] Popup message regarding need to install addin - clearly add options for Terminal server or PC version
- [NP-1265] Include balance date in the roll forward function for workpapers
- [NP-1280] N1 Current Account Movement - include in roll forward functionality
- [NP-1352] GST Adj Sheet - remove preparer / reviewer line
- [NP-1356] A1 Tax Calculations - incorporate residential rental properties profit or loss into new section
- [NP-1377] R Residential Rental and Loss Ring-Fencing- include in roll forward functionality
- [NP-1381] Q3b - row 43 - update formulas to pull from row 16 (losses attributed to shareholders...)
- [NP-1404] A1 Tax Calculations - add rows for Covid-19 Wage subsidies / Resurgence support / Short term absence and related - rows 41 & 26
- All BETA version fixes and enhancements mentioned below are now available in our LIVE version.
Fixes
- [NP-1165] Update roll forward functionality to not pull through data into locked worksheets
- [NP-1181] Print all - supporting docs - allow pdfs to be inserted when file path is relative
- [NP-1249] Import GL data - display helpful error message when balance date missing on workbench sheet
- NP-1267] Fix error - when uploading journals, if space has been entered into last journal posted cell, an unhandled exception occurs
- [NP-1366] Supporting docs - allow file paths greater than 255 characters to be added to supporting docs
- [NP-1370] I1 & I2 Investments - fix occasional error when changing number of investments
- [NP-1405] A1 Tax Calculations - update formula for Taxable loss carried forward from above in Notes to the accounts to include rows 70 and 71

Upgrade to the BETA version of the CCH Workpapers Add-in to get access to all the latest enhancements and bug fixes
Updates
- Xero integration functions: updated to work with Xero's new authentication protocol. Old protocol will not be supported from 1 April 2021.

To access these updates, select the Include check box for the specific worksheet(s) on the CCH Workpapers workbench. This will download the latest version of the worksheet from the cloud. Read more...
Updates relating to Loss carry-back scheme:
- [NP-1220] A1 row 116 - add row to "Notes to the accounts" section to record loss carried back (2020 to 2019)
- [NP-1221] A2 rows 65 and 25 - add note prompting to consider loss-carry back where taxable income is -tve for 1 or more SH
- [NP-1222] C1 rows 104:110 - Loss carry-back section added
- [NP-1223] Q3a row 44 - row added to Income tax refunds section for loss carry-back to 2019 tax year, row 89 - row added to Adjustments section for 2019 income tax refund from loss carry-back from 2020
- [NP-1224] Q3b row 17 - row added to Adjustments affecting tax section for Tax refunded from loss carry-back
Other updates:
- [NP-1216] A2t trust distribution worksheet - update formulas in cells P39 and T39 to correctly calculate ICs on trustee income retained
- [NP-1226] Q1 - for partnerships: Add question "Does entitlement to dividend income by partners differ to entitlement to partnership income?" if no, bring imputation credits through. If not, do not bring through and leave for users to calculate at a partner level
- [NP-1229] Q1 - for trusts: Add question "Are credits being transferred to beneficiaries being accounted for in tax paid on beneficiary income?" if no, pull credits through directly from T2, otherwise credits are reversed and pulled through from A2t

To access these updates, select the Include check box for the specific worksheet(s) on the CCH Workpapers workbench. This will download the latest version of the worksheet from the cloud. Read more...
- [NP-1179] T1 - FBT reimbursement - update column L to correctly use 366 or 365 depending on leap year
- [NP-1191] Q3b - amend total formulas in row 47 to include rows 37 and 38, remove formula from J44 for manual entry

Upgrade to the BETA version of the CCH Workpapers Add-in to get access to all the latest enhancements and bug fixes
Updates
- [NP-1136] – B1 hide unused rows function - update to hide rows if both GL and WP bal = 0 regardless of status
- [NP-1140] - Update Reconciled? button in ribbon to always be enabled as a short cut to relevant line on B1
- [NP-1111] - R - add rows to pull through losses and income from R1 sheets rather than just net income
- [NP-1160] - GST adj letter - prevent tracked changes status being displayed on sheet and yellow highlighting
- [NP-1114] - Fix issue where changing status to so that worksheet becomes locked or unlocked, Import GL data button does not immedicately change enabled status
- [NP-1150] - Fix issue whereby N1 sheets hang when you select them
- [NP-1129] – Update print functionality to fix error where workbook is saved in the cloud
- [NP-1130] – Update print functionality to hyperlink to documents in sharepoint instead of throwing error
- [NP-1161] – Fix issue where error received regarding setting CCH ribbon when closing workpapers or switching between workpapers for a few users

To access these updates, select the Include check box for the specific worksheet(s) on the CCH Workpapers workbench. This will download the latest version of the worksheet from the cloud. Read more...
- [NP-1131] U2 wages sheet - amend formulas for required payment in rows 28 - 39
- [NP-1138] V2 use of home as office - update square metre rate to 42.75
- [NP-1121] V3 - update rates for interest on overdrawn current account

CCH Workpapers 2020 Workbook & ADD-IN (Version 2.6.0)
Enhancements
- Improved integration with Xero API - increased speed of data import & no login required if you’ve already logged into Xero via your browser.
-
New streamlined reviewer functionality and sheet status management
- Print All Sheets function updated to optionally include supporting docs
- Supporting docs - option added to Setup sheet for absolute / relative links
- Roll Forward functionality - updated to include entity data i.e. gst status, entity type, IRD number and name
- NEW Ring-Fencing Rental Losses worksheet (R)
- C1 compilation checklist - AML prompts added
- Q2 reserves - included in Roll Forward functionality
- A4 & A5 Benchmarking sheets - benchmarking data updated
- Q3a & Q3b ICA recs - updated for 2020
- V3 Interest on Overdrawn Current Account worksheet - UOMI rates updated
- T2 - Overseas FDR/CV exempt worksheet - option added to exclude IC's in total
- U2 wages - order of IRD deductions columns updated to match IRD
- All BETA version fixes and enhancements mentioned below are now available in our LIVE version.
Fixes
-
Fixed activation error where addin cannot be activated because it has already been activated with a product key
- Supporting docs - fixed issue with opening multiple documents where excel documents were included
- Supporting docs sheet - hide / unhide unused rows amended
- Setup sheet - values pull through to B1 when suffix separator is blank - default "/" used
-
Q3b roll forward data includes pre-1989 columns
- Q3a roll forward values in adjustment section are not reversed
-
B1 - print area updated to fit to 1 page wide
-
D4 - amended formatting of totals where some showing large rounding
- Journal entry - updated to allow spaces in value cells

To access these updates, select the Include check box for the specific worksheet(s) on the CCH Workpapers workbench. This will download the latest version of the worksheet from the cloud.
Enhancements and Fixes:
- [NP-238] - V4 - updated the formulas in cells H18 and H33 to = * -1, so as to deduct the depreciation recovered amount from the total adjustment.
- [NP-237] - H1 - added a link to the IRD depreciation rate finder.
- [NP-239] - Adj Sheet - updated the first sentence related to correction of minor errors.

CCH Worksheets (in the cloud)
To access these updates, simply tick the box include the worksheet from your Workbench. This will download the latest version of the worksheet from the cloud.
If you have created a master file containing all your required worksheets, you may want to delete these (right click on the tab and select delete) then add the updated worksheets as above.
Fixes
- D1-D3 journal sheets - updated formula for variance to round to 2 dp
- D4 - amended print area
- A4 & A5
- Fixed spellingmistake in definition for Net Profit Margin
- Amended definition of Wages Turnover Ratio
- Amended current ratio formula in cell O82 on A4
- Updated formatting of current year values for consistancy:
Return on assets
Return on equity
Current ratio
Quick ratio
- Q3a - c19 - corrected formula for 3rd prov tax date
- Q3a - Removed formula in H23 to prevent double counting of 2016 terminal tax arrears
- Q1 - J16 - removed exclusion for soletraders and partnerships

Please download the 2017 Electronic Workpaper file to access the following features and enhancements. Click here to find out how.
If your workpapers have been customised in the past, the newly published file from Business Fitness will not automatically appear. To learn how to manage Business Fitness updates click here
Enhancements to 2017 Electronic Workbook and Worksheets
- Q3A &Q3BTweaks have been made to assist in the reconciliation process:
- Minor tweaks were made to accommodate for situations where prior year tax payments have been made
- Changes have been made to accommodate for situations where ICs have been converted to losses
- Provide the ability to compare any variance between the retained earnings reconciliation completed on the workpaper with the retained earnings GL balance
- Created space to specify where UOMI or penalties as overlooking these has been a common reason why the reconciliation hasn't balanced
- Multiple Rental Workpapers- by default we've added three rental workpapers but with the ability to easily add more from the Workbench. The rentals will appear as separate lines on the B1 dashboard.
- A4 & A5New workpapers which allow you to populate the IR10 from the workpapers and perform KPI calculations for the purpose of benchmarking your client's results against the industry averages published by Inland Revenue. To use this workpaper:
- Select your client's industry on the top of the workpaper
- Enter the relevant account codes to pull GL data into the form from B1, or manually enter values to populate the IR10
- Ensure the required fields are completed
- The A4 workpaper will then calculate your client's KPIs and highlight where your client's results are outside of the ranges published by Inland Revenue.
- The A5 workpaper summarises the results in a simple report format for you to update your recommendations and share with your client.
- U1Expanded to reconcile to the IR10 where payments made for different types of services contracts have been coded to one account. The workpaper allows you to:
- Calculate salary and wages paid to non-associated employees only for inclusion in Box 22 of the IR10 (i.e. reduces the salary and wage GL balance by payments made as schedular payments or to associated persons coded to the same account)
- Calculate payments made to non-associated contractors including schedular payments for inclusion in Box 23 of the IR10
- Totals payments made for professional services performed by non-associated persons for inclusion in Box 16 of the IR10
- Totals all payments made to associated persons for inclusion in Box 21 of the IR10
- Notes Sheets: Unique ID column has been added to the notes sheets so you can refer to a note using the unique ID. This is a manual field.
- (GST) adj sheet & adj letter - functionality to hide unused rows added
CCH Workpapers ADD-IN (Version 2.3.0)
Please update your CCH Workpaper Excel Add-in to version 2.3.0 to access all the latest features and enhancements listed below. Read our FAQ to find out how.
Enhancements
- Xero integration using the Xero API - export and import data directly from Xero. No need for CSV files! Select the "Xero - API" option from the workpaper setup sheet.
- Unlimited supporting documents - click on the "add column" button if you have more than 5 supporting docs per worksheet.
- Supporting documents can be added to any worksheet including journals

CCH Worksheets (in the cloud)
To access these updates, simply tick the box include the worksheet from your Workbench. This will download the latest version of the worksheet from the cloud.
If you have created a master file containing all your required worksheets, you may want to delete these (right click on the tab and select delete) then add the updated worksheets as above.
Fixes
- GST Adjustment Letter - updated letter to be a consistent font (Ticket 183)
- Fixed various printing issues on a number of worksheets to include borders and other minor issues
- A1 - updated formula in cell l104 to reference Q1 correctly (Ticket 350)
- T1 - fixed spelling mistake in title (Ticket 358)
- Y1 - Updated formula on Y1 cell E38 to reference E36 and 37 instead of E34 and 37 (Ticket 388)
CCH Workpapers ADD-IN (BETA Version 2.2.4)
Contact us if you would like to upgrade to the BETA version of the CCH Workpapers ADD-IN to get access to all the latest enhancements and bug fixes
Enhancements
- For APS accounting software: journal exports for reversing journals do not require separate csv file – extra column is added to csv file to indicate that journals are to be auto reversing
- For Excel 2013 + enabled addin to work with multiple windows on different screens using Excel New Window function
- For Xero accounting system: journal exports from D3 and D1 now allow for multiple journals within one upload rather than merging all journals into one with single heading.
- Journal upload to csv now faster
Fixes
- Issue fixed to allow embedded excel files in word when Addin installed
- For Excel 2013 + fixed issue with viewing help from CCH Workpapers ribbon

CCH Worksheets (in the cloud)
To access these updates, simply tick the box include the worksheet from your Workbench. This will download the latest version of the worksheet from the cloud.
If you have created a master file containing all your required worksheets, you may want to delete these (right click on the tab and select delete) then add the updated worksheets as above.
Fixes
- A1 – cell I104 – updated formula to reference Q1 correctly

CCH Worksheets (in the cloud)
To access these updates, simply tick the box include the worksheet from your Workbench. This will download the latest version of the worksheet from the cloud.
If you have created a master file containing all your required worksheets, you may want to delete these (right click on the tab and select delete) then add the updated worksheets as above.
Fixes
- Sheet Q3a cell e63 has been updated to reference sheet A1cell K62 (Net Assessable Income) rather than A1 K65 (taxable income per tax return)
- Non standard balance dates added back to Q3a
- Print issue on C1 Complication Checklist fixed

CCH Worksheets (in the cloud)
To access these updates, simply tick the box include the worksheet from your Workbench. This will download the latest version of the worksheet from the cloud.
NB: If you have created a master file containing all your required worksheets, you may want to delete these (right click on the tab and select delete) then add the updated worksheets as above.
Fixes
- Fixed formula on Q1 workpaper: the formula at j43 in Q1 to be =SUMIF(H29:H37,">" & BalanceDate,J29:J37) - IF(H38 > BalanceDate,J38,0).The total in cell j43 didn’t calculate properly because it didn’t subtract what is in cell J38 (a transfer out) instead it added it in.

CCH Workpapers ADD-IN (BETA Version 2.2.1)
Contact us if you would like to upgrade to the BETA version of the CCH Workpapers ADD-IN
Enhancements
- A new notification icon in the CCH Workpapers ribbon to inform you when there is a new Add-In update to install.
Fixes
- Fixed error when trying to include a new worksheet and it would not automatically link on B1
CCH Worksheets (in the cloud)
To access these updates, simply tick the box include the worksheet from your Workbench. This will download the latest version of the worksheet from the cloud.
NB: If you have created a master file containing all your required worksheets, you may want to delete these (right click on the tab and select delete) then add the updated worksheets as above.
Fixes
- Fixed error spelling error on Term Loan Worksheet O1 (cell C1 15) missing letter 'p' from expenses
CCH Workpapers ADD-IN (BETA Version 2.2.0)
Fixes
- Fixed error when trying to embedd tables in word doc
- Fixed error when trying to copy and paste data from one workbook to another
- Fixed Num Lock issue
- Fixed american date format in status update on Workbench
Please note we have had many queries regarding the alphabetical ordering of workpaper tabs - this issue was fixed in a previous release. If you are still experiencing issues please manually update your master workbook to ensure tabs are in the correct order (including hidden sheets). Additional sheets added will then automatically appear in the correct order.
CCH Worksheets (in the cloud)
To access these updates, simply tick the box include the worksheet from your Workbench. This will download the latest version of the worksheet from the cloud.
NB: If you have created a master file containing all your required worksheets, you may want to delete these (right click on the tab and select delete) then add the updated worksheets as above.
Enhancements
- Updated printing layouts to reduce number of printed pages and to include GL balance comparison for relevant sheets.
- A1 (set to print to 2 pages rather than 3)
- A2 (set to print to 1 page)
- C1 (set to 2 pages from three)
- D1, D2, D3 (set to portrait)
- F1 (adjusted to include GL and workpaper balance comparison)
- G1 & G1f (adjusted to include GL and workpaper balance comparison)
- I2 (set to print all visible investments)
- L1 (set to portrait & print to 1 page)
- L2 (set to print to 1 page)
- Adj Letter (set to print to 1 page)
- M1 (adjusted to include GL and workpaper balance comparison)
- N1 (adjusted to include GL and workpaper balance comparison)
- N2 (adjusted to include GL and workpaper balance comparison)
- O1 (set to print on 1 page)
- P1 (adjusted to include GL and workpaper balance comparison)
- P2 (adjusted to include GL and workpaper balance comparison)
- Q1 (adjusted to include GL and workpaper balance comparison)
- Q3a , Q3b (set to print on 1 page)
- R1 (set to print on 1 page)
- V3 (set to portrait & print to 1 page)
- Y1 (adjusted to include GL and workpaper balance comparison)

CCH Workpapers ADD-IN (Version 2.1.9)
Enhancements
- A response column was added to all query sheets including; A3,CF, B1,B2a, B2b, and B2c based on client feedback.
Fixes
- P1 worksheeet was updated K56 and E54 to look for balancedate + 1 year in range b20-25 and updated cell 40 to calculate automatically when sheet added
- A2 - Unlocked cells in row 58 and row 11 - formatting error.
- A2t - H-J83 - replaced missing formulas
Enhancements
- New version for terminal server- an easier way to install the Add-in to a terminal server environment
- Product key is now retained when de-activation happens so does not have to be entered each time after re-activating
- Updated notes feature: number can be added into the sheet name column
- Button added to ribbon to format journal number as deleted
Fixes
- Fixed slow reporting from APS and other applications using Excel
- Fixed issue where sheets were not displayed in correct order
- Updated notes feature so notes added manually and without a sheet value were not overwritten
- Fixed issue where num lock was being turned off
- Updated notes count to reset when note deleted
- Fixed issue where balance from N2 did not pull through to B1
- Setup sheet & B1 - cell formats updated to text from general where required
- Cell label / instructions updated on setup sheet for adding multiple codes to GST/Taxation other. Users are now instructed to remove gaps between codes

Major release 2016
Enhancements
- A customised CCH Business Fitness tab in the ribbon – so you can easily access commands.
- Ability to easily integrate your own workpapers
- New and improved design – easier and more intuitive to use
- New interactive notes tool – create and view notes in our new note taking tool.
- New validation point system– helps to highlight common compliance red flags with quality supporting commentary
- Download worksheets from the cloud - means smaller workbook file size and we can update sheets throughout the year.
Fixes
- General fixes

CCH Worksheets (in the cloud)
To access these updates, simply tick the box include the worksheet from your Workbench. This will download the latest version of the worksheet from the cloud.
If you have created a master file containing all your required worksheets, you may want to delete these (right click on the tab and select delete) then add the updated worksheets as above.
Fixes
- A1 – cell I104 – updated formula to reference Q1 correctly