How it works
This function allows the user to clean a general ledger with one click. Going from the exported general ledger information to a sheet with the cleaned general ledger in table format and a Pivot table of the data.
How to use it:
Step 1
With the General ledger export as the active sheet, click on the ‘GL Cleaners’ drop-down menu.
Step 2
Click on the relevant accounting software from which the general ledger has been imported.
On selection a pop-up window will appear.
Step 3
Confirm that you have selected the correct Accounting software by comparing your general ledger to that of the Pop-up window.
Step 4
Select the date format that is applicable to the general ledger extract.
Step 5
Click ‘Continue’.
The Audit Toolbar will begin to clean the General ledger and produce two new sheets:
- General Ledger cleaned in table format
- Pivot Table of the general ledger data.
