Financial Payment Details Report

Financial Payment Details Report

This financial report shows payment details for each Payment Account in Cin7 Core. 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 authorized users using the Report Scheduling feature available to Cin7 Core 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.

 

Prerequisites

 

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

Input:

Account Code

Select the account to show transaction details for.

Reporting Period

Allow user to select the reporting period from a list of options are set custom a custom date range

Layout

Set to the Default layout. Allows selection of saved layouts, if any.

Save Layout As

Allows saving of a layout for potential future use.

Reset Layout

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

Fields

Account

Select a payment account in Cin7 Core or select All Accounts

Supplier/Customer Name

The name of the supplier or customer who made or received the payment

Date

Date 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 Total

Invoice/Credit note/Expense etc. document total

Currency

Bank account currency

Data Header

Amount

Monetary amount of payment in document currency

Base Currency Amount

Monetary amount of payment in base currency

 

Was this article helpful?

Have more questions? Submit a request