Using the Balance Report Transactions
Use Balance Report Transactions to export details of transactions in the Balancing panel or Balance Summary into a single zip archive.
For each reconciliation, the exported zip archive includes all transactions from the following buckets in the Balancing panel or Balance Summary of the reconciliation:
- Less Unmatched
- Less Unmatched Supported
- Less Matched In-Transit
Use this report to get a snapshot of your reconciliation and all its transactions or balances at a given point in time. The recommended best practice is to generate this report before you submit a reconciliation and attach it to the reconciliation. At a later date, you can generate this report and compare it with the report that was generated when the reconciliation was submitted. Comparing these two versions of the report enables you to analyze changes that have occurred in the reconciliation after it was submitted.
To generate the balance report transactions:
- From Home, select Matching, and then select a reconciliation from the list.
- From Actions, select Open. The Overview tab of the reconciliation appears.
- In the Balancing panel, select a date. The period corresponding to the selected date is displayed in Period.
- Click Actions and then Balance Report Transactions.
The Information dialog appears indicating that a Balance Report Transactions job was submitted. It also contains the job ID.
- Click the link in the Information dialog to download the generated report.
The Job History page appears.
- Click the Succeeded link for your job ID to download the archive zip file.
The downloaded zip file contains the following:
-
A
.csv
file for each data source. The file contains transactions from all three buckets in the Balancing panel or Balance Summary, for this data source.The file name begins with the name of the data source and the job ID.
-
A
.csv
file for original adjustments in source systemThe file name begins with Adjustments_source_system and also contains the job ID.
-
A
.csv
file for original adjustments in the subsystemThe file name begin with Adjustments_subsystem and also contains the job ID.