Feature

Bank Reconciliation in FreshLedger Pro

Bank reconciliation is where most small-business books go wrong - duplicate entries, missed deposits, and category drift that nobody catches until tax time. FreshLedger Pro's Bank Reconciliation module imports your transactions from a CSV, OFX, QFX, or QBO file downloaded from your bank, then applies your rules to auto-categorize each line into the right ledger account. What the rules can't decide, you match by hand in a clean two-pane view: bank transactions on the left, your general ledger on the right. The result is a real reconciled period - opening balance, cleared items, outstanding checks and deposits, and an ending balance that ties to your bank statement to the penny. If you've ever spent a Saturday hunting a $3.47 discrepancy in QuickBooks, you'll appreciate how directly this works. No bank feed surprises, no silent re-categorizations, no auto-syncing transactions you didn't approve.

Buy FreshLedger Pro — $799

How it works

The workflow has five concrete steps. First, download a transaction file from your bank's website - FreshLedger Pro accepts CSV, OFX, QFX, and QBO formats, which covers essentially every U.S. bank and credit union. There is no automatic bank feed; you control when and what gets imported, which also means no surprise duplicate transactions when a feed reconnects. Second, on import, the rules engine runs each line through your rule list in order. A rule is a simple condition (payee contains, amount equals, amount between, memo contains, or transaction type) plus an action (assign to GL account, split across accounts by percentage or fixed amount, assign a class or job, mark as transfer). Rules can be account-specific or global. Third, anything the rules categorize with high confidence drops into a Proposed batch; anything ambiguous lands in an Unmatched queue. You review the Proposed batch in a single grid - approve all, edit inline, or kick items back to Unmatched. Fourth, for unmatched items, the manual matcher shows likely candidates from open invoices, bills, and uncleared journal entries based on amount and date proximity. You click to match, or you create a new entry on the spot - a deposit, an expense, a transfer between accounts, or a split transaction across multiple GL accounts (useful for credit-card payments that cover several expense categories, or for owner draws mixed with reimbursable expenses). Fifth, you run Reconcile: enter the statement ending balance and statement date, check off cleared items, and FreshLedger Pro shows the running difference. When the difference hits zero, you post the reconciliation, which locks those cleared transactions against accidental edits. A reconciliation report prints with cleared totals, outstanding checks list, outstanding deposits list, and a beginning-to-ending balance proof. If a prior-period transaction is later edited, the affected reconciliation is flagged so you know to re-verify.

Why it matters

Bank reconciliation isn't optional bookkeeping hygiene - it's the control that makes every other number in your books trustworthy. Your Schedule C gross receipts, your Form 1120-S distributions, your Form 941 wage totals, and your sales tax remittances all roll up from the general ledger. If the GL doesn't tie to the bank, none of those filings are defensible in an audit. The IRS expects taxpayers to maintain books and records sufficient to substantiate income and deductions (IRC Section 6001 and the regulations under it), and in practice the first thing an examiner asks for is bank statements alongside the GL. A clean monthly reconciliation produces exactly that evidence trail. Auto-categorization matters because consistency matters: the same vendor should hit the same expense account every time, so your Schedule C line 22 (supplies), line 24a (travel), and line 24b (meals - still 50% deductible for most meals under current rules) reflect real category totals rather than guesses. Rules also prevent the classic mistake of expensing a fixed-asset purchase that should have been capitalized and depreciated under MACRS - if your rule routes purchases from a specific vendor (say, an equipment dealer) to a Fixed Assets account rather than Supplies Expense, you catch it at import instead of at year-end. Finally, locking reconciled periods protects prior-year tax returns from silent restatement, which is the failure mode behind most amended-return nightmares.

Compared to other accounting software

QuickBooks Online relies heavily on its bank feed and a machine-learning categorizer that improves with use, but rule customization is shallow - rules trigger on description, amount, or bank text, and split rules are limited. QBO's auto-add behavior has also been known to post transactions before you've reviewed them, which creates cleanup work. QuickBooks Desktop has stronger rules and a more transparent reconciliation window similar to FreshLedger Pro's, but Intuit is sunsetting Desktop subscriptions for new U.S. users and pushing everyone to QBO. Xero has clean bank-rule UX and good split support, but you're paying a monthly subscription indefinitely, and Xero's bank feeds in the U.S. have historically been less reliable than in other markets. Wave is free but limited - rules are basic, and there's no concept of locking a reconciled period, so prior months can drift. FreshLedger Pro's trade-off is explicit: you give up automatic bank feeds, and in exchange you get unlimited, ordered, condition-rich rules (including multi-line splits and class/job assignment), a desktop reconciliation flow that locks closed periods, and a one-time $799 license instead of a perpetual subscription. If your bank's website lets you download an OFX or QBO file, the manual import takes about ninety seconds per account per month.

Honest limitations

Honest list: FreshLedger Pro does not connect to bank feeds - you import files manually each period. It is Windows-only; macOS users run it in Parallels, VMware Fusion, or UTM. The company file is single-user at a time, so two people cannot reconcile different accounts in the same file simultaneously over a network. The rules engine does not use machine learning - it does exactly what your written rules say, no more and no less, which is a feature for auditability but means you build your rule list yourself. Foreign-currency bank accounts are supported for import but FX gain/loss journal entries on reconciliation are not automated; you post those manually. There is no mobile receipt-capture app that feeds transactions into reconciliation.

Ready to own your books?

One-time-purchase accounting software with built-in payroll, full depreciation handling, and a free Accountant Edition for your CPA.

Buy FreshLedger Pro — $799

One-time purchase. No subscription. Free Accountant Edition included.

Frequently asked questions

Can FreshLedger Pro connect directly to my bank like QuickBooks does?
No. FreshLedger Pro does not offer live bank feeds. You log into your bank's website, download a CSV, OFX, QFX, or QBO file for the period, and import it. This is a deliberate design choice - bank feeds break often, post duplicates after reconnects, and can silently change historical data. Manual import takes roughly a minute per account per month for most small businesses, and you always know exactly what came in. If real-time feeds are a hard requirement, QuickBooks Online or Xero will fit you better than FreshLedger Pro will.
How customizable are the auto-categorization rules?
Rules combine conditions (payee contains, memo contains, amount equals, amount between, transaction type, bank account) with actions (assign one GL account, split across multiple GL accounts by percentage or fixed amount, assign a class or job code, flag as transfer between accounts, mark for review). Rules run in the order you set, and you can scope a rule to a single bank account or apply it globally. There is no limit on the number of rules. The engine is deterministic - it does not learn or change behavior on its own, which makes audit trails clean.
What happens if I edit a transaction after the period is reconciled?
Reconciled transactions are locked against casual edits. To change one, you must explicitly unlock the reconciliation, which is logged. If an amount or date change affects a previously reconciled period, that reconciliation is flagged as broken on the Reconciliation History report so you know to re-verify the ending balance. This protects prior-period numbers that have already flowed into filed tax returns (Form 1120, 1120-S, 1065, or Schedule C) and prevents the silent restatement problem common in cloud tools.
Can I split one bank transaction across multiple expense accounts?
Yes. Splits are first-class in both the rules engine and the manual matcher. A typical use case is a credit-card payment that covers fuel, meals, and office supplies in one withdrawal - you split the single bank line into three GL postings with the correct amounts. You can also build a rule that auto-splits a recurring transaction by fixed percentages, useful for things like a utility bill where a known share is personal-use add-back or a home-office allocation feeding Form 8829.
Does FreshLedger Pro cost a monthly subscription?
No. FreshLedger Pro is a one-time purchase of $799 for the Windows desktop license. The only recurring cost is optional: $99 per year for updated payroll tax tables, which you only need if you run payroll in FreshLedger Pro and want current federal and state withholding tables, current Form 941 line references, and current W-2 and 1099-NEC layouts. If you don't run payroll, you never need the annual update. Reconciliation, rules, and core accounting features keep working on the version you bought without any subscription.