Customer Payment Details Report

This report shows payment details by customer with invoiced, paid, still due/credited for the selected time period. Output currency can be changed. Use the detailed view to see payment details for each order/invoice.

Users need the Sales Reporting permission to access this report.

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

Before you start

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

Input:

Input Description
Reporting Period Allows 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.
Currency Allows the user to select the currency to be used in the report.
Layout Set to the Default layout. Allows selection of saved layouts, if any.
Save Layout As Allows saving a layout for potential future use.
Reset Layout Resets 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 Cin7 Core 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 Configure Layout menu to add some of them to your report.

Fields

Field Description
Customer Customer name
Invoice # Invoice Number identifying the sale invoice
Invoice Date Invoice issue date
Due Date Date when the invoice is due for payment
Sales Representative Name of the sales representative associated with the sale
Year Year of the invoice date
Quarter Quarter of the invoice date
Month Month of the invoice date
Customer Reference Customer reference from the sale document header
Customer Tags Comma-separated customer tags
Customer Additional Attributes 1-10 Values of customer additional attributes
Shipment Date Shipment date for the Sale Order
Shipping Address 1 Line 1 of the shipping address
City Shipping address city
State Shipping address state
Country Country location of the customer
Postcode Shipping address postcode

Data headers

Data header Description
Total Invoice Total invoice amount
Total Paid Total amount paid of the invoice
Due/Credit Amount due or credited of invoice
FX Gain/Loss Foreign exchange gains or losses

Note: If you have added an Additional Attribute set to your sale process, the attributes will appear as additional report fields.

FAQs

Can we include the payment collection date in Customer Payment Details Report?

This is not an available feature on the Customer Payment Details report, however can be requested in our feature request forum. You may want to try the Customer Payment Summary report, which shows the last payment collection date.

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 Cin7 Core, we don't have a report where we can have all three of your requirements in the same report. And also kindly note that Cin7 Core 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.

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

Was this article helpful?

Have more questions? Submit a request