One payment for multiple customers

(0) Share

Report

Posted on by Alexis C

Dear Community,

I have a frequent accounting situation that, it seems, can find no standard answer in Finance.

We send monthly invoices to our customers, and some of these customers are legal entities part of the same corporate group.

So the group decides to do only one payment to pay for multiple invoices for the multiple legal entities that we have sent invoices to.

The problem is that each legal entity in the group is defined as a customer. Now I need to find a way to do the following :

1) split the payment line to apply it to multiple customers and do the settlement on each

2) find a way to do a cross-customer settlement

Is there any way to do this ? The ideal would be a functionality that works similarly as the "breakdown of voucher" in the vendor payment journal.

Has anyone encountered this accounting situation ?

Thanks for your help,

Alexis

I have the same question (0)

All responses (9)

Answers (1)

Alexis C 45 on at

Like (0)

Report

RE: One payment for multiple customers

Hello Sourav,

we will be looking for a change in the business process, using the "invoice account" field on the customers that use the same payment company.

Thank you everyone for your help, it is much appreciated.

Alexis C.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: One payment for multiple customers

Hi Alexis C,

Would like to know if this is sorted out or still any challenges left to discuss?

Regards,
Sourav

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,612 Super User 2025 Season 2 on at

Like (0)

Report

RE: One payment for multiple customers

Hi Alexis,

I am totally agree with Andre's solution. You can either estimate to change agreement with the bank to get the payment file with structured format so the payment file (i.e Camt054) will have either Payment ID or Invoice number. So with import of the file, it will settle to customer transaction via matching against Payment ID or Invoice number.

I hope it helps,

Regards,

Alireza

Was this reply helpful? Yes No
Alexis C 45 on at

Like (0)

Report

RE: One payment for multiple customers

Hi everyone,

thank you for your time and answers, I will take some time to review them and run some tests.

Alexis

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

RE: One payment for multiple customers

Hi Alexis,

Apart from the solution suggested by other experts, here is another approach.

Problem -1: Splitting payment to multiple customer

Sol:

Step-1: Receive Payment against one customer

Customer-1 Credit 10,000 to Bank Debit 10,000

Step-2: Transfer Payment to other customer based on your working (You can use Customer payment journal line upload using Excel Add-in to avoid manual work

Customer -1 8000 (Lets say 8000 you want to transfer) Debit

Customer-2 3000 Credit

Customer -3 5000 Credit

Step-3: Now all these transactions will be open, so you can use Auto settlement feature to settle these transactions or if you want to mark invoices/ transactions during Step-2 entry you can do that.

Here is Excel upload for even settlement .

exploredynamics365.home.blog/.../

Problem-2: Cross customer balance transfer

Sol: You use settle remainder feature

exploredynamics365.home.blog/.../

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 298,280 Super User 2025 Season 2 on at

Like (1)

Report

RE: One payment for multiple customers

Hi Alexis,

On each customer, you can setup an 'Invoice account'. The invoice account can be setup with the customer account of the corporate group. The orders and invoices can be managed with an order account. The open customer transaction will be linked to the invoice account, which is then the corporate group. In this way, you have the transactions of multiple customers centralized on the corporate account and the payment processing can be done with just one customer account. In this case, you don't need a customization for either a split function or cross-customer settlement.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: One payment for multiple customers

Hi Alexis C,

Have you tried this option in customer payment journal?

Click on Payment proposal > Create payment proposal. It will help you to decide whether to do a centralized payment for the invoices from other legal entities.

Once you set the Include customer from other legal entities tab enabled in this payment proposal advanced parameters, an additional option will be available for you to decide further if system should create separate customer payment per legal entity by setting the Propose separate customer payment per legal entity check box enabled.

Kindly check and keep us posted with the outcome.

Regards,
Sourav

Was this reply helpful? Yes No
Alexis C 45 on at

Like (0)

Report

RE: One payment for multiple customers

Hi Alireza,

we are using the standard camt.054 file import for the customer payments, with the unstructured version. We are not using payment identification and we do not receive the invoice number in the camt.054 file.

Was this reply helpful? Yes No
Alireza Eshaghzadeh 14,612 Super User 2025 Season 2 on at

Like (0)

Report

RE: One payment for multiple customers

Hi Alexis,

Does the payment file that you get from the net bank have invoice number or payment identification (i.e. structured)? Do you use standard config for import payment file (e.g. Camt.054)?

Regards,

Alireza

Was this reply helpful? Yes No