{"id":20492,"date":"2026-07-13T11:31:11","date_gmt":"2026-07-13T11:31:11","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20492"},"modified":"2026-08-21T06:03:22","modified_gmt":"2026-08-21T06:03:22","slug":"how-to-process-automatic-account-reconciliation-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-process-automatic-account-reconciliation-in-idempiere\/","title":{"rendered":"How to Process Automatic Account Reconciliation in iDempiere"},"content":{"rendered":"\n

Automatic Account Reconciliation is a core iDempiere process that reconciles posted transaction lines on a General Ledger account against a predefined reconciliation rule.<\/p>\n\n\n\n

It is used in Finance and Accounting operations to match clearing accounts, suspense accounts, bank accounts, and intercompany accounts during period-end activities.<\/p>\n\n\n\n

Running this process marks matched GL Journal lines as reconciled, which keeps account balances accurate for financial reporting and audit tracking.<\/p>\n\n\n\n

Process Flow<\/strong><\/h2>\n\n\n\n
\"TenthPlanet-iDempiere-Process-AutomaticAccountReconciliation-ProcessFlow\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Only Active GL accounts are available for selection in the Account field.<\/li>\n\n\n\n
  • A Reconciliation Rule must exist for the account before the process can run.<\/li>\n\n\n\n
  • Only unreconciled transaction lines are evaluated during each run.<\/li>\n\n\n\n
  • “Run as Job” executes the process asynchronously in the background.<\/li>\n\n\n\n
  • Matched lines are flagged as reconciled and excluded from future runs.<\/li>\n\n\n\n
  • Reconciliation logic is driven entirely by the selected Rule definition.<\/li>\n\n\n\n
  • Process results are available in Process Info after completion.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • GL Account configured in the Chart of Accounts \/ Accounting Schema.<\/li>\n\n\n\n
    • Account has posted transactions with a reconciliation status of unreconciled.<\/li>\n\n\n\n
    • Reconciliation Rule defined and linked to the account.<\/li>\n\n\n\n
    • Active Accounting Schema and open Calendar Period.<\/li>\n\n\n\n
    • User role has access to the Automatic Account Reconciliation window.<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n
      Menu \u2192 Performance Analysis and Accounting \u2192 Automatic Account Reconciliation<\/strong><\/code><\/pre>\n\n\n\n
      \"TenthPlanet-iDempiere-Process-AutomaticAccountReconcilation-1\"<\/figure>\n\n\n\n
      Opening the window displays a parameter form with Account and Rule fields, a Run as Job checkbox, and a Saved Parameters bar. OK executes the process; Cancel closes the window.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Process-AutomaticAccountReconcilation-2\"<\/figure>\n\n\n\n
      Configuration Steps<\/strong><\/h2>\n\n\n\n
      Step 1: Select the Account<\/strong><\/h3>\n\n\n\n
      Identify the GL account whose unreconciled transactions need to be matched.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Click the Account field and select the GL account to reconcile, such as a bank or clearing account, from the lookup.<\/p>\n\n\n\n
      Field Reference<\/strong><\/h3>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Account<\/td>B_PAYMENTSELECT_Payment selection<\/td>GL account whose transactions will be reconciled<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 2: Select the Reconciliation Rule<\/strong><\/h3>\n\n\n\n
      The Rule determines the matching logic applied to the account’s transaction lines.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Click the Rule field and choose a previously defined reconciliation rule for the selected account.<\/p>\n\n\n\n
      Field Reference<\/strong><\/h3>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Rule<\/td>Payment Clearing (unallocated cash\/payment selection)<\/td>Reconciliation rule that defines the matching criteria<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 3: Choose the Run Mode<\/strong><\/h3>\n\n\n\n
      Large accounts with high transaction volume benefit from background processing.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Check Run as Job to process reconciliation asynchronously, or leave it unchecked to run immediately in the foreground.<\/p>\n\n\n\n
      Field Reference<\/strong><\/h3>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Run as Job<\/td>Unchecked<\/td>Runs process in background as a scheduled job when checked<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 4: Execute the Process<\/strong><\/h3>\n\n\n\n
      Running the process applies the rule and updates the reconciliation status of matched lines.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Click OK to execute. Review the Process Info summary to confirm how many transaction lines were reconciled.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Process-AutomaticAccountReconcilation-3\"<\/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>
      Process completes with zero reconciled lines<\/td>No unreconciled transactions exist for the account<\/td>Verify unreconciled GL Journal lines exist for the account<\/td><\/tr>
      OK button shows mandatory field error<\/td>Account or Rule field left blank<\/td>Select both Account and Rule before running<\/td><\/tr>
      Process takes very long to complete<\/td>High transaction volume on the account<\/td>Enable Run as Job to process in the background<\/td><\/tr>
      Reconciled balance not reflected in reports<\/td>Report was generated before process completion<\/td>Re-run the financial report after the job finishes<\/td><\/tr>
      Wrong account gets reconciled<\/td>Incorrect account selected in the parameter field<\/td>Verify the Chart of Accounts entry before executing<\/td><\/tr>
      Window not accessible to user<\/td>Role lacks access to the reconciliation window<\/td>Grant window access to the role in Role Maintenance<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Configure reconciliation rules in the GL Reconciliation Rule window.<\/li>\n\n\n\n
      • Review reconciled and unreconciled lines in the GL Journal window.<\/li>\n\n\n\n
      • Verify updated balances in the Account Balance or Trial Balance report.<\/li>\n\n\n\n
      • Set up recurring background jobs for periodic reconciliation runs.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
        Automatic Account Reconciliation is a core iDempiere process that reconciles posted transaction lines on a General Ledger account against a […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,10],"tags":[],"class_list":["post-20492","post","type-post","status-publish","format-standard","hentry","category-idempiere-accounting","category-idempiere-product"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20492","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=20492"}],"version-history":[{"count":3,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20492\/revisions"}],"predecessor-version":[{"id":28240,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20492\/revisions\/28240"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}