cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
fixed star
Level 1

The customer makes two payments to pay one invoice, in different months, and how can this two payments be displayed in the Reconcilation

 
3 Comments 3
JessT
Moderator

The customer makes two payments to pay one invoice, in different months, and how can this two payments be displayed in the Reconcilation

It's great to see you posting today, fixed star!

 

The two payments will show up on your reconciliation when you deposit them to your bank register separately. I'll guide you through paying the invoice first. Then, we'll create a bank deposit so you can proceed to reconciliation.

 

Let’s say the invoice is amounting to 100, and the customer divides the payment by two 50s. To record the first partial payment, simply click Receive payment on the invoice, and enter 50 in the Amount received field. Then, make sure the Deposit to field is set to Undeposited Funds, so you can still record a bank deposit for it. However, if you've deposited the money on the same day you got the payment in real life, just select your bank account in that field and don't record a bank deposit anymore.

 

The second payment can be recorded in the same way as the first payment.

 

partial payment.PNG

 

If Undeposited Funds was used, you can record two separate bank deposits. Make sure to enter the correct dates because that will be the basis for reconciliation. You can refer to the article about reconciling an account.

 

Please don't hesitate to reach out if you have any other concerns. Take good care always!

fixed star
Level 1

The customer makes two payments to pay one invoice, in different months, and how can this two payments be displayed in the Reconcilation

Hi, I recorded the customer payment according to the date of customer paid but it just shows the last date that the customer paid in the reconciliation.
For example:
A Customer paid the Invoice 1065, and he paid as below
28-7-2021  RM 1450
  2-8-2021  RM     20

However, this two transaction didn't show in the reconciliation. In the Reconciliation, it just shows
  2-8-2021  RM 1470

MarsStephanieL
QuickBooks Team

The customer makes two payments to pay one invoice, in different months, and how can this two payments be displayed in the Reconcilation

Thank you for sharing an update with your concern, @fixed star. I can share more details on how to spot the issues when reconciling in QuickBooks Online (QBO).

 

During the reconciliation process, you can match the deposit right away if you've done the following:

 

  1. Receive each payment on the invoices and put them into the Undeposited funds.
  2. Create a Deposit transaction to the bank account and check the two payments. Ensure that the amount is correct.
  3. Match the recorded deposit to the actual ones on the Banking page.

 

It won't matter if there are multiple invoices, so long as you've recorded them correctly. It will always be recorded as one payment when you reconcile it.

 

In your case, I recommend contacting your accountant to ensure that you've got the correct transactions and accounts when reconciling. They can access your files and assess the transactions. You can also ask for strategic advice on handling your business finances. You can refer to the articles shared by my colleague above to learn more about the process.
 

I'll be around if you have any QuickBooks-related questions. Please don't hesitate to let me know in the comment section. Take care!