CaseWare updates Audit Luxembourg

• General content update

  • Changes to all Financial Area work programs in the Plans and Procedures 
  • Response set changes in Financial Area work programs and other Checklists
  • Substantive analytical procedures worksheets added to all Financial Areas in the Plans and Procedures folder
  • Tests of controls sampling worksheets were added in the Tests of Control folder under the Risk Response folder
  • Group audit related documents have been modified to remove older group audit content
  • New documents have been added and some documents have been removed

• Planning balances are enabled

  • You can now upload planning balances for the current and prior years and;
  • View the planning balances in the Data page including multiple options for variance columns to view any changes between the planning and final balances.

• Risk assessment

  • An Inherent Risk section has been added for each Financial Statement Area (FSA) and can be determined on the basis of the Likelihood of a Misstatement Occurring (LMO) and the Magnitude of a Potential Misstatement (MPO)- as part of the revised ISA 315 standard.

• Signoffs

  • Documents A500, A505, B500 and B700 have been assigned a new role scheme and can now be signed off separately during preliminary and final audit.
  • Documents C205, C215 and D625 have been assigned the Partner review signoff scheme by default.

• (Re)Insurance companies

  • The B101 Analytical Review document is now also available for (Re)Insurance companies.

• Create areas
  • You now have the ability to create audit areas and assign them to financial groups. You can also change the default audit area assigned to existing financial groups.
  • The option to create areas is available in both the Template and engagement file from the NEW AREA option in the Risks tab or in the Product settings>Features>Areas.
  • As part of this enhancement, you can also now assign areas to financial groups in the Data page.
  • The same applies for checklists: you can assign checklists to multiple areas in the Checklist Settings. Select one or more financial groupings or areas to associate with the checklist. Risks that apply to the selected financial groupings or area will be displayed in the Risks tab of the checklist.
• Import zero balance accounts
  • You can now select to include zero balance accounts when importing data from CSV or Excel files.
• Enhancements to signoffs for risks

  • Similarly to the risk report, you can sign off the entire report or individually sign off each risk in the risk assessment report.

  • You can now apply custom signoff schemes to the risk and risk assessment reports.

• Controls testing option for risks
  • In the Will you be testing controls? option you can select whether you are testing controls for each area in the risk assessment report. If you answer that you are not testing controls, the Control risk for each assertion will be automatically set to the highest level risk. Note that this will not overwrite any manual selections made previously. 
• Disable assertions for areas
  • You can now use the checkbox for assertions to disable assertions for each area. This allows you to only enable assertions that are relevant for the area.
• Make hidden procedures and documents visible when linking
  •  When you link a risk to a hidden procedure or document, a dialog now displays to inform you that if you choose to continue, the hidden procedure or document will now become visible.
• Copy and paste documents across engagements
  • The Copy from CaseWare Cloud option now allows you to copy documents from other engagements within the same entity. You can select which engagement you want to copy documents from and then select the specific document.

• Other minor improvements and fixes
  
  • Signoff for Mapping Configuration tool is disabled
  • (Re)Insurance company: tables in document B035 Data Completeness Check - AnalyticsAI are now enabled
  • Data page- informational: the Net Income balance is now automatically allocated to financial group 14.2 Result for the financial year 

• New Mapping Configuration Tool
  • This new feature is added in the Engagement set-up folder and improves efficiency by allowing you to pre-define (non-standard) mapping layout files. An online tutorial on how to use this tool will be added to the Lux Audit training bundle.

• Other minor improvements and fixes
  • Visibility settings
  • Missing sign-off buttons for procedures in documents A100 and A405 are enabled

•  Content update: 

The following list summarizes the content updates implemented:

• New audit Work Programs:
  New Audit Work Programs have been introduced. The documents related to this change are disclosed below:
  • 40.101 Agricultural Assets - Audit Procedures (New document)
  • 335.101 Government Grants - Audit Procedures (New document)
  • 340.101 Leases for Lessees - Audit Procedures (New document)
• New Queries and Query Templates have been created:
  
  • 40.101Q Agricultural Assets - Query (New document)
  • 40.101QT Agricultural Assets Query Template (New document)
  • 335.101Q Government Grants - Query (New document)
  • 335.101QT Government Grants Query Template (New document)
  • 340.101Q Leases for Lessees - Query (New document)
  • 340.101QT Leases for Lessees Query Template (New document)
• Master sample size worksheet:
  In this new version of Lux Audit a Master Substantive Sampling Test of Details Worksheet has been included, to assist in the calculation of the sample sizes for substantive sampling. Refer to the guidance on how to add a new instance of the Substantive Sampling Test of Details Worksheet.
  
  
• New Financial Statement Areas:
  • Agricultural Assets
  • Government Grants
  • Leases for Lessees

• New feature:
  
  
  • In the Data page, you can manually add trial balance groups to a grouping structure in the firm template, if needed.
    You can also edit or delete any groups you create. Note that you cannot edit or delete any pre-existing groups in the template. 

• Other minor updates and fixes:
  
  
  • A100 Optimiser Checklist: question 'Only use the query system?" removed.
  • A500 Materiality: replaced 3 manual input materiality benchmarks by auto-calculated ones.
  • A110 and D400: minor content changes and layout improvements.
  • B100 Analytical Review: corrections and further breakdown of some accounts.

• New Documents page layout
  • The Second Reviewer button is no longer available in the Engagement properties window.
  • The More actions (...) | Sign-off option is no longer available.

• Roles and signoff schemes
  • Roles, where you define the preparer role labels and the reviewer role labels. You can add as many roles as needed. To learn more, see Define signoff roles.
  • Schemes, where you set up the applicable combination of preparer roles and reviewer roles for a specific document or a group of documents. To learn more, see Set up signoff schemes.

• Risks
  • As a firm author, you can now choose whether or not to include a text field in risks analysis widgets to add comments or notes. A new check box Include the comments field in risk analysis widgets is now available in the Risks | General tab in the product settings (included in this version). Previously, this text field was always available in analysis widgets.

• Enhanced review tools in checklists
  • You can now use review tools to track changes made in checklists after the reviewers have signed off if the  Modified since last review option is turned on in the Documents page.

• Empty Input columns in dynamic tables
  • Empty Input  columns (when cells are blank or zero) in dynamic tables are now automatically excluded when you print the financial statements. When you view the financial statements in an engagement file, the headers of empty Input columns display in gray.

• Queries
  • Improved query UI: the new query layout now features buttons available at the bottom of each question.
  • You can now edit and delete your comments in the new query layout.
  • The comments area in queries now also displays the history  of each question. 

• Risks module
  • A new filter Signoffs is now available in the new risk module.

• Customize format settings
  • You can now change the default product settings for the following format settings in an engagement: Currency, Date format, Numbers and Measurement unit.

• Drag and drop documents in the new Documents page
  • You can now drag and drop external documents, such as PDFs, Word files and Excel files from your desktop into folders and placeholders in the new Documents page.

• Transactions
  • The Columns and Filters drop-downs in the Transactions tab in the Data page have witnessed a few additions and updates.

• Replace external documents
  • You can now replace external documents. You can either select More actions () | Replace or drag and drop a new document onto the old document to replace it. When you replace a document, you can choose whether to remove pre-existing signoffs or retain them.

• Content update

• Work Program improvements

We have added an additional sub-procedure in every grouping B. Substantive Procedures Extended type procedure in Work Programs, to assist in the documentation of the audit work.

• Document A100 Optimiser checklist - Initial Engagement Decisions
  • Additional questions included to tailor engagements for Financial Vehicles. In particular, to integrate specific procedures for Private equity funds/Real estate funds.

• Plans and procedures phase
  • The specific procedures (and related assertions) for Private equity/Real estate funds will be displayed in a separate Subgroup in the checklists of the following Financial statement areas, based on visibility settings (if Private Equity fund or Real Estate fund is selected in the Optimizer checklist):
    1. Investments
    2. Equity (Corporate + Partnership)
    3. Payables
    4. Payroll and other expenses
    5. Receivables, current
    6. Receivables, non-current.
    7. Borrowings, current
    8. Borrowings, non-current
    9. Liabilities, current
    10. Liabilities, non-current
    11. Other expenses
    12. Other income

• Checklists
  • If signoff is enabled for procedures and conclusion, a warning message now displays if users attempt to sign off on the document while,
    1. One or more visible procedures have not been signed off
    2. The Conclusion section has not been signed off
    3. Visible procedures in the Conclusion section have not been signed off

• Risks module
  • Risk assessments can now be carried forward.

• Signoff
  • The logic for preparer and reviewer signoff has been enhanced. Users can now only remove their own signoffs. A user that has been granted one or more administrator security roles can remove signoffs by other users.
  • Administrator security roles in CaseWare Cloud are:
    1. Admin
    2. Settings Admin
    3. Staff Admin
    4. Entities Admin

• Duplicate & Unlink option for Cloud Connector
  • The new Duplicate & Unlink option allows you to create a copy of your spreadsheet without any formulas. This allows you to save a snapshot of your spreadsheet where data will not be updated in real-time so you can backup information or send it to your clients.

• Integration with the new risk-based transaction analysis tool AnalyticsAI  Lux application.
• PCN2020 mapping was added. A message will appear on the dashboard to convert your CaseWare file to the updated mapping. This will happen on opening a CaseWare file that has a year begin date of 01/01/2020 or later.  Accounts need to be remapped after conversion.
• Integration of Cloudbridge on the Quickstart window to enable migration of figures to our new Lux Audit cloud solution.
• Bugfixes
  
  • New sign-off roles enabled for the final materiality levels added in the '420. Materiality (Core)' document
  • CaseWare website widget on the Quickstart window
  • 'Autofill mapping & FSA' button on the Quickstart window
  • 'Other import options' button on the Quickstart window deleted