{"id":20504,"date":"2026-08-04T12:03:00","date_gmt":"2026-08-04T12:03:00","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20504"},"modified":"2026-08-20T10:32:03","modified_gmt":"2026-08-20T10:32:03","slug":"how-to-configure-payments-into-batch-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-payments-into-batch-in-idempiere\/","title":{"rendered":"How to Configure Payments into Batch in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Payments into Batch window in iDempiere lets finance teams group several individual payment or receipt documents into one batch record. It is used in store and head-office accounts payable and accounts receivable operations where multiple vendor payments or customer receipts are settled together.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once created, a Payment Batch is referenced in the Bank\/Cash Statement window, so a single bank line can be reconciled against many payments at once. This reduces manual matching effort and keeps store-level cash and vendor payment reporting accurate.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Process Flow<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"263\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Payments_Into_Batch.drawio-1024x263.png\" alt=\"\" class=\"wp-image-20684\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Payments_Into_Batch.drawio-1024x263.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Payments_Into_Batch.drawio-300x77.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Payments_Into_Batch.drawio-768x197.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Payments_Into_Batch.drawio-1536x394.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Payments_Into_Batch.drawio-2048x526.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\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>Only Active payments or receipts can be added as batch lines.<\/li>\n\n\n\n<li>Deposit Amount on the batch header is calculated as the sum of all line amounts.<\/li>\n\n\n\n<li>Document Type (AP Payment or AR Receipt) determines which payments can be added to the batch.<\/li>\n\n\n\n<li>A batch must be Completed before it can be selected during bank statement reconciliation.<\/li>\n\n\n\n<li>Negative line amounts represent outgoing vendor payments; positive amounts represent incoming receipts.<\/li>\n\n\n\n<li>Each payment can belong to only one Payment Batch at a time.<\/li>\n\n\n\n<li>Line No controls the display sequence of payments inside the batch.<\/li>\n\n\n\n<li>Processed flag is set automatically once the batch document is completed.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Prerequisites<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Business Partner (vendor or customer) configured.<\/li>\n\n\n\n<li>Organization (store or branch) configured.<\/li>\n\n\n\n<li>Bank Account configured for deposits or vendor payments.<\/li>\n\n\n\n<li>Document Type configured for AP Payment or AR Receipt.<\/li>\n\n\n\n<li>Individual Payment or Receipt documents already entered and completed.<\/li>\n\n\n\n<li>Currency configured and matching the payments being grouped.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Navigation<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Menu \u2192 Open Items (Financial Movements and Aging) \u2192 Payments into Batch<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Configuration Steps<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Create the Batch Header<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open Payments into Batch, click New, select Organization and Bank Account, set Deposit Date and Document Type, then Save the header before adding lines.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Bank Account<\/td><td>Vendor Payment_Vendor Payment_123456<\/td><td>Bank account the batch payments are drawn from or deposited to.<\/td><\/tr><tr><td>Document Type<\/td><td>AP Payment<\/td><td>Defines whether the batch groups vendor payments or customer receipts.<\/td><\/tr><tr><td>Deposit Date<\/td><td>07\/13\/2026<\/td><td>Date the grouped payments are deposited or transferred.<\/td><\/tr><tr><td>Document No<\/td><td>1000000<\/td><td>System-generated batch document number.<\/td><\/tr><tr><td>Currency<\/td><td>INR<\/td><td>Currency applied to all lines added to the batch.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"515\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-Payments-Into-Batch-1-1024x515.png\" alt=\"\" class=\"wp-image-20507\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-Payments-Into-Batch-1-1024x515.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-Payments-Into-Batch-1-300x151.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-Payments-Into-Batch-1-768x386.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-Payments-Into-Batch-1-1536x773.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-Payments-Into-Batch-1-2048x1030.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Add Payments to Batch Lines<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Go to the Lines tab, use Create Lines From to select completed payments, or add a line manually and pick the Payment record. Save each line.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Deposit Batch<\/td><td>07\/13\/2026_1000000<\/td><td>Reference back to the parent batch header.<\/td><\/tr><tr><td>Line No<\/td><td>10<\/td><td>Sequence number of the payment within the batch.<\/td><\/tr><tr><td>Payment<\/td><td>1000008_07\/07\/2026_708.00_-1<\/td><td>The individual payment document linked to this line.<\/td><\/tr><tr><td>Payment amount<\/td><td>-708.00<\/td><td>Amount of the linked payment, negative for outgoing vendor payments.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"382\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-Payments-Into-Batch-2-1024x382.png\" alt=\"\" class=\"wp-image-20506\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-Payments-Into-Batch-2-1024x382.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-Payments-Into-Batch-2-300x112.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-Payments-Into-Batch-2-768x287.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-Payments-Into-Batch-2-1536x573.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-Payments-Into-Batch-2-2048x764.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Review the Deposit Amount<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Check that Deposit Amount on the header equals the expected total of all lines, for example -258,390.50 for six grouped vendor payments.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Complete the Batch Document<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Click Document Action on the header, select Complete, and confirm. Document Status changes from Drafted to Completed and Processed is checked.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5: Use the Batch in Bank Statement Reconciliation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open Bank\/Cash Statement, select the matching statement line, and choose the Payment Batch reference instead of an individual payment.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Issue<\/strong><\/td><td><strong>Cause<\/strong><\/td><td><strong>Resolution<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Deposit Amount does not match bank slip<\/td><td>Wrong or extra payment added to a batch line<\/td><td>Remove the incorrect line and re-add the correct payment via Create Lines From<\/td><\/tr><tr><td>Payment missing from Create Lines From list<\/td><td>Payment not yet completed or already assigned to another batch<\/td><td>Complete the payment and confirm it is not linked elsewhere<\/td><\/tr><tr><td>Currency mismatch on save<\/td><td>Batch currency differs from the payment currency<\/td><td>Match the bank account currency to the currency used on the payments<\/td><\/tr><tr><td>Batch not available during reconciliation<\/td><td>Batch document still in Drafted status<\/td><td>Run Document Action \u2192 Complete on the batch header<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Next Steps<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Bank\/Cash Statement window \u2013 reconcile the completed batch against actual bank lines.<\/li>\n\n\n\n<li>Payment (Receipt) window \u2013 review or create the individual payments before batching.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The Payments into Batch window in iDempiere lets finance teams group several individual payment or receipt documents into one batch [&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-20504","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\/20504","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=20504"}],"version-history":[{"count":5,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20504\/revisions"}],"predecessor-version":[{"id":27993,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20504\/revisions\/27993"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}