This section describes the specifics of accessing and interpreting Cash Reconciliation History report.
Opening Report
You can find the report at Reports > Accounting > Accountant Reports > Cash Reconciliation History. For more information, see Viewing Reports.
Viewing Report
The report provides a flat, immutable audit trail of all manual and automated adjustments made to the in Cash Reconciliation workflow and Daily Data form. It captures changes across all payment types and exposes concurrent system updates.
The report contains the following information:
- Location: The store identifier where data was changed.
- Business Date: The operational day that the cash reconciliation belongs to.
- Shift: Shift number.
- Payout: The specific payout type, expense account, or money-out category when the changed line belongs to the Money Out section.
- Payment Type: The specific MOP or system line item impacted.
- Action: Full description of the action taken. Combines transaction type and modification state.
- Changed at: Actual server timestamp when the record was saved.
- Changed by: Username or employee name who made or triggered the update.
- Previous Value: Dollar amount before the change was saved (blank for newly created entries).
- New Value: Resulting dollar amount after the update or deletion.
Understanding System vs. Manual Updates
- Manual Update: Appears when a user types directly into an unlocked reconciliation field on the Daily Data form.
- System Update: Appears when CStoreOffice® automatically modifies an offset row based on linked transactions.
Filtering Report Data
To get the exact information you need, you can apply filters to the report:
- Select a predefined or custom date interval to narrow down history log.
- Click the Advanced Filters button to open the extended filters section:
- Select locations (stores) by name or by tag.
- Specify the additional date interval for the Business Date field.
- Select payment types you are interested in.
In addition to filtering, you can group report data by location and calculate subtotals. Select Location in the Subtotal block of Advance Filters.
Once the filters are set up, click the Refresh button to display the report data by the filter criteria.
To reuse the selected filters / grouping preset, click Save and specify the saved filter name. You can quickly apply saved filter by selecting the preset from the dropdown next to the Advanced Filters button.
Additional Actions
- To reload the report, click the Refresh button.
- To print the report, click the Print button.
- To save the report as the Microsoft Excel spreadsheet (.XSL), click the Excel button.
- To save the report as the Comma-Separated Values (.CSV file, click the Blank sheetbutton .
- To send the report to the specified email address, click the Mail button and specify the recipient, subject and description. The report will be attached to the email message as the Microsoft Excel spreadsheet (.XSL).
For more information on additional report features, see Reports.
