Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
462 Lượt xem

We are joint companies in a hospital venture. We share revenue: 50%, 50%.  We want a functionality on the invoice generation that will invoke a split of the invoice amount into 50% each posted to 2 General Ledger. One as a revenue and the other as  a payable. However the entire 100% of the amount should be posted to the customer account.


Please assist with a solution

Ảnh đại diện
Huỷ bỏ
Tác giả

Good afternoon,


The effort is very well noted.  However the challenge is we have several products and services (into 100s) which are sold or rendered under this agreement. In addition we have separate price for cash and credit for each product/service. The recommended approach will mean we will create two invoice lines which will be tied to the journal to separate our 50% revenue from the 50% payable.  But given the huge list of different products and services. This will be cumbersome.

Can we have a situation where the journal split is configured and tied to the products/services at the back-end  so that once the invoice is approved the necessary correct posting is done to the GLs

Câu trả lời hay nhất
Create a New Account for Partner Payable

Go to:

Accounting → Configuration → Chart of Accounts → Create

  • Name: Partner Company Payable
  • Code: e.g. 221000
  • Type: Current Liabilities → Payable
Create a Product for the Revenue Split

You’ll use 2 lines in the invoice:

🟢 Line 1: Revenue (50%)

  • Product Name: Service Revenue
  • Income Account: Your normal Revenue account (e.g., 701000)
  • Amount: 50% of total

🔴 Line 2: Partner Share (50%)

  • Product Name: Partner Company Share
  • Income Account: Partner Payable (the new account above)
  • Amount: 50% of total
On Invoice Creation

Manually (or via automation), create the invoice with two lines:

DescriptionAccountAmount
Hospital ServiceRevenue$5,000
Partner Company SharePayable (Partner)$5,000
Total InvoiceReceivable$10,000

Ảnh đại diện
Huỷ bỏ