How to Import Transactions into Money Pro via CSV

1. Download Your CSV From Your Bank

Go to your bank's online portal → Transactions → look for a Download or Export option. Most banks let you export as CSV. If you only see Excel, save as CSV in Excel or Google Sheets.

Choose a date range that matches the transactions you need to import, such as the current tax year or the period before you connected the account to Money Pro. Avoid downloading a date range that's already synced into Money Pro through Plaid unless you're prepared to delete duplicates.

ZenBusiness also provides a Money Pro Expenses Template if you prefer to build a CSV from scratch.

1a. Common Bank Download Starting Points

Bank websites change often, so exact labels may vary. In general, sign in from a browser, choose the account, open account activity or transactions, choose a date range, then look for Download, Export, or Download Account Activity.

2. Prepare Your CSV

Ensure your CSV has:
- Date column in MM/DD/YYYY or MM/DD/YY format (e.g., 01/15/2025)
- Vendor/Description column
- Amount column — if your bank uses separate Debit/Credit columns, note this for the import step
- Remove extra header rows or empty columns that could confuse the importer

If you downloaded transactions from a personal or mixed-use account, open the file in Google Sheets or Excel before importing. Add a column called Business?, mark the rows that are valid business income or expenses, then filter the sheet to keep only those business rows. Delete the personal rows from the import copy before saving as CSV.

Only import transactions that belong in your business records. If you're not sure whether a transaction is a deductible business expense, ask a tax professional before importing it as a business expense.

3. Import Into Money Pro

1. Go to Expenses or Income page
2. Click the gear icon (top right) → Import Transactions
   
3. Select or create a Manually Tracked Account to assign the imported transactions to (optional but recommended for balance sheet accuracy)
4. Upload your CSV file
5. Click Next
6. Map the columns: use the dropdown menus to match your CSV column headers to Money Pro fields (Date, Vendor/Merchant, Amount)
7. If your CSV has separate Debit and Credit columns, check the "2 columns" checkbox next to Amounts
8. Click Next
9. Review the transaction list — deselect any transactions you don't want to import
10. Click Done to complete the import

A confirmation popup appears when the import is finished. Navigate to the Expenses or Income page to see your imported transactions.

4. Review After Importing

Check for:
- Duplicates — if your bank is also linked via Plaid for the same period, you may have duplicates. Delete duplicates manually.
- Category mapping — imported transactions may need categories assigned. Use the Deduction Finder to bulk-categorize.
- Amount direction — if income and expenses appear reversed, the amount columns may have been mapped incorrectly. Delete the import and try again with the 2-columns option.

Can I undo a CSV import?

No — imports cannot be undone automatically. However, you can delete imported transactions in bulk using Bulk Select on the Expenses page. See How to Delete and Restore Transactions.

My bank exports in XLS (Excel) format, not CSV. What do I do?

Open the file in Excel or Google Sheets and choose File → Save As → CSV format. Then import the CSV into Money Pro.

I imported the same file twice and now have duplicates. How do I fix them?

Use Bulk Select on the Expenses page to select and delete the duplicate transactions. Filter by date range and account to find them. Note: you cannot undo a CSV import, but you can delete individual transactions.

Can I import business expenses from my personal bank account?

Yes, but filter the file before importing. Download the personal account transactions from your bank, open the file in Google Sheets or Excel, mark the business rows, delete the personal rows from the import copy, then export the remaining business-only rows as CSV. Do not import personal spending into Money Pro as business expenses.

Should I connect my personal bank account instead of importing a CSV?

Usually no. If an account has both personal and business activity, importing a filtered CSV gives you more control because personal transactions never enter Money Pro. Connecting a mixed-use personal account can create extra cleanup work because every synced transaction must be reviewed and tagged correctly.

What columns should my filtered CSV include?

Keep Date, Vendor or Description, and Amount. If your bank uses separate Debit and Credit columns, keep both and use the "2 columns" option during Money Pro import. Category is optional; you can categorize transactions in Money Pro after importing.