F FreshBooks

How to import bank transactions on FreshBooks

intermediate 8 min read Updated 2026-03-18
Quick Answer

Import bank transactions in FreshBooks by navigating to Banking > Bank Accounts, selecting your account, and clicking Import Transactions. You can either connect your bank directly or upload CSV/OFX files manually.

Try FreshBooks Full FreshBooks Review

Prerequisites

  • Active FreshBooks account
  • Bank account connected to FreshBooks or CSV/OFX file ready
  • Administrator or owner permissions
  • Recent bank statements or transaction data

Step-by-Step Instructions

1

Access the Banking Section

Log into your FreshBooks account and click on Banking in the left sidebar menu. If you don't see Banking, click on More to expand additional options.
Make sure you're logged in as an admin or owner to access banking features.
2

Select Your Bank Account

In the Banking section, click on Bank Accounts. If you already have a bank account connected, select it from the list. If not, click Connect a Bank Account to add your bank account first.
FreshBooks supports most major banks through secure API connections.
3

Choose Import Method

Once your bank account is selected, you'll see two options:
  • Click Sync Now for automatic import if your bank is connected
  • Click Import Transactions and then Upload File to manually upload CSV or OFX files
Automatic syncing is more convenient but manual uploads give you more control over which transactions to import.
4

Upload Your Transaction File (Manual Method)

If uploading manually, click Choose File and select your CSV or OFX file from your computer. Ensure your file includes columns for Date, Description, and Amount. Click Upload to proceed.
Download a sample CSV template from FreshBooks to ensure your file format matches their requirements.
5

Map Transaction Columns

FreshBooks will display a mapping screen. Match your file columns to FreshBooks fields:
  • Date column → Date
  • Description column → Description
  • Amount column → Amount
  • Reference number → Reference (optional)
Click Continue when mapping is complete.
Double-check that debits and credits are correctly identified to avoid reversed transactions.
6

Review and Select Transactions

Review the list of transactions to be imported. Uncheck any transactions you don't want to import by clicking the checkbox next to each transaction. Verify that dates, amounts, and descriptions are correct.
Import transactions in smaller batches if you have a large number to make review easier.
7

Complete the Import

Click Import Selected Transactions to finalize the import. FreshBooks will process the transactions and add them to your account. You'll see a confirmation message showing how many transactions were successfully imported.
8

Categorize and Match Transactions

After import, go to Banking > Transactions to categorize each transaction. Click on individual transactions to assign them to expense categories, match them to existing invoices, or mark them as transfers between accounts.
Set up banking rules under Banking > Rules to automatically categorize similar transactions in the future.

Common Issues & Troubleshooting

CSV file won't upload or shows format errors

Ensure your CSV file uses comma separators, has headers in the first row, and dates are in MM/DD/YYYY format. Remove any special characters or extra spaces from the file.

Duplicate transactions appearing after import

Go to Banking > Transactions, use the filter to show duplicates, and delete unwanted duplicates. Enable duplicate detection in Banking Settings to prevent future duplicates.

Bank connection fails or won't sync automatically

Try disconnecting and reconnecting your bank account under Banking > Bank Accounts > Account Settings. Clear your browser cache and ensure your bank login credentials are current.

Transaction amounts are showing as negative when they should be positive

Check your column mapping during import - you may need to reverse the debit/credit mapping. You can also manually edit individual transactions after import by clicking on them in the transactions list.

Prices mentioned in this guide are pulled from current plan data and may change. Always verify on the official FreshBooks website before purchasing.
Visit FreshBooks View FreshBooks Pricing