Bank Statement Analyzer

Transform your bank statements into clear financial insights — directly inside Microsoft Excel.

Bank Statement Analyzer Pro is a powerful Excel task pane add-in designed to automatically read, categorize, and analyze your bank transactions without ever leaving your spreadsheet. Whether your data is already in Excel or you're pasting it in from your bank's portal, this add-in turns raw transaction rows into actionable financial intelligence in seconds.

Subscription & Pricing

Bank Statement Analyzer offers a free tier with core features available at no cost. Advanced Pro features require an active paid license, purchased directly within the add-in using USDT (a USD-pegged cryptocurrency) sent to the provided wallet address.

Available subscription plans:

Monthly — $5 USDT / 30 days

3-Month — $12 USDT / 90 days

6-Month — $20 USDT / 180 days

1-Year — $35 USDT / 365 days

Licenses are activated automatically after payment is verified on-chain. No account registration is required. Subscriptions do not auto-renew; users must manually renew before expiry to maintain Pro access. Payments are made in USDT on the Tron network (buyer's choice). All payments are non-refundable once the license key has been issued.

With Free features (no license required):

a. Analyze transactions in your active Excel sheet

b. Auto-categorize transactions across 14 categories

c. Get Monthly trend charts

d. Get Financial Health Score

e. Search & filter transactions

With Pro features (paid license required):

a. Export full HTML summary reports by email

b. Write Transaction notes (attach memos up to 140 characters per row)

c. Transaction flagging (mark rows for review, filter flagged items, export with flag column)

d. Manual re-categorization with instant dashboard updates

e. Excel sheet color-highlighting by category

f. Priority feature access for future updates

Who is this for?

1. Freelancers & self-employed professionals who need to track income and expenses across multiple clients or projects.

2. Small business owners who want a fast way to review monthly cash flow without expensive accounting software.

3. Accountants & bookkeepers who regularly process client bank statements and need to categorize transactions quickly.

4. Personal finance enthusiasts who want deeper insight into their spending habits directly from their bank exports.

5. Excel power users who prefer to keep their financial data in spreadsheets rather than third-party cloud platforms.

What it does:

1. Analyzes your active Excel sheet — detects transaction columns automatically and reads your data in place.

2. Paste CSV or text — import directly from your bank's online portal without any file conversion.

3. Auto-categorizes transactions across 14 categories including Salary, Rent, Utilities, Food & Dining, Transport, Healthcare, Subscriptions, and more.

4. Generates a Financial Health Score — a clear at-a-glance rating based on your income, expenses, and spending patterns.

5. Monthly trend charts — visualize your spending and income month by month with built-in recharts-powered graphs.

6. Highlights transactions in your Excel sheet by category using color coding for quick visual scanning.

7. Search & filter — find specific transactions or filter by category, date, or amount.

8. Export summary reports — generate and email a full HTML financial report directly from the add-in (Pro).

9. Pro license system — unlocks advanced features with a USDT crypto payment.

10. Split Debit/Credit column support — automatically detects bank statements with separate Debit and Credit columns (Date | Description | Category | Debit | Credit | Balance), in addition to the existing single Amount column format.

11. Pre-assigned category import — if your CSV/Excel data has a Category column, those categories are used as-is; unrecognized or blank values fall back to auto-detection.

12. Manual re-categorization — tap any category badge in the Transactions tab to reassign it from all 14 categories; changes instantly update the full dashboard (Pro).

13. Transaction notes — attach a short memo (up to 140 characters) to any transaction; notes appear in CSV exports as a dedicated column and in email reports as an italic line under the description (Pro).

14. Transaction flagging — tap the flag icon on any row to mark it for review; flagged rows are visually highlighted in red, filterable with a dedicated toggle, and exported with a "Flagged?" column in CSV and a flag badge in reports (Pro).

Why choose Bank Statement Analyzer?

Unlike browser-based financial tools, your data stays inside Excel on your machine — it is never uploaded to a third-party server. The add-in works alongside your existing workflow, meaning you keep full control of your data while gaining the power of automated analysis. With support for Excel Desktop and Excel Online, it's accessible wherever you work.