Worksheet

Order to settlement matching sheet

Printable sheet, one line per order. Columns hold order ID, gateway transaction ID, gross amount, fee, refund, net settled, payout batch, bank date, courier remittance reference and exception note. A top box totals unmatched rows by cause.

Name: ______________________   Business: ______________________   Date: ______________

Scroll the table sideways to see every column.

Cross out or rewrite any heading that does not fit your business. From the guide “Why gateway settlements do not match your store orders”, www.gullysystem.com/blog/why-gateway-settlements-do-not-match-your-store-orders