How do you get a reconciliation report to show the registered balance just to the end of the month and not to the day you are reconciling on.

Thank you for your question, reception7.
 

In QuickBooks Online CA, the reconciliation report is a static snapshot of the reconciliation you perform. It doesn’t automatically adjust to show balances only to the end of the month unless you set the reconciliation up for that month-end date.
 

Here are the steps to ensure the report reflects the registered balance up to the end of a specific month:
 

• When starting the reconciliation, enter the statement ending date as the last day of the month you’re reconciling. For example, if you’re reconciling for March, enter the statement ending date as 3/31/2024.
 

• During the reconciliation process, only check off transactions that are dated on or before that month-end date. This ensures the reconciliation focuses on the balance and activity up to the end of the desired month.
 

• After reconciling, the reconciliation report will display the register balance, statement ending balance, and cleared transactions as of the month-end date you set at the start of the reconciliation.
 

If you performed the reconciliation on a later date (e.g., mid-month or beyond) and need the report to reflect only month-end balances, please note that QuickBooks does not automatically adjust reconciliation reports to reflect prior month-end balances if a reconciliation has already been completed beyond that date.
 

To correct the report to reflect only month-end balances, you would need to undo the reconciliation and redo it using the correct month-end date.

Please leave us a response if you have other questions or concerns.