Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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:
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.
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
@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.
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:
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!
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here