Viewing Pre-Built Sales Reports

Admin: Corporate Admin
Page: Reports > Orders
URL: [CLIENTID].corpadmin.directscale.com/Corporate/Reports/Sales
Permission: ViewSales()

The Orders Reports page features specific data on sales-related activities in the system.

View each report by clicking the report’s name.

  Click the Export button to export any report; a CSV file will download. You can open it in any spreadsheet program (such as Microsoft Excel or Google Sheets).

Orders Reports

Orders tile
  You can access the order’s Detail and Associate’s Detail pages in the reports by clicking the Order Number or Name links respectively.

Total Sales

Total Sales report

The Total Sales report shows every order for the selected period and market.

The data is paginated; meaning, the entries are separated into different pages. By default, the report returns ten entries per page. To increase this amount, select either 10, 25, 50, or 100 from the Show entries drop-down.

Show entries drop-down

Each page displays the Page Totals that sum up the USD Subtotals and USD Totals for the currently viewed page and the Overall Totals for the currently selected period.

Page and Overall Totals section

Orders

Orders report

The Orders report displays all orders for the selected period and market. You can filter the results further by entering an Associate's Name, Customer ID, or even the Notes attached to the order. 

Invoices

Invoices report

The Invoices report is the same as the Orders report.

New Sales

New Sales report

With the New Sales report, view orders placed by new accounts/first-time customers for the selected period.

Recurring Sales

Recurring Sales report

With the Recurring Sales report, view orders from customers who’ve placed at least one order in the past.

Total Sales with Order Status (Legacy)

Total Sales with Order Status Legacy report

The Total Sales with Order Status (Legacy) is the same report as the Total Sales report, but with the addition of a Status column with each order’s current status (Paid, Pending, Shipped, etc.). 

Performance Reports

Performance tile

Autoship Summary & Forecast

Autoship Summary Status tab

The AutoShip Summary Status report displays a breakdown of the AutoShips processed for the period selected. This report provides you with a Message summary and the Associate Count for each message.

Selecting a message opens a slide-out panel reflecting each Associate's Name, Autoship ID, Order Number, Date, and Subtotal tied to the AutoShip message. 

Autoship Summary Forecast tab

The AutoShip Summary Forecast report shows the projected total of AutoShip orders that are scheduled to process during the selected period. See the Grand Total section for the total USD sum of the order forecast. 

Sales by SKU

Sales by SKU report

With the Sales by SKU report, view all orders for a specific inventory item SKU. The results sort by currency type.

To find a SKU:

  1. Select the period and market.

  2. Enter the SKU in the Item SKU field, and press Enter on your keyboard.

    The data table filters, showing only the queried SKU.

  3. Click the arrow to expand the row to view all the orders for the SKU.

Sales by SKU (Legacy)

Sales by SKU Legacy report

The Sales by SKU (Legacy) report is an older version of the Sales by SKU report with lesser functionality.

Sales By Order Type

Sales By Order Type report

The Sales By Order Type is the same report as the Total Sales report; however, this report can filter by a specific order type.

Order Type filter

Audit Reports

Audit tile

Returns & Refunds

Returns and Refunds report

With the Returns and Refunds report, view the orders that have a negative payment applied to their account.

Sales Tax Report

Sales Tax report

With the Sales Tax report, view all the order’s taxes paid filtered by specific cities.

Click the Details button to view each order’s tax details.

Order Tax Details pop-up
  You must set up a Tax Service Provider. Learn how with the Tax Provider Integration guide.

Abandoned Orders

Abandoned Orders report

When a logged-in Associate adds an item to the cart, doesn’t place an order, and leaves the site. After six hours, the order is considered "abandoned" and is displayed in this Abandoned Orders report.

Payments

Payments report

View all payments along with their associated Merchant, Type, and Status for the selected period in the Payments report. 

Total Payments

Total Payments report

View all payments and their total for the selected period in the Total Payments report.

Payments by Type

Payment Type report

The Payment Type report is the same as the Total Payments report.

Fallback Tax Reconciliation Report

Fallback Tax Reconciliation report

When a tax service goes down, every sale that doesn’t collect tax is recorded in the Fallback Tax Reconciliation report.

Learn more:

Other Reports

Other tile

Reports requested by you, built during the implementation stage before launch; these vary by client.

Was this article helpful?
0 out of 0 found this helpful
Previous Next

Comments

0 comments

Please sign in to leave a comment.