Payment Details Report

This financial report shows payment details for each Payment Account in DEAR. All data about payments, money tasks and bank transfer operations is included in the report.

NOTE: This report is different from the Customer Payment Details Report, which shows payment details for sales orders by customer. For more information, see Customer Payment Details Report.

The report is accessible to users with the following access levels:

  1. Sales Reporting
  2. Purchase Reporting
  3. Financial Reporting.

This report can be automatically generated and sent out to authorised users using the Report Scheduling feature available to DEAR customers with Automation module subscriptions. See Report Scheduling for more information.


The report inputs are shown in the table below.


Account Code

Payment account code
Beginning date of report
Closing/end date of report
Refreshes the report results based on the latest data
Apply Filter
Sets filter on fields used in the report
Allows export of report data to Excel, PDF or RTF
Set to the Default layout. Allows selection of saved layouts, if any.


After setting the inputs described above, pressing the Update button refreshes the report based on the selected inputs. The output fields are shown in the table below.

Column NameDescription
Payment AccountPayment account in DEAR
Supplier/Customer NameThe name of the supplier or customer who made payment
DateDate of payment
DocumentInvoice/credit note/purchase order/sale quote number, as related to payment. When clicked, the document is opened in another window.
ReferenceReference for payment
CurrencyBank account currency
Payment Amount in Document CurrencyMonetary amount of payment in document currency
Payment Amount in Base CurrencyMonetary amount of payment in base currency

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.