Re-importing Audit Data & Analytical Procedures

Re-importing Audit Data & Analytical Procedures

Re-importing Audit Data

Here at Cloudoffis we understand that things do not always flow smoothly and there will be times when the data imported when the audit job is created may need to to be updated. We have a function for both Cloud based and non Cloud based software's to Re-import Lead Schedule items without losing the work you have already completed, this saving you time.

Re-import Lead Schedule (Cloud Based)

This option is available form the Fund Dashboard for all audit jobs (top right of screen)


Select Re-import option

You will then be provided with 2 options as per below

Option 1 Delete Existing Data

This option re-imports data and deletes all of the work already completed for the audit job (eg Bookmarks, Comments, Checklist progress etc). This is not our most popular option but does have its uses. Once selected click Re-import, you will also have the option from this page to open the most recent change report for each audit once re-importing is complete.


Delete Existing Data Warning 


Option 2 Overwrite Existing Data

This option re-imports data and all of your work already completed will remain (eg Bookmarks, Comments, Checklist progress etc). You will of course need to review the change report as some of the work already completed will require editing dependent on changes. Once selected click Re-import, you will also have the option from this page to open the most recent change report for each audit once re-importing is complete.


Overwrite Existing Data Warning



The below applies for both options 1 &2

Once Yes is selected you will get a new pop up as per below

When completed all data has been updated and you will have the option to close or View Change Report

View Change Report

When select you will receive a pop up which stipulates the original value and the new value for any changes. If there has been no changes you will receive the below.


Analytical Procedure Versions

Whenever an audit job is created an Analytical procedure Version 1 is provided. This exists within the Plan/Preliminary File Setup/Analytical Procedure.


When you Re-import Lead Schedule you will receive a new version each time. All versions are kept to refer back to if required.

NOTE: The change report only exists to refer to for the most recent re-import for the particular audit job. This can be accessed form the Re-import Lead Schedule screen at any time.



Opening Analytical Procedures

When you click on a version the Analytical Procedure will open in a new tab, you can open as many versions as you require and each will open in a new tab for review as per below example.


Re-import Lead Schedule (Non Cloud Based)

The steps for Non Cloud Based Re-importing are exactly as per the above with one exception as per below.

When you select Re-import Lead Schedule and choose an option you will be provided with a slide on the right providing the option to upload new Trial Balance (Compulsory) and the option of uploading a new General Ledger. We suggest uploading both reports, the optional upload for the general ledger exist for clients who are using non partnered software and creating their trial balances manually.



All other steps are identical to Cloud based instructions.

    • Related Articles

    • How to Import & Re-import Clients

      Introduction Here's how you can Import and Reimport clients in Sorted. How to Import Clients Step 1: Click on Clients > Manage Clients > Import Clients. Step 2: Choose from four options to import jobs from Class, BGL 360, SuperMate, or manual upload. ...

    • SMSF Sorted - Tutorial Video Part 2 - Importing Funds and Creating Jobs

      Tutorial Video Part 2 - Importing Funds and Creating Jobs This video provides a demonstration on how to import funds from Class or BGL360 and how to create a 'Job' to reconcile the fund and prepare the Audit Workpapers.

    • Submitting and Re-submitting to Auditor

      Introduction If you want to submit any of the available funds for audit, follow the simple steps given below. You can follow the same steps given below to Resubmit the Fund to the auditor. How to Submit a Fund for Audit to an Auditor Step 1: Locate ...

    • Create Audit Job for Class Fund "Internally"

      Create Audit Job for Class Fund "Internally" Select Manage Clients Select from the Audit Menu Choose the fund and select Create Audit Job To locate fund you may need to expand the show entries option located in bottom left or scroll through pages. ...

    • How a connected business can submit a job to Audit

      Overview Some firms may be connected to an external Accountant or Administrator, and do work for those external businesses. Jobs for these external businesses can now be submitted to audit by those businesses directly once the work has been marked as ...