search-icon

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. Use this report to view detailed transaction information for the selected account such as customer/supplier, transaction reference, date, currency, payment total and value in base currency.


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.


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 is accessible to users with the following access levels:

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


Prerequisite:


Data from this report can be exported in Excel, PDF or RTF format. 


Input:

Account CodeSelect the account to show transaction details for.
Reporting PeriodAllow user to select the reporting period from a list of options are set custom a custom date range
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets layout to the default layout or selected saved layout.


Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters. 


Output:

The following output fields are available for this report.

Fields
AccountSelect a payment account in DEAR or select All Accounts
Supplier/Customer NameThe name of the supplier or customer who made or received the payment
DateDate of payment
Document #Invoice/credit note/purchase order/sale quote number, as related to payment. When clicked, the document is opened in another window.
Document TotalInvoice/Credit note/Expense etc. document total 
CurrencyBank account currency
Data Header
Amount Monetary amount of payment in document currency
Base Currency AmountMonetary 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.