Deposited invoice payments not appearing in QB bank account

Good day to you, @Ștefan.

I'll share some steps to help you fix the negative QuickBooks balance of your bank account in QuickBooks Online (QBO).

Once your bank account is connected to QBO, the system automatically creates an opening balance. Thus, you'll want to review it together with your recorded transactions to ensure that the amount is correct based on your real-life bank account. Here's how:

1. Go to the Gear icon at the top.
2. Select Chart of Accounts under Your Company.
3. Locate the account, then click Account history under Action.
   
   
4. Find the opening balance, then edit it if needed.
5. Double-check the amount of each recorded transaction in your account register.
6. You can either delete or edit the transactions if necessary to fix them.
   
   
7. Select Save or Save and close.

Regarding the process of combining the payments first into the undeposited funds account and then depositing them to your bank, you can check out these articles to read more details about the process:

• Deposit payments into the Undeposited Funds account in QuickBooks Online
• What’s the Undeposited Funds account?

Once you're good with all of your transactions, you can now proceed to reconcile an account in QBO. If everything matches up with your bank or credit card statements, you know your accounts are balanced and accurate.

Keep me posted if you have follow-up questions about the QuickBooks balance by commenting below. We're happy to help anytime. Keep safe!

Thanks for your reply @Kevin_C, but I don't think this is addressing my issue.

1. I don't need to explicitly set an opening balance since I've tracked everything in QB since the creation of the bank account. Basically my bank account started with zero funds.

2. I DO NOT need to follow the process of depositing into "undeposited funds" since I can simply associate a payment with multiple invoices directly.

3. I checked the chart of accounts for my "Wise GBP Account" and strangely, the invoices are marked as PAYMENT (as if going out of the bank account), while the recorded payments are marked as DEPOSIT (which is correct in my opinion). Why do the invoices appear as PAYMENT out? See the screenshot below.

Ștefan

Hi there, @stefanistrate.

Thanks for adding further details in regards to your concern. The screenshot is very helpful as well.

I'm here to provide further details with your concern. 

In QuickBooks Online, the payment column in the bank register represents the amount that was paid or received for a transaction.

When you create an invoice it is considered a sales transactions and is recorded in the sales section of your chart of accounts. When the customer pays the invoice, the payment is recorded in the bank register as a deposit.

If you see an invoice listed in the Payment column of the bank registered, it means that the invoice has been paid by the customer.

Furthermore, the payment column in the bank register is not the same as the Amount Due column in an invoice. The Amount Due column shows the total amount that the customer still owes on the invoice, while the Payment column in the bank register reflects the amount that has already been paid. 

I’m also sharing these articles for your guide when reconciling your transactions:

• Learn the reconcile workflow in QuickBooks.
• Reconcile An Account In QuickBooks Online.

I'm just a post away if you have any other bank balance concerns. I'll be around to assist you further. Have a great rest of your week.

Thanks for your reply, @AbegailS_! As per your comment, assuming that invoices being listed in the Payment column is the expected behaviour, how can I still solve my issue of negative balance in my bank account?

I have decided to delete my 5 existing invoices and the 3 associated payments and start with a clean plate to ease the debugging.

1. Here's how my bank account looks at the moment.

I want to retroactively add 4 invoices with 3 payments that match the listed transactions. My understanding is that the negative balance from QB is due to these 3 transactions that are not yet categorised. Once I'll match them to 3 invoice payments, QB should match the Wise GBP Account bank balance exactly. Is this the right interpretation?

2. My next step is to recreate the 4 invoices I issued in the past. This is how they look.

3. Upon checking the Bank transaction section, I noticed something strange: why did the QB balance decrease even more by the total amount of the invoices? All I wanted to do was to create invoices to match the existing transactions once paid and deposited.

Any idea what is going on? It's really disappointing to not be able to figure out such a simple workflow with the public documentation. Am I doing something wrong?

Ștefan

Thank you for getting back to us, @stefan.

I'll share some information to help you fix the negative balance on your account.

Reconciling the account with bank statements is the best way to fix the discrepancy between bank balances. However, if the difference is substantial, you should confirm that a beginning balance has a record in your bank in QuickBooks (the bank balance of the date you start recording transactions in QuickBooks).

 This balance would be the first transaction entered into the account. Follow the steps below to check this:

1. Go to the Chart of Accounts.
2. Select Account History.
3. From the bank account page, click the Date button to re-order the list from oldest to newest.

To review the opening balance in QBO, I'm adding this article: Fix issues the first time you reconcile an account in QuickBooks Online. This provides details about account reconciliation.

Please know that I'm just a Reply away if you have other concerns about reconciling transactions. I'll be around to lend a hand. Have a great day!

This is not helpful. Did you fully read my last message? It's not a matter of reconciling, but rather an issue with invoicing.

Getting back and forth isn't easy, @stefanistrate. I understand the frustration you feel when you're not getting the assistance you need.  

Don't worry, let me redirect you to the best help available so the deposited payments will reflect in your bank account in QuickBooks Online (QBO).

Since none of the troubleshooting steps provided by my colleagues worked on your end, I'd recommend reaching out to our customer support. They'll be able to use a screen-sharing tool that helps identify the cause of the issue better. This way, they can walk you through performing the troubleshooting steps to resolve your concern. To do that:

1. Go to Help and click the Search tab.
2. Click Contact Us.
3. Provide a brief description of your issue and click Next.
4. Choose between Chat with us and Have us call you.

Furthermore, here's an article if you want to automatically categorise transactions from your bank: Set up bank rules to categorise online banking transactions in QuickBooks Online. The more often you use your bank rules in QBO, the better it becomes with categorising. It can eventually even scan transactions and add information like payees.

Feel free to get back to this thread if you have clarifications with bank deposits. We're always here to assist you with your concerns. Stay safe, and have a nice day.