How it works
This function is designed to reconcile two datasets by aligning summary data (e.g., totals in a revenue ledger) with the corresponding detail data (e.g., individual entries in a revenue invoice listing). It identifies discrepancies by ensuring that the aggregate of detailed transactions matches the summarized figures.
How to use it:
Step 1
In the Analysing and Sampling group of The Audit Toolbar, within the more drop-down, click on ‘Batch Recon’.
A new Pop-up window will be displayed.
Step 2
The function runs based on having two datasets each with a Key header/Reference Number column and a value header/column.
Key header/Reference Number column (Order Number)
- The Order Number column serves as the identifier or key column.
- It is used to match rows between the two tables.
- Each entry in this column should be unique (or treated as such for matching) to ensure accurate comparisons between the tables.
Value Column (Total Cost)
- The Values column contains the numerical or transactional data associated with each account.
- This is the column being compared between the two tables to identify differences, such as discrepancies in balances, amounts, or other metrics.
Now, select the Key and value headers/columns for the Summarised dataset.
Step 3
Select the Key and value headers/columns for the Detailed dataset.
The tool can reconcile the items that each value belongs to before totaling the individual transactions. To include this move to step 4 otherwise click OK and skip to step 5.
Step 4 [Optional]
Select the Items header/column.
Then Click OK
Step 5
A new sheet will be populated, where each of the batch items from the summary are compared to the total values for each item from the detailed dataset.
If items are selected, then a column for with the total value from the detailed dataset each item will be shown and this will agree to the total value.
