cancel
Showing results for 
Search instead for 
Did you mean: 
richard83
Level 1

I am trying to record a deposit from a finance company. The total recieved has 8% removed from my invoice. Can I create a rule to match and record both the sale and fees?

 
Solved
Best answer June 16, 2020

Best Answers
Catherine_B
QuickBooks Team

I am trying to record a deposit from a finance company. The total recieved has 8% removed from my invoice. Can I create a rule to match and record both the sale and fees?

I'll show you how to match bank downloaded transactions, richard83.

 

The invoice within QuickBooks won't directly match to the bank downloaded transaction since they have different amounts. The option to create a bank rule to automatically match the invoice to the deposit deducted with the fees is unavailable.

 

We can receive the payment of the invoice and deposit it to the Undeposited Funds account. After that, we can record a bank deposit entering a negative amount for the fees. From there, we can match the deposits. 

 

I'll show you how:

  1. Open the Invoice and click Receive Payment at the upper-right. 
  2. Under the Deposit to drop-down, click Undeposited Funds and then Save and close.
  3. From the left menu, click the +New button and select Bank deposit
  4. Check the invoice payment.
  5. Under the Add funds to this deposit section, select the customer's name, bank fees expense account, and the amount of the charge. 
  6. Click Save and close

Just go to the Banking page and match the deposit we just recorded to the deposit shown in your bank feeds. 

 

If there's anything else that you need help with, just let me know by leaving a reply below. Take care and have a great day!

View solution in original post

1 Comment 1
Catherine_B
QuickBooks Team

I am trying to record a deposit from a finance company. The total recieved has 8% removed from my invoice. Can I create a rule to match and record both the sale and fees?

I'll show you how to match bank downloaded transactions, richard83.

 

The invoice within QuickBooks won't directly match to the bank downloaded transaction since they have different amounts. The option to create a bank rule to automatically match the invoice to the deposit deducted with the fees is unavailable.

 

We can receive the payment of the invoice and deposit it to the Undeposited Funds account. After that, we can record a bank deposit entering a negative amount for the fees. From there, we can match the deposits. 

 

I'll show you how:

  1. Open the Invoice and click Receive Payment at the upper-right. 
  2. Under the Deposit to drop-down, click Undeposited Funds and then Save and close.
  3. From the left menu, click the +New button and select Bank deposit
  4. Check the invoice payment.
  5. Under the Add funds to this deposit section, select the customer's name, bank fees expense account, and the amount of the charge. 
  6. Click Save and close

Just go to the Banking page and match the deposit we just recorded to the deposit shown in your bank feeds. 

 

If there's anything else that you need help with, just let me know by leaving a reply below. Take care and have a great day!

Need to get in touch?

Contact us