FreshBooks bank reconciliation matches imported bank transactions to FreshBooks entries such as expenses, invoice payments and other income. You set a start date and opening balance, match each bank line, and watch two balances converge. It proves matching, not a statement. An accountant should still tie each month-end balance to the bank statement and review what stays unmatched.
What FreshBooks bank reconciliation matches
FreshBooks bank reconciliation, which FreshBooks calls Bank Rec, pairs bank transactions with entries already in FreshBooks. Bank transactions appear on the left of the screen. FreshBooks entries, such as expenses, payments and credits, appear on the right. A match says that a bank line and a bookkeeping entry describe the same money.
FreshBooks's help article What is bank reconciliation? says the feature lets you match any bank transaction to any FreshBooks entry, with the aim of making the balance sheet cash figure agree with the real bank balance. The same article says Bank Rec is available on trials and on the Plus, Premium and Select plans, and recommends reconciling at least once a month.
Matching is the core of any reconciliation, so this is real work. A matched line tells you an invoice payment was received, or an expense was paid. Each unmatched line on the left is money the books have not explained yet.
Setting the FreshBooks reconciliation start date and opening balance
Bank Rec needs a start date and an opening balance for each account. FreshBooks recommends the first day of a recent bank statement, and the opening balance is the balance on that day. Pick a date at the start of a statement, because the statement then prints the exact figure you need.
FreshBooks's article How do I set up bank reconciliation? gives the details. On a bank statement, look for the Opening Balance or Balance Forward line at the top of the transactions. For a credit card, use the Previous Statement Balance. The article also says the start date can go back only as far as the first imported bank transaction, and that bank connections pull up to 90 days of activity.
That 90-day limit matters when you take on a client mid-year. If the books need reconciling from January and it is now October, a bank connection alone will not reach back. Check what import options the client's account offers before you plan the catch-up, and keep the bank's statements for the months the feed cannot cover.
Which balances does the FreshBooks reconcile screen compare?
The reconcile screen compares two balances. The Bank Account Balance is the opening balance plus every imported transaction as of the latest sync. The FreshBooks Balance is the opening balance plus or minus the transactions you have matched. When every bank line is matched, the two agree.
FreshBooks's setup article defines both, and adds that journal entries posted to the account also move the FreshBooks Balance, which is the first place to look when the two disagree. Note what they share: the same opening balance, and the same imported bank data. The Bank Account Balance is not read from a bank statement. It is built from the feed. If the feed drops a transaction or brings one in twice, both balances can still agree with each other while disagreeing with the bank.
Credit card accounts show as negative balances, because the card is a liability. That is expected and not a sign of error.
What FreshBooks bank reconciliation leaves unchecked
Bank Rec checks that bank lines and FreshBooks entries match. It does not, in the help articles, ask you to enter a statement ending balance and date and prove the matched items reach it. That statement-to-books proof, period by period, is what an auditor or reviewer expects a bank reconciliation to show.
Three gaps follow from that:
- Feed completeness. A missing or duplicated bank line is invisible if both balances are built from the same feed.
- Cut-off. The Bank Account Balance is live as of the last sync, not as of month-end, unless you take steps to fix the date.
- A frozen record. Matching can change after the month closes. Unless you save a dated copy of the month's position, nothing shows what the reconciliation looked like when it was done.
The Bank Reconciliation Summary report fills part of the gap. It lists unmatched FreshBooks entries and unmatched bank transactions, takes a date range such as End of Last Month, and exports to CSV or PDF.
What should an accountant add to a FreshBooks reconciliation each month?
Add the statement. At each month-end, compare the bank statement's closing balance with the FreshBooks Balance at the same date, explain any difference with listed items, and save the Bank Reconciliation Summary as of that date. That turns matching into a reconciliation a reviewer can sign.
A month-end checklist:
- Download the bank statement PDF for the month.
- Run the Bank Reconciliation Summary with the date range set to the month-end.
- Note the statement's closing balance and the FreshBooks Balance at that date.
- List every unmatched item from the report, with its date and amount.
- Show that the statement balance, adjusted for those items, equals the FreshBooks Balance.
- Look for duplicates in the bank list: same amount, same payee, within a few days.
- Save the statement, the report and your working as one file.
A worked example with made-up figures: the September statement closes at 12,480.60. The FreshBooks Balance at September 30 is 12,105.60. The report shows one unmatched bank deposit of 375.00 from a client who paid by transfer. Match the deposit to its invoice payment, and the two balances agree.
Property managers need more than this, because trust money brings its own rules. The guides to AppFolio bank reconciliation and Yardi bank reconciliation cover those systems.
Edge case: a FreshBooks bank balance off by a few cents
A gap of a few cents between the statement and the FreshBooks Balance looks harmless, but it has a cause, and the cause can repeat. Rounding on a foreign-currency charge, a fee split oddly, or a transaction keyed by hand with a typo are the usual sources. Find it rather than writing it off.
The approach in chasing a reconciliation that is off by a few cents applies here: look for an amount whose cents match the gap, then for currency lines, then for manual entries. If a match was made wrongly, unmatch it and redo it. That is a smaller fix than reversing a whole month, a distinction the guide to unreconciling in QuickBooks Online makes for another product.
For firms that review many small-business files, PreciseBankFlow reads the statement itself, checks that it foots from opening to closing balance, and lists the lines that do not match the books, which is the proof Bank Rec leaves to you. It is opening in small groups; request a spot.