A bank connection can be green while transactions are missing, and a report can be internally correct while differing from another system because its period, accounting method, currency, status, or cutoff is different. FreshBooks bank reconciliation joins imported bank transactions to expenses, invoice payments, bill payments, other income, credits, transfers, owner equity, journal entries, processor deposits, and fees. Each object follows a different business story that a generic match button cannot explain.
FreshBooks' current help content places Bank Reconciliation and several accounting reports on trials and Plus, Premium, and Select plans. Connections can vary by country and aggregation partner, reports commonly run one currency at a time, and import support differs by data object. Connected apps may be disconnected in FreshBooks or within the integration itself. A supportable workflow therefore records plan, country, partner, application, ownership, source of truth, and recovery route.
This guide gives Georgia CPA, bookkeeping, advisory, and finance teams an evidence-first operating model for bank feeds, reconciliation, accounting reports, CSV import and export, apps, financial lock, troubleshooting, and recovery. ALLMSP can coordinate access, endpoints, protected evidence, integration ownership, and vendor cases; the accountant or authorized financial owner decides classification, adjustments, closing, tax treatment, and whether the books are ready.
Key decisions at a glance
- Confirm current plan and supported bank-connection partner, establish the correct account and opening balance, and preserve a statement-backed baseline before matching transactions.
- Reconcile imported bank transactions to FreshBooks entries using the appropriate match or classification, and treat online-payment deposits, fees, refunds, payroll, and journal entries as evidence-specific cases.
- Define report period, accounting method, currency, account scope, status, and cutoff before comparing a FreshBooks report to another ledger or export.
- Validate CSV imports and exports by object, field, date, currency, duplicate behavior, unsupported data, totals, and retention; an export is not a complete application restore image.
- Inventory connected apps and bank feeds, troubleshoot from the last known good boundary, avoid premature disconnection, protect against duplicate reimports, and reconcile every repair.
Establish the Bank Account, Opening Balance, and Import Boundary
Inventory every cash, credit-card, payment-clearing, payroll, and other account that enters the workflow. Record the legal owner, currency, statement period, FreshBooks Chart of Accounts mapping, connection or manual-import method, supported country and bank partner, credential owner, multi-factor requirement, import history available, last successful date, reconciliation owner, and support path. Bank Reconciliation is plan-dependent, so confirm the current account before designing a process around a menu that may not be available.
Set the reconciliation start date and opening balance from authoritative statements and prior books. FreshBooks bank reconciliation compares Bank Account Balance to FreshBooks Balance and can use a direct bank connection or a manually created account with uploaded CSV transactions. Preserve the statement, calculation, approval, date, and currency used for the opening position. A wrong opening balance can make every later match look suspicious even when individual transactions are correct.
Define the import boundary. FreshBooks' general import guidance describes CSV support for clients, expenses, items, bank-reconciliation transactions, and other specific data or assisted transfer paths, not an unrestricted restore of every object. Connected banks may import only a defined historical range, and partner behavior varies. Run a sample, compare earliest and latest transaction dates, accounts, pending or posted treatment, duplicate behavior, signs, currencies, and total counts, then approve expansion.
- Confirm the plan, business country, bank-connection partner, account ownership, currency, and financial period before configuration.
- Keep bank credentials and verification codes out of FreshBooks notes, spreadsheets, screenshots, tickets, and shared runbooks.
- Preserve the approved opening balance and start date with statement evidence in protected accounting records.
- Validate a CSV's encoding, headers, date format, amount sign, currency, account mapping, duplicates, and unsupported fields before import.
- Assign one person to monitor the last imported transaction and another to review reconciliation exceptions on a defined cadence.
Match Transactions From Business Evidence, Not Convenience
Reconcile regularly enough to find gaps while source evidence is available. FreshBooks allows imported bank transactions to be matched to FreshBooks entries or marked as transfers, owner equity, expense refunds, and other supported classifications. Review suggested matches rather than accepting them in bulk by appearance. Compare amount, date, account, payee or client context, invoice, expense, bill, payment, refund, and supporting documentation, then preserve why the match or classification is correct.
Handle processor deposits and fees as composite evidence. A net bank deposit may represent several online payments minus processing fees and can require the workflow documented for the configured processor. Refunds, bill payments, payroll apps, manual journal entries, credits, and missing expenses also have specific treatments in FreshBooks' simple and complex reconciliation guidance. Use the current article for the transaction type and do not force a one-to-one match merely to eliminate an unmatched row.
Investigate a balance difference with a timeline. Compare the actual bank balance and last posted transaction, FreshBooks imported boundary, opening balance, unmatched bank transactions, unmatched FreshBooks entries, manual accounts, journal entries, transfers, deleted or duplicate expenses, processor payouts, and changes after the period. The Bank Reconciliation Summary report can list unmatched items across accounts on eligible plans. Correct the proven source and recheck the complete period instead of inserting an unexplained adjustment.
- Require review for likely matches involving identical amounts, repeated vendors, split transactions, batch deposits, refunds, and transfers.
- Separate bank posting date, processor event date, FreshBooks entry date, invoice date, and accounting period in the investigation.
- Reconcile gross payments, processing fees, net deposits, refunds, disputes, and payout timing according to the active processor evidence.
- Document manual journal entries and account classifications with accountant approval and retain the business explanation.
- Close an exception only when the bank, FreshBooks entries, related documents, and applicable reports agree or have explained timing differences.
Control Reports, Imports, Exports, and Financial Lock
Create a report dictionary for every formal review. Record the FreshBooks report, business, date range or as-of date, accounting method, currency, filters, statuses, account scope, fiscal year, run time, owner, exported filename convention, and comparison source. FreshBooks says reports are generally run one currency at a time; specific reports and accounting features can be plan-dependent. A Trial Balance is an accrual snapshot as of a date, while a General Ledger explains period movement. Use each report for its documented purpose.
Validate imports and exports at the object level. FreshBooks offers CSV or PDF paths across clients, expenses, invoices, items and services, vendors, Chart of Accounts, reports, and other supported areas, but coverage and fields differ. The Chart of Accounts can be exported; current FreshBooks guidance says an existing chart cannot be imported directly, while eligible Advanced Accounting users or invited accountants can customize it. Preserve record counts, totals, currencies, archived and deleted behavior, attachments, unsupported fields, and post-import exceptions.
Use Financial Lock after authorized review, not as a substitute for reconciliation. Current FreshBooks guidance says the owner and Accountant – Full Access can set a past lock date, restricting changes to invoices, payments, expenses, journal entries, other income, and other documented objects for the locked period. Record approval, lock date, reports, open exceptions, and who may unlock. Export relevant reports before and after close, while acknowledging that exports support comparison and continuity rather than recreating every FreshBooks relationship and setting.
- Version report definitions and preserve filters, currency, accounting method, status, cutoff, and as-of context with each export.
- Test a small import for every object and reject rows with unknown owners, currencies, dates, identifiers, or duplicate behavior.
- Reconcile imported totals to the source and to FreshBooks reports, then sample individual records, links, tax, and archive state.
- Protect exports as financial and client records with approved storage, access, encryption, retention, and disposal controls.
- Require accountant or owner approval before setting or changing Financial Lock and record any later unlock and adjustment.
Troubleshoot Connections and Apps From the Last Known Good Boundary
Maintain an integration register for bank connections, payment processors, payroll, expense tools, CRM, time systems, importers, automation, and other FreshBooks apps. Record the business purpose, owner, vendor, FreshBooks role, source and destination objects, direction, frequency, credentials or authorization owner, country and plan dependency, alerts, renewal, last success, reconciliation, and retirement. FreshBooks lets eligible users disconnect an app from Connected Apps, and some integrations can also be disconnected from their own system; both sides require review.
When a bank feed stalls, identify the connection partner and follow its current FreshBooks troubleshooting article. For the documented Yodlee flow, FreshBooks describes viewing the issue, refreshing, verifying changed login information, completing bank verification, allowing processing time, and contacting Support if imports remain absent. It warns that disconnection should be a last resort because it can disrupt reconciliation, and re-adding a bank can import duplicate expenses. Preserve the last imported date and duplicates baseline before acting.
Recover with the smallest supported change: correct verification, refresh, reauthorize an app, repair a mapping, import a controlled missing range, remove a proven duplicate, or escalate with sanitized evidence. Before disconnecting or reimporting, export relevant reports and lists, preserve the bank statement and exception set, and define how to detect repeated entries. After repair, reconcile the bank, expenses, payments, payouts, Chart of Accounts, Trial Balance, General Ledger, and period reports. Record the cause, action, side effects, and current owner.
- Capture the plan, country, partner, account, connection status, last successful import, affected range, error wording, and recent changes.
- Never include bank credentials, verification answers, one-time codes, payment data, client details, or full statements in an ordinary support ticket.
- Check the bank and FreshBooks before retrying so a delayed transaction is not reintroduced as a duplicate expense or payment.
- Disconnect only after reviewing reporting and reconciliation impact, export evidence, reauthorization, duplicate controls, and the vendor's supported path.
- Close with matched balances, explained exceptions, validated reports, monitored next import, assigned ownership, and updated runbook steps.
Vendor documentation and ALLMSP resources
- FreshBooks: Bank reconciliation
- FreshBooks: Set up bank reconciliation
- FreshBooks: Reconcile simple transactions
- FreshBooks: Reconcile complex transactions
- FreshBooks: Bank Reconciliation Summary
- FreshBooks: Troubleshoot a Yodlee bank connection
- FreshBooks: Import data
- FreshBooks: Export data
- FreshBooks: Export reports
- FreshBooks: Chart of Accounts
- FreshBooks: Trial Balance report
- FreshBooks: Financial lock
- FreshBooks: Apps
- ALLMSP FreshBooks Software Support
- ALLMSP Software Support
- ALLMSP Managed IT Services
- ALLMSP Cybersecurity Services
- ALLMSP Cloud Computing and Migrations
- ALLMSP CPA and Financial Firm Resources
- Contact ALLMSP
Frequently Asked Questions
Which FreshBooks plans include bank reconciliation?
Current FreshBooks help says Bank Reconciliation and related accounting features are available on trials and Plus, Premium, and Select plans. Confirm the active subscription and country before designing roles, procedures, reports, or integrations around those menus.
Can FreshBooks bank reconciliation use a CSV instead of a connection?
Yes. FreshBooks documents reconciliation through a direct bank connection or a manually created bank account with uploaded CSV transactions. Validate opening balance, date range, currency, signs, duplicates, account mapping, and totals before importing the full period.
How should the opening balance for FreshBooks bank reconciliation be set?
Use authoritative bank statements and prior books to select the start date and opening balance, preserve the calculation and approval, and verify the first imported boundary. An incorrect opening position can make correctly matched later transactions appear out of balance.
Should FreshBooks likely matches be accepted automatically?
Review each suggested match against amount, date, account, source document, payee or client context, invoice, payment, expense, bill, refund, and supporting evidence. Repeated amounts, batch deposits, split transactions, transfers, and refunds deserve additional scrutiny.
How are online payment deposits and fees reconciled in FreshBooks?
Use the FreshBooks complex-transaction guidance and the configured processor's evidence to connect gross client payments, processing fees, refunds or disputes, and net bank deposits. Compare event and posting dates and avoid forcing a one-to-one match when the deposit is a batch.
Why can two FreshBooks reports show different totals?
Differences can reflect business, period or as-of date, accounting method, currency, status, account scope, fiscal year, filters, cutoffs, unmatched entries, or later edits. Record the report definition and drill into supporting transactions before posting an adjustment.
Can a Chart of Accounts be imported into FreshBooks?
Current FreshBooks guidance says an existing Chart of Accounts cannot be imported directly. The chart can be exported, and eligible Advanced Accounting users or invited accountants can customize accounts. Verify the current plan and map each account under accounting supervision.
Are FreshBooks CSV and PDF exports a complete backup?
No. Exports can preserve supported lists, reports, and documents for evidence and continuity, but they do not recreate every relationship, setting, permission, app authorization, payment state, or platform behavior. Maintain protected exports and a documented support-based recovery plan.
What should happen before disconnecting a FreshBooks bank connection?
Identify the partner and issue, refresh or verify through the documented path, preserve the last imported boundary and reports, contact Support when appropriate, assess reconciliation impact, and prepare duplicate controls. FreshBooks warns that reconnecting can import duplicate expenses.
How can ALLMSP support FreshBooks accounting operations in Georgia?
ALLMSP can inventory connections, protect endpoints and exports, document imports, collect sanitized evidence, coordinate bank and app troubleshooting, monitor ownership, and support recovery while the firm's accountant controls classifications, adjustments, reconciliation, reports, closing, and tax decisions.
