FreshBooks Bank Transactions Missing or Duplicated

How to fix it

Try these in order — the most common fix is first.

1. 1. Find duplicates

   Copy steps
   1. Run the General Ledger Report for Petty Cash
   2. Compare it to the bank statement
   3. Delete the duplicate transaction in FreshBooks
   Did this fix it? Yes No

2. 2. Find missing transactions

   Copy steps
   1. Reconcile all transactions in the connected accounts first
   2. Check the opening balance is the real opening balance
   3. Compare month-end balances using the Balance Sheet or Trial Balance
   4. Use the General Ledger Report month by month to locate the gap
   5. Add, edit or undelete via the self-serve option in Bank Reconciliation
   Did this fix it? Yes No

3. 3. Transactions older than 90 days

   Copy steps
   1. Add them manually or import a CSV of the bank feed
   2. Then reset the account's opening balance to the earliest transaction date you reconcile
   Did this fix it? Yes No

Symptoms

Transactions don't import, appear twice, or Bank Reconciliation won't balance and a Petty Cash balance is left over.

Why it happens

• Bank Connections only import the last 90 days
• Reconnecting or disconnecting a bank can import duplicates
• Wrong opening balance (end-of-day instead of opening balance)
• Several feeds for the same account

This guide also covers

• freshbooks duplicate transactions
• freshbooks bank reconciliation not balancing
• freshbooks missing bank transactions
• freshbooks petty cash balance

The same problem in other apps

All missing or lost data guides →

• Xero Login and MFA Not Working (Lost Phone) (Xero)

Other FreshBooks errors

• How to Cancel FreshBooks Subscription
• FreshBooks Bank Connection Not Working
• FreshBooks Invoice Not Received by Client
• FreshBooks Online Payments Not Working
• FreshBooks Payout Delayed or On Hold
• FreshBooks Can't Log In
• FreshBooks Two-Factor Code Not Working
• FreshBooks Client Limit Reached (5 Clients on Lite)