SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
mendingtrails
Level 1

Undeposited Funds

I have over $12,000 in undeposited funds sitting in my QB online account. All of these funds have actually cleared our bank and been deposited into our account and came in through QB online payments. The customers' accounts show that they have paid these amounts. But we can't reconcile our books because these funds show as not being deposited. Any ideas on how to correct this?

5 Comments 5
CharleneMaeF
QuickBooks Team

Undeposited Funds

I know ways to clear the Undeposited Funds account, mendingtrails.

 

The Undeposited Funds account holds the payments you received from invoices. Thus, the amount is cleared from this account when deposited.

 

Here's how:

 

  1. Go to + New and then select Bank Deposit.
  2. From the Account drop-down, choose the account you want to deposit the funds.
  3. Select the checkbox for each transaction.
  4. Make sure the total of the selected transactions matches your deposit slip. 
  5. Click on Save and close.

 

For more details, please see this article: Record and Make Bank Deposits.

 

Aside from that, you can also edit the Deposit to account for the recorded payment. This removes the transaction that shows up in the Undeposited Funds account. I'll show you how:

 

  1. Go to Sales and then select Customers.
  2. Click the customer's name and look for the payment.
  3. In the Receive Payment page, change the account from the Deposit to drop-down list to the correct bank account.
  4. Click on Save and close.

 

Once done, you can now reconcile the account. Then, view, print, or export a reconciliation report for future purposes.

 

Please keep us posted if you need additional assistance in reconciling your account. We're always here to help you out.

mendingtrails
Level 1

Undeposited Funds

Thank you. This did move things out of the undeposited funds account. It duplicated transactions, however. My bank account is linked to QB so when the funds were deposited and credited to the appropriate invoices, they went to the right place. A "ghost" of them just appears to have stayed in the undeposited funds account. But I can't find a reason some did this and some didn't.

 

Maybe this isn't the same issue, but I also have duplications from my bank account and then quickbook generated "system recorded fees/deposits".

DivinaMercy_N
Moderator

Undeposited Funds

Thanks for providing further details about your concern, @mendingtrails. I'm here to provide additional info about the system generated fees you see in your account.

 

To clarify, have you recall activating or subscribing to an add-on service (QuickBooks Payments or Payroll) in QuickBooks Online (QBO)? To determine what the fees are for, let's check your Billing and Subscription page. Here's how:

 

  1. Navigate to the Gear icon.
  2. Next, select Account and settings.
  3. Then, proceed to the Billing & Subscription tab. 
  4. You’ll see all your active subscriptions there.

 

On the other hand, you can also open your Intuit account through the Customer Account Management Portal Site (CAMPS) website to further check the details. Refer to the steps below:

 

  1. Go to the My Account page and log in using your Intuit account credentials.
  2. Next, select View your transaction history in the Payment and Order Activity section. 
  3. From the Payment History page, click the Period drop-down and select a date.
  4. Filter the list by date and time. The payment history can show both payments and refunds in your account within the last 360 days or one year.
  5. Select the Details link next to the payment or refund to see more information.

 

For reference, please see these articles: 

 

Then, to handle duplicate transactions you can exclude them if they are already recorded in your QBO account. Also, to see who made the changes. in your account, you can open the Audit log report.

 

Please keep me posted on how this goes. If you have any other concerns about managing managing your transactions in QBO, feel free to leave a reply below. I'll be more than happy to lend a hand. Have a good one and take care.

mendingtrails
Level 1

Undeposited Funds

I have QB Plus. That's it. The fees are often a percentage QB takes for allowing customers to pay directly within the invoice. 

 

I've attached a screenshot. Take a look at the $1.70 that's in there twice. This would be an example. The second one is where I categorized when it came in through my synced bank account. The first was generated by the program. It happens both with deposits and payments.

Mich_S
QuickBooks Team

Undeposited Funds

I know the reason for duplicate entries when categorizing transactions, @mendingtrails

 

The amount of $1.70 is showing as a duplicate because you're already using QuickBooks Online Banking to reconcile bank deposits. Find out more information about the payment processing fee by reading this article: What are the fees for QuickBooks Payments?


Since you currently have a merchant account where funds are automatically deposited, I advise removing the transaction added to your bank feed. I'll show you how:

 

  1. Click on Bookkeeping, choose Transactions, then go to Banking.
  2. Go to the For Review tab.
  3. Hit the checkbox of the transactions to exclude.
  4. Once done, click on Exclude.

 

I'll also attach these links that you may find helpful when handling transactions in QuickBooks: 

 

 

Please let us know if this goes well. We're here to help you further is you have other concerns with deposits, bank feeds, or QuickBooks in particular. Take the best care! 
 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us