Reconcile Customer Payments with the Cash Receipt Journal or from Customer Ledger Entries

Article
03/31/2022

When you receive a cash payment from a customer or give a cash refund you can apply the payment or refund to close open debits or credits. You can specify the amount to apply. For example, you can apply partial payments to customer ledger entries. Closing customer ledger entries keeps customer statistics, account statements, finance charges, and so on, up-to-date.

Tip

On the Customer Ledger Entries page, red font means that the related payment is past its due date. If overdue payments are becoming a problem, we can help you reduce their frequency. You can enable the Late Payment Predictions extension, which uses a predictive model that we built in Azure Machine Learning to predict the timing of payments. These predictions help you reduce outstanding receivables and fine-tune your collections strategy. For example, if a payment is predicted to be late, you can adjust the terms of payment or the payment method for the customer. For more information, see Late Payment Predictions.

You can apply customer ledger entries in several ways:

By entering information on dedicated pages:
- The Payment Reconciliation Journal page. For more information, see Applying Payments Automatically and Reconciling Bank Accounts.
- The Payment Registration page. For more information, see Reconcile Customer Payments from a List of Unpaid Sales Documents.
- The Cash Receipt Journal. This option is described below.
By filling in the Applies-to Doc. No. field on sales credit memo documents. This option is described below.
By using the Set Applies-to ID action on a customer ledger entry. This option is described below.
By using the Apply Entries action on the Bank Deposit page, and then entering the invoice number in the Applies-to ID field. For more information, see Create Bank Deposits.

Note

If the Application Method field on the customer card contains Apply to Oldest, payments are applied to the oldest open credit entry, unless you manually specify an entry. If the application method is Manual, you always apply entries manually.

To fill and post a cash receipt journal

A cash receipt journal is a type of general journal. You can use it to post transactions to general ledger, bank, customer, vendor, and fixed assets accounts. You can apply the payment to one or more debit entries when you post the payment. You can also apply from the posted entries later.

Choose the icon, enter Cash Receipt Journal, and then choose the related link.
Choose the Edit Journal action.
Select the relevant batch in the Batch Name field.
Fill in the Posting Date field.
In the Document Type field, select Payment.

The Document No. field is filled by the number series assigned to the batch.
Use the External Document No. field to store an identifier, such as the customer's check number.
In the Account Type field, select Customer.
In the Account No. field, select the relevant G/L account.
If you want to post the application at the same time as you post the journal, do one of the following.
In the Balancing Account Type field, select G/L Account for cash payments, and Bank Account for other payments.
In the Balancing Account No. field, select the cash account for cash payments, or the relevant bank account for other payments.
Post the journal.

To apply a payment to a single customer ledger entry

Choose the icon, enter Cash Receipt Journal and choose the related link.
Choose the Edit Journal action.
On the first journal line, enter the relevant information about the entry to be applied.
In the Document Type field, enter Payment.
In the Account Type field, enter Customer.
In the Bal. Account Type field, enter Bank Account.
In the Applies-to Doc. No. field, choose the field to open the Apply Customer Entries page.
On the Apply Customer Entries page, select the entry to apply the payment to.
In the Amount to Apply field, enter the amount you want to apply to the entry. If you don't enter an amount, the maximum amount is applied.

At the bottom of the Apply Customer Entries page, you can see the specific amount in the Applied Amount field and also whether the application balances.
Choose the OK button. The Cash Receipt Journal page now shows the entry in the Applies-to Doc. Type and Applies-to Doc. No. fields.
Post the cash receipt journal.

To apply a payment to multiple customer ledger entries

Choose the icon, enter Cash Receipt Journal, and then choose the related link.
Choose the Edit Journal action.
On the first journal line, enter the relevant information about the entry to be applied.
In the Document Type field, enter Payment.
In the Account Type field, enter Customer.
In the Bal. Account Type field, enter Bank Account.
In the Amount field, enter the full payment as a negative amount.
To apply the payment to multiple customer ledger entries when posting, choose the Apply Entries action.
Select the lines with the entries that you want the applying entry to be applied to, and then choose the Set Applies-to ID action.
On each line, in the Amount to Apply field, enter the amount you want to apply to the individual entry. If you don't enter an amount, the maximum amount is applied.

At the bottom of the Apply Customer Entries page, you can see the specific amount in the Applied Amount field and also whether the application balances.
Choose the OK button.
Post the cash receipt journal.

To apply a credit memo to a single customer ledger entry

Choose the icon, enter Sales Credit Memos, and then choose the related link.
Open the relevant sales credit memo.
To apply the credit memo to a single customer ledger entry when posting, in the Applies-to Doc. No. field, select the entry to which you want to apply the payment.
On the line in the Amount to Apply field, enter the amount you want to apply to the entry.

If you don't enter an amount, application automatically applies the maximum amount. At the bottom of the Apply Customer Entries page, you can see the specific amount in the Applied Amount field and also whether the application balances.
Choose the OK button. The Sales Credit Memo page now shows the entry you have selected entered in the Applies-to Doc. Type and Applies-to Doc. No. fields. And the amount of the credit memo to be posted, adjusted for any possible payment discounts.
Post the credit memo.

To apply a credit memo to multiple customer ledger entries

Choose the icon, enter Sales Credit Memos, and then choose the related link.
Open the relevant sales credit memo.
To apply the credit memo to multiple customer ledger entries when posting, choose the Apply Entries action.
Select the lines with the entries that you want the applying entry to be applied to, and then choose the Set Applies-to ID action.
On each line, in the Amount to Apply field, enter the amount you want to apply to the individual entry. If you don't enter an amount, the maximum amount is applied.

At the bottom of the Apply Customer Entries page, you can see the specific amount in the Applied Amount field and also whether the application balances.
Choose the OK button. The Sales Credit Memo page now shows the amount of the credit memo to be posted, adjusted for any possible payment discounts.
Post the credit memo.

To apply posted customer ledger entries

Choose the icon, enter Customers, and then choose the related link.
Open the customer card for the customer with entries that you want to apply.
Choose the Ledger Entries action, and then select the line with the entry that will be the applying entry.
Choose the Apply Entries action. The Apply Customer Entries page opens showing the open entries for the customer.
Select the lines with the entries that you want the applying entry to be applied to, and then choose the Set Applies-to ID. action.
For each line in the Amount to Apply field, enter the amount you want to apply to the individual entry. If you don't enter an amount, the maximum amount is applied.

At the bottom of the Apply Customer Entries page, you can see the specific amount in the Applied Amount field.
Choose the Post Application action. The Post Application page appears with the document number of the applying entry and the posting date of the entry with the most recent posting date.
Choose the OK button to post the application.

If the posted application has resulted in closed customer ledger entries, the Open field is cleared for these ledger entries.
To see the ledger entries, choose the icon, enter Customers, and then choose the related link. Browse to the card for the relevant customer to see the ledger entries.

On the ledger entry list, on the line that contains the ledger entry that was fully applied to, you can see that the Open check box isn't selected.

Note

After you select an entry on the Apply Customer Entries page, or several entries by setting the Applies-to ID, the Applied Amount field on the journal line will contain the sum of the remaining amounts for the posted entries you've selected, unless the field contains something already. If you select Apply to Oldest in the Application Method field on the customer card, the application occurs automatically.

To apply customer ledger entries in different currencies to one another

If you sell to a customer in one currency and receive payment in another currency, you can still apply the invoice to the payment.

Here's an example. You apply Entry 1 in one currency to Entry 2 in another currency. The posting date on Entry 1 is used to find the exchange rate to use to convert amounts on Entry 2. The exchange rate is found on the Currency Exchange Rates page.

Applying customer ledger entries in different currencies must be enabled. For more information, see Enable Application of Ledger Entries in Different Currencies.

Choose the icon, enter Cash Receipts Journal, and then choose the related link.
Open the journal you want, and fill in the first empty journal line using a currency code.
Choose the Apply Entries action.
Select the line with the entry you want to apply to the entry in the cash receipt journal, choose the Set Applies-to ID action, and then select the entry you want to apply to.
Choose the OK button to return to the cash receipt journal.
Post the sales journal.

Important

When you apply entries in different currencies, the entries are converted to USD. Although the exchange rates for the two currencies are fixed, for example between USD and EUR, there may be a small residual amount when they are converted to USD. These small residual amounts are posted as gains and losses to the account specified in the Realized Gains Account or Realized Losses Account fields on the Currencies page. The Amount (USD) field is also adjusted on the vendor ledger entries.

To correct an application of customer entries

When you correct an application, correcting entries are created and posted for all entries. The correcting entries are the same as the originals but have an opposite sign in the Amount field. The correcting entries include all general ledger entries derived from the application. For example, the payment discount and currency gains/losses. The entries that were closed by the application are reopened.

Choose the icon, enter Customers, and then choose the related link.
Open the relevant customer card.
Choose the Ledger Entries action.
Select the relevant ledger entry, and then choose the Unapply Entries action.
Alternatively, choose the Detailed Ledger Entry action.
Select the application entry, and then choose the Unapply Entries action.
Fill in the fields in the header, and then choose the Unapply action.