{"id":20215,"date":"2026-07-09T11:55:30","date_gmt":"2026-07-09T11:55:30","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20215"},"modified":"2026-07-09T11:55:58","modified_gmt":"2026-07-09T11:55:58","slug":"how-to-configure-bank-cash-statement-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-bank-cash-statement-in-idempiere\/","title":{"rendered":"How to Configure Bank\/Cash Statement in iDempiere"},"content":{"rendered":"\n

Introduction<\/strong><\/h2>\n\n\n\n

The Bank\/Cash Statement window reconciles transactions recorded in iDempiere against the actual bank or cash account statement. It is the final checkpoint in the payment reconciliation cycle.<\/p>\n\n\n\n

Finance teams use it to confirm store collections, vendor payments, and cash deposits match the bank record before closing a period.<\/p>\n\n\n\n

Completing a statement updates the bank account balance, marks linked payments as reconciled, and creates an auditable reconciliation trail.<\/p>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • A Bank Account must be selected before creating a statement.<\/li>\n\n\n\n
  • Each statement belongs to a single Organization and Bank Account.<\/li>\n\n\n\n
  • A statement can contain multiple Statement Lines.<\/li>\n\n\n\n
  • Statement Lines can be created manually, from Payments, or from Deposit Batches.<\/li>\n\n\n\n
  • At least one Statement Line must exist before completion.<\/li>\n\n\n\n
  • The accounting period must be open for the statement to complete.<\/li>\n\n\n\n
  • Statement Difference and Ending Balance are calculated automatically.<\/li>\n\n\n\n
  • Completing the statement marks linked Payments as Reconciled.<\/li>\n\n\n\n
  • The Bank Account Current Balance updates only after completion.<\/li>\n\n\n\n
  • A completed statement becomes read-only and is marked Processed.<\/li>\n<\/ul>\n\n\n\n

    Process Flow Diagrams<\/strong><\/h2>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Configuration Steps<\/strong><\/h2>\n\n\n\n

    Step 1: Create the Statement Header<\/strong><\/h3>\n\n\n\n

    The header identifies which bank account and period the statement covers, and captures the opening balance carried from the previous reconciliation.<\/p>\n\n\n\n

      \n
    • Open a new Bank\/Cash Statement record. <\/li>\n\n\n\n
    • Select the Bank Account and Document Type, set the Statement Date and Account Date, and enter the Beginning Balance before adding lines.<\/li>\n<\/ul>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Organization<\/strong><\/td>CDC<\/td>Store or business unit the statement belongs to<\/td><\/tr>
      Bank Account<\/strong><\/td>POS Cash Account_POS Cash_100001<\/td>Bank or cash account being reconciled<\/td><\/tr>
      Document Type<\/strong><\/td>Bank Statement<\/td>Document type controlling numbering and workflow<\/td><\/tr>
      Statement Date<\/strong><\/td>07\/01\/2026<\/td>Date the bank statement was issued<\/td><\/tr>
      Account Date<\/strong><\/td>07\/01\/2026<\/td>Accounting date used for posting<\/td><\/tr>
      Beginning Balance<\/strong><\/td>1,000.00<\/td>Opening balance carried from the prior statement<\/td><\/tr>
      Ending Balance<\/strong><\/td>1,660.80<\/td>Calculated automatically after lines are added<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Step 2: Add Statement Lines<\/strong><\/h3>\n\n\n\n

      Click Create lines from, filter by Bank Account, Tender Type, Business Partner, or Transaction Date, select the matching payments, and confirm to generate the lines.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Bank Account<\/strong><\/td>POS Cash Account_POS Ca…<\/td>Filters payments belonging to this account<\/td><\/tr>
      Transaction Date<\/strong><\/td>07\/01\/2026<\/td>Upper bound for payments to include<\/td><\/tr>
      Create Line Per Payment<\/strong><\/td>Unchecked<\/td>Groups or separates lines per payment<\/td><\/tr>
      Payment<\/strong><\/td>1000001<\/td>Completed payment selected for the line<\/td><\/tr>
      Amount<\/strong><\/td>660.80<\/td>Payment amount pulled into the statement line<\/td><\/tr>
      Business Partner<\/strong><\/td>ALPHA RETAIL SOLUTIONS<\/td>Customer or vendor tied to the payment<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Step 3: Review Statement Line Details<\/strong><\/h3>\n\n\n\n

      Each generated line should be checked for accuracy before the statement is completed, since amounts and references feed directly into the reconciliation.<\/p>\n\n\n\n

        \n
      • Open each Statement Line and confirm the Statement Amount, Transaction Amount, Currency, Payment, and Business Partner match the bank record. <\/li>\n\n\n\n
      • Adjust Charge or Interest Amount if the bank applied fees.<\/li>\n<\/ul>\n\n\n\n
        Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
        Statement Line Date<\/strong><\/td>06\/22\/2026<\/td>Date the transaction appears on the bank statement<\/td><\/tr>
        Statement Amount<\/strong><\/td>660.80<\/td>Amount as shown on the bank statement<\/td><\/tr>
        Transaction Amount<\/strong><\/td>660.80<\/td>Amount recorded in the linked payment<\/td><\/tr>
        Charge Amount<\/strong><\/td>0.00<\/td>Bank charge deducted for this transaction<\/td><\/tr>
        Interest Amount<\/strong><\/td>0.00<\/td>Interest applied to this transaction<\/td><\/tr>
        Currency<\/strong><\/td>INR<\/td>Currency of the statement line<\/td><\/tr>
        Payment<\/strong><\/td>1000001_06\/22\/2026_660.80_-1<\/td>Payment matched to this line<\/td><\/tr>
        Invoice<\/strong><\/td>150000_06\/22\/2026_660.80<\/td>Invoice associated with the payment<\/td><\/tr>
        Business Partner<\/strong><\/td>ALPHA RETAIL SOLUTIONS<\/td>Customer or vendor for this transaction<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        Step 4: Match Bank Statement (Optional)<\/strong><\/h3>\n\n\n\n

        Use this when payments were imported from a bank feed and are not yet linked to invoices or business partners in iDempiere.<\/p>\n\n\n\n

          \n
        • From the header, select Match Bank Statement and run the process. <\/li>\n\n\n\n
        • iDempiere searches for matching Payments, Invoices, and Business Partners and links them to the statement lines automatically.<\/li>\n<\/ul>\n\n\n\n
          \"\"<\/figure>\n\n\n\n

          Step 5: Create Payment (Optional)<\/strong><\/h3>\n\n\n\n

          Bank charges, interest, or miscellaneous deposits often appear on the statement without a corresponding payment already in iDempiere.<\/p>\n\n\n\n

            \n
          • Select the unmatched Statement Line, click Create Payment, and confirm. <\/li>\n\n\n\n
          • A new Payment is generated and linked automatically to that line.<\/li>\n<\/ul>\n\n\n\n
            \"\"<\/figure>\n\n\n\n

            Step 6: Complete the Statement<\/strong><\/h3>\n\n\n\n

            Completing the statement finalizes the reconciliation and updates the store\u2019s bank account balance for reporting.<\/p>\n\n\n\n

            From Document Action, select Complete. iDempiere recalculates the Statement Difference and Ending Balance, reconciles linked payments, and updates the Bank Account balance.<\/p>\n\n\n\n

            Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
            Document Action<\/strong><\/td>Complete<\/td>Finalizes the statement and locks it for editing<\/td><\/tr>
            Document Status<\/strong><\/td>Completed<\/td>Status after successful completion<\/td><\/tr>
            Statement Difference<\/strong><\/td>660.80<\/td>Difference between beginning and ending balance<\/td><\/tr>
            Ending Balance<\/strong><\/td>1,660.80<\/td>Final reconciled balance for the account<\/td><\/tr>
            Approved<\/strong><\/td>Checked<\/td>Automatically set true on completion<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
            \"\"<\/figure>\n\n\n\n

            Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n
            Issue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>
            No Statement Lines available<\/strong><\/td>No completed Payments exist for the selected Bank Account<\/td>Complete the source Payments first or add lines manually<\/td><\/tr>
            Unable to complete the statement<\/strong><\/td>No Statement Lines exist or the accounting period is closed<\/td>Add at least one line and confirm the period is open<\/td><\/tr>
            Statement becomes read-only<\/strong><\/td>Statement was already completed and processed<\/td>This is expected; void and re-create if changes are needed<\/td><\/tr>
            Payment missing in Create Lines From<\/strong><\/td>Payment is not completed or belongs to a different Bank Account<\/td>Complete the payment and confirm the Bank Account matches<\/td><\/tr>
            Statement Difference is incorrect<\/strong><\/td>A Statement Line amount does not match the actual bank record<\/td>Review and correct the affected line before completing<\/td><\/tr>
            Bank Account balance not updated<\/strong><\/td>Statement was not completed, only saved as Drafted<\/td>Run Document Action \u2192 Complete to trigger the balance update<\/td><\/tr>
            Duplicate statement lines created<\/strong><\/td>Create Lines From was run more than once for the same payments<\/td>Delete the duplicate lines before completing the statement<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

            Next Steps<\/strong><\/h2>\n\n\n\n
              \n
            • Review the reconciled Statement Lines for accuracy.<\/li>\n\n\n\n
            • Verify the updated Bank Account balance in Cash Management.<\/li>\n\n\n\n
            • Review generated accounting entries in General Ledger.<\/li>\n\n\n\n
            • Proceed to the next Bank\/Cash Statement cycle when a new statement arrives.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

              Introduction The Bank\/Cash Statement window reconciles transactions recorded in iDempiere against the actual bank or cash account statement. It is […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[58,10],"tags":[],"class_list":["post-20215","post","type-post","status-publish","format-standard","hentry","category-accounting","category-product"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=20215"}],"version-history":[{"count":2,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20215\/revisions"}],"predecessor-version":[{"id":20224,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20215\/revisions\/20224"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}