A sales CSV you can actually import
Download a blank itemised sales CSV and a tested three-row example with a service, retail sale and signed refund. Includes field mapping instructions.
Start with one row per item, not a daily total. This template matches the eight recognised import columns in Trimsum. The blank file contains headings only; the fictional example contains two sales and a refund so you can inspect a real exception before preparing your own file.
The useful part
Keep sales and refunds signed, preserve the original reference, and supply tax separately when it is available. The example produces $43.00 commission after its refund is reviewed under the stated assumptions.
Your working files
Download blank templateCSV · Column headings only. Add your own records to a copy.Download fictional exampleCSV · Completed sample records in AUD. Use for practice, not a live close.Two files, two different jobs
Use the blank download when assembling an itemised source file. Keep an untouched copy of the original export beside it, because a tidy CSV is not a substitute for the source evidence. Use the fictional example to practise mapping and review; do not append it to business records. Header-only blanks become importable after you add at least one complete sale.
Fill the eight columns
| Field | What to enter |
|---|---|
| Reference | Original invoice or item reference. Keep leading zeros as text. |
| Date | Item date in YYYY-MM-DD, within the chosen source period. |
| Staff | Person earning the commission, as supported by the source. |
| Item | Specific service or product description. |
| Category | Service or Retail; review other classifications explicitly. |
| Amount | Signed line sales including the supplied tax, in AUD. |
| Tax | Signed tax amount for that line; leave unknown values blank. |
| Reported commission | Source commission in AUD, or blank if not supplied. Zero means a reported zero. |
Read the fictional three-row example
Mia has a $220.00 service with $20.00 supplied tax, a $33.00 retail item with $3.00 tax, and a $110.00 partial service refund with $10.00 tax. Refund values are negative in the file. Assuming commission excludes supplied tax and rates are 40% service and 10% retail, the calculation is $80.00 + $3.00 − $40.00 = $43.00. The source reports zero commission on the refund, creating a reviewable $40.00 difference.
| Line | Sales | Tax | Basis | Commission |
|---|---|---|---|---|
| Service | 220.00 | 20.00 | 200.00 | 80.00 |
| Retail | 33.00 | 3.00 | 30.00 | 3.00 |
| Refund | −110.00 | −10.00 | −100.00 | −40.00 |
| Total | 143.00 | 13.00 | 130.00 | 43.00 |
Check before importing
Do not put currency formulas in the file. The import reads values, not spreadsheet calculations. A refund tax amount must have the same sign as its sales amount.
- Save as a comma-separated CSV with one header row and no subtotal lines.
- Check the date convention and map each source column once.
- Keep unknown tax blank; a zero is an explicit amount, not an unknown.
- Confirm the row count and signed total against the source before reviewing commission.
Rates and decisions stay outside this file
A sales file does not choose the applicable commission agreement. Set the supplied staff rates and calculation basis separately, then review questioned rows. The example is arithmetic practice, not a recommendation about refund recovery, tax treatment or employee pay. If your report has a different structure, map its existing columns instead of repeatedly renaming source data.
Put it to work.
Find formatting problems before starting a commission run.
Check a sales file