Summary of the Report
The Reconciliation report shows the takings entered using the reconciliation feature in OfficeMate. This report is often accessed by or given to the bookkeeper so that they can compare this to the takings that arrived in the actual bank accounts or the accounting software for the business.
Note: To find this report search 'Reconciliation Report' in OfficeMate
![](https://help.ordermate.com.au/hs-fs/hubfs/Reconciliation-png-2.png?width=1251&height=882&name=Reconciliation-png-2.png)
Available Filters in the Report
- Daily
- Summary
The Information in the Report
Filters
- The date filter will only list dates where a reconciliation has been started
- Reconciliation can be completed per shift and/or by date
- The filter will single shifts/dates only
- The summary filter if;
- Enabled: Will show an itemised list of ALL tender types entered ie. Visa, Mastercard, AMEX, Cash
- Disabled: Will show a SUM of each payment type entered ie. Credit Total, Cash
Cashdrawer (Displayed left to right)
- Each 'Terminal Location' will be listed as a heading, then;
- Each cashdrawer will be listed individually (with totals)
- A sum of all cashdrawers in that location will be calculated
- Then a sum of ALL cashdrawers per location will be calculated
Float Actual
- The value of the Float that has been manually entered
- A Float is the amount of cash in the cashdrawer at the beginning of the shift
Skims Actual
- The sum of all Skims that have been manually entered
- A skim (sometimes known as a rake) is a way to record cash that was removed from the cashdrawer prior to the end of a shift
Cash Actual
- The sum of all Cash that has been manually entered
Cash System
- The expected Cash total
Cash Variance
- The difference between 'Cash System' and 'Cash Actual + Petty Cash + Float' totals
- Can be positive (+) or negative (-) variance
Card Actual
- Any Card tender types that have manually been entered in reconciliation will be listed
- Any tender types not used will be omitted
* If the summary filter is enabled, all tenders will be grouped
Card System
- The expected Card total
Card Variance
- The difference between Card System and Card Actual
- Can be positive (+) or negative (-) variance
Web Actual
- Any WEB types that have manually been entered in reconciliation will be listed
- Any tender types not used will be omitted
Web System
- The expected WEB total
Web Total
- The difference between WEB System and WEB Actual
- Can be positive (+) or negative (-) variance
Petty Cash
- The sum of all petty cash that has been manually entered
- Petty Cash is a way to record cash that was removed from the cashdrawer to make purchases during a shift
Over Ring
- The sum of all Over Rings that have been manually entered
- Over rings are a way to correct or adjust the takings for accidental payments made. Refunds is the preferable method to amend mistakes.
Cashout Actual
- The sum of all Cashout that have been manually entered
- Cashout is processed on the eftpos terminal, where the customer is given cash (usually as part of a sale) as part of the transaction
- This total is usually found on the eftpos summary
Total Actual
- The sum of ALL tender types that have manually been entered in reconciliation will be listed
Total System
- The expected total of ALL payment types
Total Variance
- The difference between Total System and Total Actual
- Can be positive (+) or negative (-) variance
- This is your total variance
- Per Cashdrawer and;
- Per Location and;
- For ALL Cashdrawers for ALL locations
Note: This is a takings report, so GST, discounts/surcharges etc are not itemised