Get the original Mercury bank statement PDF, preserve the currency printed on your statement, convert the file, and review the rows before accounting or reconciliation.
In the Mercury dashboard open Documents & Data, select an account from the Statements dropdown, choose one or more monthly statements, and download. The original provider file is a better conversion source than screenshots, scanned printouts, or a browser page saved with missing columns.
Mercury statements contain Date UTC, Description, Type, Amount, and Balance. Signed amounts must be mapped without losing the original transaction type. This guide explains what to download, what Parse Statement extracts, and which checks matter before you export the result.
- Use the official Mercury statement or document channel
- Preserve the currency printed on your statement and verify the statement period
- Review Date, Description, Debit, Credit, Balance after extraction
- Open the separate Mercury PDF password guide when the file is locked
Download the correct Mercury file
In the Mercury dashboard open Documents & Data, select an account from the Statements dropdown, choose one or more monthly statements, and download.
The access path and product details below were reviewed against Mercury's official material on July 14, 2026. Interface labels can change, so the linked provider remains the final reference.
- Choose the intended account, card, wallet, folio, order, or service before selecting the period.
- Prefer the original PDF, HTML, or provider export over screenshots and print-to-PDF copies.
- Keep the delivery email until the file opens because it may contain document-specific password instructions.
- Confirm that the file itself shows the expected period and preserve the currency printed on your statement.
What Parse Statement extracts from Mercury
Mercury statements contain Date UTC, Description, Type, Amount, and Balance. Signed amounts must be mapped without losing the original transaction type.
The normalized review table uses Date, Description, Debit, Credit, Balance. The exact source headings may differ, but the values should remain traceable to the statement rather than being inferred from a brand name or file name.
- Keep Date UTC meaning explicit
- Preserve signed amount direction
- Retain transaction type for bookkeeping
Validate the rows before export
Start with the statement period, opening or prior balance, closing or total value, and the count of visible activity. Then spot-check high-value rows, page transitions, credits, refunds, fees, and any description that wraps onto another line.
A successful extraction is not the same as a reconciled result. If the source provides a running balance, each row should move that balance in the expected direction. Where it does not, pause and inspect the original page before using the data.
- Keep Date UTC meaning explicit
- Preserve signed amount direction
- Retain transaction type for bookkeeping
- Compare debit and credit totals with the provider document.
- Resolve warnings before importing the file into accounting software.
Choose an export for the next job
Use Excel or Google Sheets for review, formulas, filters, and collaborative cleanup. Use CSV for a controlled import or a simple data handoff. Use OFX or QIF only when the destination supports that format and the account, currency, and transaction direction have been checked.
Keep an untouched copy of the source file and a reviewed copy of the export. That gives an accountant or reviewer a direct way to trace any adjusted row back to the original document.
- Excel: review, formulas, comments, and reconciliation work.
- CSV: clean table exchange and controlled accounting imports.
- OFX or QIF: compatible finance and bookkeeping products after validation.
- Cleaned PDF: archiving and sharing a standardized copy, not a substitute for source records.
Troubleshoot a difficult Mercury statement
If the file asks for a password, use the separate Mercury password article and the instruction supplied with that exact document. Never enter a NetBanking password, OTP, card PIN, CVV, or UPI PIN into a PDF password field.
If the file opens but contains only images, obtain a digital statement when possible. If rows are missing at page breaks, shorten the period or re-download the original file before relying on an OCR-only copy.
- Re-download the original provider file before trying a browser-generated copy.
- Check that the selected period actually contains activity.
- Use AI fallback for an unfamiliar layout, then review its confidence warnings.
- Do not force a result when totals or balances cannot be reconciled.
Mercury rows after normalization
This synthetic example shows the shape of a reviewed export in a fictional USD example. It is not real customer data and it does not reproduce the provider's interface.
- Source: Mercury
- Currency: USD (fictional example)
- Output: Review first
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-04-03 | ACH credit | 1,250.00 | 18,750.00 | |
| 2026-04-08 | Wire transfer | 5,000.00 | 23,750.00 | |
| 2026-04-11 | Card expense | 480.00 | 23,270.00 |
- Keep Date UTC meaning explicit
- Preserve signed amount direction
- Retain transaction type for bookkeeping
Result: A structured table (shown in fictional USD example) that stays traceable to the original bank statement PDF.
Real use cases
Accountant or bookkeeper
Need: Needs Mercury activity in a consistent table.
Outcome: Receives reviewed rows with source context and printed currency preserved.
Founder or finance team
Need: Needs a repeatable monthly close workflow.
Outcome: Keeps the original file, validation notes, and export together.
Individual user
Need: Needs searchable records without manual typing.
Outcome: Can filter and verify the converted rows before download.
Frequently asked questions
Where should I download my Mercury statement?
Use only Mercury's official app, website, or registered statement email. In the Mercury dashboard open Documents & Data, select an account from the Statements dropdown, choose one or more monthly statements, and download.
Can I convert a Mercury statement to Excel?
Yes. Use the dedicated Mercury converter, review the extracted Date, Description, Debit, Credit, Balance, and export to Excel, CSV, Google Sheets, or another supported format.
What currency should a Mercury export use?
Preserve the currency printed on your statement. The document itself is authoritative; never replace or assume a currency simply because of the institution name.
What if the Mercury PDF asks for a password?
Open the separate Mercury password guide and follow the instruction supplied with that exact statement. A PDF password is not your banking login, OTP, card PIN, CVV, or UPI PIN.
Should I import the result immediately?
Review the period, row count, amount direction, totals, references, and any running balance first. Test accounting imports with a small controlled file before using a full period.