TL;DR: Reconciling a Mercury account at month-end is not hard, but most founders make it harder than it needs to be by trying to eyeball it. Pull the statement, match deposits to your payout processor, account for IRS reserve transfers and outgoing wires, treat Treasury yield as interest income, and ignore pending transactions until they clear. Then run the 4-point sanity check before you hand anything to your CPA.
What "reconciled" actually means
Reconciled has a boring, precise definition, and it's worth getting it right before you touch a single transaction. Your books are reconciled for a given month when the ending balance in your ledger matches the ending balance on your Mercury statement, and every transaction in between is accounted for in both places. That's it. Not "looks about right." Not "close enough." The two numbers tie out to the penny, and you can explain any line that doesn't.
The reason this matters isn't pedantry. An unreconciled account is an account where money could be missing and you wouldn't know. A duplicate Stripe payout, a wire you recorded twice, a refund that hit your bank but never made it into your ledger — these don't announce themselves. They just quietly make your revenue or your cash position wrong, and you find out months later when your CPA asks why the balance sheet doesn't foot.
For a solo founder running a SaaS business through Mercury, the monthly reconciliation is the single most important bookkeeping task you do. If you do nothing else, do this. It's the check that proves the rest of your numbers are real.
Step 1: Pull the Mercury statement, not the dashboard
Start with the official monthly statement, not the running transaction feed. In Mercury, go to Settings, then Statements, and download the PDF or CSV for the closed month. The distinction matters: the dashboard shows live, ever-changing data including pending items, while the statement is a frozen snapshot with a fixed beginning balance, a fixed ending balance, and a closed list of posted transactions. You reconcile against the snapshot.
Write down two numbers before you do anything else: the statement's beginning balance and its ending balance. These are your goalposts. The beginning balance should already match last month's reconciled ending balance — if it doesn't, you have a problem in a prior period and you should stop and fix that first, because everything downstream depends on it.
If you're using Prosper, your Mercury transactions are already flowing in through Plaid, so the data is sitting in your ledger waiting to be matched. The statement is still the source of truth you check against. Plaid sync gets the transactions in; the statement confirms nothing was dropped or doubled.
Step 2: Match your deposits to the payout source
This is where most SaaS founders trip, because the deposit in Mercury is almost never the same number as the revenue your customers paid. Stripe takes its fee, batches charges, and pays you out a few days later in a lump sum. So a $4,000 Mercury deposit might represent $4,120 in customer charges minus $120 in Stripe fees. If you book the $4,000 as revenue, your revenue is understated and your fees are invisible.
The fix is to match each Mercury deposit back to its source payout, not to individual invoices. Pull the Stripe payout report for the month and line up each payout's net amount against the deposits that landed in Mercury. The gross charges become revenue, the processor fees become an expense, and the net is what hits the bank. We cover the mechanics of this split in detail in our guide on how to categorize Stripe payouts.
Run through your deposits in this order so nothing gets miscategorized:
- Stripe payouts — match net deposit to the Stripe payout report; split gross revenue from processor fees.
- PayPal or other processor payouts — same treatment, separate fee account.
- Customer wires or ACH paid directly to Mercury — these are usually revenue at face value, no fee split.
- Transfers from another account you own — these are not income; they're movements of your own cash.
- Refunds and chargebacks landing as negative deposits — contra-revenue, not an expense.
Step 3: Handle IRS reserves and outgoing wires
A lot of disciplined founders keep a separate Mercury account or a savings sub-account where they park money for quarterly estimated taxes. When you move $3,000 from your operating account into that IRS reserve, that transfer is not an expense. It's your own money moving from your left pocket to your right pocket. If you categorize it as a tax payment, you've just overstated your expenses by $3,000 and the actual tax payment later will get double-counted. Book it as a transfer between accounts.
The transfer only becomes a real expense when the money actually leaves for the IRS — when you pay the estimated tax via EFTPS or your CPA's portal. That's the moment it hits your books as an estimated tax payment. Until then it's just cash sitting in a different bucket. Our post on quarterly estimated taxes for founders walks through how much to set aside.
Outgoing wires need a second look because Mercury often shows the wire and a separate wire fee as two lines. The wire itself gets categorized based on what you bought — a contractor payment, a software annual plan, a legal invoice. The $5 or $15 wire fee is a bank charge, categorized separately. Don't bundle them, or your vendor expense will be off by the fee and your bank charges line will be empty when your CPA expects to see one.
Step 4: Treat Mercury Treasury yield as interest income
If you've parked idle cash in Mercury Treasury, you're earning yield, and that yield shows up as deposits into your account. It is tempting to ignore these small amounts or lump them in with revenue. Don't. Treasury yield is interest income — a distinct category from your product revenue — and your CPA will want it broken out because it's taxed and reported differently than the money you earn from selling software.
Practically, this means creating an interest income account in your ledger and categorizing every Mercury Treasury yield deposit there. The amounts might be small one month and meaningful the next depending on your balance, but consistency is what matters. If yield is revenue in January and interest in February, your year-end numbers are a mess and someone has to untangle it.
In Prosper, recurring deposits like Treasury yield get recognized by the auto-categorization once you've confirmed the category the first time, so you set it once and the pattern holds. You still review it — Prosper surfaces transactions that need a human decision rather than asking you to scroll through every line — but the routine stuff stops demanding your attention. Whether you use Prosper, Wave, or a spreadsheet, the principle is the same: yield is interest, and it lives in its own account.
Step 5: Leave pending transactions alone
Pending transactions are the most common reason a reconciliation refuses to balance. A pending charge is money the bank expects to move but hasn't actually settled yet. It shows up in your live Mercury dashboard, it might show up through Plaid, but it is not on your closed statement — because the statement only includes posted transactions as of the closing date.
The rule is simple: reconcile to posted transactions only. If something is still pending on the last day of the month, it belongs to next month's reconciliation, when it posts. Recording a pending item in the current month is how you end up with a balance that's off by the exact amount of a charge that hasn't cleared, then spend twenty minutes hunting for an error that isn't an error.
This is also why you wait a few days after month-end before reconciling. If you try to close the books at 11:59pm on the last day of the month, half your end-of-month activity is still pending. Give it three or four business days so everything posts, then pull the statement and reconcile against clean, settled data.
The 4-point sanity check that catches most errors
Before you call the month done and hand anything to your CPA, run these four checks. In our experience they catch the large majority of the errors that would otherwise show up weeks later — roughly 95% of the ones we see — and they take about two minutes once you're used to them.
If all four pass, you're reconciled. If one fails, you've localized the problem to a specific category of error instead of staring at a wall of transactions wondering what's wrong.
- Balances tie out: your ledger's ending balance equals the Mercury statement's ending balance, to the penny. This is the headline check — if it passes, you're most of the way there.
- Beginning balance matches: this month's opening balance equals last month's reconciled close. A mismatch means a prior period got edited after you closed it.
- No uncategorized transactions: every line has a category. An uncategorized transaction is a decision you haven't made yet, and it's where errors hide.
- Transfers net to zero: every transfer out of one account you own has a matching transfer into another. If your IRS reserve transfer shows on one side but not the other, your cash is misstated.
Making the 15 minutes actually take 15 minutes
The first time you do this, it takes an hour because you're building the muscle memory and setting up your categories. By the third month, a clean Mercury close genuinely runs about fifteen minutes, because the only real work left is matching deposits, handling the handful of transfers and wires, and running the four checks. Everything routine has a home.
The thing that makes it fast is not doing it all at month-end. If your transactions are already categorized as they come in, reconciliation becomes a verification step rather than a data-entry marathon. This is the whole pitch for tooling: QuickBooks and Xero can do bank reconciliation, but they're built for businesses with a bookkeeper driving them, and you end up clicking through every transaction yourself. Prosper is built for the solo founder doing this alone — auto-categorization handles the repetitive lines through Plaid sync, exception-based review surfaces only what needs your judgment, and it's $29/mo flat. Results vary based on your transaction volume and how clean your data is.
Whatever tool you use, the goal is the same: walk into month-end with most of the work already done, spend fifteen minutes confirming the numbers tie out, and hand your CPA books that are actually reconciled instead of approximately right. Your CPA reviews and decides the tax treatment — your job is to make sure the cash is real and the categories are consistent. That's what reconciliation buys you.
Prosper is bookkeeping software and does not provide tax or legal advice. Consult a qualified professional for tax advice. Results vary based on transaction volume, data quality, and workflow setup.