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.

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

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.

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.

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!

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