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
Available Filters in the Report
The Information in the Report
Label |
Description |
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 |
|
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 |
|
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 |
|
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