You currently have no notifications!
Close Menu

How can we help you?

Tell us more about your query, we'd be happy to help.
How did you hear about us?:
IRP Shopper
Common Tasks (1)
Interventions (1)
Languages (1)
Questions & Answers (1)
Reviews (1)
Site Scripts (1)
Subscriptions (1)
Web Services (1)
IRP Freshdesk
Training Videos
Peer Support

Financial Reports

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.

FinancialReports.aspx page

The main FinancialReports.aspx page appears as follows:

Financial Reports main page in IRP Admin

The page 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)

How To Add or Edit a Financial Report
Live Market Data
Today v Yesterday 0.12%
July 2024 v July 2023 15.82%
YTD 2024 v 2023 3.45%
Arts and Crafts 0.39%
Baby & Child 0.05%
Cars and Motorcycling 1.17%
Electrical & Commercial Equipment 0.06%
Fashion Clothing & Accessories 0.03%
Food & Drink 0.04%
Health and Wellbeing 0.03%
Kitchen & Home Appliances 0.17%
Pet Care 0.24%
Sports and Recreation 0.05%
Toys, Games & Collectables 0.17%

Copyright © 2023 IRP Commerce. Use of this website constitutes acceptance of the IRP World Acceptable Use Policy, IRP World Terms of Use, IRP Privacy Policy and IRP Cookie Policy

IRP Commerce Limited, Concourse 3, Catalyst, BT3 9DT, UK. Company Number: NI 041856. VAT Number: GB 888249658
A Deloitte Fast 50 Company eight times: 2010, 2011, 2012, 2013, 2014, 2018, 2019 & 2020