Bank Reconciliation in Keepler lets you match your bank transactions with your accounting records to ensure your books reflect your real bank balances. It also allows you to create transfers, owner’s equity adjustments, and expense refunds by marking your bank transactions accordingly.

You can reconcile by either connecting your bank account directly for automatic syncing or by manually creating a bank account and uploading transaction files (CSV). Once you set the opening balance, you can start reconciling transactions easily.

Before You Begin

• Keepler currently supports reconciliation for business bank accounts only, personal, crypto, investment, loan, or line of credit accounts are excluded and should be managed via manual journal entries.
• Reconciliation is performed in a single currency; transactions will only appear if they match your bank account’s currency.
• Manual journal entries affect your ledger but do not appear in the reconciliation screen.

Set Up Bank Reconciliation

You can set up bank reconciliation in two ways:

• Connect your bank account: Automatically import transactions via secure bank connections.
• Create a manual bank account: For regions where bank connections aren’t available, or if you prefer to upload CSV files.

Adding a Bank Account in Keepler

1. From your Keepler Dashboard, locate the Cashflow option in the sidebar and click it.

   

2. Click the Add New Cashflow button.

   

3. A popup form will appear prompting you to enter your bank details to securely process financial transactions:

   • Bank Name
   • Account Holder Name
   • Currency (e.g., USD)
   • Account Number
   • SWIFT/BIC Code
   • IBAN
   

4. Fill in all required fields marked with an asterisk (*) and click Save.

5. The bank account will then appear at the top of the Cashflow page as an overview card.

   

6. Each bank card has an action menu where you can Edit, Delete, or View Bank Statement.

Managing Bank Statements

• When you click Load Bank Statement, a popup opens showing:

  • An overview of all bank statement details.
  • Options to upload related documents such as PDFs via drag-and-drop or file chooser.
  • Tools to search and filter statements for easier management.
  

Understanding Balances

• Bank Account Balance: Reflects your opening balance plus all imported transactions in real-time.
• Keepler Balance: Your opening balance plus all matched transactions and journal entries posted in Keepler.

For credit card accounts, balances show as liabilities (negative), whereas bank accounts show as assets (positive).

Finding Your Reconciliation Start Date & Opening Balance

For Bank Accounts

• Use the opening balance or balance forward line from your bank statement as your reconciliation start point.
• If starting mid-statement, pick the date you want to reconcile from and use the previous day’s balance as your opening balance.
• Enter these values exactly as shown on your statement, including positive or negative signs.

For Credit Card Accounts

• Use the statement period’s start date as your reconciliation start date.
• Enter the previous statement balance as your opening balance.
• If starting mid-period, calculate your opening balance by adjusting the previous balance with purchases, fees, payments, and credits posted before your start date.

Frequently Asked Questions (FAQs)

What if I set the wrong opening balance?

You can reset your opening balance anytime:

• Go to Accounting Space
• Click on Cashflow option in the sidebar
• Select the account’s reconciliation widget
• Click More Actions > Edit
• Enter a new start date and opening balance
• Confirm to update

Matched transactions will remain unless you change the start date to a future date, which will unmatch transactions falling between the old and new dates.

Can I disconnect my bank account?

Yes. To stop importing transactions:

• Check if your bank is supported (see our list here)
• Follow your bank connection partner’s instructions to disconnect.

How do I clear a disconnected bank account?

Clearing will:

• Unmatch all transactions from reconciliation
• Remove the opening balance from your Chart of Accounts
• Keep imported expenses but zero out the account balance

To clear:

• Go to Accounting Space
• In the Bank Reconciliation widget, enable Show disconnected accounts
• Select the disconnected account > More Actions > Delete Disconnected Account
• Confirm to reset the account

After Setup

Once set up, you can start matching your transactions to your records. Keepler helps you spot unmatched transactions, categorize them, and finalize reconciliation to keep your books accurate and audit-ready.

Next: Learn how to create your first expense.