Skip to main content

Uploading bank statements and CSVs

Upload the CSV transaction files and PDF statements Finaloop asks for on Banks & Cards, and find the export guide for your bank so your accounts stay reconciled.

Written by Emily Burrows

About

Applies to: Finaloop Accounting, Margins

Upload a CSV of your transactions or a PDF bank statement when Finaloop asks for one, so every bank and card account in your books is complete and reconciled. You only upload when there's a task waiting for you: Finaloop pulls everything else from your connected accounts.

Finaloop asks for files in three situations:

  • Your bank doesn't support a direct connection, so the account is kept up to date from monthly uploads (a manually managed account).

  • Your bank shares only part of your history, so older transactions are missing.

  • Finaloop needs a statement to confirm a balance, for example when you close an account or at year end.

Your bank connection is secure. Finaloop uses bank-level encryption and never stores your bank login. Access is read-only: Finaloop can see your transactions to keep your books, but it can't move money, make changes to your account or bill you with this data.


1. Upload a file Finaloop asked for

Requests for files are tasks called missions. In Finaloop Accounting, you'll find them on the Banks & Cards page.

  1. In Banks & Cards → Accounts overview, click Review on the account. The button shows how many tasks are open, for example Review (1).

  2. Click Review on the task. It lists the account and the exact dates Finaloop needs.

  3. Download the file from your bank for those dates. The guide for your bank, listed under Export guides by bank, shows where to find it.

  4. Click Upload attachments for a CSV, or Upload PDF Statement for statements, and choose your files. You can add more than one file.

    Upload Missing Transactions panel with the dates, the Upload attachments button and Submit highlighted.

    ① Requested dates, ② Upload attachments, ③ Submit.
    ​

  5. Click Submit.

You'll see "Data submitted successfully", and the task moves to processing while Finaloop adds the transactions to your books.

Nothing happened in that period? Select No transactions occurred during this period (or No statements available on a statement task), click Submit, then confirm with Yes, I'm sure.

In Margins: In Margins, there's no Banks & Cards page. Upload tasks for accounts without a direct connection, such as Payoneer or Apple Card, appear in Finish setup, your setup checklist.


2. What Finaloop can ask for

Task

What to upload

Fill Your Account With Transactions

A CSV of all transactions for a new manually managed account, for the dates shown.

Upload Missing Transactions

A CSV for the dates shown. For a manually managed account, this is the monthly update, sometimes with a PDF statement for the last month.

Upload Historical Transactions

A CSV of older transactions your bank didn't share through the connection.

Upload Monthly Statements

One PDF statement for each month shown.

Confirm Closing Balances (year)

Your year-end balance, with PDF statements when Finaloop needs them.

Close your account

The last PDF statement showing a zero balance, and a CSV if transactions are missing.

Transaction files are CSV, XLS or XLSX, and each transaction needs a date, a description and an amount. Statements are PDF only.

Upload files exactly as your bank exports them, in the original format and currency. Don't convert a PDF statement into a CSV or edit the data: changed files can fail to reconcile.

If a CSV is missing the date, description or amount column, you'll see Unsupported file format. Click Upload another file to pick a complete export. Continue anyway sends the file as it is, which can take longer to process and may not reconcile your account.


3. Export guides by bank

Each guide shows where to export a CSV and download PDF statements in that bank's website or app.

Bank not listed? Log in to your bank's website, open the account's transaction history and look for an export or download option (CSV or Excel). Statements are usually under Statements or Documents.


Related articles


Need help?

If your bank can't export the dates a task asks for, or a file keeps failing, tell us the account and the dates, and reach out to our Support team through chat or at [email protected].

Did this answer your question?