--- title: Bank reconciliation description: Here we'll walk you through how to use the bank reconciliation module. Bank reconciliation is the process of comparing the amounts in the cash account in the general ledger to the amounts appearing on --- [Skip to content](https://support.paragon-erp.com/bank-reconciliation#main-content) English Show submenu for translations [![paragon logo-1.png\]](https://support.paragon-erp.com/hs-fs/hubfs/paragon%20logo-1.png?width=240&height=75&name=paragon%20logo-1.png)](https://support.paragon-erp.com/?hsLang=en) - [New Ticket](https://share-eu1.hsforms.com/1PiwaZCxTRpabuHVnQxGeXQc751y) - [Tickets](https://help.paragon-erp.com/tickets) - [Knowledge Base](https://support.paragon-erp.com/) - [Sign out](https://20488534.hs-sites.com/_hcms/mem/logout) Open main navigation Close main navigation - [New Ticket](https://share-eu1.hsforms.com/1PiwaZCxTRpabuHVnQxGeXQc751y) - [Tickets](https://help.paragon-erp.com/tickets) - [Knowledge Base](https://support.paragon-erp.com/) - [Sign out](https://20488534.hs-sites.com/_hcms/mem/logout) - English Show submenu for translations - [Go to website](https://www.paragon-erp.com/) [Go to website](https://www.paragon-erp.com/?hsLang=en) Welcome! Search our Knowledge Base. - There are no suggestions because the search field is empty. 1. [ParagonERP](https://support.paragon-erp.com/?hsLang=en) 2. [Finance](https://support.paragon-erp.com/finance?hsLang=en) 3. [Financial Settings](https://support.paragon-erp.com/finance?hsLang=en#financial-settings) October 22, 2025 # Bank reconciliation ### Introduction Here we'll walk you through how to use the bank reconciliation module. Bank reconciliation is the process of comparing the amounts in the cash account in the general ledger to the amounts appearing on the bank statement. The objective is to be certain that there is consistency between the amounts, and that your company's amounts are accurate and complete. #### **Set up bank accounts** To use bank reconciliation, you will need to have already [added your bank accounts](https://support.paragon-erp.com/creating-bank-accounts?hsLang=en) to Paragon.  #### **Open the bank reconciliation module** From the home screen, click the **settings** button in the top right corner of the screen. ![](https://support.paragon-erp.com/hubfs/Knowledge%20Base%20Import/DocsDisplay-Feb-02-2024-09-04-16-0337-PM-1-1-3-1.png)   From the settings screen select the **bank reconciliation** option in the **financials** card. ![](https://support.paragon-erp.com/hs-fs/hubfs/Bank%20Reconciliation%20from%20settings-jpg.jpeg?width=1826&height=773&name=Bank%20Reconciliation%20from%20settings-jpg.jpeg)   The bank reconciliation **summary** screen will appear. Here, you can either manually enter your bank statements, or you can import your bank statement via an excel sheet. We'll walk you through each of the options. ![](https://support.paragon-erp.com/hubfs/Knowledge%20Base%20Import/DocsDisplay-Feb-02-2024-09-04-21-5412-PM-1-1-3-1.png) #### **Option 1: Manually enter your bank statement** First, click the **add** button. Then, start filling in your information: - Line number. This will populate automatically. It is the line ordinal number. - Bank clearing date. This is the date on which you received your bank statement for the transaction in question. - Type. This is the type of transaction. It could be a payment, deposit, or adjustment. - Reference. This would be a short note you'd like to add to the posting. - Amount. The amount of the transaction on the bank statement. - Linked transaction. The sequence number of the corresponding transaction in Paragon. - Linked line. This would only be filled with an Excel line number if you import your bank statement. - Period. The GL period in which the bank statement was issued. - Reconciled. This will either be a red x, or a blue checkmark. This is to signify whether the transaction has been reconciled or not. #### **Option 2: Import your bank statement** If you'd like to import your bank statement in one shot via an Excel sheet, follow these instructions. First, contact us at [support@paragon-erp.com](mailto:support@paragon-erp.com), and we'll send you the bank reconciliation template. The template will look similar to this: ![](https://support.paragon-erp.com/hubfs/Knowledge%20Base%20Import/DocsDisplay-Feb-02-2024-09-04-20-2383-PM-1-1-3-1.png) As an example, we've populated one row to illustrate what should be filled in. - transactionLineID. This will be the ordinal number telling the system what line will be listed first. In this case, we would be importing the 4th line. - bankAccountID. This will be the account number of your bank account. You'll find this in the **financial** tab of **my company** found in the **settings**. - ![](https://support.paragon-erp.com/hubfs/Knowledge%20Base%20Import/DocsDisplay-Feb-02-2024-09-04-18-1026-PM-1-1-3-1.png) - transactionDate. Enter the date of the bank statement in the format of YYYY-MM-DD - transactionType. Leave this field blank. You will manually fill it in once your import is complete. - amount. The absolute amount of the transaction. Don't make any amount negative, as this will automatically happen when you select the transaction type. - description. You can enter a note here if you wish. It will show up in the reference column when imported. Once you're ready to upload the file, click the **action** button at the bottom right hand of the screen. ![](https://support.paragon-erp.com/hs-fs/hubfs/Screenshot%202025-10-22%20083907-png.png?width=195&height=118&name=Screenshot%202025-10-22%20083907-png.png)   Click **import**. Select your file and upload. The bank statement transactions will appear on your screen, and you can start matching up transactions. ![](https://support.paragon-erp.com/hubfs/Knowledge%20Base%20Import/DocsDisplay-Feb-02-2024-09-04-16-7814-PM-1-1-3-1.png)   #### **Link your transactions** Once you've chosen your transaction types, and are ready to link your transactions, click the **click to link** option. A modal will pop up and you should see your transaction to link. ![](https://support.paragon-erp.com/hubfs/Knowledge%20Base%20Import/DocsDisplay-Feb-02-2024-09-04-17-2942-PM-1-1-3-1.png)   Select your transaction, and click the **accept** button when you're finished. ![](https://support.paragon-erp.com/hubfs/Knowledge%20Base%20Import/DocsDisplay-Feb-02-2024-09-04-15-1589-PM-1-1-3-1.png)   Once you've finished linking your transaction, you'll see that the reconciled column will have a checkmark to show it was reconciled. ![](https://support.paragon-erp.com/hubfs/Knowledge%20Base%20Import/DocsDisplay-Feb-02-2024-09-04-20-7720-PM-1-1-3-1.png)   #### **Modify lines** If you want to modify lines on your bank reconciliation list, you can right-click on the line to access these options: ![](https://support.paragon-erp.com/hs-fs/hubfs/Screenshot%202025-10-22%20084741-png.png?width=146&height=95&name=Screenshot%202025-10-22%20084741-png.png) #### **What's next?** Once you're done with your bank reconciliation, you can move forward with confidence, and reconcile as many accounts as you'd like.   - [Paragon Basics](https://support.paragon-erp.com/paragon-basics?hsLang=en#main-content) - [Paragon Modules & Features](https://support.paragon-erp.com/paragon-basics?hsLang=en#paragon-modules-features) - [Basic use Paragon](https://support.paragon-erp.com/paragon-basics?hsLang=en#basic-use-paragon) - [Advanced use Paragon](https://support.paragon-erp.com/paragon-basics?hsLang=en#advanced-use-paragon) - [Paragon policies](https://support.paragon-erp.com/paragon-basics?hsLang=en#paragon-policies) - [Customer](https://support.paragon-erp.com/paragon-basics?hsLang=en#customer) - [Configuring Paragon](https://support.paragon-erp.com/configuring-paragon?hsLang=en#main-content) - [Basic Settings](https://support.paragon-erp.com/configuring-paragon?hsLang=en#basic-settings) - [Advanced Settings](https://support.paragon-erp.com/configuring-paragon?hsLang=en#advanced-settings) - [My Company Settings](https://support.paragon-erp.com/configuring-paragon?hsLang=en#my-company-settings) - [User Management & Access](https://support.paragon-erp.com/configuring-paragon?hsLang=en#user-management-access) - [Import & Export](https://support.paragon-erp.com/configuring-paragon?hsLang=en#import-export) - [Attributes](https://support.paragon-erp.com/configuring-paragon?hsLang=en#attributes) - [PDF Templates](https://support.paragon-erp.com/configuring-paragon?hsLang=en#pdf-templates) - [Configuring - Aloha](https://support.paragon-erp.com/configuring-paragon?hsLang=en#configuring-aloha) - [Product](https://support.paragon-erp.com/configuring-paragon?hsLang=en#product) - [Associations](https://support.paragon-erp.com/configuring-paragon?hsLang=en#associations) - [Purchase](https://support.paragon-erp.com/purchase?hsLang=en#main-content) - [Vendor & Product](https://support.paragon-erp.com/purchase?hsLang=en#vendor-product) - [Purchase Order](https://support.paragon-erp.com/purchase?hsLang=en#purchase-order) - [In Transit & Receiving](https://support.paragon-erp.com/purchase?hsLang=en#in-transit-receiving) - [Vendor Invoicing](https://support.paragon-erp.com/purchase?hsLang=en#vendor-invoicing) - [Vendor](https://support.paragon-erp.com/purchase?hsLang=en#vendor) - [Manufacturing](https://support.paragon-erp.com/manufacturing?hsLang=en#main-content) - [Work Orders](https://support.paragon-erp.com/manufacturing?hsLang=en#work-orders) - [Bill of Materials](https://support.paragon-erp.com/manufacturing?hsLang=en#bill-of-materials) - [material](https://support.paragon-erp.com/manufacturing?hsLang=en#material) - [Inventory](https://support.paragon-erp.com/inventory?hsLang=en#main-content) - [Warehouse Management](https://support.paragon-erp.com/inventory?hsLang=en#warehouse-management) - [Inventory Adjustment](https://support.paragon-erp.com/inventory?hsLang=en#inventory-adjustment) - [Inventory Value](https://support.paragon-erp.com/inventory?hsLang=en#inventory-value) - [Inventory Transfer](https://support.paragon-erp.com/inventory?hsLang=en#inventory-transfer) - [Picking](https://support.paragon-erp.com/inventory?hsLang=en#picking) - [Packing](https://support.paragon-erp.com/inventory?hsLang=en#packing) - [Sales](https://support.paragon-erp.com/sales?hsLang=en#main-content) - [Sales Order](https://support.paragon-erp.com/sales?hsLang=en#sales-order) - [Reservations](https://support.paragon-erp.com/sales?hsLang=en#reservations) - [Returns](https://support.paragon-erp.com/sales?hsLang=en#returns) - [Invoicing](https://support.paragon-erp.com/sales?hsLang=en#invoicing) - [Finance](https://support.paragon-erp.com/finance?hsLang=en#main-content) - [Financial Settings](https://support.paragon-erp.com/finance?hsLang=en#financial-settings) - [GL Mapping](https://support.paragon-erp.com/finance?hsLang=en#gl-mapping) - [Journal Entries](https://support.paragon-erp.com/finance?hsLang=en#journal-entries) - [Reports](https://support.paragon-erp.com/reports?hsLang=en#main-content) - [Financial Reporting](https://support.paragon-erp.com/reports?hsLang=en#financial-reporting) - [WIGO](https://support.paragon-erp.com/reports?hsLang=en#wigo) - [Integrations](https://support.paragon-erp.com/integrations?hsLang=en#main-content) - [QuickBooks](https://support.paragon-erp.com/integrations?hsLang=en#quickbooks) - [Minox](https://support.paragon-erp.com/integrations?hsLang=en#minox) - [Shopify](https://support.paragon-erp.com/integrations?hsLang=en#shopify) - [2Ship](https://support.paragon-erp.com/integrations?hsLang=en#2ship) - [Mobile](https://support.paragon-erp.com/integrations?hsLang=en#mobile) - [Google](https://support.paragon-erp.com/integrations?hsLang=en#google) - [Release Notes & Rules](https://support.paragon-erp.com/release-notes-rules?hsLang=en#main-content) - [Rules](https://support.paragon-erp.com/release-notes-rules?hsLang=en#rules) - [Release Notes](https://support.paragon-erp.com/release-notes-rules?hsLang=en#release-notes) - [Transactions](https://support.paragon-erp.com/transactions?hsLang=en#main-content) - [Receive Payment](https://support.paragon-erp.com/transactions?hsLang=en#receive-payment) - [Transaction Basics](https://support.paragon-erp.com/transactions?hsLang=en#transaction-basics) - [Quote](https://support.paragon-erp.com/transactions?hsLang=en#quote) - [Sales Order](https://support.paragon-erp.com/transactions?hsLang=en#sales-order) - [Make Payment](https://support.paragon-erp.com/transactions?hsLang=en#make-payment) - [Credit](https://support.paragon-erp.com/transactions?hsLang=en#credit) - [Invoice](https://support.paragon-erp.com/transactions?hsLang=en#invoice) [![Logo for ParagonERP](https://support.paragon-erp.com/hs-fs/hubfs/paragon%20logo.png?width=401&height=126&name=paragon%20logo.png "Logo for ParagonERP")](https://www.paragon-erp.com?hsLang=en) We do our utmost to share all relevant information for our customers here. Still missing the answer to a question? Then please contact support. Copyright © 2026, ParagonERP