cancel
Showing results for 
Search instead for 
Did you mean: 
BratAtTbredMgmtGrp
Returning Member

Bank reconciliation

Hello,

I recently started a new job with a fairly large company and somehow, the books are a complete disaster. A previous empoyee made a huge mess out of everything and for the life of me, I can't seem to fix it. The bank account dates back to 2015 and not a single time was this account reconciled correctly. The balance is hundreds of thousands of dollars off. I've printed out bank statements but can only get as far back as 2021 for them. But is this even smart to do? I don't want to mess up anything from previous years but I don't think it can be messed up anymore than it already is. Do you have any suggestions for how I can at least get this year accurate, even if it involves making a new company file or something? Thanks!

4 Comments 4
FishingForAnswers
Level 8

Bank reconciliation

@BratAtTbredMgmtGrp  You have my condolences; I've had to fix a few things like this, and it's never easy, and rarely the same processes involved.

 

A good starting point may be to look for 'Forced Reconciliation' entries, where whoever handled it before forced the books to reconcile despite discrepancies.

 

Past that, I'd say your course of action depends in large part on what kind of company you're dealing with.

 

For instance, if it were a sole proprietorship (Unlikely, since you mentioned it was a large company), it'd probably be easiest to simply start a new file as of the start of this year, though there's a lot of possible complications even with that kind of company.

 

If it were a sole proprietor and you opted to keep the old file going, I suppose you could use an Equity account to bring the bank accounts to balance at the start of the current year as well; Sole proprietors have a much simpler Equity system to track than, say, S Corps. It's just money taken out/put in, and the Retained Earnings rolling over from year to year... basically.

 

In all likelihood, though, it may be best to consult a CPA if for nothing else than advice. There are smart people here, but they also can't see your books in real time even if you wanted to share them with strangers.

 

(Also, for reasons you're no doubt aware, keeping hard copies of the bank statements would be a great idea going forward. Banks are so stingy with those.)

KimberlyS
QuickBooks Team

Bank reconciliation

You can at least ensure your beginning balance for 2024 is correct, BratAtTbredMgmtGrp. Allow me to discuss this matter further to keep you guided.

 

You can pull up a bank statement for 2024 to check the ending balance for that period. After that, ensure the ending balance is correct for the year. However, you would still need to fix discrepancies in your data from the prior years in case of an audit. You can communicate with the bank account owner to get the statements from 2015 to the present.

 

On the other hand, I agree with @FishingForAnswers. The process of either fixing the previous year's reconciliation or starting a new file depends on the company you're dealing with. If you require additional assistance, you can visit our ProAdvisor portal to consult with an accountant experienced in QuickBooks for help with necessary corrections.

 

Moreover, you can scan this article for guidance if your accounts don't match your bank statements at the end of reconciliation: Fix issues when you're reconciling in QuickBooks Desktop.

 

Furthermore, you might want to review your past reconciliations by running a Previous Reconciliation report. It can be customized based on your needs if you have to focus on specific details.

 

Please return to this thread if you have other questions regarding fixing reconciliations in QuickBooks Desktop. We're here to lend a hand anytime and in all possible ways.

Rainflurry
Level 14

Bank reconciliation

@BratAtTbredMgmtGrp 

 

How bad are the other balance sheet accounts?  Are receivables and payables a mess too?  Do you have access to the company tax returns?  

BratAtTbredMgmtGrp
Returning Member

Bank reconciliation

EVERYTHING is a disaster! I have yet to see a single correct balance, or transaction. Even their chart of accounts is a nightmare ("Due to XXXXXX" being an other current liability as well as an expense) Im going to consult an accountant and see what they have to say. 

 

Thank you all for your advice!!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us