Customer Payment Summary Report

This report shows a payment summary for your customers, with total invoiced, paid and still due/credited for the selected time period. Output currency can be changed. This report does not break down totals by order/invoice.


Prerequisite

Table of Contents


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


You can also print or email customer statements for unpaid or outstanding balances.


Input:

Reporting PeriodAllows the user to select the reporting period from a list of options or set a custom date range. This report is filtered by invoice date. Note that only payments made within the reporting period will be shown. 
CurrencyAllows the user to select the currency to be used in the report.
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving a layout for potential future use.
Reset LayoutResets the 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. You may have to open the More Fields dropdown menu to add some of them to your report. 


Fields
CustomerCustomer name
Customer Tags
Comma-separated customer tags
Customer Additional Attributes 1-10
Values of customer additional attributes
Last Invoice Date
Date of last invoice issued to the customer
Last Payment DateDate of last payment from the customer
Data Headers
Total Invoice
Total invoice amount
Total PaidTotal amount paid of the invoice
Due/CreditAmount due or credited of the invoice
FX Gain/LossForeign exchange gains or losses


FAQs

[back to top]


I need a payment report that would provide a breakdown on payment method, amount, and warehouse location.  Where can I find such report, or should I create one?

Unfortunately as of the current design of DEAR, we don't have a report where we can have all three of your requirements in the same report. And also kindly note that DEAR records the payment based on the accounts not on the payment method.


As a workaround, I would like to suggest you to use the Customer Payment Detail report or Customer Payment Summary report, and the Sales Order Detail report or the Sales Overview report and merge those two reports together in Excel.


I really need the reports for the customer payment that included the date of payments. Could you please advise?

The Customer Payment Detail and Customer Payment Summary show the date of last payment. You can also check the sale activity statement for the customer to see their payments over a selected time period. 


Please could you advise what report I would run to be able to drill down and find what customer balance make up the Accounts Receivable amount on the balance sheet.

You could modify the sale overview report to view the information you require and save the layout for future reference.



Still no answer to your question? Please do not hesitate to get in touch with DEAR support.

Did you find it helpful? Yes No

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