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
- Go to Expenses or Income page
- Click the gear icon (top right) → Import Transactions
- Select or create a Manually Tracked Account to assign the imported transactions to (optional but recommended for balance sheet accuracy)
- Upload your CSV file
- Click Next
- Map the columns: use the dropdown menus to match your CSV column headers to Money Pro fields (Date, Vendor/Merchant, Amount)
- If your CSV has separate Debit and Credit columns, check the "2 columns" checkbox next to Amounts
- Click Next
- Review the transaction list — deselect any transactions you don't want to import
- 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.
Related Articles
- How to Connect Your Bank Account to Money Pro
- How to Track Expenses
- How to Delete and Restore Transactions
Still need help? Call (844) 493-6249 or email support@zenbusiness.com.
