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