About
Applies to: Finaloop Accounting
Finaloop Accounting, Finaloop's real-time bookkeeping and accounting service, imports your Mercury activity automatically once you connect Mercury, and you can export a CSV of your transactions or a PDF statement from Mercury and upload it whenever we need data the connection can't provide.
In certain cases, we may need your help getting transactions or reports we can't import automatically from your bank or financial institution. We'll ask for these in a mission, a task in My missions where we ask you for information we need. Here's how to connect Mercury, how to find the relevant reports in your Mercury account, and how to upload them to Finaloop.
1. Connect Mercury to Finaloop
Mercury connects to Finaloop automatically, so your transactions flow into your books without uploads. Your Mercury business bank accounts and credit cards connect through Plaid, a secure service that links bank accounts, and Mercury Treasury accounts connect with a read-only API token, a key you create in Mercury that lets us view your Treasury activity without moving money. If Mercury isn't connected yet, follow these steps:
Click Connect banks and cards.
In Select institution, search for Mercury and select Mercury for your business bank accounts and credit cards, or Mercury Treasury for your Treasury accounts.
Follow the on-screen instructions. For Mercury Treasury, create a read-only API token in Mercury, paste it in Finaloop, and click Done.
Your Mercury accounts then appear in Banks & Cards → Accounts overview.
When we ask you to upload files
Once Mercury is connected, you only need to upload files when we ask for them in a mission on your Mercury account. This usually happens when:
We need transactions from before your connection's history starts, or for a period the connection missed. We'll ask for a CSV.
We need to confirm your balances, for example during onboarding or at year end. We'll ask for PDF bank statements.
Note: For year-end closing balance reviews, we ask Mercury customers for both the PDF statement and a full-year CSV, so have both ready.
2. Exporting a CSV file of your Mercury transactions
This guide will walk you through downloading a CSV file containing your transaction history for your Mercury account. Source: Mercury's Bulk-export statements, receipts, and CSVs from Mercury Business
What you'll need to export a CSV
Your Mercury account login credentials (Username & Password)
Steps to export a CSV
Log in to your Mercury account using your username and password.
Once logged in, click your organization name in the top-left corner of your dashboard and select Documents & Data.
Under Statements, you'll see two dropdowns:
Year: Select the year for which you want to download the transaction history.
Accounts: Choose the specific Mercury account for which you want the CSV file. Remember to select only one account at a time.
Locate the most recent statement available for the chosen year and account. You'll see three dots (...) on the right side of the statement.
Click on the three dots (...) and select QuickBooks CSV. Your CSV file will be downloaded and saved to your device.
① Year, ② Accounts, ③ QuickBooks CSV.
Head over to your mission in Banks & Cards → Accounts overview and upload your CSV file, following the steps in "Uploading your CSV or PDF to Finaloop".
Export transactions for a specific date range
If your mission asks for specific dates, you can export them from the Transactions page in Mercury instead:
Go to the Transactions page.
Click Export all, or apply filters for the dates and account your mission asks for and click Export filtered.
Choose .csv as the format and click Download.
3. Exporting a bank statement (PDF) from your Mercury account
As part of our onboarding and year-end reviews, we may ask for bank statements to confirm your bank balances and keep your books accurate. Mercury creates a monthly statement for each account between the 1st and 3rd of the following month. Source: Mercury's Downloading monthly statements
What you'll need to download a statement
Your Mercury account login credentials (Username & Password)
Steps to download a statement
Log in to your Mercury account using your username and password.
Click your organization name in the top-left corner of your dashboard and select Documents & Data. You can also open a specific account and click View Statements.
Under Statements, select the year and the account your mission asks for.
Hover over the month your mission asks for and click Download PDF to save the statement to your device. To download several months at once, select them and click Download.
Head over to your mission in Banks & Cards → Accounts overview and upload your PDF file, following the steps in "Uploading your CSV or PDF to Finaloop".
If we ask for the current month, click Generate a custom statement on the same page, since the monthly statement isn't ready until the following month.
4. Uploading your CSV or PDF to Finaloop
In Banks & Cards → Accounts overview, click Review on your Mercury account (the button shows the number of open requests, for example Review (1)).
Click Review on the request.
Click Upload attachments (for a CSV request) or Upload PDF Statement (for a statement request) and choose your file.
Click Submit.
You'll see Data submitted successfully once your file is on its way to us.
Tip: Upload your CSV in its original format and currency, and avoid converting a PDF into a CSV or altering any data.
Related articles
Need help?
If you have any questions or trouble finding the information you need, feel free to contact us at [email protected]!