All Collections
Figure: Detailed Use
Reports
Financials on Orders page: Total - Subtotal - Revenue
Financials on Orders page: Total - Subtotal - Revenue

The financial columns are not matching up when comparing the main Orders page to the corresponding export.

Ned Creed avatar
Written by Ned Creed
Updated over a week ago

On the main Orders page, there is a row towards the top with seven financial headers:
>Total
>Credits
>Discounts
>Tax
>Shipping
>Average
>Revenue
These headers are the financial breakdown of the orders being displayed on the page.

When you export that list of orders (selecting the check box next to the orders and using the “Choose an Action” drop down menu to access the “Order Totals Export .csv”) you will see these six financial headers in the spreadsheet, starting at Column AR:
>Subtotal
>Credits
>Discount
>Shipping
>Tax
>Total

**Very Important** Please be aware that “Subtotal” is not shown on the main Orders page in Figure and “Revenue” is not shown in the corresponding “Order Totals Export”.

When comparing the main Orders page and the export, the cells for Credits, Discounts, Shipping, and Tax will match up exactly.

On the main Orders page:
>Revenue: Represents the Subtotal minus Credits and minus Discounts.
>Total:
Represents the Subtotal plus Shipping and plus Tax.

In the corresponding export spreadsheet:
>Subtotal in column AR: Represents the Revenue plus Credits and plus Discounts.
>Total in column AW: Represents the Subtotal minus Credits and minus Discounts, then adding Shipping and adding Tax.

All the numbers will match up, it is just a different set of parameters that make up the “Total”.

Below is a color coded example.

Did this answer your question?