Simple Tutorial: Exporting Mercury Transactions to Google Sheets.

Mercury is a popular business banking app in the United States. It offers a range of features to help you manage your business finances, including the ability to export your transactions into a spreadsheet. This can be useful if you want to analyze your transactions in more detail or create custom reports.

Follow these steps to export your Mercury transactions into Google Sheets.

Once you have your transactions in Google Sheets, you can analyze them the way you want. You can create custom reports, track your spending, and even create a budget.

How to Export Mercury Transactions into Google Sheets

Step 1: Log in to your Mercury account

• Go to the Mercury website.
• Enter your login and passcode to log in to your account.
• Click "Sign In."
• Go through the two-factor authentication process if you have it enabled.

Step 2: Navigate to the Transactions Page

• Once you're logged, click on the "Transactions" tab on the left-hand side of the screen.
• Click on the account you want to export transactions from.

Step 3: (Optional) Filter transactions you want to export

• Click on the "Add Filter" button to filter transactions by date range, amount, and many more.
• By default, Mercury will show you all transactions on the account.

Step 4: Find Download Transactions Button

• Once you have the transactions you want to export, click on the "Export All" button on the top right corner of the transactions table.

Step 5: Open the File in Google Sheets

• Open New Google Sheet.
• Click on "File" in the top left corner.
• Select "Import" from the dropdown menu.

Step 6: Upload the File

• Click on "Upload" tab.
• Drag and drop the file you downloaded from Mercury or click on "Browse" button.

• Once the file is uploaded, you will see the transactions in Google Sheets.

Now you can analyze your transactions the way you want. You can create custom reports, track your spending, and even create a budget. Mercury even provides categories for each transaction, account names for employee accounts, negative transactions are debits, and positive transactions are credits.

But what if you want to automate this process?

To automate this process, you can use a tool like OpenBudget. OpenBudget is a personal finance tool that automatically imports your transactions straight into Google Sheets. It's a great way to keep track of your finances without having to manually download and import your transactions.

It also has other useful features like automatically categorizing your transactions, so you can easily create custom reports and track your spending without having to do unnecessary manual work.