Costco CommissionFile ConverterMilk TagsHorizon CommissionGreen Spoon CommissionCheck DepositsBOL/Pick Report SplitterPrice per CaseBelo Milk StatementNDPRB 7209 FormComplaint Trend

Costco Commission — PO / Sales Order Matcher

Match each Frontline PO to its QuickBooks Sales Order number.

How to prepare your files

1. QuickBooks — export Costco Transactions with P.O.# column

  1. In QuickBooks, go to Reports > Memorized Reports and run Costco Transactions.
  2. Click Customize Report > Columns and make sure P. O. # is checked.
  3. Set the date range wider than the Frontline invoice period — add 2-3 months of buffer on both sides. For example, if the Frontline invoice covers February, set the report from November through the current date.
  4. Click Export > Export to CSV.

2. Frontline Invoice — use the .xlsx file as-is from their email

No changes needed. Just save the attachment and upload it here.