Upload your Chase, Bank of America, or Wells Fargo statement and see your total spending, income, and net cash flow in seconds. No formulas needed — the numbers appear automatically.
Total Transactions
47
Total Spending
$4,218
Total Income
$6,400
Net Cash Flow
+$2,182
Free preview · From $1 to download
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| # | Date | Description | Debit | Credit | Balance | |
| 1 | 1 | 01/06/2026 | UPI-HDFC-John Doe-HDFC001 | 2,500.00 | 47,500.00 | |
| 2 | 2 | 02/06/2026 | NEFT-SALARY-ACME Corp | 65,000.00 | 1,12,500.00 | |
| 3 | 3 | 03/06/2026 | ATM-CASH WITHDRAWAL | 10,000.00 | 1,02,500.00 | |
| 4 | 4 | 05/06/2026 | POS-AMAZON PURCHASE | 3,299.00 | 99,201.00 | |
| 5 | 5 | 07/06/2026 | UPI-SWIGGY-FOOD ORDER | 450.00 | 98,751.00 | |
| 6 | 6 | 10/06/2026 | IMPS-RENT PAYMENT | 15,000.00 | 83,751.00 |
Live editable preview — like Google Sheets, inside your browser
Sum of all debit transactions across the statement period
Sum of all credit transactions — salary, transfers, refunds
Income minus spending — instantly see if you're saving or spending down
Opening balance, closing balance, and running balance per transaction
After downloading your Excel file, here's what to do next:
=SUMIF(D:D,">0")Sum all debit transactions (total spending)
=SUMIF(E:E,">0")Sum all credit transactions (total income)
=COUNTIF(C:C,"*AMAZON*")Count all Amazon purchases
=AVERAGEIF(D:D,">0")Average transaction amount for debits
=MAX(D:D)Find your largest single expense