How to Upload Your Bank Statement to CashFlowSmart: A Step-by-Step Guide

Uploading your first bank statement is the single action that transforms CashFlowSmart from an empty dashboard into a live financial intelligence tool. Most contractors complete this step in under 15 minutes. Here is exactly how to do it.

Step 1 — Export Your Bank Statement as a CSV

CSV (comma-separated values) is the preferred format because it gives CashFlowSmart the cleanest data to work with. Every major US bank supports CSV export. Here is how to find it in the most common banks used by contractors:

Chase Business: Log in → Accounts → select your checking account → Download Account Activity → set date range → select CSV format → Download.

Bank of America Business: Log in → Accounts → Activity → Download → select date range → choose CSV (Microsoft Excel) format → Download.

Wells Fargo Business: Log in → Accounts → select account → Download Account Activity → choose date range → select Comma Separated Values (.csv) → Download.

US Bank: Log in → Accounts → select account → Export → choose date range → select CSV → Export.

Regions, Truist, Fifth Third, and most regional banks follow the same pattern: find the transaction history view, look for a Download or Export button, and select CSV or Excel format. If you cannot find it, search your bank's help center for "export transactions CSV."

Step 2 — Upload the CSV to CashFlowSmart

Log in to your CashFlowSmart dashboard and navigate to the Transactions page. Click the Upload Statement button in the top right corner. Drag your CSV file into the upload area or click to browse. The system will parse the file and show you a preview of the transactions it found before importing anything.

The preview shows the date, description, and amount for each transaction, along with the category the system has automatically assigned based on keyword matching. Review the first 10–15 rows to confirm the data looks correct. If the dates or amounts look wrong, it usually means the CSV has a non-standard column order — contact support and we will add your bank's format to the parser.

What Happens During Import

When you confirm the import, CashFlowSmart processes each transaction in sequence. For each row, it first checks whether a transaction with the same date, amount, and description fingerprint already exists in the database — this prevents duplicates if you upload overlapping date ranges. It then applies your vendor rules to assign a category. Any transaction that does not match a vendor rule goes to the AI categorizer, which uses the description text to assign the most likely category. Transactions that the AI is uncertain about are flagged for your review.

The entire import process for a 90-day statement (typically 400–600 transactions) takes under 60 seconds. When it completes, your Monday Morning Truth Card updates immediately with the new data.

Reviewing and Correcting Categories

After import, navigate to Transactions and filter by "Uncategorized" to see any rows that need manual review. For each one, select the correct category from the dropdown. If the same vendor appears multiple times with the wrong category, use the "Create vendor rule" option to fix all future transactions from that vendor automatically — you will never have to categorize that vendor again.

Plan for about 15–20 minutes of review after your first import. Subsequent monthly uploads typically require less than 5 minutes of review because your vendor rules handle the recurring transactions automatically.