Get 50% OFF QuickBooks for 3 months*

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.
Maverick2
Level 6

Undeposited funds G/L running balance

This is a question from my CPA about the mechanics of QB Desktop.

When we go to the balance sheet and click on the Undeposited Funds G/L, she says she would expect to the see the balance be $0.00 every so often.

We get payment by check, direct ACH, and QB payments. For checks, the payment is applied to the customer invoice and deposited in QB the same day. Maybe next day but that's rare. ACH payments are the same. The payments go to undeposited funds, then are deposited to the QB bank account.

Now for credit cards payments, QB does things behind the scenes that can't be controlled by a user so that's a little mystery area. All the payment activity (check, ACH, CC) can be overlapping, but there are times when there are days or a week where we don't get payments. Can someone shed some light?

Solved
Best answer February 11, 2023

Best Answers
hectorgarciacpa
Level 4

Undeposited funds G/L running balance

**Quick answer bellow**

 

Long answer:

In QuickBooks Desktop, the Undeposited Funds account is used as a holding place for incoming payments that have not yet been deposited into the bank account. This account is automatically created by QuickBooks and is used to track the total amount of money that is collected from customers but has not yet been deposited into the bank.

 

Here's how it works:

  1. When a payment is received, whether it's by check, ACH, or credit card, QuickBooks will record the payment in the Undeposited Funds account. This increases the balance in the Undeposited Funds account and decreases the Accounts Receivable balance.

  2. When you're ready to deposit the payments into the bank account, you can use the "Make Deposits" feature in QuickBooks to select the payments you want to deposit and move them from the Undeposited Funds account to the bank account. This decreases the balance in the Undeposited Funds account and increases the balance in the bank account.

  3.  

Regarding credit card payments, QuickBooks Desktop integrates with various payment processors, such as PayPal or Square, to process credit card payments. When a credit card payment is processed, the payment is automatically recorded in QuickBooks and deposited into the Undeposited Funds account. However, the processing of credit card payments can take several days, and this can result in a delay between the time the payment is received and when it is recorded in QuickBooks.

In terms of the balance in the Undeposited Funds account, it's not necessary for the balance to be $0.00 every so often. The balance will fluctuate based on the timing of payments received and deposits made. If there are periods of time where no payments are received, the balance in the Undeposited Funds account may remain unchanged. The important thing is that the balance in the Undeposited Funds account accurately reflects the amount of money that has been collected from customers but has not yet been deposited into the bank.

 

 

**The problem is, that in your company file, there were not very often moments where there were zero transactions in Undeposited Funds.   Because you have a normal businesses with consistent cash flow, and it's normal to have payments pending to be deposited.   THE ISSUE is there is no way to force QuickBooks to group payments by Deposits from the report to make it easier for your CPA to understand...

View solution in original post

3 Comments 3
hectorgarciacpa
Level 4

Undeposited funds G/L running balance

**Quick answer bellow**

 

Long answer:

In QuickBooks Desktop, the Undeposited Funds account is used as a holding place for incoming payments that have not yet been deposited into the bank account. This account is automatically created by QuickBooks and is used to track the total amount of money that is collected from customers but has not yet been deposited into the bank.

 

Here's how it works:

  1. When a payment is received, whether it's by check, ACH, or credit card, QuickBooks will record the payment in the Undeposited Funds account. This increases the balance in the Undeposited Funds account and decreases the Accounts Receivable balance.

  2. When you're ready to deposit the payments into the bank account, you can use the "Make Deposits" feature in QuickBooks to select the payments you want to deposit and move them from the Undeposited Funds account to the bank account. This decreases the balance in the Undeposited Funds account and increases the balance in the bank account.

  3.  

Regarding credit card payments, QuickBooks Desktop integrates with various payment processors, such as PayPal or Square, to process credit card payments. When a credit card payment is processed, the payment is automatically recorded in QuickBooks and deposited into the Undeposited Funds account. However, the processing of credit card payments can take several days, and this can result in a delay between the time the payment is received and when it is recorded in QuickBooks.

In terms of the balance in the Undeposited Funds account, it's not necessary for the balance to be $0.00 every so often. The balance will fluctuate based on the timing of payments received and deposits made. If there are periods of time where no payments are received, the balance in the Undeposited Funds account may remain unchanged. The important thing is that the balance in the Undeposited Funds account accurately reflects the amount of money that has been collected from customers but has not yet been deposited into the bank.

 

 

**The problem is, that in your company file, there were not very often moments where there were zero transactions in Undeposited Funds.   Because you have a normal businesses with consistent cash flow, and it's normal to have payments pending to be deposited.   THE ISSUE is there is no way to force QuickBooks to group payments by Deposits from the report to make it easier for your CPA to understand...

Maverick2
Level 6

Undeposited funds G/L running balance

Very much appreciated Mr. Garcia! 

AlcaeusF
Moderator

Undeposited funds G/L running balance

Hello hectorgarciacpa,

 

I have reviewed the solution you’ve shared and it's correct and accurate. Thank you for sharing your inputs to help address the issue.

 

We love to see members supporting one another! Have a great day. 

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

Need to get in touch?

Contact us