1. Export the source
Start with Timely’s invoice detail report for itemised invoiced lines. Its sales reports normally group by invoice date, which can differ from the appointment date. In a transaction summary, “processed by” identifies the person who handled a payment, not necessarily the person who earned the sale. Check discounts and staff attribution against the original invoice before mapping a line.
Timely says invoice detail can contain packages and vouchers, while its sales report can include unpaid invoices. Check whether each kind of line belongs in your commission agreement. Trimsum cannot infer package recognition or payment eligibility from the export alone.
Keep the invoice dates you intend to reconcile and include refunds as negative lines. Export formats and available columns vary by provider report; check the file before importing.
2. Map the fields
In Trimsum, select Import CSV and choose the file. Trimsum detects the separator. Confirm the date format, then map the available columns to the fields below.
| Field | What to check |
|---|---|
| Reference | Invoice or sale identifier |
| Date | Invoice date, with the correct date format |
| Staff | The person who earned the commission |
| Item | Service or product description |
| Category · optional | Service or Retail; for a single-category report, choose the category fallback when no column is mapped |
| Amount | Signed amount; refunds must be negative |
| Tax · optional | Explicit tax amount, if your export provides it |
| Reported commission · optional | The provider’s commission amount to compare |
3. Check before closing
Review a service, a retail line and a refund in the preview. Add your staff’s agreed rates. Set the tax basis, then work through any duplicate or commission-difference questions. Only finalise when the review is complete.
Walk through the full processAudit a commission report