Sales Tool
TSA Sales Commission Calculator
Import QuickBooks sales from CSV or capture each sale manually. VAT and expenses are removed before commission is calculated.
Sales incl. VAT
R0.00
Sales ex VAT
R0.00
Expenses
R0.00
Commissionable
R0.00
Total Commission
R0.00
Add Sale Manually
Default commission is 10%, but every sale can have its own rate.
Formula: Sale incl. VAT ÷ (1 + VAT %) = sale ex VAT. Then expenses are deducted. Commission is calculated on the remaining amount.
Import QuickBooks CSV
Recognises common Date, Customer, Invoice, Amount and expense column names.
Drop your QuickBooks CSV here
or select a CSV file from your computer.
Imported sales default to 10% commission unless your CSV includes a commission column.
Imported sales default to 10% commission unless your CSV includes a commission column.
Sales & Commission Detail
0 sales loaded
| Date | Invoice | Customer | Sale Incl. VAT | VAT Removed | Sale Ex VAT | Expenses | Commissionable | Rate | Commission | Actions |
|---|
Commission Graph
Sale value versus commission earned per transaction.
How the calculation works
Commission is based on the value left after VAT and the expenses linked to that sale have been removed.
1Start with the full sale amount including VAT.
2Remove VAT using the VAT rate for that sale.
3Subtract expenses directly linked to the sale.
4Apply the commission percentage to the remaining amount.