Skip to main content
August 24, 2021
Question

Bank Reconciliation... how to move on?

  • August 24, 2021
  • 1 reply
  • 0 views

Hi, 

 

Briefly, about myself:

-I use Quick book desktop premier non-profit version.

-I have not completed bank reconciliation for June and July. 

-I am temporary person who is taking over the role until new accountant is hired. 

 

I have a discrepancy in bank reconciliation for June and I know the cause of it: (1) Somebody is trying to re-deposit cheque and (2) other cheque is simply a fraud as the cheque number is way too huge to be ours ... one digit more than where our company is at. Basically, there are 2 extra deposits than expected. We already asked the bank for investigation. 

 

I want to move on to the next month's bank reconciliation but since the balance does not match, I cannot complete the bank reconciliation for June yet. I noticed that the former accountant made a liability account (2000's) for transactions that needs to be hold temporarily until they have been investigated. From her past journal entries, I figured out how to write these fraud/duplicate cheques in general journal. But again, the issue that I have is that I cannot move onto July's statement until June's balance matches. In order to make the balance match, I thought of changing the initial balance (ie. add the amount of duplicate and fraud to the initial balance) so the amount in QB and bank statement would match. However, I am not sure if this is the right way to go. I do not know if this info would help but I do not think she forced QB to reconcile as I cannot find any record in "reconciliation discrepancy" account. How should I go about?

 

Thank you so much. 

1 reply

August 24, 2021

Hello yibk,

 

Glad to hear from you again. QuickBooks is a versatile program that helps you get ahead with your work. Reconciling your accounts can be a lengthy process and I'd like to help make sure you're on the right track with your work. 

 

Making sure you're recording your transactions properly is an essential step for maintaining clean books. Based on what you've described, I'd recommend reaching out to an accounting professional for expert advice on how to record the transactions. If you're not in contact with a professional, don't worry, you can search for one using this link here.

 

I'll also leave this question open in the Community so other accountant users can share their advice. Otherwise, feel free to ask other questions, I've got your back.