Undeposited funds and bank rec

It's good to see you here in the Community, usermichael-lamb.  
 

Let me share some information and how you can manage your transactions in QuickBooks Online.  

Undeposited Funds account let's you keep a record of payments in QuickBooks until you physically deposit the same payments at your real-life bank. Banks often combine all the payments you deposit into a single transaction. Once you have the deposit slip, you can start recording and combine those transactions in QuickBooks with a bank deposit.  

However, if you connect your bank and credit card accounts into QuickBooks, you don't need to combine downloaded transactions or use Undeposited Funds since QuickBooks already has the info from your bank. You just need to categorize and match those transactions in QuickBooks.  

Like this:  

1. Go to Bookkeeping, then Transactions.
2. Select Bank accounts .
3. Click the tile for the account you want to review.
4. Go to For review tab to start your review.  

I've added this article for more details: Categorize and match online bank transactions in QuickBooks Online.  

After that, you can start reconciling those transactions. Use this link as your reference: Reconcile an account in QuickBooks Online.  

Get back to me if you still need help or if you have any follow-up questions about banking. I'll be here to check. Have a great day!

Ok, we have the bank account and credit card linked so should not have to use undeposited funds which are leading to an overstatement of revenue and variance in our bank rec. Subsidiary questions I have are then the following:

1. How can I reverse what is already in undeposited funds which are causing the duplication in these two areas - can I do it by journal or if not by what other way?

2. We are using invoicing and then directly charging a lot of customers by credit card, I know we could do that by sales receipt. Is the latter a requirement?

Thanks

Michael

My other question re-categorization was if not using undeposited funds is this changed to AR (other side being cash) rather than income/revenue since the invoice has gone to revenue and AR, which would be standard accounting practice.

Thanks

Michael

Hi there, @usermichael-lamb. Thanks for getting back to us in the Community. I’ll further assist you in sorting out this issue about your transactions in QuickBooks Online.

If you’ve already reconciled your account while the undeposited funds wasn't cleared, you will create a journal entry to offset the amount.

Here’s how:

1. On the left navigation bar select + New and choose Journal Entry.
2. Choose an account from the Account field on. Enter the appropriate amount in the appropriate field, depending on whether you need to debit or credit the account.
3. Select the other account you're moving money to or from on the next line. Enter the same amount in the opposite column, depending on whether you typed a debit or credit on the first line.
4. Check the amounts; one line should have the same amount in the Credit column and the other should have the same amount in the Debit field. This indicates that the books are in order.
5. Write information on the memo section for you to know the purpose of your journal entry.
6. Select Save and new or Save and close.
   
   

Alternatively, you can also Match the transactions so the amount won’t show in the undeposited funds.

However, I suggest working with your accountant with regards to categorizing your transactions. This way, they might have specific instructions on how to handle the Undeposited funds account.

If they don't have one, you can invite them to your account. If you’re not affiliated with one, you can visit our ProAdvisor page and find one from there.

For more details about Undeposited Funds account and how to combine multiple payments together, check out this article: What’s the Undeposited Funds account?

Here's an article for more information about Undeposited Funds in QBO: Undeposited Funds.

I'll be around if you need further assistance with your transactions in QBO. I'm very eager to help. Take care!