Reconciling Your Sales: A Five-Minute Weekly Routine
How a small business can reconcile sales in five minutes a week: match orders, ledger, and deposits, and catch fees, refunds, and gaps while they're small.
Five minutes a week is the cheapest bookkeeping you will ever buy. When a small business reconciles sales weekly, a missing payout or a forgotten refund gets caught while it is one line old, instead of surfacing three months later as a mystery no one can untangle. Reconciliation sounds like accountant language, but the act itself is simple: checking that what you sold, what your payment platform recorded, and what reached your bank all tell the same story.
This routine is built for a seller with a phone, a busy week, and no bookkeeper on payroll.
Why bother reconciling sales when you're a small business
Small is exactly when errors are affordable to catch. A boutique doing thirty orders a week can spot one odd line in seconds. The same business a year later, doing thirty orders a day, inherits every unexamined habit at ten times the volume.
The habit also builds an asset. Clean, matching records are what banks ask for when you want a loan, what tax season runs on, and what turns "I think February was good" into numbers you would stake a decision on. Sellers who reconcile weekly stop fearing their own books, and that confidence shows up everywhere from pricing to negotiations.
What you need before the timer starts
Three records, all of which already exist. First, your list of last week's orders, wherever orders live. Second, your money ledger, meaning the platform record of payments, fees, refunds, and payouts. Third, your bank statement, or just the mobile banking app opened to last week.
Add one running spreadsheet or notebook page as your reconciliation log. The log holds two things only, the weekly totals and any open questions, so it stays readable for years.
The five-minute weekly reconciliation routine
Same day, same time, every week. Monday morning with coffee works well because the weekend's sales are complete.
- Pull last week's orders. Filter your orders to the week just ended and note the count and total. A CSV export straight into your spreadsheet makes this a ten-second job.
- Match orders against the money ledger. The ledger's paid total should explain the order total exactly, once fees are accounted for. Circle anything paid in the orders view that has no money line, and anything charged that has no order.
- Match payouts against bank deposits. Every payout line in the ledger should appear on the bank statement, allowing for the usual transfer lag. One payout, one deposit, no exceptions unexplained.
- Log the sales that happened off-platform. Cash taken at a market table and direct bank transfers belong in your log too, or your "total sales" will quietly become "total card sales" and mislead you.
- Write down what doesn't match, with a date. An open question written down is a task. An open question in your head is a worry. Most items resolve themselves by the next check, when a settling payment lands.
- Note the week's number somewhere you'll see it. A single running line per week turns into a trend chart for free, and trends are where decisions come from.
The first run might take fifteen minutes while you learn where everything lives. By week three, five minutes is honest.
The four mismatches you'll actually find
Reconciliation surfaces the same few patterns over and over, and almost all of them are ordinary.
| What you notice | The usual cause | What to do |
|---|---|---|
| Deposit smaller than sales total | Processing fees deducted before payout | Check the ledger's fee lines, then relax |
| Order paid, no money line yet | Settlement timing across the week boundary | Carry it to next week's check |
| Money line with no matching order | A refund, dispute, or manual charge | Trace it the same day while memory is fresh |
| Sales total feels low | Cash or transfer sales never logged | Add them to the log and tighten the habit |
Refund and dispute lines deserve one extra beat of attention, since each one has a story worth remembering. If a dispute ever grows into a formal chargeback, the trail you have been keeping becomes your defence, as covered in our guide to chargebacks for Jamaican merchants.
Selling in two currencies doubles the columns, not the work
USD sales reconcile exactly like JMD sales, provided you never mix the columns. Keep a JMD line and a USD line in your weekly log, match each against its own balance and its own payouts, and resist converting between them in your head, because remembered exchange rates are how books drift from reality. Our guide to running a Jamaican business in USD and JMD covers the strategy side of holding and pricing in both.
Let the platform do the collecting
The routine is five minutes only when the records are already organized, and this is where your tools either help or hurt. On Inkress, the pieces arrive ready: every order links to its payment, the ledger carries each fee, refund, and payout as its own line per currency, sales export to CSV for your log, and monthly PDF statements give your accountant the formal version of what you have been checking all along.
Reconciliation is the habit that makes every other money decision easier, and it costs less time than scrolling a feed. If your current records are a chat history and a memory, an Inkress account will hand you the ledger side of this routine already built.
Common questions
What does it mean to reconcile sales?
Reconciling is checking that three records agree: the orders you sold, the payment platform's ledger of money in and out, and your bank statement. When all three tell the same story, your books are trustworthy, and differences point you straight at fees, refunds, timing, or missed entries.
How often should a small business reconcile?
Weekly is the sweet spot for small sellers. Daily is overkill at low volume, while monthly lets errors pile up into an untangling job. A fixed five-minute slot on the same morning each week keeps the task small enough to actually happen.
Why is my bank deposit smaller than my sales total?
Processing fees are deducted before payouts, and any refunds you issued draw from the same balance. Your ledger's fee and refund lines should explain the difference exactly, and if they do not, that gap is precisely what reconciliation exists to catch.
Do I need accounting software to reconcile sales?
No. A single spreadsheet or notebook page holding weekly totals and open questions is enough at small scale. What matters is the habit and the matching, and a platform that exports your sales to CSV covers the data side without any extra software.
How do I reconcile cash sales alongside card sales?
Log cash and bank-transfer sales in your weekly record the same day they happen, in their own column. They will never appear in your card ledger, so the log is the only place your true total exists.