cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
Michael Hunter
Level 2

just connected bank account on qb online, how do i get them to match after years of difference,

just connected bank account on qb online, how do i get them to match after years of difference, since i have had qb for years then went to qb online it shows sales but ive never recorded outgoings so there is now years of difference in balance, is there away to reset balance without causing any issues

Solved
Best answer January 07, 2022

Accepted Solutions
EmmaM
QuickBooks Team

just connected bank account on qb online, how do i get them to match after years of difference,

Hello Michael, Thanks for the clarification. In order to bring QBO in line with the bank balance if there are 14 years of difference but you want to correct that for the current financial year so your balance sheet shows correctly it would be a case of doing a journal entry to amend the bank balance to what it should be in QB however you would then need to offset that change against another chart of account. We'd advise confirming with an accountant the best way to show this. As the difference is so large and we do see you do not want to go over 14 years' worth of data. The alternative would be starting from the current financial year and your accountant closing the previous financial year. 

View solution in original post

7 REPLIES 7
TirzahC
QuickBooks Team

just connected bank account on qb online, how do i get them to match after years of difference,

Let me help you sort this out, Michael Hunter.

 

There are several reasons why QuickBooks may not recognize a match:

 

  • The transaction is older than 180 days.
  • The dollar amount in QuickBooks is different than what cleared the bank.
  • The transaction type is different in QuickBooks than at the bank. QuickBooks wants to match a check with a check and an expense with an ACH or debit/credit card swipe.
  • The transaction was recorded in a different bank account.
  • The transaction from the bank is a payment/ deposit of two or more open transactions in QuickBooks.

In addition, here's an article you can read to learn more about how you can categorize and match your downloaded transactions:  Download, Match, and Categorize your Bank Transactions in QuickBooks Online.

 

Please let me know how it goes in the comment section down below. I'd be always around ready to lend a helping hand.

Michael Hunter
Level 2

just connected bank account on qb online, how do i get them to match after years of difference,

Thank you for the reply, however i am unsure if this is correct in my case.

my quickbooks started in 2007 and when i receive payments i deposit them into my bank account on the software, so for 14 years quickbooks has seen money going into my bank but nothing out as i never used it for this purpose.

now in 2022 i have connected my bank and there is a difference of £700,000.00 between my actual bank and quickbooks account

AlcaeusF
Moderator

just connected bank account on qb online, how do i get them to match after years of difference,

Hello @Michael Hunter,

 

We want to help you with your questions about the bank account balance. However, we need more information about it to provide the correct resolution and to get this sorted out promptly.

 

Did you migrate from QuickBooks Desktop to QuickBooks Online? Are you able to move your bank transactions to the new version of QuickBooks? If you can add more information like screenshots, it will help us provide a much more accurate resolution.
 
In the meantime, you can check the following article for more information about connecting bank account in QuickBooks Online: Connect bank and credit card accounts to QuickBooks Online.

 

Please know that you're always welcome to post any questions you have in this space. Have a great day ahead.

Michael Hunter
Level 2

just connected bank account on qb online, how do i get them to match after years of difference,

Thanks for reply.

 

I migrated from desktop to online several years ago but still did not connect banking until now. I can not set the opening balance as it is now as opening balance was in 2007.

LeizylM
QuickBooks Team

just connected bank account on qb online, how do i get them to match after years of difference,

Hi there, Michael Hunter

 

Please allow me to join the thread and lend a helping hand so you'll be able to connect your account to QuickBooks Online (QBO).

 

For me to give you the right amount of information, may I know if you've received an error message when trying to connect your account?

 

There are certain bank errors that block QuickBooks from downloading new transactions. If you happen to encounter one, follow the links listed in the Step 4 section of this article to be guided in fixing it: What to do if you get a bank error or can't download transactions.

 

If the issue persists, we can perform some troubleshooting to see if it's a browser-related cause for this behavior.

 

We can start with opening a Private Window or an Incognito Window in your web browser. This will open your account in a clean slate and loads fresh data.

 

Here's how:

 

  • Mozilla Firefox / Internet Explorer: Press CTRL Shift P
  • Safari: Press Command Shift N
  • Google Chrome: Press CTRL Shift + N

 

If it works, you can go back to your original browser and clear the cache. Alternatively, you can use other compatible browsers.

 

You'll also want to manually enter transactions to your bank. Please read this article for more information: Manually Upload Transactions into QuickBooks Online

 

In addition, you can match transactions that you've entered in QuickBooks. Here's an article for reference: Categorize and Match Online Bank Transactions in QuickBooks Online.


Drop me a message below with updates on your banking connection concern. I’ll get back to you as soon as I can. Always take care!

Michael Hunter
Level 2

just connected bank account on qb online, how do i get them to match after years of difference,

thamks, there are no errors in connecting my bank, my issue is that the time of register creation 2007 and connecting bank to qbo 2022 is 14 years worth of difference. i need to bring qbo into line with actual bank balance 

EmmaM
QuickBooks Team

just connected bank account on qb online, how do i get them to match after years of difference,

Hello Michael, Thanks for the clarification. In order to bring QBO in line with the bank balance if there are 14 years of difference but you want to correct that for the current financial year so your balance sheet shows correctly it would be a case of doing a journal entry to amend the bank balance to what it should be in QB however you would then need to offset that change against another chart of account. We'd advise confirming with an accountant the best way to show this. As the difference is so large and we do see you do not want to go over 14 years' worth of data. The alternative would be starting from the current financial year and your accountant closing the previous financial year. 

Need to get in touch?

Contact us