A new business owner often opens the sales dashboard, then the bank account, and finds two numbers that do not match. Nothing is necessarily wrong. Payment processors usually hold funds briefly, subtract fees, net out refunds and pay out in batches. The job of reconciliation is to explain the difference line by line, so you are not guessing at month end. Here is a routine you can set up in your first month.
Why the numbers differ
A single customer payment can travel a long way before it appears as a deposit. Typical gaps include:
- Timing. A sale made late on the 30th may settle in the next month.
- Fees. Processors commonly deduct fees before paying out, so the deposit is smaller than the sales total.
- Refunds and chargebacks. These reduce a payout or are taken from a later one.
- Batching. One deposit can combine many sales across several days.
- Other activity. Tips, shipping, sales tax collected or adjustments may appear in one report but not another.
Your own processor reports are the authority on how your payouts are built. Do not rely on a general description, including this one.
Gather four sources each month
Collect these for the same date range:
- The sales report from your point-of-sale or store system.
- The processor’s payout or settlement report.
- The bank statement, showing each deposit.
- A list of refunds, disputes and adjustments for the period.
Use one reporting month as the starting point, then obtain adjacent-period transaction and payout detail where needed to explain opening and closing unsettled balances. Download the reports as files and save them in a folder named for the month. The IRS notes in its recordkeeping guidance that you may use any recordkeeping system suited to your business that clearly shows income and expenses, so choose a method you will actually follow.
Match from the bank backward
Start with the bank deposits, because they are the money that actually arrived.
- List each deposit with its date and amount.
- Find the processor payout that matches it (skip deposits that are transfers, loans or owner contributions; track those separately). Note the payout date and the gross sales, fees and refunds inside it.
- Trace the payout to the sales included in it. You are not matching every sale by hand. You are confirming that the payout’s gross sales line agrees with the sales report for the dates it covers.
- Record any difference and give it a reason: timing, a fee, a refund or unknown.
Anything marked unknown becomes a question, not an adjustment. Do not force the totals to agree by editing a number.
Use a simple reconciliation sheet
One page per month is enough. Put these lines on it:
- Gross customer collections processed through this processor, with included components (tips, shipping, sales tax collected) identified
- Less refunds, chargebacks and fees, each counted once
- Plus or minus documented reserve movements and other adjustments
- Plus opening unsettled funds, less closing unsettled funds
- Expected processor deposits
- Actual processor deposits shown by the bank
- Unexplained difference
Reconcile each processor separately. Identify cash receipts, loans, owner contributions and transfers separately from processor deposits.
The remaining difference is the amount still to investigate; a zero difference does not by itself prove that every item was classified correctly.
Keep a running list of open questions
Every unmatched item goes on a list with the date, amount, where you saw it and what you need to resolve it. Examples: “Payout on the 14th is lower than the report suggests; need the fee detail from the processor,” or “Refund appears in the sales report but not in the payout.” Review the list weekly. In the first month it is normal for it to be long, and it shortens as you learn how your processor reports.
Be careful about tax treatment
How fees, refunds and sales tax are treated for tax purposes is a separate question from whether the deposit matches. Keep the reconciliation factual and leave tax conclusions to a qualified tax professional, working from official guidance. The IRS recordkeeping page explains that you must keep records as long as needed to prove the income or deductions on a tax return. For Nevada sales and use tax questions, start with the Nevada Department of Taxation.
A routine you can repeat
- Weekly: download reports, update the open-questions list.
- Month end: complete the one-page reconciliation and save the files.
- Next month: carry forward any timing items so they are not counted twice.
Do this for the first month and the process becomes familiar quickly. Save this outline, adapt it to your processor’s reports and bring your questions to a qualified professional if something still does not make sense.
This article provides general information, not legal, tax, or financial advice.
Business Compliance Advisors (BCA), a registered fictitious firm name of Elemarix Ventures LLC, Clark County, Nevada. consultbca.com | businesscomplianceadvisors.com
Sources
- Internal Revenue Service, Recordkeeping: https://www.irs.gov/businesses/small-businesses-self-employed/recordkeeping
- Nevada Department of Taxation: https://tax.nv.gov/
Legal services through Newman Law, LLC.
