Import and reconcile commission statements
Commissions > Reconcile turns a host's payout statement or a supplier's commission statement into receipts on your bookings. Owners and admins only.
CSV
1. Choose what the statement reports: a host agency's payout to you, or a supplier's payment.
2. Choose the file. Turtini proposes which column holds what: confirmation number, client, dates, gross commission, the host's split and the net paid to you.
3. Check every column choice, and the date and amount formats, then click Check mapping. The preview shows the first lines and the booking each would match.
4. Name the mapping to save it. The next file with the same columns is recognized and uses the saved mapping, which you can still edit.
5. Click Import. Lines that match one booking by confirmation number, with nothing else close, are applied right away. Everything else waits in the queue.
PDF
Wally reads the statement's table into lines. A line read from a PDF does nothing until you check it against the statement, correct anything wrong, and click These match the statement. Then match it like any other line. A scanned PDF with no text is sent as an image, and can take longer.
THE TWO QUEUES
- Received, not matched: statement lines with no booking yet. Match a suggested booking, choose one, create the booking from the line, or set the line aside.
- Expected, not paid: bookings that are due, late, partly paid or short-paid by the host.
HOST SHORT-PAYS
A host statement line usually carries the gross the supplier paid and the net passed to you. Both are recorded, so the booking compares what the host passed down with what your frozen split says it should have. A gap shows as Host short-paid.
UNDOING A MATCH
Open the statement and click Unmatch on the line, with a reason. The receipts the match added are reversed, not deleted, and both steps are in the booking's history.