Financials

The Financials report category includes a sub-set of reports specific to accounting. The Financials option generates a corresponding list of standard reports that are populated in the Standard Reports drop-down. These financial reports use data drawn from the Accounting Summary table, which reflects shipped orders (orders that are assigned a ship date), for the purpose of accounting. All the reports under the Financials can be exported.

Important: If you are setup for accrual accounting (based on the financial transaction being recognized when the goods leave the store or warehouse) then you need to use the reports listed under the Financials drop-down list.

The list of financial reports are described in the table below.

Report	Description
Inventory Transactions	The Inventory Transactions provides visibility to a filtered view of all SKU history across all SKUs. Inventory transaction reasons codes are assigned against any action taken on a SKU. Reason codes are defined in the Inventory Transaction Reason Codes section.
*Orders Report	The Orders Report displays a list of all orders, grouped by sales channel, either created or shipped within a specified date range. Items are recognized once they are shipped. Any order level adjustments, discounts or shipping charges are applied against all order items regardless of having been shipped.
*Order Items Report	The Order Items Report displays a list of all orders and the order item details, grouped by sales channel, status, or brands that occurred within a specified date range.
Payments Report	The Payments Report displays a listing of all order payments applied within a specified date range. Payments can be filtered to display for one or all Sales Channels and Brands through which orders were placed. The “Transaction ID” values displayed represent the corresponding order transaction type, i.e., Amazon Order ID, Paypal or credit. Individual payment records can be hidden when grouping in the Payments Report so that only Group Totals are returned in the results. Once a Grouping option has been added, the Suppress Details checkbox displays below the grouping option(s). Uncheck the box to view the detailed payment records.
Promotions Report	The Promotions Report displays a list of all promotional discounts applied to orders, grouped by sales channel, shipped within a specified date range. Note: Selecting Units Sold or Units Returned requires grouping by order number, so you need to also select Order Number for your Results display. If you do not select Order Number an error is shown when the report is run.
*Return Items Report	The Returns Items Report displays a list of all orders and the returned item details, grouped by sales channel, status, or brands that occurred within a specified date range.
*Returns Report	The Returns Report displays a list of all returned orders, grouped by sales channel, status, or brands that occurred within a specified date range.
Sales Report	The Sales Report displays sales information, grouped by sales channel, for orders shipped within a specified date range.
*Sales Tax Report	The Sales Tax Report displays the total sales tax dollar amount by state for orders shipped within a specified date range. Sales tax is calculated at the time of order placement using defined sales tax rules.
Shipments Report	The Shipment Report displays a list of all orders shipped, total number of items shipped and total weight; grouped by status, method, or date within a specified date range.

*Note: If you are setup for accrual accounting, all changes to an order are reflected on the date in which they occur. For example, a return for an item purchased in a previous month is recognized on the date of the return and NOT backdated to the original sales date.

Additionally, if you enter in a "Ship Date" and the date entered is 1/1/19 (other than Ship date) The date that is recognized in reporting as "today's" date not the back date. Entering a date from the past has no effect on reporting.