cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Help us improve your self help experience. We'll donate $1 to WHO for every completed survey. Complete the survey now.
Level 2

Why are my "In Quickbooks" balance and my "Bank Balance" showing different numbers for my new company?

I have created a new company and the only transaction I have had before setting up QBO was a Paypal verification payment of £0.01. When I go into quickbooks, if I add the transaction, I then have an "In Quickbooks" balance of £0.02. Which I know is not much but its frustrating. I don't know where the extra penny is coming from... Any help would be great! I want to get this sorted out before we run much more through these books.
Solved
Best answer November 02, 2019

Accepted Solutions
QuickBooks Team

Why are my "In Quickbooks" balance and my "Bank Balance" showing different numbers for my new company?

Hello there, r-sorrell,

 

Let me clarify things out for you about the balance in QuickBooks.

 

Once your bank account is connected, the system automatically creates an opening balance. The amount is based on the real-life bank account. Thus, it causes the incorrect balance in QuickBooks.

 

No worries. You can either edit or delete this entry. Simply go to your Chart of Accounts and make changes from there. Here's how:

  1. Go to the Gear ⚙️ icon at the right top.
  2. Select Chart of Accounts under Your Company.
  3. Locate the account, then click Account history under Action.
  4. Find the opening balance.
  5. You can either delete or edit it.
  6. When you edit it, make sure to enter a zero amount to fix the opening balance.
  7. Click Save and close.

I've added this article for additional information: Fix opening balance issues in QuickBooks Online. This link will also help ensure QuickBooks will match your bank records.

 

Let me know if there's anything else you need with your bank account and I'd be glad to help you out.

View solution in original post

6 REPLIES 6
QuickBooks Team

Why are my "In Quickbooks" balance and my "Bank Balance" showing different numbers for my new company?

Hello there, r-sorrell,

 

Let me clarify things out for you about the balance in QuickBooks.

 

Once your bank account is connected, the system automatically creates an opening balance. The amount is based on the real-life bank account. Thus, it causes the incorrect balance in QuickBooks.

 

No worries. You can either edit or delete this entry. Simply go to your Chart of Accounts and make changes from there. Here's how:

  1. Go to the Gear ⚙️ icon at the right top.
  2. Select Chart of Accounts under Your Company.
  3. Locate the account, then click Account history under Action.
  4. Find the opening balance.
  5. You can either delete or edit it.
  6. When you edit it, make sure to enter a zero amount to fix the opening balance.
  7. Click Save and close.

I've added this article for additional information: Fix opening balance issues in QuickBooks Online. This link will also help ensure QuickBooks will match your bank records.

 

Let me know if there's anything else you need with your bank account and I'd be glad to help you out.

View solution in original post

Level 2

Why are my "In Quickbooks" balance and my "Bank Balance" showing different numbers for my new company?

That worked perfectly. Thanks.

Level 2

Why are my "In Quickbooks" balance and my "Bank Balance" showing different numbers for my new company?

I do not see the Account History under Action.... 

Moderator

Why are my "In Quickbooks" balance and my "Bank Balance" showing different numbers for my new company?

Thanks for pointing this out, susan76.

 

The Account History option is an old feature in QuickBooks Online (QBO). Under Action, you can use the View register instead.

 

To be updated with the latest improvements made in the product, feel free to visit this link: https://quickbooks.intuit.com/blog/whats-new/.

 

Get back to me if you have any other questions. I'm a post away to help. Have a great day!

Level 1

Why are my "In Quickbooks" balance and my "Bank Balance" showing different numbers for my new company?

Hi I did the Opening Balance part and still my "in quickbooks amount is way higher than my bank balance is there any possible reason for this. If so how can I fix it

QuickBooks Team

Why are my "In Quickbooks" balance and my "Bank Balance" showing different numbers for my new company?

Allow me to share some details about the mismatch amount between QuickBooks and your bank's balance, @mandarin.

 

This happens when there are outstanding checks, duplicate transactions, transactions that may have been modified or deleted. I'd recommend carrying out full reconciliation of the account would be the best way to find the discrepancy and allow you to amend the account accordingly.

 

Checking the Account register to verify the opening balance is one way to spot if there's an opening balance not being added correctly. This figure should be the balance of your bank account on the first day of your financial year to be accurate. Also, let's make sure that every transaction there are reconciled in the Account register. This is how it looks like:

 

 

To know more about the causes and resolution of the mismatched balances, you can check out this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

You can also reach out to an accountant to make sure that your books are accurate. If you don't have one, you can find an accountant here: https://quickbooks.intuit.com/find-an-accountant/.

 

Please don't hesitate to let me know if you have other questions or concerns. I'd be happy to help you further. Take care.