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?

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.

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..

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!

Hello thank you for your reply. I was bit confused with what you trying to guide me.

Can I do receive payment and pass journal for the bank charges?

Under receive payment, click customer name, key in amount of $990.00

Thus it will be underpaid of $10.00

I pass journal DR Bank Charges CR Customer name $10.00 ?

Can it be done?

Thanks 

Let me ease your confusion, Userhuini.

You'll have to receive the payment the normal way and deposit it to Undeposited Funds. From there, you can add the bank charges.

Instead of receiving $990, you'll receive the full amount, and deposit it to the Undeposited Funds. From the Bank deposit page, select the $1000 payment. Then, under Add funds to deposit, add the bank charge and enter the amount as negative. This way, you'll get $990. 

I'll also include this article as a future reference: Record invoice payments in QuickBooks Online.

If you have additional questions, please feel free to get back to this thread. We'll reply as soon as we can. Keep safe!

Hello thank you very much for getting back to me so fast.

However my company do not have undeposited funds.

Can you please suggest or see if my working doable?

thanks 

Thanks for getting back to us, userhuini.

We can create an Undeposited Funds account if you don't have one on your Chart of Accounts. Here's how to do it:

1. Click Accounting on the left menu and go to the Chart of Accounts tab.
2. Click the New button and select Current assets in the Account Type field.
3. Select Undeposited Funds in the Detail  Type field and enter the Name.
4. Enter other necessary details and click Save and Close.

After that, you can already use this account when following the steps on the earlier responses.

We'll be right here if you need anything else.

Hello, thank you for getting back to me, unfortunately, our company not intend to create this Undeposited Funds, please give me other solutions.

Thanks a lot .

Thanks for coming back, userhuini.

If you don't use the Undeposited Funds account, the payment will automatically be posted to your register. We can put the money directly into an account like your current account. We only use the Undeposited Funds if you need to group the payment with others. Here's how you can record the partial payments of an invoice: 

1. Click the + New Plus icon.
2. Select Receive Payment.
3. From Customer dropdown, choose the name of the customer.
4. From the Payment method dropdown, select the payment method.
5. From the Deposit to dropdown, tap the account you put the payment into
6. In the Outstanding Transactions section, hit the checkbox for the invoice your recording payment for.
7. Press Save and close.

For more details about this one, see the Record invoice payments in QuickBooks Online article. Then, categorise and match it to your bank statement. 

Feel free to visit our Banking page for more insights about managing your bank transactions.

I'd like to know how things going after trying the steps, as I want to ensure this is resolved for you. Just reply to this post and I'll get back to you. Take care always.