Financial Summary

Overview
The Financial Summary is used to give an overview of The financial status of the business. It summarises Sales, Refunds, Purchases and Stock Value. Where an entry has a magnifying glass icon next to it, this will display additional information.

Table of Contents

Generating the Report

Report Length

The default period for a report is 1 month from the current date. This can be customised by clicking on the date range. Dates can either be typed in or selected from the calendar drop down. When you are happy with the report length click View Report.

Please Note! The maximum length for reporting is 90 days.

Report Currency

The dropdown menu on the right hand side of the screen allows you to select the currency you wish to see financial details for. Choosing a specific currency will only display financial transactions in that currency. Choosing Combined will show data in the default currency, which can be set in the General tab of General Settings. Please note that if the currency code set in Application Settings is not recognised, the combined option will not be available. A list of ISO 4217 Currency Codes is available here. In the case that there have been financial transactions in other currencies, they will be converted to the default currency using the current exchange rate, as provided by the European Central Bank.

Further Breakdowns

Any table or row title that contains a magnifying glass  can be clicked to get further information about that sub-set of the data. This data will be shown in a pop out menu and is grouped by day .

Report Sections

Sales Details

Selection Criteria:

  • Orders are included based on the ReceivedDate, which is the time and date the order was placed on the sales channel
  • Orders must be processed
  • The order status must be either; Paid, Return or Resend

Values Reported:

  • Subtotal: The sum of the order subtotals, sum of the line costs before tax, for all relevant orders
  • Tax: The sum of all tax, including tax paid on postage, for all relevant orders
  • Shipping (excl. Tax): This is the sum of all the postage costs, excluding tax, for all relevant orders

Negatives Details

Selection Criteria:

  • Orders refunded and actioned between the given dates to qualify for inclusion in this section

Purchases Details

Selection Criteria:

  • Purchase orders must be marked as delivered within the specified date range to be included in this report

Values Reported:

  • Subtotal: The sum of the purchase order subtotals, sum of the line costs before tax, for all relevant purchase orders
  • Tax: The sum of all tax, including tax paid on postage, for all relevant purchase orders
  • Shipping (excl. Tax): This is the sum of all the postage costs, excluding tax, for all relevant purchase orders
  • Returned: This is the value of stock returned to a supplier using the Partial Return feature in purchase order management

Stock Details

Selection Criteria:

  • All stock changes between the given dates will be taken into consideration

Values Reported:

  • Begin: The total stock value at the beginning of the report period
  • Shipped: This is the sum of the stock value that has been shipped by processing orders
  • Scrapped: This is the sum of the stock marked as scrapped, because of refunds, returns or exchanges
  • Returned: This is the value of stock returned, that is available to resell, during the specified date period
  • Added: Value of the stock with the following tags:
    • Fulfilment Sync SKUXXXXXXXX
    • Purchase Item OrderXXXXXXX
    • Stock Booked In directly XXXXXXX
    • Create item from XXXXXX inventory mapping
    • Imported from file
    • BATCH INSERT
    • Channel SKU Added
    • Stock level created from import file
    • OPENING STOCK
  • Adjusted: other processes that caused a change in stock value:
    • Change due to Order shipped
    • Change due to Item scrapped
    • Change due to Order return
    • Chage due to Fulfilment centre sync
    • Creation from inventory mapping
    • Purchase Order Item
    • Import from file
    • Opening stock
    • Channel SKU added
  • Subtotal: The difference between the stock values between the beginning of the report period and the end
  • End: The closing stock value