Skip to main content
All CollectionsReportingTips
End of Day Reconciliation
End of Day Reconciliation

Tips for end of day reconciliation process and finding discrepancies

Updated over 3 weeks ago

Overview

The Reconciliation Report provides a summary of payment totals recorded for each payment method. It is typically used at the end of the day to reconcile the payments recorded in PracSuite against your daily takings (e.g. cash, EFTPOS, Credit Card, Health Fund).

In most cases you will be reconciling this report against your:
- Cash drawer

- POS terminal summary (e.g. Tyro EFTPOS terminal)

- Bank statement

The results of this report can also be grouped by date and business.


How to manage discrepancies

If you are noting a discrepancy between the Reconciliation Report and your physical cash, EFTPOS or banking records, possible causes include:

- An additional payment has been recorded in PracSuite;
- A payment has not been recorded in PracSuite;
- A payment has been recorded with an incorrect amount, date, business or payment method.

You should trust that the amounts listed in PracSuite are accurately calculated based on the payments you have entered. We recommend the following approach to finding discrepancies:


1) Identify the affected payment method(s)

Using the Reconciliation Report, identify the payment method(s) that are not reconciling and note the difference in amount between PracSuite and your source.

e.g.

"We are missing $120.00 in EFTPOS payments in PracSuite, compared to the EFTPOS terminal printout."

or

"Our cash is $100.00 over in PracSuite, but our Credit Card value is $100 short."

Please ensure you are searching for a limited date range, such as a single day, rather than an entire week or month.

2) Confirm that you are comparing the correct details

Ensure that you are referencing the correct date and business on your Reconciliation Report, in comparison to your EFTPOS, Credit Card, or Health Fund summary.

3) Search the Payments Report for details

Run the Payments Report in PracSuite, searching by "Payment Date" to obtain a detailed list of payments recorded with that payment method.

4) Cross-checking your transactions

Cross-check each payment on the Payments Report against each transaction on your terminal printout or banking summary.

e.g.

If you have a ↑↑ HIGHER↑↑ amount recorded in PracSuite compared to your EFTPOS summary, you are searching for a payment that is not recorded on your EFTPOS terminal.

If you have a ↓↓LOWER↓↓ amount recorded in PracSuite compared to your EFTPOS summary, you are searching for a payment that is not recorded in PracSuite.

Note that the Payments Report in PracSuite includes a date and time, which should be checked chronologically against your EFTPOS/Banking summary.


Still having trouble?

You can also filter these reports by Date and Time. ​


This can be used to reduce the search range to the smallest window possible. If you cannot reconcile an entire day, try to reconcile a few hours at a time until you find the issue.

5) Make appropriate payment adjustments

Resolve the payment discrepancy in PracSuite by:

- Adding or removing a payment.
- Editing a payment to be the correct amount, type, date or business.

Click here for instructions on how to edit payments.


Frequently Asked Questions

How are Tyro settlements received?

As with Bank Transfers, several factors can affect when your daily takings from Tyro services are deposited into your account. Please see the following page for more details: https://help.tyro.com/s/article/Guide-to-Tyro-settlements

Most Tyro transactions made via integration with PracSuite are approved or declined immediately, and when approved, they can be trusted to reach your bank account on schedule. If you believe payments are not being received correctly, please refer to Tyro or your accountant/bookkeeper for further investigation.

For further information on Tyro Health Fund settlements, please see below:
https://help.tyrohealth.com/en/articles/5826582-tyro-health-online-settlements


How are bank transfers and cheques reconciled?

Bank transfers and deposited cheques may not appear in your bank account immediately, often taking 1-2 business days. In most workflows, you would only record the payment in PracSuite after it has been confirmed in your bank account, which would then reconcile cleanly.

If you are recording a bank transfer preemptively, based on a remittance advice, the payment dates in PracSuite may appear differently compared to the transaction on your bank statement. Consider reconciling directly against Reports > Billing > Bank Transfers or Reports > Billing > Cheques if needed.

Did this answer your question?