Skip to main content
ZenBusiness

import-csv

How to Import Transactions into Money Pro via CSV

To import transactions via CSV, go to the Expenses or Income page in Money Pro, click the gear icon → Import Transactions, upload your CSV file, map the columns to Money Pro fields (Date, Vendor, Amount, Category), review the transactions, and click Done. Money Pro does not automatically deduplicate — don't import the same file twice.

When to Use CSV Import

Use CSV import when:
- Your bank isn't supported by Plaid for automatic linking
- You need historical transactions beyond what your bank shares via Plaid
- You're migrating from QuickBooks, Excel, or another bookkeeping tool
- You prefer not to link your bank account directly

If your bank supports Plaid, automatic linking is preferred — it's continuous and requires no manual work.

Step-by-Step: Import Transactions

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.

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

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

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.

Frequently Asked Questions

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.


  • Was this article helpful?