Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Keep Track of Which Factory Deposits and Balances Are Due, and Stop Paying Twice or Late?
Problems We Solve

How Do We Keep Track of Which Factory Deposits and Balances Are Due, and Stop Paying Twice or Late?

Importers track factory deposits and balance payments in spreadsheets and pay late or twice. We build a payment schedule tied to each purchase order.

Updated 2 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Factory payments usually come in stages (deposit on order, balance before shipping or against documents) and are tracked in a spreadsheet separate from the orders and the accounts. We build a payment schedule tied to each purchase order, triggered by real events like inspection release, with bank details checked against a verified record, and reconciled to what was paid.

Which balance is due this week?

You have eleven open orders with six factories. Each has a deposit paid when the order was placed and a balance due before shipping, or against a copy of the bill of lading. The spreadsheet that tracks them was last updated by someone who is on holiday. A factory emails to say the goods are ready and they need the balance before they will release the cargo. Another sends an invoice for a deposit you think you have already paid.

Your finance person searches the bank statements and emails to find out what has actually been paid, against which order, at which amount.

Why staged payments are hard to track

Payment terms with overseas factories are tied to events (order confirmation, production complete, inspection passed, goods shipped) rather than to dates. Those events are known by the buyer, not by finance. The invoices, proforma invoices and payment requests come by email in varying forms. And the accounts system knows what was paid but not which stage of which order it covered.

StageUsual triggerCommon slip
DepositOrder confirmedPaid on a proforma, then invoiced again
BalanceGoods ready or inspection passedPaid before inspection result
Balance against documentsBill of lading copyDocuments not checked first
AdjustmentsShort shipment or claimsNot deducted from the balance

What payment confusion costs

Late balances hold up shipments, because factories will not release cargo until paid. Duplicate payments take time to recover from an overseas supplier. Paying a balance before an inspection result leaves you with little to hold back if the goods fail. And changes to a factory's bank details by email are a well-known route for fraud; if nobody checks them, a payment can go to the wrong account.

The payment schedule we build

  1. Each purchase order holds its payment terms as stages, with the trigger event and the amount or percentage.
  2. Proforma invoices and payment requests are read from email and matched to the order and stage, so duplicates are flagged before anything is paid.
  3. Stages become due when their trigger happens: for example, the balance becomes payable only when the inspection result is recorded as released.
  4. Factory bank details are held in a verified record. Any request with different details is blocked and flagged for a call-back check by your team.
  5. Finance gets a list of payments due, with the order, stage and supporting documents, to approve and pay through your bank.
  6. Payments made are recorded against the stage and matched to your bank feed or accounts system, and any claims or shortages are shown as deductions from the balance.
  • One view of what is owed to each factory, by stage.
  • Payments released by events, not by chasing emails.
  • Bank detail changes checked every time.

What finance sees afterwards

A clear list of payments due this week, each with a reason and the documents behind it. Nothing paid twice. Balances tied to inspection results. Changes to bank details stopped until checked. And when a factory says they have not been paid, the answer is on screen, with the date, amount and reference.

Does your payment process look like this?

  • Deposits and balances are tracked in a spreadsheet.
  • Factories chase balances you thought you had paid.
  • Balances are sometimes paid before inspection results.
  • Bank detail changes arrive by email and are acted on.
  • Nobody can quickly total what you owe each factory.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does it make the payments?

No. Finance approves and pays through your bank as usual. The schedule tells them what is due and why.

Can it work with our accounts system?

Yes. It records payments against orders and can create bills in Xero or QuickBooks through their APIs.

How does the bank details check work?

Verified details are held per factory. A request with different details is held until someone confirms the change through a known contact, following your own procedure.

What about foreign currency?

Stages are held in the order currency, and the actual rate on each payment is recorded.

Keep reading

More on Problems We Solve

Start here

Tell us where the import paperwork piles up

Describe what you import, who your forwarder and broker are, and what you track shipments and costs in today. We will tell you what we would build, what we would leave to your forwarder's own tools, and if a smaller change would do, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →