Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
There are bank transactions going back to 2018 and the bank rec has never been done. I have tried to do it but it is not matching. I know the 'books' are correct as the accountant has done year end up to April 2021. I don't want to mess around really with previous years. I want to start afresh and do the bank rec from April 2021 onwards but obviously the balance at that date does not match. Can I enter an opening balance for 01/04/2021 as per the bank statement and continue from there? If so, what journal would I put in for this? Will I be then left with transactions in the bank rec always waiting to be matched?
I know this in an ideal world it would be done but if anyone can help with a solution it would be appreciated.
Solved! Go to Solution.
Hi. I would ask your accountant for a copy of their bank reconciliation at 31st March 2021. That could show up outstanding transactions at 31/03/21 (entries posted in March that didn't clear until April) and help with your first reconciliation at that date.
If they don't have one (!) then the only solution would be to post a correcting Journal as you suggest, on 1st April, but again, I would ask your accountant where to post the opposite side. You can then do one reconciliation up to that date to tick everything as cleared.
Hi. I would ask your accountant for a copy of their bank reconciliation at 31st March 2021. That could show up outstanding transactions at 31/03/21 (entries posted in March that didn't clear until April) and help with your first reconciliation at that date.
If they don't have one (!) then the only solution would be to post a correcting Journal as you suggest, on 1st April, but again, I would ask your accountant where to post the opposite side. You can then do one reconciliation up to that date to tick everything as cleared.
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.