Skip to main content

Shopify Balance - Uploading your transactions & bank statements (CSV or PDF) to Finaloop

Connect Shopify Balance to Finaloop Accounting and, when we ask, export a CSV of your transactions or a monthly statement from Shopify and upload it, so your Shopify Balance accounts stay accurate in your books.

Written by Emily Burrows

About

Applies to: Finaloop Accounting

Finaloop Accounting, Finaloop's real-time bookkeeping and accounting service, imports your Shopify Balance activity automatically once you connect Shopify Balance as a bank account, and you can export a CSV of your transactions or a monthly statement from Shopify 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 Shopify Balance, how to find the relevant reports in your Shopify Balance accounts, and how to upload them to Finaloop.

1. Connect Shopify Balance to Finaloop

Shopify Balance connects to Finaloop automatically through Plaid, a secure service that links bank accounts, so your transactions flow into your books without uploads. If Shopify Balance isn't connected yet, follow these steps:

  1. Go to Settings → Banks & Credit Cards.

  2. Click Connect banks and cards.

  3. In Select institution, search for Shopify Balance and select Shopify Balance powered by Evolve Bank.

  4. Follow the on-screen instructions to sign in to Shopify and choose your accounts.

Your Shopify Balance accounts then appear in Banks & Cards → Accounts overview.

When we ask you to upload files

Once Shopify Balance is connected, you only need to upload files when we ask for them in a mission on your Shopify Balance 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 monthly statements.

2. Check that you have permission to export from Shopify Balance

The store owner can view and download Shopify Balance statements. Staff can export transactions as a CSV once the owner grants them the View Balance account activity permission, while statements stay with the owner. Source: Shopify's Viewing or exporting your Shopify Balance account details

If you can't see the Shopify Balance pages or export your transactions, the owner can grant the permission in Shopify. Here's what they should do:

  1. Go to Settings → Users.

  2. Click on your staff account.

  3. In the Permissions section, select View Balance account activity.

  4. Click Save.

If we ask for a statement and you're not the owner, ask the owner to download it for you, following the steps in "Exporting a bank statement from your Shopify Balance account".

3. Exporting a CSV file of your Shopify Balance transactions

This guide will walk you through downloading a CSV file containing your transaction history for your Shopify Balance account.

What you'll need to export a CSV

  • Your Shopify account login credentials (Username & Password)

Steps to export a CSV

  1. Log in to your Shopify account using your username and password.

  2. Go to Finance → Balance.

  3. In the Accounts section, click the relevant account.

    Shopify Balance page with the Main account card outlined in the Accounts section.

  4. Click the Export icon (an arrow pointing up) at the top right of the Transactions section.

    Shopify Balance Main account page with the Export icon outlined at the top right of the Transactions section.

  5. Choose the month relevant to your mission and click Export as CSV. This will save the CSV file to your device. If your export has over 100 transactions, Shopify sends it to you by email instead.

    Shopify Export transactions window with October ticked and the Export as CSV button outlined.

    ① The month you need, ② Export as CSV.
    ​

  6. 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".

4. Exporting a bank statement from your Shopify Balance account

As part of our onboarding and year-end reviews, we may ask for statements to confirm your balances and keep your books accurate. Only the store owner can view Shopify Balance statements.

What you'll need to download a statement

  • Your Shopify account login credentials (Username & Password), as the store owner

Steps to download a statement

  1. Log in to your Shopify account using your username and password.

  2. Go to Finance → Balance.

  3. In the Accounts section, click your Main account.

  4. Click View statements at the top right of the page.

    Shopify Balance Main account page header with the View statements button outlined.

  5. Click the statement of the month relevant to your mission. The statement opens in a new tab, where you can save it to your device as a PDF.

  6. Head over to your mission in Banks & Cards → Accounts overview and upload your PDF statement, following the steps in "Uploading your CSV or PDF to Finaloop".

5. Uploading your CSV or PDF to Finaloop

  1. In Banks & Cards → Accounts overview, click Review on your Shopify Balance account (the button shows the number of open requests, for example Review (1)).

  2. Click Review on the request.

  3. Click Upload attachments (for a CSV request) or Upload PDF Statement (for a statement request) and choose your file.

  4. 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]!

Did this answer your question?