Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
LIMITED TIME 90% OFF QuickBooks for 3 months*
Buy nowHi All,
I'm QB desktop user. I'm reconciling a bank account that hasn't been updated in several years. I've brought the records up to a certain point, but I'm missing one month’s bank statement from 2023. I do have the following month's statement and everything after that, so I know the start and end balances for the missing period by using the ending balance from the previous month and the beginning balance from the following month.
Can I reconcile the missing month using just those balances for now? And if I later receive the missing statement, will I be able to go back, enter that month's transactions, and revise or undo the reconciliation without affecting the following months that have already been reconciled? If yes, what is the correct way to do this in QuickBooks?
Reconciling missing transactions from the previous month will create ending and beginning balance discrepancy, @Som123.
The correct way to do this is to wait until you receive the missing statement. Once you have it, manually enter the transactions associated with that period. You can undo the entire reconciliation and perform a mini reconciliation.
You can refer to this guide: Reconcile previously deleted and re-entered checking or credit card transactions.
I would also recommend consulting your accountant for additional guidance before proceeding with this.
In case you want to run your previous reconciliation reports to fix the current discrepancies, you can check this guide: Get reports for previous reconciliations in QuickBooks Desktop.
If you have any further questions, please leave a comment below.
Once you reconcile a month, you cannot undo the reconciliation without affecting subsequently reconciled months. However, you can reconcile the missing month and put the month-end discrepancy (assuming there is one) into a Reconciliation Discrepancies expense account. Then, when you get the statement, you can reclassify the amount in Reconciliation Discrepancies to the appropriate P&L/balance sheet accounts with journal entries. That could be a tedious process if a large number of transactions hit the bank account in a month,
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here