Checkbook Reconciliation Report Has a Difference on Last Page

Checkbook Reconciliation Report Has a Difference on Last Page

When you print the checkbook reconciliation report after saving a reconciliation, the last page of the report has a calculation that compares the “Reconciled Balance” (what the account balance actually should be, based on the data and transactions you have entered) and the “Register Balance”.  The difference amount in that section should $0.00. Reasons it might not be $0.00 are

  • The Statement Ending amount on the last page of the printed reconciliation report isn’t correct.  This is the amount you entered as the statement ending balance before you saved the reconciliation;

  • There are transactions in the reconcile windows of the Checkbook screen that will never appear on a future bank statement;

  • There are transactions in the register that shouldn’t be there.  You included them in a previous checkbook reconciliation rather than voiding them, and forced the reconciliation to balance.

  • You voided one or more checkbook transactions that had been included in previous checkbook reconciliations, but did not re-create and re-reconcile those transactions;

  • You have never reconciled the account so that the reconciled balance and register balance are the same.

  • A system error in one or more checkbook transactions.

To resolve a difference, do the Checkbook Reconciliation steps in our End of Period Procedures.  Those procedures will have you run a Checkbook to GL Reconciliation report, will also help you find and fix certain issues, and will have you call QFloors Support for certain issues caused by system errors.  After doing all of the the checkbook reconciliation steps in the End of Period Procedures, if the Checkbook to GL Reconciliation report still shows that you need to make an adjustment to the account, you have two options:

    1. Find and correct your transaction errors.

    2. Make the adjustment indicated.


    • Related Articles

    • 1099 for Vendor that is NOT in Employees-Subs Screen

      The data that QFloors uses for printing your 1099’s and the corresponding Form 1096 comes only from pay that was created from the Employees/Subs screen.  If you need to include a vendor in your batch of Form 1099’s and the corresponding Form 1096, ...

    • Inventory Balancing

      INVENTORY BALANCING An explanation of various incorrect procedures we’ve seen customers do, and what the correct procedures are to keep your Inventory general ledger account and your Stock list in balance.  There are various procedures in QFloors ...

    • Barcode Equipment

      QFloors Barcode Equipment Included with your QFloors product is the ability to interface with barcoding equipment.  Barcoding features can help you Populate sales orders with materials at the point of sale (POS) Receive and track inventory Count and ...

    • Quick Check

      Quick Check Use the Quick Check feature in the Checkbook screen to quickly create a payment.  The payment may be printed as a check, or may be a “Non-check Item” to reflect electronic transactions that occur in your bank or credit card account. ...

    • QFloors Won’t Open on Workstation After it is Updated to version 1803 of Windows 10 (Microsoft issue - discontinued SMBv1)

      QFloors Won’t Open on Workstation After it is Updated to version 1803 of Windows 10 (Microsoft issue - discontinued SMBv1) Issue: QFloors won’t open at a workstation (error message that the server has been turned off, or the database files have been ...