We have a client which is an Insurance Broker. Upon recording of their incoming payments, two things happen simultaneously. One is the recording of Payable to the actual insurance company and second, the recording of their commission.
Example Journal entry:
Debit: Cash in bank 100,000
Credit: Payable to Insurance Company 80,000
Commission Income 10,000
Output Tax 1,200 (10,000*12%VAT)
Excess AP 8,800 (Excess payment)
A few issues here:
1. We cannot post a payment to an account and be able to compute the commission income and its VAT automatically.
2. If they opt to not compute it automatically, we cannot post the payment to the Supplier/Customer account and the GL account simultaneously.
I know how we can post the AP to the Insurance company and the excess amount but we are having a hard time in the Commission and tax postings.
Thank you and Regards,