Product
Balancely’s job is mechanical, not creative: turn a Canadian credit-card or bank PDF into a clean Excel workbook where the totals already match the statement. No regex template per bank, no copy-paste, no manual sign cleanup.
How it works
The whole pipeline runs inside one Vercel function. No queue, no worker farm, no second service for you to operate.
01
Drop up to 6 statements at once. Balancely accepts every Canadian issuer — RBC, TD, Scotia, BMO, CIBC, Canadian Tire — plus American Express, smaller credit unions, and arbitrary formats fall back to the same engine.
02
Files run through the parser in parallel. The engine extracts transactions, period dates, balances, and the issuer’s sign convention.
03
Section totals (payments, returns, charges, interest) are summed and compared to the totals printed on the statement. 2-cent tolerance. Anything off raises an amber flag in your workbook.
04
A three-sheet Excel file: Summary (one row per statement), All Transactions (every txn, sortable), Vendor Summary (top vendors by absolute spend).
The workbook
Same layout whether you uploaded one statement or four. The aggregate view is what your bookkeeper or accountant actually needs.
Sheet
One row per statement. Opening balance, payments, returns, purchases + fees, interest, new balance, minimum payment, reconciled status. Credit-card workbooks render every cell as a negative outflow so summing matches the change in balance.
Sheet
Every transaction across every uploaded PDF, sortable and filterable. Date, type, description, category, amount, FX note. Sign convention enforced after the AI parse so payments are always negative, purchases always positive.
Sheet
Top vendors by absolute spend, with count and sign indicator. Light normalization on description text so "STARBUCKS #4422" and "STARBUCKS #4439" roll up together.
Sheet
Aggregated by your saved vendor → category rules. Tag a vendor once in the preview, every future statement auto-categorizes. % of spend computed against total outflows so you see where the money actually goes.
Sign convention
Pick the document type at upload time. For credit-card statements, every amount lands negative in the workbook so summing the Amount column equals the change in balance. For bank statements, debits and credits keep their usual signs.
The preview tabs in the app render the same signs that will end up in the file — no surprises when you open the .xlsx.
Categorization
Tag a Petro-Canada transaction as Vehicle & Fuel in the preview — every Petro-Canada row on every future statement gets that category automatically. The same rule applies in the workbook, the CSV, and the QuickBooks export.
The 14 default categories are tuned for Canadian freelancers — Meals (50% deductible), Vehicle, Office Supplies, Software & Subscriptions, Professional Services, and ten more. Add your own if the defaults don't fit.
Try it freeSaved rules apply at upload time. Manage them in /dashboard/categories.
Exports
Same parse, three downloads. Categories travel into each format — your bookkeeper sees them in QuickBooks the same way you tagged them in Balancely.
Four-sheet workbook. The default everyone understands. Conditional formatting and frozen panes baked in.
One combined UTF-8 file. RFC 4180 quoting. Works in every spreadsheet, every importer.
OFX 2.x Web Connect. Imports directly into QuickBooks Desktop and Online with categories surfaced in the Memo field.
Free to start. No credit card. Statement AI reconciles to the cent.