Please insert an additional income account in the software (ie. Commission sales) by effecting a fixed percentage of sales as commission while entering the sales value and such commission should be automatically deducted from purchase cost.
Eg .:
Sales made at Rs 400. Rate of commission is 5%.
The effect of Journal Entry will be
Purchase Dr 380
Cash Dr 20
To Sales 380
To Commission 20
Effectively, you’re asking to embed or tag a purchase invoice as well as a payment or a receipt within a sales invoice.
I wouldn’t have my hopes high on this simply because:
-
Tagging a purchase and payment to a sale is a bad accounting and legal practice. Each aspect should have it’s own proper documentation. For now it may seem like a time saver but it’s going to come back to bite you.
-
This will overcomplicate sales invoices to to include all fields from purchase invoices + all fields from payments. And there’s no guarantee that all the lines of the invoices have the same suppliers or terms like rate, or payment. So you will have to have a confusing multidimensional data structure within the sales invoice. It might suit certain users but it’s not good for Manager.io.
-
To keep things simple, the developer may rely on assumptions that all items come from one supplier and share all purchase and payment details as well as the commission rate. In that case, manager will have to be rewritten any time the terms of commission sales change
Alternatives
-
Use Copy to function to copy a purchase invoice from the sales invoice. This will copy most, if not all, relevant details. And then copy again to a payment.
-
Use API to automate creation of related transaction documentation. This would require a high level of IT expertise, so you might want to hire a developer.