Paste a shipment invoice payment advice and see exactly how the parser reads it. Settlements are entered under Settlements → Add new settlement; this page is for checking a new or awkward advice format before you trust it there.
Build 2026-08-26 · if a result looks wrong, hard-reload first (⌘⇧R) — this page is a plain file and browsers cache it.
Columns produced, in the sheet's order:
id · vendor_id · company · tt_ref · date_paid · ref_number · shipment_id · invoice_date · amount · surcharge · additional_ref.
The header totals (TotalInvoices, TotalDebitsCredits, AmountDue, AmountPaid) are
deliberately left out — the sheet calculates those from the line items.
Tab-separated, not comma. CSV text pasted into Sheets lands in one column; tabs split into cells on their own.
Line items are read by shape, not by position, because pasted
text loses the column alignment the PDF had. On each line: money is money, a
7/16/2026 is the invoice date, a run of digits is the shipment id, and the
words in front are the reference. That is what lets
TEST payment -$18.42 — no shipment, no date — come out right
alongside a full row such as
2026AB002 76259 7/16/2026 $41,245.20.
TotalInvoices is checked, not copied. If the line items do not add up to it you get a warning. That check matters most for text pulled off a screenshot, where a misread digit is the failure worth catching — and it is why the rows are shown to you here before they reach the sheet.
It will not guess. A line it cannot make sense of is reported rather than silently dropped or half-filled.