{"id":20477,"date":"2026-07-13T11:20:40","date_gmt":"2026-07-13T11:20:40","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20477"},"modified":"2026-08-13T04:42:38","modified_gmt":"2026-08-13T04:42:38","slug":"how-accounting-fact-reconciliation-manual-form-woks-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-accounting-fact-reconciliation-manual-form-woks-in-idempiere\/","title":{"rendered":"How Accounting Fact Reconciliation (Manual) Form Woks in iDempiere"},"content":{"rendered":"\n

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

Accounting Fact Reconciliation (manual) is a Form in iDempiere Core used to compare GL Journal Fact_Acct entries against the accounts they were generated from, and to flag matched records as reconciled.<\/p>\n\n\n\n

It is used during month-end and year-end closing, when finance teams verify that subledger balances such as receivables, payables, inventory clearing, or bank accounts agree with the General Ledger.<\/p>\n\n\n\n

Marking records as reconciled keeps the audit trail clean and helps identify posting errors, duplicate entries, or unbalanced accounts before financial statements are finalized.<\/p>\n\n\n\n

Process Flow Diagram<\/strong><\/h2>\n\n\n\n
\"TenthPlanet-iDempiere-Form-Accounting-ProcessFlow\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Only posted Accounting Fact records generated from GL Journals appear in the grid.<\/li>\n\n\n\n
  • Records are filtered by the selected Accounting Schema’s currency and calendar.<\/li>\n\n\n\n
  • The Reconciled checkbox shows whether a Fact_Acct row has already been matched.<\/li>\n\n\n\n
  • Selected records can only be processed when the Difference field equals zero.<\/li>\n\n\n\n
  • Organization value “*” includes Fact_Acct records across all organizations in the schema.<\/li>\n\n\n\n
  • Business Partner and Product filters narrow results to a specific subledger dimension.<\/li>\n\n\n\n
  • Account Date range restricts reconciliation to a specific posting period.<\/li>\n\n\n\n
  • Process action sets IsReconciled = Y on all selected Fact_Acct records.<\/li>\n\n\n\n
  • Reset clears current filters and the selected result set without saving changes.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Accounting Schema configured with a valid Calendar and Currency.<\/li>\n\n\n\n
    • GL Journals or source documents posted so Fact_Acct records exist.<\/li>\n\n\n\n
    • Organization structure configured for the client.<\/li>\n\n\n\n
    • Chart of Accounts and Account (Element Value) configured.<\/li>\n\n\n\n
    • Business Partner and Product master data configured, if filtering by these fields.<\/li>\n\n\n\n
    • User role has read\/write access to the Accounting Fact Reconciliation form.<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n
      Menu \u2192 Performance Analysis and Accountig  \u2192 Accounting Fact Reconciliation (manual)<\/strong><\/code><\/pre>\n\n\n\n
      \"TenthPlanet-iDempiere-Form-AccountingFactReconcilation(Manual)-1\"<\/figure>\n\n\n\n
      Opening the form displays filter fields at the top \u2014 Accounting Schema, Organization, Account, Business Partner, Product, Reconciled, and Account Date range \u2014 with an empty results grid below until Refresh is clicked.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Form-AccountingFactReconcilation(Manual)-2\"<\/figure>\n\n\n\n
      Configuration Steps<\/strong><\/h2>\n\n\n\n
      Step 1: Select the Accounting Schema<\/strong><\/h3>\n\n\n\n
      Fact_Acct records are schema-specific; selecting the schema scopes reconciliation to the correct ledger and currency.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Choose an Accounting Schema, such as “POTS UN\/38 Indian Rupee”, from the dropdown. This is mandatory before running a search.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Accounting Schema<\/td>POTS UN\/38 Indian Rupee<\/td>Defines the ledger, currency, and calendar used for reconciliation.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 2: Apply Organization and Account Filters<\/strong><\/h3>\n\n\n\n
      Narrowing by Organization and Account focuses reconciliation on a specific business unit or GL account.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Select an Organization (“*” for all organizations) and, if needed, an Account to reconcile a specific account such as a bank or clearing account.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Form-AccountingFactReconcilation(Manual)-3\"<\/figure>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Organization<\/td>(*)<\/td>Restricts results to one organization or includes all organizations.<\/td><\/tr>
      Account<\/td>P_ASSET_Product asset<\/td>Filters Fact_Acct rows to a specific GL account.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 3: Filter by Business Partner or Product (Optional)<\/strong><\/h3>\n\n\n\n
      Useful for subledger reconciliation, such as AR\/AP by customer or vendor, or inventory by product.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Enter a Business Partner or Product to isolate Fact_Acct entries tied to that partner or product.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Business Partner<\/td>(blank)<\/td>Filters facts linked to a specific customer or vendor.<\/td><\/tr>
      Product<\/td>(blank)<\/td>Filters facts linked to a specific product.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 4: Set the Account Date Range<\/strong><\/h3>\n\n\n\n
      Limits reconciliation to a specific accounting period, such as the month being closed.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Enter a From and To Account Date, for example 01-06-2026 to 30-06-2026, to reconcile a single period.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Form-AccountingFactReconcilation(Manual)-4\"<\/figure>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Account Date (From)<\/td>01-06-2026<\/td>Start of the reconciliation period.<\/td><\/tr>
      Account Date (To)<\/td>30-06-2026<\/td>End of the reconciliation period.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 5: Refresh to Retrieve Fact_Acct Records<\/strong><\/h3>\n\n\n\n
      The results grid stays empty until the filters are applied and the search executes.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Click the Refresh button (circular arrow icon) to load the matching Fact_Acct records into the grid below.<\/p>\n\n\n\n
      Step 6: Review Records and the Difference Field<\/strong><\/h3>\n\n\n\n
      The Difference field shows whether the selected debit and credit entries balance to zero.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Review each row and confirm the Difference field reads 0 before marking records as reconciled.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-Form-AccountingFactReconcilation(Manual)-5\"<\/figure>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Reconciled<\/td>Unchecked<\/td>Shows the current reconciliation status of a row.<\/td><\/tr>
      Difference<\/td>0<\/td>Net debit\/credit variance of the currently selected records.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 7: Drill Down with Accounting Fact or Document Zoom<\/strong><\/h3>\n\n\n\n
      Confirms the source posting or originating document before committing the reconciliation.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      Select a row, then click Accounting Fact to view the GL posting, or Document Zoom to open the originating document.<\/p>\n\n\n\n
      Step 8: Process the Reconciliation<\/strong><\/h3>\n\n\n\n
      Commits the match and sets IsReconciled = Y on the selected Fact_Acct records.<\/p>\n\n\n\n
      Instructions<\/strong><\/em><\/h3>\n\n\n\n
      With Difference at 0, click Process to mark the selected records as reconciled. Use Reset to clear filters and start over.<\/p>\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>
      Grid stays empty after filtering.<\/td>Refresh not clicked, or no Fact_Acct records exist for the filters.<\/td>Click Refresh; confirm documents are posted for the selected schema and date range.<\/td><\/tr>
      Difference field is not zero.<\/td>Selected records include unbalanced or partially reconciled postings.<\/td>Narrow filters by Account or Business Partner and re-select matching debit\/credit pairs.<\/td><\/tr>
      Process button stays disabled.<\/td>No records selected, or Difference is not zero.<\/td>Select rows in the grid and confirm Difference equals 0 before processing.<\/td><\/tr>
      Expected records missing from results.<\/td>Wrong Organization or Account Date range selected.<\/td>Set Organization to “*” and widen the Account Date range.<\/td><\/tr>
      Records reconciled by mistake.<\/td>Process run without reviewing Document Zoom details first.<\/td>Reconciliation is manual; involve an administrator to correct the record if needed.<\/td><\/tr>
      Business Partner or Product filter returns no rows.<\/td>Value is not linked to any Fact_Acct entry in the schema.<\/td>Clear the filter and confirm the partner or product appears on posted documents.<\/td><\/tr>
      Accounting Schema dropdown shows no valid entries.<\/td>Accounting Schema not configured for the client or role.<\/td>Configure Accounting Schema under General Rules \u2192 Accounting Rules.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Review the General Ledger Journal for the reconciled period.<\/li>\n\n\n\n
      • Configure Bank Statement Matching for bank account reconciliation.<\/li>\n\n\n\n
      • Run Financial Reports to confirm subledger-to-GL balances.<\/li>\n\n\n\n
      • Set up Period Control to close the reconciled accounting period.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
        Introduction Accounting Fact Reconciliation (manual) is a Form in iDempiere Core used to compare GL Journal Fact_Acct entries against the […]<\/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-20477","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\/20477","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=20477"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20477\/revisions"}],"predecessor-version":[{"id":20491,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20477\/revisions\/20491"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}