Payment reconciliation for small businesses: match the money to the order

Start with a question you can answer

“Did this customer pay for this order?” sounds simple until you have several payment methods, a bank statement and an inbox full of screenshots. Payment reconciliation is the work of matching the sale to the evidence that money moved, then explaining the differences.

For a small business, a useful routine does not need to start with a complicated spreadsheet. It needs a consistent order reference, the correct payment record and a clear distinction between money received directly and money still owed to the business.

OurPay keeps checkout, customer and order records connected. Finance adds the collection or ledger history needed to investigate a payment. The remaining task is to read those records correctly and resolve exceptions before they become a pile of unanswered customer messages.

Keep three records in view

Begin with the order: what was sold, to whom, for which amount and currency? Then identify the payment evidence. For direct INR collections, that is the actual receipt in the receiving bank account. For a provider payment, it is the confirmed provider transaction.

Finally, check the money position. A direct collection may already be in your bank. An international capture may contribute to Seller Payable and still need settlement. These records describe related events, but they are not interchangeable.

For example, two orders can both show confirmed payment while the money reached your business through different routes. One may have a verified INR bank receipt; the other may have a captured USD payment and an outstanding payable. Keep the currency and route visible when you review them.

Review domestic collections against the bank

In OurPay, open Finance → Collections to review direct payment references. Match the receiving account, reference and full amount against the actual bank record. Customer-submitted details help you locate the transfer; they are not enough to confirm it.

If several customers pay the same price, the amount alone cannot identify the order. If a customer supplies a reference twice, investigate the original receipt rather than treating the second submission as new money. OurPay prevents the same receipt from funding another order for that receiving account.

Only confirm a collection once the receipt matches. OurPay then completes the order and connects the invoice and configured benefits. Keep unmatched, short or unresolved transfers pending while you investigate instead of forcing the records to agree.

Follow provider payments through their own records

For an international payment, look for the confirmed provider capture attached to the sale. The browser returning from checkout is not the same evidence. Use the order and payment state to establish what actually happened.

Provider identifiers are useful when a payment is pending, refunded or disputed. Keep them connected to the OurPay order so a support enquiry can be traced across both systems. Do not replace your customer identity with a provider transaction number; one customer can have many payments.

After confirmation, inspect the relevant fee and adjustment entries. The gross amount paid by the customer is not necessarily the amount eventually owed to the seller. A refund or dispute can change the position after the original checkout succeeded.

Read Seller Payable without counting it twice

Seller Payable records the amount owed within OurPay’s seller ledger after the relevant entries. It is not a second name for the cash balance in your bank account. A direct INR receipt should not be added to a provider payable as if both were waiting for the same settlement.

Keep currencies separate while reconciling. Adding an INR receipt to a USD amount produces a number with no useful meaning unless a defined conversion is applied and recorded. Retain the original transaction amounts and the evidence for any conversion used in your accounting.

Automatic seller payouts are not currently available in OurPay’s standard service. If an external settlement is arranged with the operator, do not assume the bank transfer automatically changes the displayed payable. Retain the transfer evidence and agree how the outstanding records will be reconciled.

Give each mismatch a specific next action

An exception list is useful only if someone can act on it. “Payment issue” is too vague. Record whether the reference is missing, the amount differs, the provider is still pending or a settlement record has not been matched. Assign the next step to someone who can inspect the relevant source.

If the bank receipt is missing, check the destination details and ask the customer to verify the transfer status. If a provider attempt is pending, investigate that attempt before creating another. If a refund has been requested, distinguish the request from a confirmed refund and retain the resulting provider reference.

Close the exception only when the evidence supports the new state. Do not rename a payment as settled merely to clear a queue. Your future support response and accounting review will depend on the same record.

Use a short, repeatable review

Choose a review frequency that matches your order volume. A small team might check new collections during its normal fulfilment routine and review unresolved exceptions at the end of the working day. The important part is that the responsibility and evidence are consistent.

1. 01Review new orders and identify the payment route and currency.
2. 02Match direct collections to actual receiving-bank receipts.
3. 03Check provider payments for confirmed captures and later adjustments.
4. 04Keep unresolved references, amount differences and pending attempts on an exception list.
5. 05Review Seller Payable separately from bank receipts and settlement evidence.
6. 06Attach the resolution to the original order so another teammate can follow it.

Make the record useful to the next person

Good reconciliation reduces the amount of explanation a teammate needs. They should be able to open the order, see the payment route, identify the confirmation and understand any refund or adjustment without asking the person who handled the original sale.

OurPay gives those events a shared place in the product. Your process supplies the final discipline: confirm bank receipts carefully, keep unlike currencies and balances distinct, and write down the reason when money and order status appear to disagree.

Start with the next unresolved order rather than trying to redesign your entire finance operation. Once the matching steps are clear, repeat them. A small routine that closes real exceptions is more useful than a dashboard full of totals your team cannot explain.