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 ‘UniCleaner’ Button in the Cleaning and Structuring Section.
Upon selection a pop-up window will appear.
Step 2
On this pop-up, if you can see that the System has been correctly identified, you can click “Continue”.
Please proceed to step 6, otherwise continue to the next step. The Audit Toolbar will begin to clean the General ledger and produce two new sheets:
- General Ledger cleaned in table format. (Step 6)
- Pivot Table of the general ledger data. (Step 7)
Step 3
On this pop-up, if the System has not been identified, the you have the option to proceed to the Automated GL Recognition Parameters. This will allow you to still clean the GL, without UniCleaner knowing what the source account system is.
Click on “Continue” and a new pop-up will appear.
Step 4
In this step, you are required t essentially assist UniCleaner to understand the layout of the GL by selecting examples of each of the items shown. Simply click on the Magnifying Glass next to each item and select the related example from the GL.
Here are some things to keep in mind in this step:
- Row with Headings: In most Cases this row would be automatically identified and highlighted by UniCleaner on your behalf.
- Blank Headings: Only tick this if the headings the GL you are working with does not have headings.
- First Account: This is the only item where you need to select a specific item, the First Account.
- Debit and Credit vs Amount: In some cases you might have only an Amount heading. In that case you simply need to select an example of a Debit and a Credit in the Amount column. The same can be said for the Opening balances.
- Optional items: The option items will determine whether these items are included and taken into consideration in your clean or not.
Step 5
Once you have completed the above 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.
Step 6
On completion you will see two new sheets. The first is the General Ledger cleaned in table format
Step 7
The second is a Pivot Table of the general ledger data showing the Month-to-Month Movements for each account.
It includes a heatmap which illustrates the trends per account in a visual format.
