Mercury Bank Statement to Excel for Startups

TL;DR Mercury lets you export transactions as CSV, which is great for day-to-day work. For month-end bookkeeping, investor reporting, audits, loans or tax, also keep the monthly statement PDFs and convert them, because they're the official record with opening and closing balances. In Excel, keep one table with an Account column for each Mercury account, label transfers between your own accounts so they cancel out, and prove each statement balances before importing or reporting. A simple monthly package (PDFs, a reconciled workbook, and notes on funding and large payments) keeps your accountant and investors happy.

Mercury is popular with startups and online businesses because it's built for founders who live in software. Many teams connect it straight to their accounting system and never look at a statement. Then something comes up: a year-end close, an investor due diligence request, a venture debt application, an R&D credit claim, a switch of bookkeepers, or a gap in the bank feed, and suddenly you need statements in a spreadsheet.

Mercury describes itself as a financial technology company rather than a bank, with banking services provided through partner banks. For your bookkeeping, that doesn't change much: you still have accounts, statements, balances and transactions to reconcile. This guide covers getting Mercury data into Excel, structuring it for a startup's needs, proving it's complete, and putting it to work. We describe the app in general terms, because product screens change frequently.

CSV export or statement PDF?

CSV exports from the transaction list are the fastest way to get data out, and they often include helpful fields beyond what a statement prints, such as categories or notes you've added. Use them for quick analysis and day-to-day bookkeeping.

Monthly statement PDFs are the formal record for each account and period. They show the opening and closing balance and every posted transaction. Accountants closing the books, auditors, lenders and investors doing diligence generally want statements, and a statement is the right thing to reconcile against.

The two can disagree at the edges. Exports can include pending items or be filtered without you noticing, and they don't come with official balances. A good habit is to work day-to-day from exports and close each month against the statement. If you only have PDFs, perhaps from a prior bookkeeper or a data room, convert them to a table.

Save statements with consistent names, for example mercury-checking-2026-07.pdf and mercury-savings-2026-07.pdf.

Multiple accounts, one workbook

Startups often run several accounts: an operating checking account, a savings or reserve account, maybe a separate account for payroll or a specific project, plus cards. That's good financial hygiene, but it multiplies the statements.

Structure the workbook as one table with these columns:

The Account and Statement columns let you filter down to a single statement for checking, while still running company-wide summaries. Our guide to combining multiple bank statements in Excel covers the mechanics.

Converting statement PDFs

For a short statement, copy and paste or Power Query can work. Expect to clean up wrapped descriptions, header rows and amounts stored as text. See our Power Query bank statement guide for that route.

SheetStatement converts statement PDFs into rows with real dates and signed amounts and runs a balance check before export. Download Excel or CSV, or formats for QuickBooks and Xero. The free plan covers 3 pages a month. Starter ($9), Pro ($19) and Business ($39) monthly plans cover larger volumes, useful when a year of statements across several accounts needs converting at once for diligence.

Prove each statement balances

For each account and each month:

=ROUND(Opening + SUMIFS(Tx[Amount], Tx[Statement], "2026-07 checking") - Closing, 2)

Zero means the statement is complete. Build a small control sheet with one row per statement: account, month, opening, closing, sum of activity, and the difference. Add one more check, that each statement's opening balance equals the previous month's closing balance for the same account:

=IF(ROUND(Opening - PreviousClosing, 2) = 0, "OK", "Gap")

A "Gap" means a missing month, a statement downloaded twice, or a typo in a balance.

The control sheet becomes a one-page proof for your accountant or an auditor that the transaction data is complete. The free balance checker is a quick way to confirm individual statements.

Transfers between your own accounts

Internal transfers are the biggest source of inflated numbers in multi-account workbooks. A move of 150,000 from checking to savings appears as -150,000 on checking and +150,000 on savings. Count both as cash flow and you've invented 300,000 of activity.

Flag them:

1. Set Type to Transfer on both sides.
2. Match them, by amount (opposite sign) and date, with a helper column:

=COUNTIFS(Tx[Amount], -[@Amount], Tx[Date], [@Date], Tx[Type], "Transfer")

A result of 0 on a transfer row means the other side is missing or landed on a different date. Investigate before closing the month.

3. Exclude Transfer rows from income, spending and burn reports.

The same applies to card payments if your card is a separate account: paying the card balance from checking is a transfer, and the individual card transactions are the spending.

Startup-specific categories

Founders and their accountants usually care about a few categories that general templates miss.

• Funding. Equity investments, SAFE proceeds, convertible notes and loans are not revenue. Keep them in their own categories, with a note on the instrument. This matters a lot for anyone reading your numbers.
• Payroll and contractors. Payroll provider debits are often single large lines covering wages, taxes and fees. Your payroll reports break them down; the bank just shows the total.
• Software and cloud. Usually the biggest line after people. Track by vendor so you can spot creeping costs.
• Revenue. Card processor payouts or customer wires. Payouts are usually net of fees; record the gross and fees separately using your processor's reports. Our guide to reconciling Stripe payouts shows how.
• Interest and yield. Interest earned on reserve balances is income, but separate from operating revenue.

A rules table that maps counterparties to categories automates most of this. See Excel formulas to categorize transactions.

Monthly burn and runway from statements

With categorized, reconciled data, burn and runway are a pivot table away.

• Net burn for a month: the change in total cash across all accounts, excluding funding inflows. Or equivalently, operating outflows minus operating inflows, excluding transfers and funding.
• Gross burn: total operating outflows.
• Runway: current cash divided by average net burn over recent months.

=SUMIFS(Tx[Amount], Tx[Month], "2026-07", Tx[Type], "<>Transfer", Tx[Category], "<>Funding")

gives net operating cash flow for July. A negative number is burn. Our guide to building a cash flow statement from bank statements goes further. These are cash figures, not accounting profit; accrual accounting can tell a different story, and investors may ask for both.

Getting it into accounting software

If your bank feed broke or never covered the early months, import the converted statements to fill the gap.

• QuickBooks Online: CSV or QBO. See importing into QuickBooks Online.
• Xero: CSV in Xero's layout. See the Xero CSV import format.

Before importing, find exactly where the feed's data starts and stops, and import only the missing dates. Overlap creates duplicates; see fixing duplicate transactions after import if it happens. Then reconcile each month to the statement's closing balance.

A worked example

A seed-stage startup is raising a small extension. The lead investor asks for twelve months of bank statements and a reconciled cash summary.

1. Download. The finance lead downloads twelve statements each for checking and savings, twenty-four PDFs in total.
2. Convert. All twenty-four become one table with Account and Statement columns.
3. Control sheet. Every statement balances, and each opening balance matches the prior closing balance, except one month for savings. The PDF for that month was saved twice under different names and the real one was missing. Downloading it fixes the gap.
4. Transfers. The matching formula flags one transfer without a partner. It turns out the savings side posted a day later. The date tolerance is widened to two days and the pair matches.
5. Categories. The seed round and a small SAFE are tagged as funding. Revenue payouts are matched to the processor's reports.
6. Summary. A pivot table gives monthly gross burn, net burn and ending cash, and the runway calculation goes into the investor update.
7. Data room. The PDFs, the workbook and the control sheet go into the data room together.

The investor sees source documents, a complete transaction set, and a one-page proof that the two agree.

A month-end routine that takes an hour

Most early-stage companies don't have a full-time finance person, so the close tends to slip. A short, repeatable routine keeps it from piling up. Once the workbook is set up, this takes about an hour a month for a typical seed-stage company.

1. Download the statements for every account and card as soon as they're available, and save them with the standard names.
2. Convert and append them to the main table, filling in the Account and Statement columns.
3. Update the control sheet. Every new statement should balance on its own and pick up where the previous month left off.
4. Match transfers. Clear every unmatched transfer before moving on. An unmatched transfer almost always means a missing account, a timing difference, or a mistake.
5. Categorize new counterparties. Add any new vendor or customer to the rules table, so next month they're categorized automatically.
6. Review large or unusual items. Filter for anything above a threshold you choose, say 5,000, and add a note: what it was, who approved it, and where the supporting document is.
7. Reconcile the books. If you use accounting software, reconcile each account to the statement's closing balance. Our month-end close checklist covers the rest of the close, such as accruals and payroll.
8. Update the dashboard. Refresh the pivot table with cash, gross burn, net burn and runway.

Skipping a month is how catch-up projects start. If you're already behind, our guide to catch-up bookkeeping suggests the order to work in, oldest month first.

Handing over to a new bookkeeper or accountant

Startups change finance providers often: a founder doing it themselves hands off to a part-time bookkeeper, who later hands off to a firm. Every handoff is a chance for gaps. A clean package makes it painless:

• All statement PDFs for every account since the company opened, or at least since the last closed year, named consistently.
• The combined workbook with Account, Statement, Type, Category and notes.
• The control sheet showing every statement balances and links to the next.
• A list of accounts and cards, including closed ones, with opening and closing dates.
• Notes on funding: dates, amounts and instrument types for each round.
• Known open items: unmatched transfers, uncategorized transactions, disputes, refunds in progress.

A new provider who can see that the transaction data is complete can start on the actual accounting immediately, instead of spending the first weeks rebuilding the history. Our guide to a bookkeeper's workflow for multiple clients shows the same idea from the provider's side.

Audits, R&D claims and loans

The same reconciled file supports other requests.

• Audits and reviews: auditors typically confirm balances independently, but a reconciled transaction file speeds up testing. See preparing bank statements for an audit.
• Business loans and venture debt: lenders often ask for several months of statements and may analyze inflows and balances. See bank statements for a business loan.
• Tax credits: claims that depend on specific expenses, such as qualifying research costs, need transaction-level support. Categorize carefully and keep invoices. This is general information; work with a qualified tax adviser.

Record-keeping habits that pay off later

A few small habits make every future request easier, whether it comes from an investor, an auditor, a lender or a tax adviser.

Download statements even when you don't need them. Bank feeds and exports are convenient, but the statement is the document people ask for. Saving each month's PDF as it arrives takes seconds; reconstructing two years of statements during a fundraise takes days.

Keep notes next to the numbers. A Notes column in the workbook is where context lives: "Refund of duplicate invoice", "Deposit for office lease, refundable", "Founder loan, see agreement dated March". Six months later, nobody remembers.

Don't delete closed accounts from the workbook. If you close an account, keep its statements and its rows, and record the closing date and where the final balance went. Gaps in account history are one of the most common diligence questions.

Keep supporting documents linkable. Store invoices and receipts in a folder structure that matches your categories or months, or add a link column. The bank statement shows that money moved; the invoice shows why.

Troubleshooting

Export totals don't match the statement. The export probably includes pending transactions or excludes some accounts. Close the month against the statement.

Card transactions missing from checking. If the card has its own statement or account, its transactions live there. Include it as a separate Account.

Foreign currency payments. International wires may show the amount in your account currency only. Keep the invoice currency and amount in a note for reference.

Dates shift by a day. Time zones and posting cut-offs can put a transaction on a different date in an export than on the statement. Use the statement date for reconciliation.

FAQ

Can I export Mercury transactions as CSV?

Yes, the transaction list can be exported. That's ideal for day-to-day work. For month-end closes, audits, loans and investor diligence, also keep and reconcile the monthly statement PDFs.

Why do I need statements if I have the export?

Statements are the official record with opening and closing balances, which is what you reconcile against and what third parties ask for. Exports can include pending items and don't carry official balances.

How do I handle several Mercury accounts?

Use one table with an Account column and a Statement column. Balance each statement separately, then flag transfers between accounts on both sides so they cancel out.

Is investor funding income?

Not for bookkeeping purposes. Equity, SAFEs, convertible notes and loans should be categorized separately from revenue. Ask your accountant how to record each instrument.

How do I calculate burn from bank statements?

Sum operating inflows and outflows for the month, excluding transfers between your accounts and funding. A negative total is your net burn. This is a cash measure, not accounting profit.

Can I import converted statements into QuickBooks or Xero?

Yes. Import only the dates the bank feed missed, one month at a time, and reconcile each month to the statement's closing balance.

Is it safe to upload statements?

See the security page for how SheetStatement processes and stores statements, and review any service's policy before uploading.

How much does it cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro $19 and Business $39.