--- title: Using Bank Feeds (Business Central) slug: svb/using-bank-feeds-business-central description: Streamline your reconciliation process with Bank Feeds in Business Central. Use Bank Feeds with either the Bank Account Reconciliation or Payment Reconciliation Journal modules. Read this guide to learn how! docTags: kOBW7Pa05SaMsJIm9Vdtp createdAt: 2022-10-13T22:59:15.000Z --- This guide covers how to use Bank Feeds with the Bank Account Reconciliation module or the Payment Reconciliation Journal to streamline your reconciliation process. Bank Feeds allow you to import transactions into only one module: either the Bank Account Reconciliation module OR the Payment Reconciliation Journal, but not both. Please select the module that best suits your organization's workflow during the setup of your bank feed. *** ## Bank Account Reconciliation Module To initiate your first Bank Feed using the Bank Account Reconciliation module, begin by using the system search bar to locate and open **Bank Account Reconciliation**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/WkFYjE5JM0R3EFCAaIEPC_image.png" size="80" width="824" height="632" caption="Select Bank Account Reconciliations" position="center" showCaption="true"} Once the page loads, navigate to the top menu bar, select **Process**, and then click **New**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/oYpJiPjzx9wYRjQ98oAgX_image.png" size="80" width="1208" height="463" caption="Select New" position="center" showCaption="true"} You will then be prompted to select the specific Bank Account you wish to reconcile to complete the setup. *** ## Import With Bank Account Reconciliation Follow these steps to import your bank account transactions into Business Central for reconciliation using the Bank Account Reconciliation module. ::::WorkflowBlock :::WorkflowBlockItem ### Go to Bank Account Reconciliation Select **Cash Management** and then navigate to the **Bank Account Reconciliation **module. Select the Bank Account you would like to start with. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/-54dXNLMu828jXol2vmfh_screenshot-2024-01-16-at-35139-pm.png" size="80" width="1464" height="575" position="center" caption="Select a Bank Account" showCaption="true"} ::: :::WorkflowBlockItem ### Import Bank Statement To retrieve new data, select **Import Bank Statement**. This action will load all transactions received since your last import was triggered. ::Image[]{src="https://app.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/olpOdzU-EduT46Y1O1L6w_screenshot-2024-01-11-at-12046-pm.png" size="80" width="1656" height="974" position="center" caption="Select Import Bank Statement" showCaption="true"} If no new data is available, a system notification will appear to confirm that there are no new transactions to import. ::: :::WorkflowBlockItem ### Expected Fields The list below outlines how the transaction data imports into the Business Central columns: | **Business Central Column** | **Transaction Data** | | --------------------------- | ------------------------------------------ | | Transaction Date | Settled Date | | Document Number | Customer Reference\* | | Related Party Name | Counter Party Name or Related Party Name\* | | Description | Description | | Amount | Amount | | Check No. | Check No.\* | | Additional Transaction Info | BAI2 Code | Fields marked with an asterisk (\*) are conditional. This data will only appear in Business Central if it is provided in the bank's transaction details; not all transactions will contain this specific information. ::: :::: *** ## Match Transactions With Bank Account Reconciliation With your columns configured and your data imported, you are ready to begin reconciliation using the Bank Account Reconciliation module. Follow these steps to match the imported transactions to your existing Business Central entries. ::::WorkflowBlock :::WorkflowBlockItem ### Automatically Match Transactions To use the automatic match feature, go to **Matching --> Match Automatically**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/zK-x4oi29HdwtsPBl11kZ_screenshot-2024-02-01-at-32556-pm.png" size="80" width="1645" height="853" position="center" caption="Click on Matching Automatically" showCaption="true"} The system will prompt you to enter a **Transaction Date Tolerance**. The recommended tolerance depends on the payment method used; for example, ACH and Wire payments typically settle within five business days, whereas checks depend on when your vendor deposits them. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/k_q9qpbRfY3Yp5rjkuQ7__screenshot-2024-02-01-at-32627-pm.png" size="80" width="937" height="645" position="center" caption="Enter In The Number of Tolerance Days" showCaption="true"} Business Central will attempt to match the transactions based on these criteria. Once the process is complete, a summary will appear displaying the number of lines successfully matched. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/3JNpVLylZdVt8SQs51Zon_screenshot-2024-02-01-at-32704-pm.png" size="80" width="625" height="306" position="center" caption="Overview of Matched Transactions" showCaption="true"} ::: :::WorkflowBlockItem ### Manually Match Individual Transactions To manually match transactions, click on the corresponding transaction on both the **Bank Statement Lines **section and the **Bank Account Ledger Entries **section. With both lines selected, click **Matching -> Match Manually.** ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/KMhtfAEhLrjF_TnoH2DNe_screenshot-2024-01-23-at-31058-pm.png" size="80" width="1580" height="756" position="center" caption="Click Match Manually" showCaption="true"} Once the transactions are matched, they will both turn green to signify success. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/-XuT8eWSZJj_TjWFiwuLf_screenshot-2024-01-23-at-31133-pm.png" size="80" width="1577" height="641" position="center" caption="Successful Match Made" showCaption="true"} ::: :::WorkflowBlockItem ### Manually Match Multiple Entries to One Bank Statement Line You can also match Bank Account Ledger Entries to a single bank statement line. First, select the target line in the **Bank Statement Lines** section. Next, in the **Bank Account Ledger Entries **section, hold down **Control** (Windows) or **Command** (Mac) while clicking to select the multiple transactions you wish to group together. Then, click **Matching -> Match Manually**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/pHdxynlWerbI1NJFM4dzB_screenshot-2024-01-23-at-31519-pm.png" size="80" width="1568" height="722" position="center" caption="Click Manual Matching" showCaption="true"} Once matched, the system will highlight the single statement line and the multiple ledger entries in green, indicating they are successfully matched. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/_GaJKizxshQ1Rt1OKiBov_screenshot-2024-01-23-at-31456-pm.png" size="80" width="1545" height="451" position="center" caption="Successful Match Made" showCaption="true"} ::: :::WorkflowBlockItem ### Removing Matches If you incorrectly match a transaction, you can easily remove the link. Select the matched lines in both the **Bank Statement Lines **and **Bank Account Ledger Entries **sections. Next, click **Matching --> Remove Match**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/VBla_iWpKebuGoKxGcN_I_screenshot-2024-01-23-at-31139-pm.png" size="80" width="1578" height="708" position="center" caption="Click Remove Match" showCaption="true"} The green highlighting will disappear, indicating that the transactions are no longer matched and are available to be rematched. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/nx_50eK_-RdFSDSHigXHL_screenshot-2024-01-23-at-31058-pm.png" size="80" width="1542" height="436" position="center" caption="Transactions are Successfully Unmatched" showCaption="true"} ::: :::WorkflowBlockItem ### Deleting Transactions If you need to delete a transaction, click on the three dots beside the **Transaction Date**. ::Image[]{src="https://api.archbee.com/api/optimize/LTm6J44NoHZKpyGlNLpLN-9adcz9W2uRsKSobE3r_H--20250430-004121.png" size="80" width="2684" height="1690" position="center" caption="Click on Delete" showCaption="true"} Click **Yes,** and the transaction will be deleted. ::Image[]{src="https://api.archbee.com/api/optimize/LTm6J44NoHZKpyGlNLpLN-xv2H4_ofkZJp_PDJo4zar-20250430-004200.png" size="70" width="1094" height="496" position="center" caption="Click Yes" showCaption="true"} ::: :::: *** ## Payment Reconcilitation Journal Module To initiate your first Bank Feed using the Payment Reconcilitation Journal module, begin by using the system search bar to locate and open **Payment Reconcilitation Journal**. Select **Cash Management → Payment Reconciliation Journal.** ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/HnhMBpkWEVDe7WTq9KdU2_image.png" size="80" width="996" height="512" caption="Select the Payment Reconciliation Journal" position="center" showCaption="true"} To complete the setup, select **Process → Import Bank Transactions. ** ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/g32TbY36fuwIlaBe0iecW_image.png" size="80" width="1182" height="466" caption="Select Import Bank Transactions" position="center" showCaption="true"} *** ## Import With the Payment Reconciliation Journal Follow these steps to import your bank account transactions into Business Central for reconciliation with the Payment Reconciliation Journal. ::::WorkflowBlock :::WorkflowBlockItem ### Go to Payment Reconciliation journal Select **Cash Management** and then navigate to the **Payment Reconciliation Journal **module. Select the bank account you would like to import your transactions from. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/uRUlqaIwVmUBhtDECWeC-_screenshot-2024-01-16-at-113625-am.png" size="80" width="951" height="452" position="center" showCaption="false"} ::: :::WorkflowBlockItem ### Import Bank Statement To retrieve new transactions, select **Import Bank Statement**. This action will load all transactions received since your last import was triggered. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/XwKejpE19nwHj3h-NZlj6_screenshot-2024-01-16-at-113647-am.png" size="80" width="1654" height="972" position="center" caption="Import New Transactions" showCaption="true"} If no new data is available, a system notification will appear to confirm that there are no new transactions to import. ::: :::: *** ## Match Transactions With Payment Reconciliation Journal With your bank data imported, you are ready to begin reconciliation using the Payment Reconciliation Journal module. Follow these steps to match the imported transactions to your existing Business Central entries. ::::WorkflowBlock :::WorkflowBlockItem ### Automatically Match Transactions To use the automatic match feature, click on **Apply Automatically**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/JpRFQPDDeP-86mNmhC2Ue_xwkejpe19nwhj3h-nzlj6screenshot-2024-01-16-at-113647-am.png" size="80" width="1654" height="972" position="center" caption="Click Apply Automatically" showCaption="true"} A prompt will appear asking if you wish to overwrite any previously applied entries. Select **Yes** or **No** based on your preference. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/Dopq0PJnOs3fgM_uXGUqL_screenshot-2024-02-01-at-44247-pm.png" size="70" width="578" height="275" position="center" showCaption="false"} Business Central will now attempt to match the transactions. Once completed, it will provide a summary of the total number of lines that were matched successfully. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/sPJ69T5T1prLV5_BhtXPY_screenshot-2024-02-01-at-44307-pm.png" size="62" width="585" height="251" position="center" caption="Overview of Matched Transactions" showCaption="true"} ::: :::WorkflowBlockItem ### Manually Matching Transactions To match a specific transaction manually, first select the transaction line you wish to reconcile. Once you have selected the line, click on **Manual Application** **--> Apply** **Manually**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/jW6KBdGr817XydzMGS97E_screenshot-2024-02-01-at-43744-pm.png" size="74" width="1636" height="721" position="center" caption="Click Apply Manually" showCaption="true"} You can now select the corresponding single entry or multiple entries to complete the match. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/45UrizQbf3-iGNNJ3nGKZ_screenshot-2024-02-01-at-44123-pm.png" size="60" width="926" height="936" position="center" caption="Select Lines to Apply" showCaption="true"} Once applied, the transaction description will populate, and the **Match Confidence **status will update. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/4WRYXR1v0MHm0bREzf5ZR_screenshot-2024-02-01-at-44229-pm.png" size="80" width="1655" height="792" position="center" caption="View Matched Transactions" showCaption="true"} ::: ::::