Guides
Working answers to the problems that come up around statement conversion — QuickBooks import rules and their unhelpful error messages, scans and combined statements, and how to evaluate the tools themselves. Written from building the converter and testing against real statements.
How-to
Free account reconciliation template (Excel): GL, balance sheet and clearing accounts
One working paper for any balance sheet account: ledger vs support, aged reconciling items, sign-off, and step-by-step clearing-account reconciliation.
September 18, 2026
How to reconcile a bank statement in QuickBooks Online
Ending balance, ending date, tick to a zero difference — and the causes behind a difference that won't close, with where to look for each.
September 10, 2026
How to upload a bank statement to QuickBooks Online
The Upload from file path step by step, which file types it takes, the limits that make uploads fail, and what to do when the statement only exists as a PDF.
September 10, 2026
SBA Form 413, the personal financial statement: what it asks and where the numbers come from
Who files it, what each section wants, why every figure must share one date, and how lenders check the cash lines against your bank statements.
September 7, 2026
Categorizing bank transactions in QuickBooks Online without creating cleanup
For Review, bank rules, reclassifying in bulk, and what to do when a year of transactions arrives as PDFs instead of a feed.
September 5, 2026
Migrating QuickBooks Desktop to Online: what happens to your bank history
The migration moves the ledger, not the bank feed. Getting a clean cut-off, reconnecting without duplicates, and backfilling the gap from statements.
September 3, 2026
Free bank reconciliation template (Excel), with a worked example
For one bank account: deposits in transit, outstanding checks, a tick-off sheet for the statement, a worked example, and how to trace a difference.
September 1, 2026
Bank statements for an SBA loan: what lenders ask for and why
How many months lenders want, what underwriters read in the statements, why edited files are detected — and how to turn the stack into package numbers.
August 31, 2026
What is a QBO file? Web Connect, explained properly
OFX 1.02 with Intuit tags, the INTU.BID check, and why deterministic FITIDs are the difference between safe re-imports and duplicated books.
August 31, 2026
Convert a credit card statement to Excel or CSV
Convert the PDF, then set the sign convention so charges don't import as deposits, and check the statement's period totals.
August 30, 2026
Bank statement OCR: convert scanned statements to Excel, CSV or QBO
How to convert a scanned bank statement, and why checking against the printed balances matters more than any OCR accuracy figure.
August 29, 2026
Converting a combined checking + savings statement
Statements that carry several accounts in one PDF break most converters. How to get one clean, reconciled file per account.
August 28, 2026
QuickBooks imported every date as 1/1/1970 — the fix
The epoch-date bug is a date-format parse failure. What triggers it, how to repair a CSV that does, and how to spot the wrong-month variant before it posts.
August 28, 2026
QuickBooks CSV import errors, and the rules behind them
The column layouts QuickBooks accepts, the row and size limits it enforces, and the formatting rules whose error messages don't name them.
August 27, 2026
Import bank statements older than 90 days into QuickBooks Online
The bank feed stops at 90 days; the client is years behind. The full path from old PDF statements to imported, reconciled transactions.
August 26, 2026
Comparisons
How to cancel DocuClipper (credits, auto-renewal, refunds)
Cancel before the renewal date, spend the credits first, keep the confirmation — and what to do if a charge lands after you cancelled.
August 30, 2026
ProperSoft alternatives: ProperConvert on the desktop or a web converter
ProperSoft merged CSV2QBO and its other utilities into one desktop app. When a web converter fits better, when it doesn't, and a fair test.
August 27, 2026
MoneyThumb alternatives: leaving desktop converters behind
Lifetime licenses with a first-year-only PDF add-on, Windows only, per user: what the desktop model costs you and which tools to test instead.
August 26, 2026
How to pick a bank statement converter (a working method)
Every tool claims 99% accuracy. A test you can run yourself in twenty minutes, and the billing and format questions that actually separate the tools.
August 25, 2026
DocuClipper alternatives: what to check before you switch
Why people leave — credits, renewals, per-bank accuracy — and how to evaluate a replacement against the complaints rather than the feature grids.
August 25, 2026