A NEW ERA OF INTELLIGENT QUANTITATIVE ECOMMERCE - THAT WORKS FOR YOU ECOMMERCE - THAT WORKS FOR YOU
Knowledge Base
+
Admin Messages (1)
+
Common Tasks (1)
+
Insights (1)
+
Interventions (1)
+
Languages (1)
+
Questions & Answers (1)
+
Reviews (1)
+
Site Scripts (1)
+
Web Services (1)

Financial Reports

How Tos (1)

You can find this section under Statistics > Financial Reports in the IRP Admin left navigation menu.

You use this section to create custom financial reports. You can select date ranges and grouping options for your reports, pick specific field types and include multiple filters such as Shipping Country, Language, Currency, Order Type, Payment Type, Order Status, Non Cancelled Orders, Completed Orders.

The Financial Report builder deals with two types of Financial Transactions: Money In and Money Out.

Money In Transactions appear when:

  • An Order is placed
  • An item is subsequently added to an Order that has already been placed
  • Manual Charges are performed against an Order

Money Out Transactions appear when:

  • An Order is completely Cancelled / Refunded
  • 1 or more Individual Items are Cancelled from an Order
  • 1 or more Individual Items are Returned from an Order
  • Manual Refunds are performed on an Order

The Financial Report Builder is not dependent on when an Order was placed but is dependent on when the actual Transaction was performed. For example, if an Order was placed on the 1st Jan and a subsequent Refund was performed on the same Order on the 1st Feb, the Refund and Tax associated with it would be Time Stamped on the 1st Feb.

The functionality covers all Financial Transactions processed by the IRP, and all Order Statuses. Transacted Amounts and Goods Amounts are differentiated as the IRP does not assume that items are being Charged / Refunded at the same rate as they have been added to / removed from an Order. This differentiation is clearly spelt out when Financial Reports are being generated.

When an Order is placed, the IRP calculates the Goods In value as:

Value of All Items + Value of Shipping

The IRP then calculates the Goods Tax value as:

Tax of All Items + Shipping Tax

The same principle works for Money Out transactions.

For more information about how tax is calculated on Orders, see How Tax is Calculated on Orders in the IRP.

The Financial Reports Screen

The main FinancialReports.aspx screen appears as follows:

Financial Reports main screen in IRP Admin

The screen shows the following details for each report:

  • ID: This is the unique ID of the report in IRP Admin. This is added automatically by the IRP.
  • Name: This is the name of the report.
  • Date Range: The date range can be: This Calendar Year, Last Calendar Year, This Calendar Year And Last, Last 12 Months, Last 6 Months, This Month, Last Month, Custom Date Range.
  • Group By: Reports can be grouped by: Month, Year, Day, Sum Over Time Period.
  • Fields: This shows the number of fields included in the report.
  • Filters: This shows the number of filters included in the report. These might include Shipping Country, Language, Currency, Order Type, Payment Type, Order Status, Non Cancelled Orders, Completed Orders.
  • Download: Click this button to download a report in MS Excel format.
  • Edit: Click this button to edit the details of a report. For more information, see the How To Add or Edit a Financial Report article in this section.


How To Guides (1)


Copyright © 2018 IRP Commerce. Use of this website constitutes acceptance of the IRP World Terms of Use, IRP Privacy Policy and IRP Cookie Policy
IRP Commerce is a Trading Name of Export Technologies Limited, a Deloitte Fast 50 Company six times: 2010, 2011, 2012, 2013, 2014 & 2018   Deloitte.