How to Reconcile Receipts to Your Bank Statement (Without Plaid)

Most small business owners reconcile their books once a year, in a panic, the week before their accountant’s deadline. They open the bank statement, open their receipt pile, and start matching them up. By the third hour they are angry, by the fifth hour they have given up, and at the end they hand their accountant something that is “close enough.”

This is not a discipline problem. Annual reconciliation is just a bad design. Receipts and bank charges drift apart over twelve months: returns, partial refunds, deposits split across statements, charges that hit the bank a day or two after the receipt date. Doing it monthly — ideally weekly — takes about ten minutes and catches the kinds of problems that turn into thousand-dollar headaches at tax time.

You also do not need to give any app your bank login to do it. The CSV (or PDF) statement your bank already provides is enough.

What reconciliation actually catches

Reconciliation is not a bookkeeping ritual. It is the process that uncovers four specific problems:

• Charges with no receipt. A bank transaction exists but you have no documentation. If you cannot prove what it was for, you cannot deduct it. Without reconciliation, you find these in April — or never.
• Receipts with no charge. You captured a receipt, but it never hit the bank. Maybe a duplicate. Maybe a refund you forgot about. Maybe a personal expense that snuck onto the business books.
• Fraudulent charges. The unrecognized $79 to “ABC SERVICES.” You can dispute it now — or pay tax on undocumented charges later.
• Forgotten income. Especially for landlords, freelancers, and gig workers, deposits show up in your bank account from sources you have already forgotten. Reconciliation catches them.

None of these are visible if you only look at receipts. None of these are visible if you only look at the bank statement. They appear in the gap between the two.

Why “just connect your bank” isn’t the right answer for everyone

Most modern bookkeeping tools push you toward a Plaid-style connection: hand over your bank credentials, the tool pulls your transactions automatically, end of story. There are real upsides to that approach, but also real downsides that the marketing rarely mentions.

You are handing your live banking credentials — or read-only access via OAuth — to a third-party service that probably uses a fourth-party intermediary (Plaid, Yodlee, MX). If any link in that chain has a credential incident, your account is exposed. Your bank might also disable the connection without warning when they change their security model, which they do regularly.

The CSV/PDF route is slower in the “getting the data in” step but it has properties the connected route does not:

• You never give anyone your bank password.
• The data you import is the data the bank officially confirmed — not a live feed that can lag, double up, or drop transactions.
• It works for every bank, every credit union, and every business credit card. No “sorry, we don’t support your bank” surprises.
• It works during the period after you cancel an account or close a card — you can still download the statement and reconcile it.

The right answer for most owner-operators and small businesses is the lower-tech one: download the statement once a month, drag it into the tool, reconcile, done.

The matching rules — what counts as a match

When SendToBooks compares a bank transaction to your receipts, it is looking at three things together:

• Date. Bank posting date is usually within 1–3 days of the receipt date. For credit card transactions in particular, the posting lag can be longer over weekends. We use a sliding window around the receipt date rather than insisting on an exact match.
• Amount. Exact match preferred. Small differences (a tip line that was added at the table, a foreign currency conversion fee) are flagged for your review rather than auto-matched.
• Merchant text. Bank descriptors are garbage. “SQ *JOES PIZZA” or “TST* JOE’S PIZZA NYC” needs to match the merchant we extracted from the receipt — which says “Joe’s Pizza.” We do this with fuzzy matching, not exact string compare.

A confident match (good on all three) is linked automatically. A less-confident match (good on two of three) is surfaced for one-click approval. Anything we cannot match at all goes into a “needs attention” bucket so you do not lose it in the noise.

Refunds and returns

Refunds are where most reconciliation tools fall apart. The refund hits the bank as a positive amount; the original charge was a negative; they happen weeks apart; and naive matching will not connect them. So you end up with a refund credit floating in your books that nets you a phantom “income” line.

The right behavior is to link the refund to the original purchase so they net out. SendToBooks does this automatically when the merchant, amount, and approximate date line up. When the match is ambiguous (multiple candidate purchases), we ask you which one in a short pick-list. The refunded amount then deducts from the original transaction, and your receipts stay accurate: the business spent the net amount, not the gross.

The monthly workflow

Here is what a monthly reconciliation looks like once your email forwarding and Snap are running for you in the background:

1. Once a month, download last month’s statement from your bank. CSV is preferred, PDF works fine. (Most banks let you download either; some only do PDF for credit cards.)
2. Open SendToBooks, go to Reconcile, drop the file in.
3. Confirm any one-click matches that need your approval. This is usually the bulk of the work and takes a few minutes.
4. For transactions with no receipt: either upload one if you find it, or mark the transaction with a note for your accountant (“recurring software subscription, no receipt issued”). The IRS does not require a receipt for everything — the bank record itself is often sufficient for sub-$75 items — but a note saves you from explaining it later.
5. For receipts with no bank match: investigate. Usually it is a duplicate scan, a personal expense that drifted into the business pile, or a charge that posts after the statement period closes.

The first month is the longest because you are working through an accumulated backlog. By month three the whole thing takes ten minutes.

What to do with mystery transactions

You will always have some. The bank’s descriptor is cryptic, you do not remember the charge, and you cannot find a matching receipt. The instinct is to ignore them. Resist it.

The discipline that pays off is to handle every unknown charge in one of three ways:

• Categorize it. If you can identify it (you Google the descriptor, you check your calendar, you find it was for X), record the category and add a note.
• Dispute it. If you cannot identify it and it does not look like anything you would have done, call your bank. Fraudulent charges are common and bank dispute windows are short — usually 60 days from the statement date.
• Mark it. If it is small and you simply cannot remember (a $9 charge from four weeks ago), categorize it as a best guess and tag it for review. Patterns emerge across months. By the third time you see the same vendor you usually figure out what it was.

The point is to never leave a transaction unaccounted for. Unknown charges are how fraud accumulates and how deductions disappear.

The compounding benefit

Once you do this monthly for three or four months, two things happen. First, your books match your bank statement, which means at tax time your accountant is not chasing reconciliation problems for three weeks. Second, you start noticing patterns. You catch the duplicate subscription you forgot about. You see the merchant who keeps charging the wrong tip. You spot the recurring vendor you could renegotiate.

None of that is visible at year-end. It is only visible when you look at the gap between your receipts and your bank statement on a schedule that lets the data still be fresh in your head. The Plaid-and-forget approach optimizes for “I never have to think about this.” The monthly-CSV approach optimizes for “I have a clear picture of my finances at all times.” The second one is worth ten minutes a month.