Intermediate
How to import bank transactions on FreshBooks
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.
Prerequisites
- Active FreshBooks account
- Bank account connected to FreshBooks or CSV/OFX file ready
- Administrator or owner permissions
- Recent bank statements or transaction data
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.
Tip
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.
Tip
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
Tip
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.
Tip
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)
Tip
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.
Tip
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.
Tip
Set up banking rules under Banking > Rules to automatically categorize similar transactions in the future.
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.
Ready to get started with FreshBooks?
Put this tutorial into practice. Visit FreshBooks and follow the steps above.
Visit FreshBooks →