cancel
Showing results for 
Search instead for 
Did you mean: 
mrweiner
Level 1

Invoice payment deposited into bank account not linked to my QBO account -- how to reconcile?

At the beginning of the year I started operating as a Corp instead of a Sole Prop. As such, I've got a new QB online account for the corp whose books started at the beginning of 2020. In Feb I sent out an invoice from this corp account which was processed through Quickbooks payments. However, at this point I hadn't updated my bank account for deposits, so the funds were deposited into the Sole Prop bank account (which is not, and should not be, linked to this QBO acct).

 

This is causing an issue where my corp's register doesn't match my corp bank account balance. Quickbooks' register has an entry for the "undeposited funds" and associated fee for the invoice, but since the deposit went into an unlinked account there's no transaction to link those to.

What would be the proper way to remedy this? The undeposited funds (ie the invoice amount) is $5760 and the fee is $167.29. I can easily write myself a check to the Corp from the Sole Prop but not sure how to reconcile this & handle the orphaned entries. I'd assume it's something with "match" but not sure exactly what to do.

5 Comments 5
GlinetteC
Moderator

Invoice payment deposited into bank account not linked to my QBO account -- how to reconcile?

Welcome to the Community, mrweiner. 

 

I've got steps on how to handle this in QuickBooks Online. We'll have to create a bank deposit to link the invoice payment less the amount of the fee. Please note to refer to the bank statement when reconciling your account.

 

Here's how to make a bank deposit:

 

  1. Select +New and choose Bank Deposit.
  2. From the Account drop-down ▼, select the account you want to deposit the money into.
  3. Select the box for each payment.
  4. Select Save and close.

For more information, please refer to this article: Record and make Bank Deposits in QuickBooks Online

 

I've also added links about reconciliation in QBO:

Let me know if you need anything else. I'll be around to help.

Rustler
Level 15

Invoice payment deposited into bank account not linked to my QBO account -- how to reconcile?

@mrweiner 

 

I can easily write myself a check to the Corp from the Sole Prop but not sure how to reconcile this & handle the orphaned entries. I'd assume it's something with "match" but not sure exactly what to do.

 

Yep that is what you do, then do a manual recon of the account.  In the sole proprietor account you would make the deposit as equity investment, and the check would use equity drawing as the expense

 

In the corp account, use make deposits after you actually make the deposit in real life

mrweiner
Level 1

Invoice payment deposited into bank account not linked to my QBO account -- how to reconcile?

@GlinetteCThank you for the info, but I'm unable to follow the steps as provided. When I'm on the Bank Account form, there are no payments listed for me to select.

EDIT: Sorry Rustler...looks like I replied to the wrong comment.

Catherine_B
QuickBooks Team

Invoice payment deposited into bank account not linked to my QBO account -- how to reconcile?

Thanks for keeping us updated and I've read the thread as well, mrweiner.

 

In QuickBooks Payments, we can set an account to where we'll deposit the payments of the invoice. It's possible that you've set it to default as Undeposited Funds. I'll show you how we can update and verify that:

  1. Go to the Gear icon and click Account and Settings
  2. Select the Payments menu. 
  3. Click QuickBooks Payments and review and edit the account. 
  4. Once done, click Save and then Done

We can also review an invoice payment that was deposited to the Undeposited Funds account. Just click Sales and select Invoices. Click the linked payment and review the account that's under the Deposit to field.

 

Then, we can go back to the Bank deposit page to see if the payments are now listed under the Select the payments included in this deposit section. 

 

You can also use these articles on how to manage your bank feeds: 

Feel free to get back to us if you need anything else. You take care always!

 

mrweiner
Level 1

Invoice payment deposited into bank account not linked to my QBO account -- how to reconcile?

Thank you for the extra info. I actually sorted this all out a few minutes ago. The issue was that since the invoiced payment did deposit (just into the wrong bank account), the payment was already associated with an existing deposit.

I had to delete the existing deposit, as well as the auto-generated Bank Charge expense relating to the payment processing fee. Afterward I was able to create a new deposit, where the payment was now present since it was disassociated from the auto-generated deposit.

Need to get in touch?

Contact us