Skip to main content
January 14, 2021
Question

How to match the invoice underpaid by customer? customer owed 1k paying 990, $10 is bank charges. How am i going to record?receive payment 1k from customer then $10 JV?

  • January 14, 2021
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

Rose-A
January 14, 2021

Let me help you go over to your account and have your customer payment with bank charges recorded, userhuini.

 

You can record a partial payment of the invoice and match it to your bank statement. If it will not automatically detect it as a matching entry, click on Find Match to look for the payment.

 

 

As for the bank charges,  we can add the fee as we deposit the invoice payments to your register. Here's how we do it:

 

  1. Click + New in the left panel and choose Bank Deposit.
  2. Select the bank account in the Account field and enter the Date.
  3. Under the Select the payments included in this deposit section, mark the invoice payment.
  4. Go to the Add funds to this deposit section, and select the bank fee account in the ACCOUNT column.
  5. Enter the bank charge as a negative amount.
  6. Hit Save and close.

However, if the bank charges are showing in a separate amount, you can record it using the journal entry. To help you manage your bank statements, I recommend editing, assigning, and categorising them. Also, you can match them to the existing entries in the software. Just go to the For Review tab from the Banking menu. Doing so will help you ensure the accuracy of your financial records.

 

Please know you can continue to reach me here with any additional questions about QuickBooks transactions or anything about invoice payments as well as bank charges concerns. Wishing you a wonderful rest of your day.

userhuiniAuthor
January 15, 2021

Hello thanks for getting back to me so fast. Are you telling me that I need to perform RECEIVE PAYMENT and BANK DEPOSIT? we are not linked our bank thus I wonder if I still can as per normal under RECEIVE PAYMENT? Will it be double since your bank deposit you again input the customer name? thanks a lot yeah..

AlcaeusF
January 15, 2021

Thanks for getting back to us, @userhuini.

 

Yes, you need to use the Receive Payment option and make sure to deposit it to your Undeposited Funds (UF) account first to avoid duplicates. Here's a sample screenshot from my test account.

 

If you don't use the UF account, the payment will automatically be posted to your register. Once done, you can now follow the steps shared by my colleague above to deposit the payment to the correct account with the bank charge.

 

I'm also adding this article that tackles matching transactions for future reference: Categorise and match online bank transactions in QuickBooks Online.

 

Please leave a comment below if you have any additional questions or concerns. I'm always here to help. have a good one!