7 min read

Reconciling Carrier Payouts

Track every delivered order until the carrier pays you: import COD payout statements, match them by tracking number, and mark orders as paid in the Payouts Center.

In cash on delivery, the sale is not finished when the parcel arrives. Your carrier collects the cash at the customer's door, holds it, and remits it to you days or weeks later β€” usually minus its fees. The Payouts Center at https://v2.egrow.com/centers/payouts is where you close that gap: it keeps a live queue of every delivered order that has not yet been paid out to you, lets you import your carrier's payout statement to reconcile hundreds of orders in one pass, and shows exactly how much of your money is still sitting with your carriers.

Before you begin

  • Understand how orders move through your pipeline and its centers β€” see The Order Centers, Explained. An order enters the payouts queue once it reaches the delivered stage and still has money due; the stage badge under the page description shows you which stage feeds the queue.
  • Ask each carrier for its payout statement (also called a remittance report) as a CSV file with a header row. Most carrier portals can export one alongside every payment they send you.
  • Check which identifier the carrier uses in that file β€” its tracking number, your order number, or an internal ID. You will pick the matching key during import.

Why "delivered" is not the same as "paid"

Between the moment an order is marked delivered and the moment the carrier's money lands in your account, cash can quietly go missing: a parcel marked delivered that the carrier never remits, a statement that skips a few orders, a payout that does not add up. If you ship any real volume, checking this by hand across spreadsheets is where sellers lose money. The Payouts Center answers one question continuously and audibly: which delivered orders has the carrier not paid us for yet, and how much is that? Reconciling means matching what the carrier says it paid against that queue, so every dirham, dollar, or euro is either in your account or on a claim list.

The four summary cards

The cards at the top give you the cash position at a glance:

  • Delivered, Unpaid β€” how many delivered orders are still waiting for their payout.
  • Unpaid Amount β€” the total money those orders represent: cash your carriers are currently holding.
  • Paid This Month β€” how many orders were marked as paid this month.
  • Paid Amount (Month) β€” the total reconciled this month, so you can sanity-check it against your bank deposits.

Use the refresh button in the top-right corner to reload both the cards and the queue at any time.

The payouts queue

The table below the cards is a full order table, the same layout you know from the other centers: order number, date, customer (with phone), address, payment, the order's pipeline stage shown as a colored pill, shipping details, the Amount Due, assigned team members, and a shortcut to the customer's inbox conversation. Each row has a checkbox for bulk actions, and clicking a row opens the complete order detail panel so you can verify line items, totals, and history before touching anything. When the queue is empty, the center tells you plainly: "No payouts pending β€” all delivered orders are paid."

To find specific orders, use the search box β€” it matches the order number, tracking number, customer name, or phone β€” or the funnel button next to it, which opens a filter panel with a date range; while a range is active the funnel shows a badge and the panel offers one-click clearing. Results are paginated with sticky controls at the bottom.

Tip: the queue supports barcode scanners. Scan a tracking number on a returned remittance slip and eGrow types it into the search and pre-selects the matching order β€” you can mark it paid without touching the keyboard.

Step 1 β€” Get the carrier's statement

Download or request the payout statement for the period you are reconciling. It must be a CSV file, up to 10 MB, with a header row naming the columns. One statement per carrier per payment cycle is the natural rhythm.

Step 2 β€” Import it into eGrow

Click Import Paid Orders in the top-right corner of the center. In the import window, click Upload CSV or simply drag the file in. eGrow parses the file in your browser on the spot and shows the file name, its size, and how many columns and rows it found; if the file is empty or missing its header row, you are told immediately, before anything is sent.

Step 3 β€” Choose how to match orders

Tell eGrow which order field the values in your CSV correspond to, under Match orders by:

  • Tracking Number β€” the carrier's own tracking code (the default, and usually the safest, since it is the carrier's reference).
  • Order Number β€” the number printed on your receipts.
  • Order ID β€” eGrow's internal numeric ID.

Then pick the CSV column that contains that value. eGrow pre-selects the likely column by recognizing common header names such as tracking_number, order_number, or order_id, and shows a preview of the first five values from the chosen column so you can confirm they look right before starting.

Step 4 β€” Start the import and watch it run

Click Start Import. The import runs as a background job on the server: a progress card appears in the bottom-right corner of the screen with the file name, a live progress bar, and a running count ("120 of 400 Β· 30%"). Progress streams in real time, and the job keeps running even if you navigate to another page or reload β€” the card follows you. When it finishes, the card reports how many orders were marked paid and how many rows failed to match, and the queue and summary cards refresh automatically.

Note: one import runs at a time. If you reopen the import window while a job is in progress, it tells you so and points you to the progress card β€” just let it finish.

Step 5 β€” Sweep up the rest manually

Not every payout arrives as a file β€” a carrier may hand you cash for a few orders, or a small statement is faster to tick off by eye. Select the paid orders with the row checkboxes; the table header now shows how many are selected and a Mark as Paid button. Click it and eGrow confirms with a toast ("Marked N order(s) as paid"), clears the selection, and refreshes the queue and the cards.

Important: marking an order as paid records the money against it and removes it from the queue. Only mark orders paid when the cash has actually reached you β€” the queue is your claim list against the carrier, and an order removed too early is a discrepancy nobody will chase.

Reading the results and chasing discrepancies

After an import, two lists deserve your attention. First, whatever remains in the queue for the statement's period: those orders were delivered but the carrier did not pay for them β€” that is your claim list for the next call with the carrier. Second, the failed rows from the import: the carrier paid for something eGrow could not match, which usually means a mistyped reference, an order from another system, or an order that was already marked paid.

Tip: reconcile on a fixed schedule β€” for example weekly, per carrier. Small discrepancies are easy to resolve while the delivery is fresh in everyone's memory, and nearly impossible to recover months later.

The bigger money picture

Payouts is the "money in" half of your finances. Review the individual payments recorded against orders in the Transactions Center, track the "money out" side β€” ad spend, carrier fees, salaries β€” with Expenses, and if you pay your team per confirmed or delivered order, set that up in Commissions. Analytics then reads across all of it to show your real profit: what was sold, what was actually collected, and what it cost.

Was this article helpful?

Previous

🧾 Tracking Expenses in eGrow

Next

The Transactions Center πŸ’³

Related Articles

Can't find what you're looking for?

Our support team is here to help. Submit a ticket and we'll get back to you as soon as possible.

Contact Support
Need Help?