Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
R
REB1952
November 9, 2021
Solved

BANK DIFFERENCE

  • November 9, 2021
  • 1 reply
  • 0 views

Hi I did not use quick books for a year. But have gone back to it. Everything goes through my bank. My bank only downloaded the last 90 days so I entered the previous 60 days manually. I then ran a TB at 1 June 2021 and put through a journal to bring this inline with my TB at 31 May 2021. However even though I know everything is entered in my bank from 1 June 2021 to date I have a large difference on the quickbook balance compared to the actual balance. Should I have done something else? Run a year end first or something? Is it now to late or is it still recoverable? Or should I simply open up a new company on Quickbooks and start from scratch? It means I will have wasted 3 days work.

Best answer by ChristineJoieR

Hi,

Sorry but I am not uploading a years transactions I don't need. It would be simpler to start from scratch.

As I have said there are transactions in the account going up to May 2020, then nothing for a year until 1 June 2021, when I started again.

 

Is there some way of changing the opening balance to the actual balance at 1 June 2021, otherwise it will be simpler to start from scratch?


Thank you for visiting at Community, @REB1952.

 

I am here to help you with your concern. There's a way to edit your opening balance without starting from scratch.

 

Follow the below:

 

  1. Go to Setting, then click Chart of Accounts.
  2. Find and click the Opening Balance account.
  3. Edit the amount, then click Save.

 

 

You can refer to this link for you guide.

 

You can also utilise this link to reconcile your bank statement in QuickBooks Online.

 

For more concern regarding this, don't hesitate to drop comment. I am always here to lend a helping hand. 

 

 

 

1 reply

E
EmmaM
Level 10
November 9, 2021

Hello, Reb1952, Without seeing the journal(that is something you may want to check is right with your accountant. The best thing to do would be to use the reconciliation tool, we'd recommend doing a month reconciliation at a time, so for example the first month if that is May or June 2021 or prior to that. It will ask you to enter an ending balance which you would take of the bank statement itself for each ending period(you enter the ending dates and then tick all the transactions which show in the bank in that period( you'll find a lot of them are pre-ticked. More information on how to do a reconcile can be found here. We've also included an article about fixing issues if it is your first time reconciling. Essentially the month where you find a difference you can enter missing transactions or remove duplicates to make the difference zero. Any queries we're happy to help just reply to this thread.

R
REB1952Author
November 10, 2021

Thank You. Very Helpful. I have checked the journal and my opening TB at 1 June 2021 is correct.

However the opening balance on the bank reverts back to 2019 and there is the whole year June 2020 to May 2021 not entered because I did not use Quickbooks. How do I get it to reconcile from 1 June 2021 onwards using the opening bank balance at 1 June 2021?

C
ChristineJoieRQuickBooks TeamAnswer
QuickBooks Team
November 10, 2021

Hi,

Sorry but I am not uploading a years transactions I don't need. It would be simpler to start from scratch.

As I have said there are transactions in the account going up to May 2020, then nothing for a year until 1 June 2021, when I started again.

 

Is there some way of changing the opening balance to the actual balance at 1 June 2021, otherwise it will be simpler to start from scratch?


Thank you for visiting at Community, @REB1952.

 

I am here to help you with your concern. There's a way to edit your opening balance without starting from scratch.

 

Follow the below:

 

  1. Go to Setting, then click Chart of Accounts.
  2. Find and click the Opening Balance account.
  3. Edit the amount, then click Save.

 

 

You can refer to this link for you guide.

 

You can also utilise this link to reconcile your bank statement in QuickBooks Online.

 

For more concern regarding this, don't hesitate to drop comment. I am always here to lend a helping hand. 

 

 

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement