Ensure that your Bank Account Balance matches your FreshBooks Balance by regularly reviewing, matching or marking any bank transactions that come into your Bank Reconciliation. Match expenses, invoice payments, bill payments, other income, and credits. You can also mark as transfer, owner’s equity, or an expense refund. If you’re looking to do more complex reconciliation check out the reconciling complex transactions article instead.
Completing your bank reconciliation will help ensure your accounting reports are up to date.
If you’ve just connected a new bank connection, you will need to set up your bank reconciliation before starting to reconcile. Once you have your bank connected and an opening balance set, you can start reconciling transactions.
Unmatched Transactions
Before transactions are reconciled they will remain in an unmatched state. You can view your list of Unreconciled Bank Transactions on the left side of bank rec. There are two types of transactions that may or may not affect your reports inside your account:
Unmatched Money-in Transactions
- Unreconciled Bank Transactions in your account like deposits and invoice payments received (including bank transfers (ACH) and checks), and anything else that is an increase to your Bank Account Balance
- Will not affect your reports or FreshBooks Balance until you match or mark as inside bank rec
- Income entries are not automatically created when imported, they need to be manually added by creating a transaction before they can be matched
Unmatched Money-out Transactions
- These are unreconciled bank transactions in your account like expenses, bill payments made and anything else that is a decrease to your Bank Account Balance
- Displayed both under the Unreconciled Bank Transactions (left) and the FreshBooks Entries (right) sections inside your Bank Rec widget
- Bank connections automatically import expenses in FreshBooks to correspond with the money-out transaction imported from your bank account
-
Will affect your reports since Expense entries are automatically created when they’re imported or created manually
- These expenses flow through Petty Cash first when imported and in an unmatched status, but will be reassigned to a Bank or Credit Card account when matched
- If a money-out entry is Marked As, the associated imported expense entry will be automatically deleted and will not affect your Profit and Loss report
- Use the deleted link in the Expenses section to review any deleted expenses
Likely Matches and Reconciling Transactions
To help you get through reconciling transactions faster, FreshBooks will first suggest possible matches based on identical information from both Unreconciled Bank Transactions and FreshBooks Entries. You can either approve the matches or skip them using the steps below:
- Select the Accounting section
- Your bank account(s) will be listed in the Bank Reconciliation widget, select the # left to match link
- From here, review each row of matches and either:
-
Uncheck any box(es) next to each row that is not a correct match (like expense or invoice payments, transfers between accounts, credit card payments) and select Confirm and Continue
-
Leave all the boxes checked and select Confirm and Continue to reconcile all of them
-
Or select the Skip button to ignore the Likely Matches and review all transactions individually instead.
-
Any remaining unmatched transactions will need to be matched by you manually. Depending on what kind of transaction you need to match, choose from the below options and follow the specified steps:
Note: If you've reconciled all transactions on the left side under Unreconciled Bank Transactions, you've completed bank rec for the day. Transactions under FreshBooks Entries may have been imported via CSV, paid in cash, or with a bank/credit card that is not connected in FreshBooks, which means they don’t need to be matched in bank rec. At this time, there is no option to hide these from the Unmatched section.
Match
If you have an Unreconciled Bank Transaction and there is also a corresponding entry (or multiple entries) in the FreshBooks Entries section, use the below steps to match them together.
- In the Bank Account Transactions section on the left, check off a transaction
- Then in the FreshBooks Entries section on the right, use the search bar if you need to find your entries, and check off one or several entries that match
- Select the Match button.
Filter Transactions
You can filter your views to quickly reconcile specific entry types using these steps:
- Select the settings icon on the right side of the search bar under either column
- Choose a new Start and End date
- If needed, under FreshBooks Entries, you can specify the Entry Type (Payments and Other Income, Check Payments, Expenses, Credits, or Bill Payments)
- Select Apply to save and new entries will appear
- In the Bank Account Transactions section on the left, check off a transaction
- Then in the FreshBooks Entries section on the right, check off one or several entries that match
- Select the Match button.
Create a New Entry
If the FreshBooks entry doesn’t exist yet, you can create it with these steps:
- Under FreshBooks Entries, select the Create a New Entry button
- Then choose from Expense, Other Income, Payment, or Bill Payment depending on what kind of matching entry you need to create
- Once saved, this entry will now appear in the list of FreshBooks Entries
- Check off the entry or entries that you’ve just created
- Select the Match button.
Mark As...
If your Unreconciled Bank Transaction doesn’t require an accompanying FreshBooks Entry to match it to because it is a transfer, owner’s equity or expense refund, choose from the below for the steps:
You can view how journal entries are posted in accounting reports in How are common transactions recorded as journal entries? here.
Mark as Transfer
If the transaction is a transfer to pay off a balance in another account (e.g., bank transfer for credit card payments), you can mark it as a transfer without needing to match it to a FreshBooks Entry:
- Check off the box next to the Bank Account Transaction
- Select the Mark As button at the top
- Then select Transfer
- Enter details on the transfer as needed in the Note box
- Select Submit to finish and the Bank Account Transaction will no longer appear as an option to match. The corresponding imported expense on the FreshBooks Entries side will also be deleted automatically
- Make sure to also Mark as Transfer in the other account that received a transfer or was transferred from, if that account is also connected to bank rec to ensure your books remain accurate.
Notes:
- When marked as a transfer, two accounts will be affected in your reports:
-
Money-in transactions marked as transfers:
- Will increase the balance in the connected Bank account and decrease the balance in the Petty Cash account
-
Money-out transactions marked as transfers:
- Will decrease the balance in the connected Bank account and increase the balance in the Petty Cash account
-
Money-in transactions marked as transfers:
- Once Marked as Transfer, these can be found in the Matched tab in chronological order of when you marked them, with a note indicating it's a Bank Transfer
- Use Mark as Transfer for any entries that have to be recorded with a journal entry (e.g., loan, long-term asset purchase, etc.) that need to be reflected in a custom account
Mark as Owner’s Equity
If the transaction is Owner’s Equity (explained here), you can mark it as so with the below steps:
- Check off the box next to the Bank Account Transaction
- Select the Mark As button at the top
- Then select Owner’s Equity
- Enter details on the equity as needed in the Note box
- Select Submit to finish. The Bank Account Transaction will no longer appear as an option to match. The corresponding imported expense will also be deleted automatically.
Notes:
-
Once marked as Owner’s Equity, you can find them in the Matched tab in chronological order of when you marked them, with a note indicating it's Owner’s Equity
-
These transactions will also be located inside the Owner’s Equity account on the Chart of Accounts or the General Ledger report
Mark as an Expense Refund
If the transaction is a payment you received from a merchant when returning an expense, you can use the Mark as an Expense Refund option. Use the below steps:
- Check off the box next to the Bank Account Transaction
- Select the Mark As button at the top
- Then select Expense Refund
- Next, choose the Refunded Expense Category under Operating Expenses or Cost of Goods Sold
- Then enter details about the refund as needed in the Note box
- Select Submit to finish. The Bank Account Transaction will no longer appear as an option to match.
Notes:
-
Once marked as an Expense Refund, you can find them in the Matched tab in chronological order of when you marked them, with a note indicating it's an Expense Refund
- The Expense Refund selected will reflect accordingly in your accounting reports
- On the General Ledger report, expense refunds will appear under the account corresponding to the Refunded Expense category
- On the Profit and Loss report, expense refunds will be reflected in the individual refunded expense category
- On the Expense report, a breakdown of all refunds can be found in the Expense Refunds section at the end
Viewing Matched Transactions
All matched transactions, including those marked as transfers, owner’s equity and expense refunds, can be viewed with the below steps:
- Select the Accounting section
- Then select the # left to match link for the account you want to review in the Bank Rec Widget
- Select the Matched sub-tab.
Notes:
- Transactions marked as transfers, owner’s equity and expense refunds will specify the type of entry under the FreshBooks Entry column header
- If you’ve accidentally matched the wrong transactions together, you can unmatch them by checking off the box(es) next to the match(es), and selecting the Unmatch Transactions button above the list. The transactions from this match will then appear in the Unmatched sub-tab for you to reconcile correctly
- Editing or deleting a FreshBooks entry like expenses, invoices, other income and payments will cause matched transactions to unmatch