Reconciliation Report

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
  • 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