Basic Finance Export (Between Dates) - With Returns

This report is designed to provide basic information about the financial transactions (orders) that have taken place within a business. The status column will detail whether the order had a return associated with it. It includes Date, Source, Country, Tax and Payment Type for use by staff that need summary information on the business' income and tax liabilities (by Country, if necessary).

Selection Criteria

Linnworks will select the items to be included in the report based on the following criteria

Parameters - The following parameters can be used to configure this report

  • Date Range:
    • Start date: From the start of the day for the specified date
    • End Date: To the end of the day for the specified date

Rules - internal logic applied to extract only those records that fulfill the specified criteria

  • This report returns all processed orders where the received date lies between the given start and end dates
  • This report will state whether an order had items returned in the status field

Reported Values

The following values are returned by the report

Values - Column names and description

  • Order Date: The date and time at which the order was placed on the sales channel
  • OrderId: This is the Linnworks OrderID
  • Source: This is the channel the order has been downloaded or imported from. Orders placed within Linnworks will display as DIRECT
  • SubSource: The SubSource shows the specific integration the order was downloaded from
  • status: This is the status of the order, which can either be: Unpaid, Paid or Resend. If an order or part of an order was returned, the status will be appended with; WITH RETURNS
  • Processed Date: The date and time at which the order was processed in Linnworks
  • Billing Country: This is the name of the country used for billing purposes
  • Payment Method: This is the Linnworks payment method that has been applied to the order
  • Currency: This is the currency used on the order or set in the channel config for that sales channel
  • CountryTaxRate: This is the tax rate specified in the country list (Settings > Application Settings > Manage Country List). If no tax rate is given for the order country then the system default rate is used
  • Postage Cost: The shipping cost, as downloaded from the channel
  • Subtotal: This is the sum of all the line costs for the order, exclusive of tax
  • PostageCostExTax: This is the shipping cost excluding tax
  • Tax: This is the total amount of tax paid on the order
  • TotalCharge: This is the total cost of the order including tax and postage
  • TotalDiscount: This is the total discounted amount, in the order currency, for the order.