Payment Tracking Sheet for China Orders

A payment tracking sheet for China orders is a single spreadsheet that records every deposit and balance payment against each supplier order: the amount due, the amount paid, the payment method, the due date, the exchange rate, and the current status. If you can open one file and answer "what is owed, to whom, and by when" in under a minute, your sheet is doing its job. If you can't, it is a filing cabinet, not a control tool.

Most importers discover they need one the hard way. A deposit goes out in March, production runs six weeks, and by the time the balance comes due, the buyer has lost track of which tranche was paid and what exchange rate applied to the deposit. CN Ally manages payment milestones for buyers as part of product sourcing, and the same structure works in a spreadsheet or accounting software. The sheet is cheap; the missed payments it prevents are not.

China orders almost never settle in one payment. The industry standard for a first order is 30% deposit by T/T wire to confirm the production slot, with the 70% balance released only after the buyer verifies production, tied to documents rather than a vague calendar promise. When money moves in tranches, over weeks, in two currencies, a dedicated tracker keeps the arithmetic honest.

What Columns Does a Payment Tracking Sheet for China Orders Need?

Build your sheet around these columns, one row per tranche:

Column · What goes in it · Why it matters

• Order ID: Your internal order reference · Links payments to the right PI and shipment
• Supplier name: Factory or trading company, as on the PI · Prevents confusion when one factory trades under two names
• PI / PO number: Proforma invoice or purchase order number · Ties each payment to a signed agreement
• Product / SKU: Short description · Identifies the order when IDs are unfamiliar
• Order value: Total in contract currency · The anchor every tranche is calculated from
• Currency: USD, EUR, CNY · Contract currency of the order
• Payment terms: e.g. T/T 30/70, 30/40/30, L/C · Records what was agreed before money moves
• Tranche: Deposit / Balance / Tooling / Sample · Makes clear which milestone this row tracks
• Due date: Contractual deadline for this tranche · Drives reminders before money is late
• Due amount: Amount owed for this tranche · Calculated from order value and terms
• Date paid: Actual payment date · Separates plans from reality
• Amount paid: Amount sent, in contract currency · The figure you reconcile against bank records
• Payment method: T/T, L/C, escrow, platform · Matters for fees, timing, and disputes
• Bank / platform fees: Fees you paid on this transfer · Part of the true order cost
• Exchange rate: Rate applied on the payment date · Explains why home-currency totals move
• Home-currency cost: Amount in your books' currency · What your accountant actually books
• Status: Pending / Paid / Overdue / Disputed · One-glance health of the tranche
• Proof: Receipt, SWIFT confirmation, BL copy · Evidence if anything is contested

Keep agreed and actual figures in separate columns. "Due amount" and "date paid" are different facts; overwriting one with the other erases the variance that flags short payments.

How Do You Track Deposits and Balance Payments Across an Order?

Track deposits and balance payments as separate rows. Each tranche has its own trigger, deadline, and proof, so a T/T 30/70 order gets two rows: the deposit (due when the PI is signed) and the balance (due against the QC report and BL copy).

Treat the deposit row as a verification checkpoint. Pay only after the PI names line up: business license, PI, bank account, and storefront naming the same entity. Send it only to the company's account, never a personal account or an unrelated "finance office." Record the exact account holder name in the notes column; if the supplier ever asks you to pay elsewhere mid-order, the original is on file.

The balance row is where most sheets go quiet, and it is where the leverage lives. Write the release trigger into the PI ("70% payable after passed QC report and BL copy") and mirror it in the sheet. Without a documented trigger, production finishes, shipping is booked, and the supplier treats payment as overdue while you are still waiting for inspection.

Tooling-heavy orders need a third row. When molds or custom engineering are involved, a common structure is 30/40/30: 30% against the tooling agreement (mold ownership in writing), 40% against first-article approval, 30% after passed QC and shipping documents. Squeezing tooling into the deposit row loses track of who owns the mold.

For a detailed breakdown of each payment method's tradeoffs, this guide to paying Chinese suppliers safely ranks T/T, letters of credit, escrow, and third-party platforms by acceptance and safety.

Which Payment Methods Should the Sheet Record?

Record the method of every tranche: it determines fees, arrival time, and where the proof lives. A T/T wire leaves a SWIFT confirmation; an escrow release leaves a platform record; an L/C leaves bank documents. If you ever dispute a payment, the method tells you where the evidence is.

Method · Typical use · What to log in the sheet

• T/T bank wire: Most formal bulk orders, standard T/T 30/70 · SWIFT confirmation number, sender fees, value date
• Letter of credit (L/C): Larger orders where bank guarantees make sense, often above ~$50,000 equivalent · Issuing bank, L/C number, document deadlines
• Escrow / platform escrow: Small first orders where neither side wants to move first · Platform name, escrow reference, release condition
• Cross-border platforms (XTransfer, Wise, PingPong, WorldFirst): Small and mid-size orders, simpler operations and lower fees · Platform transaction ID, FX rate quoted at booking
• PayPal / marketplace payments: Samples and low-value trial orders · Transaction ID, higher fee noted separately

Method choice shifts with the relationship: first orders lean toward T/T 30/70 or escrow; established buyers may negotiate longer terms. The sheet records the method used, so a year-end review shows what each method cost per order. Platforms typically clear same-day to two days versus one to three working days for a SWIFT wire. The wire, escrow, and letter of credit comparison on Statrys is a useful reference for matching the method to the order size.

Never leave the method column blank. Months later you won't reconstruct which payments carried bank fees and which were fee-free, and landed-cost accounting becomes guesswork.

How Do You Track Exchange Rates and the True Cost of Each Payment?

Record the exchange rate that applied on the date each payment was made, and convert every tranche into your home currency on its own row. Deposits and balances on the same order are often paid weeks apart, and the rate can move between them, so a blended rate hides the real cost.

Use three columns per tranche: the amount in contract currency, the exchange rate with its source and date, and the resulting home-currency cost. Keep bank fees in their own column, since they belong to a different accounting category than the payment itself. Per-transaction wire fees are small, but across dozens of orders they become a line item your accountant should see, not absorb.

The common mistake is recording only the contract-currency figure and converting at month end. That produces a tidy number that matches nothing in your bank statements, and the answer to your accountant's question is always the same: fees plus FX timing. The rate column also protects you commercially: if a supplier cites currency moves to justify a price adjustment, you have your own dated record to check it against.

What Does a Monthly Reconciliation Routine Look Like?

Reconciliation is the monthly hour that keeps the sheet honest. Without it, statuses go stale and fees go unrecorded. Run it on the same day each month.

First, match statements to rows. Pull bank and platform statements and check each transfer against its sheet row: amount in contract currency, beneficiary name matching the company on the PI, and value date on or before the due date. Mark matched rows "Paid" and attach the SWIFT confirmation or platform receipt. Paid is not the same as received, so note anything the supplier has not confirmed.

Second, sweep the pending and overdue rows. For each pending deposit, confirm the PI is signed and the production slot is reserved; a deposit you assumed was scheduled may have been quietly forgotten. For each overdue balance, check the release trigger: did the QC report pass, did the BL copy arrive? If the trigger was met and the money hasn't moved, that is your cash-flow decision. If it wasn't met, the sheet is holding money back with a documented reason, which is exactly what it should do.

Finally, update totals. Sum the home-currency cost per order and compare against the quoted price plus expected fees. Small variance (correspondent-bank charges, a point of FX movement) is normal; a large gap means something was recorded wrong or an extra charge slipped through. This per-order summary is what you hand your accountant. Buyers who work with an agent on the ground often have the QC and shipping-document milestones confirmed for them; see quality control for how those checks are structured.

Which Mistakes Make a Payment Sheet Useless?

The mistakes that kill payment sheets are rarely dramatic. They are small recording habits that compound until the sheet no longer reflects reality, and by then nobody trusts it enough to fix it.

One row per order. A single row cannot hold a deposit paid in March, a balance due in May, and a tooling payment in February: different triggers, methods, and rates. Split tranches into rows from day one; reconstructing them from memory is where errors enter.

Recording plans as facts. Overwriting "due amount" with "amount paid" erases the variance that flags short payments. Planned and actual figures live in separate columns, always.

No due dates. A sheet without due dates is a history book. Translate loose PI language ("balance before shipment") into a real date tied to the inspection schedule.

Ignoring fees and FX. Wire fees, platform fees, and exchange-rate timing are real costs. A sheet recording only contract-currency payments will never match the bank statement, and the unexplained gap will eventually make someone stop trusting the file.

No proof attached. A "Paid" status without a SWIFT confirmation, receipt, or release record is an opinion. When a supplier claims a deposit never arrived (correspondent-bank delays and bookkeeping errors happen), the proof column is your defense.

No single owner. A file everyone can edit and nobody maintains decays within a quarter. One person owns updates and runs the monthly reconciliation, or the status column becomes noise.

How Do You Keep Suppliers, Accountants, and Your Team Aligned?

Decide your conventions once and write them on a second tab: contract currency per supplier, date format, what counts as "Paid" (money sent, or supplier confirmed receipt?), and how fees are labeled. A new hire or accountant should inherit these, not invent their own.

Share a read-only view with each supplier showing only their rows, so both sides reconcile against the same due dates and proof references. Keep internal notes (margins, negotiation reminders) on a tab the supplier cannot see.

Your accountant needs the home-currency cost per tranche, proof attachments, and fees separated from payments. Export a clean monthly summary rather than handing over the working file. If you use accounting software, the sheet is the working tracker and the software is the book of record. Reconcile the two monthly, and treat any mismatch as a sheet bug until proven otherwise.

For questions about how payment coordination fits into a sourcing engagement, see the FAQ, or email hi@cnally.com to set up a tracker for an active order.

Frequently Asked Questions

How often should I update a payment tracking sheet for China orders?

The day any payment event happens: deposit sent, balance released, fee charged, supplier confirms receipt. Waiting until month end means reconstructing dates from memory. Monthly reconciliation verifies what was recorded; it doesn't record it.

Should deposits and balance payments share one row?

No. One row per tranche. Deposits and balances have different due dates, release triggers, methods, and often different exchange rates. Merging them into one figure destroys exactly the detail the sheet exists to keep.

Which currency should the sheet use?

Record each amount in the order's contract currency, then convert every tranche to your home currency at the rate on the payment date. Converting everything upfront hides FX movement between tranches.

How do I track overpayments, credits, and refunds?

Give each its own row with a negative amount and a clear tranche label ("Credit," "Refund") linked to the original order ID. Do not net them against other payments. Supplier refunds can take weeks to clear, so keep the status "Pending" until the money lands.

Is a spreadsheet enough, or do I need accounting software?

A spreadsheet serves importers running a handful of orders. Once you have dozens of active tranches or need audit-ready records, keep the sheet as the working tracker and your accounting software as the book of record, reconciling monthly.

What if a supplier asks me to pay a different account mid-order?

Stop and verify before sending anything. Check the new details against the original PI, request written confirmation on company letterhead, and confirm through a channel you already trust: the contact you've dealt with all along, not the email that carried the new details. Record any agreed change with a date. Mid-order account switches are a standard payment-fraud pattern.

The Rule That Keeps Your Sheet Honest

If you cannot open the sheet and state, within sixty seconds, what is owed to whom and by when, it is decorative. Build it with one row per tranche, separate columns for planned versus actual, dated exchange rates, and proof on every paid row. Reconcile on the same day every month, and give one person ownership of updates.

Start this week with your most expensive open order: add the template columns, split its payments into rows, and attach the proof you have. Then do the next one. The first hour feels uncomfortable; every hour after is routine. The first time the sheet stops a balance leaving before inspection passes, it has paid for itself many times over.