Occasionally, a reconciliation may show as out of balance when the Actual Counted totals don’t match the system’s Calculated Totals. This usually indicates one or more payments were entered incorrectly or assigned to the wrong payment type, such as recording a Visa payment as MasterCard. Identifying and correcting these discrepancies ensures your reconciliations remain accurate and your accounting data stays consistent.
Note: It is important to make payment corrections prior to completing the reconciliation process.
Correcting Out of Balance Transactions
1. Navigate to Accounting Module / Reconciliation.
2. Click Reconcile Accounts.
3. Click on any link below a total to display the details you want to review and determine which payments were entered in error.
4. Compare the amounts for each transaction to your records and find the payments that are incorrect, taking note of the corresponding invoice number for each transaction.
5. If an error is found, close the Reconciliation window and navigate to the Sales Module.
6. Hover over the Orders tab. Click Search.
7. Enter the invoice number that needs to be corrected and click Search.
8. Click on the invoice number to be directed to the order view screen.
9. Click on the Overrides tab.
Note: This tab is visible only to users with the appropriate override permissions.
11. Click Edit Payment.
12. Click Edit Payment to the right of the transaction you need to update.
13. Edit the payment information as needed and enter a reason for making the edits.
14. Click Adjust Payment.
15. After saving any corrections made, return to the Reconciliation page in the Accounting Module and repeat this step until all payments are properly displayed and accounted for.
