{"id":21899,"date":"2026-07-23T11:15:18","date_gmt":"2026-07-23T11:15:18","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=21899"},"modified":"2026-08-21T05:58:41","modified_gmt":"2026-08-21T05:58:41","slug":"how-does-unreconciled-payments-report-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-does-unreconciled-payments-report-in-idempiere\/","title":{"rendered":"How does Unreconciled Payments Report in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Unreconciled Payments report provides detailed information about payments and receipts in iDempiere that have not yet been reconciled against a bank statement. It displays each payment transaction along with its bank account, transaction type, and amount details, helping users identify which payments still need to be matched during bank reconciliation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The report is mainly used by Finance and Accounts teams to review outstanding bank transactions, support the bank reconciliation process, and confirm that recorded payments match actual bank activity.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Business Rules<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The report retrieves data from the <strong>C_Payment_V<\/strong> report view.<\/li>\n\n\n\n<li>Each record represents a single payment or receipt transaction.<\/li>\n\n\n\n<li>Payment amount, discount amount, write-off amount, tax amount, and over\/under amount are automatically sign-adjusted based on transaction type: receipts are shown as positive amounts, while payments are shown as negative amounts.<\/li>\n\n\n\n<li>A multiplier field reflects the sign adjustment applied to each transaction based on whether it is a receipt or a payment.<\/li>\n\n\n\n<li>A payment is considered unreconciled when its <strong>IsReconciled flag<\/strong> on C_Payment is set to <strong>&#8216;N&#8217;<\/strong>, meaning it has not yet been matched to a bank statement line.<\/li>\n\n\n\n<li>Only payments with a <strong>non-zero<\/strong> payment amount are included in the report results \u2014 zero-amount transactions are excluded.<\/li>\n\n\n\n<li>The report is read-only and does not create or update payment data.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Report Parameters<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Unreconciled Payments &#8211; Parameter window<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Unreconciled Payments parameter window allows users to filter payment records before generating the report. Users can select Bank Account, Transaction Date, Transaction, and Transaction Type to display only the payment records that match the selected criteria.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"408\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment.png\" alt=\"TenthPlanet-iDempiere-Accounting-UnreconciledPayment\" class=\"wp-image-21900\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-300x120.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-768x306.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Parameter<\/strong><\/td><td><strong>Purpose<\/strong><\/td><td><strong>Filtering Behavior<\/strong><\/td><td><strong>Sample Data<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Bank Account<\/td><td>Selects the bank account the payment was made through.<\/td><td>Displays payment records for the selected bank account.<\/td><td>POS Cash Account<\/td><\/tr><tr><td>Transaction Date<\/td><td>Selects the payment transaction date or date range.<\/td><td>Displays payment records matching the selected date or date range.<\/td><td>01-Jul-2026 to 22-Jul-2026<\/td><\/tr><tr><td>Transaction<\/td><td>Selects a specific payment transaction (document).<\/td><td>Displays the selected payment transaction only.<\/td><td>PAY-1000045<\/td><\/tr><tr><td>Transaction Type<\/td><td>Selects the type of payment transaction (e.g. receipt, payment, transfer).<\/td><td>Displays payment records matching the selected transaction type.<\/td><td>Bank Statement Payment<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Report Output<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The Unreconciled Payments report displays one row per unreconciled payment or receipt. Each row shows the transaction amount signed according to whether it is a payment or a receipt, along with bank account and transaction type details.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The report includes the document number, bank account, transaction type, transaction date, currency, payment amount, reconciliation status, and document status. It helps users track outstanding bank transactions and follow up on items still awaiting reconciliation.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"422\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-1.png\" alt=\"TenthPlanet-iDempiere-Accounting-UnreconciledPayment-1\" class=\"wp-image-27064\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-1.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-1-300x124.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-1-768x317.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"422\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-2.png\" alt=\"TenthPlanet-iDempiere-Accounting-UnreconciledPayment-2\" class=\"wp-image-27065\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-2.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-2-300x124.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-2-768x317.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"422\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-3.png\" alt=\"TenthPlanet-iDempiere-Accounting-UnreconciledPayment-3\" class=\"wp-image-27066\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-3.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-3-300x124.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-3-768x317.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"422\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-4.png\" alt=\"TenthPlanet-iDempiere-Accounting-UnreconciledPayment-4\" class=\"wp-image-27068\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-4.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-4-300x124.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-4-768x317.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"422\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-5.png\" alt=\"TenthPlanet-iDempiere-Accounting-UnreconciledPayment-5\" class=\"wp-image-27069\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-5.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-5-300x124.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnreconciledPayment-5-768x317.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>The Unreconciled Payments report provides detailed information about payments and receipts in iDempiere that have not yet been reconciled against [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,58],"tags":[],"class_list":["post-21899","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-accounting"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21899","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=21899"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21899\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=21899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=21899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=21899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}