Consolidate multiple invoices in one invoice for same customer

[Sandeep9812]

Hi team,

One of my customer has not paid his last 11 invoices. He is asking me to send one consolidate invoice (combined invoice for all the overdue amount) for the overdue amount. How can I combine all 11 invoices in one ?? 
I am using myob essential account, need your suggestions.

[Steven_M]

Hi @Sandeep9812 

MYOB Business doesn't have the ability to consolidate multiple invoices into a single record. Should this be required you would be looking at manually working out the total value and then recording an invoice for that amount. 

The above process also needs some consideration around what you are going to do with regard to the current invoices in the system as you are duplicating your invoices using that above process:

• Option 1: Delete a set of invoices after creation i.e. delete the original or the new combined one
  
  
• Option 2: Set up a holding banking (Accounting>>Chart of accounts>>Create account - give the account a number, name, and set the account type to be Bank). Once created, you would pay off the original invoices through the Sale>>Create invoice payment function as you would normally. When creating the combined invoice you would use that holding account as the allocation account. This process will close off the original sales, only leaving the combined invoice.

Alternatively,to sending an invoice, you want to send out the customer a statement that would show the outstanding invoices OR a copy of a Sales report (would recommend a report like the Sales register report for that customer) outlining the outstanding invoices.