How does Unreconciled Payments Report in iDempiere

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.

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.

Business Rules

• The report retrieves data from the C_Payment_V report view.
• Each record represents a single payment or receipt transaction.
• 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.
• A multiplier field reflects the sign adjustment applied to each transaction based on whether it is a receipt or a payment.
• A payment is considered unreconciled when its IsReconciled flag on C_Payment is set to ‘N’, meaning it has not yet been matched to a bank statement line.
• Only payments with a non-zero payment amount are included in the report results — zero-amount transactions are excluded.
• The report is read-only and does not create or update payment data.

Report Parameters

Unreconciled Payments – Parameter window

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.

Parameter	Purpose	Filtering Behavior	Sample Data
Bank Account	Selects the bank account the payment was made through.	Displays payment records for the selected bank account.	POS Cash Account
Transaction Date	Selects the payment transaction date or date range.	Displays payment records matching the selected date or date range.	01-Jul-2026 to 22-Jul-2026
Transaction	Selects a specific payment transaction (document).	Displays the selected payment transaction only.	PAY-1000045
Transaction Type	Selects the type of payment transaction (e.g. receipt, payment, transfer).	Displays payment records matching the selected transaction type.	Bank Statement Payment

Report Output

• 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.

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.