cancel
Showing results for 
Search instead for 
Did you mean: 
shawn-mccaffrey1
Level 1

Can not edit undeposited funds to match downloaded bank transaction Using Desktop 2020 Needed when invoice payment does not match bank deposit

 
2 Comments 2
Ryan_M
Moderator

Can not edit undeposited funds to match downloaded bank transaction Using Desktop 2020 Needed when invoice payment does not match bank deposit

Hi @shawn-mccaffrey1,

 

Allow me to clear some things up for you. The Undeposited Funds account holds your invoice and sales receipt payments, that you haven't deposited to a bank account yet. You can change the total amount in this account either by depositing your sales transaction payments into it. or depositing the amount from this account to a bank account. 

 

Since you're trying to match it to your bank transactions, I suggest you deposit these funds to the appropriate bank account before you can proceed.

 

Here's how:

  1. Go to the Banking menu.
  2. Select Make Deposits.
  3. All payments in the Undeposited Funds account will be listed on the Payments to Deposit window. Put a check on what you need to deposit. 
  4. When done, click Save & Close.

Additional details about working with the Undeposited Funds can be found here: Deposit payments into the Undeposited Funds account in QuickBooks Desktop. Look for the Make a bank deposit section, as well as the Review your Undeposited Funds account

 

As for the process of matching your bank transactions, take a look at this article: Add and match Bank Feed transactions in QuickBooks Desktop. There are 2 options listed, the Express Mode and the Classic Mode.

 

Need further assistance? Place a comment below, and I'll be sure to get back to you. 

john-pero
Community Champion

Can not edit undeposited funds to match downloaded bank transaction Using Desktop 2020 Needed when invoice payment does not match bank deposit

You can edit the invoice payment before adding it to a deposit. The written amount is the legal amount of a check and overrides the numbers - but whatever the amount that cleared your bank would be the amount that cleared your customer's bank and so they either shorted you or paid too much.  Thus the invoice is still open or there is a customer credit to use later.

 

Or the deposit total might just be wrong at the bank and in a day or two they will correct it. In this situation, you have choice of making the deposit match the bank and then make a new adjustment when that comes through.

 

Finally an option is the add the transactions from UF to a deposit and add an adjustment line to the deposit (only when you know for certain the payment amount is correct and that the check correctly cleared - this can happen especially with cash deposits where you swear you added right but somewhere between the store and the bank you dropped some coins along the way.

Need to get in touch?

Contact us