{"section":"tutorials","requestedLocale":"en","requestedSlug":"understanding-the-value-of-approved-revenues","locale":"en","slug":"understanding-the-value-of-approved-revenues","path":"docs/en/tutorials/orders/all-orders/understanding-the-value-of-approved-revenues.md","branch":"main","content":"For VTEX, every financially approved order has its total amount considered as revenue, including shipping costs and taxes applied to the final product price. All orders that go through this status are included in the invoice, regardless of subsequent cancellation or return.\n\n## 1. Understanding revenue on VTEX\nTo understand the invoice, you need to understand the definition of revenue. On VTEX, all orders marked as **approved** in the Orders module are considered revenue. This includes:\n\n- Order total including shipping and taxes.\n- Canceled orders, including those denied by the anti-fraud solution.\n- Purchase tests.\n\nAll the above cases use the whole platform infrastructure because this is the stage when a customer completes the purchase. This is why these orders are included in the revenue.\n\n### Identifying when an order is marked as approved\nAn order is marked as approved when the payment is authorized. The process varies based on the payment method used for the order:\n\n- **Credit card:** The order is marked when the acquirer validates the balance and card information.\n- **Pix and boleto (Brazil):** The order is marked only after payment confirmation.\n\nOnce an order is marked as approved, VTEX no longer considers changes to the order for billing purposes.\n\n## 2. Exporting the invoice financial report\nThe financial report includes **all approved orders** in the period corresponding to the invoice, considering only the environment from which it's exported. If you have multiple environments, you must export a report for each one. After export, the report will be sent to your email shortly.\n\nThe **Invoices module** generates the financial report. To export it, follow the steps below:\n\n1. In the VTEX Admin, click the initial of your email address at the top right corner.\n2. Click **Billing  Invoices**, or type **Invoices** in the search bar.\n3. Select the desired invoice.\n4. Click `Financial Report`.\n\n> ℹ️ The financial report is static and doesn't change after it's generated. You can access it at any time to view the revenue.\n\n## 3. Analyzing and manipulating the financial report\nThe financial report is in **CSV** format with several columns detailing each order. To validate the invoice values, apply **filters to the columns** in the report, following the criteria below:\n\n### Filtering and calculating the transacted GMV\nUse the `=SUMIF` function in Excel to calculate the total number of orders in different scenarios:\n\n| **Revenue type**                          | **Applied filters**                                               | **Summed column**              | **Description**                                                                                              |\n|-------------------------------------------|-------------------------------------------------------------------|--------------------------------|--------------------------------------------------------------------------------------------------------------|\n| Certified marketplace                     | `IsCertifiedMarketplace (Q) = True (T)`                           | `Value STR (G)` or `Value (F)` | `Value STR` contains the total of each order in 00,00 format and `Value` contains the total in 00.00 format. |\n| External seller                           | `IsExternalSeller (S) = True (T)`                                 | `Value STR (G)` or `Value (F)` | `G` or `F` indicate the column used for the sum.                                                             |\n| B2B                                       | `IsB2B (O) = True (T) and IsCertifiedMarketplace (Q) = False (F)` | `Value STR (G)` or `Value (F)` | `O` and `Q` are report columns.                                                                              |\n| B2C                                       | `BillingType (O) = B2C`                                           | `Value STR (G)` or `Value (F)` | Filters are applied per column.                                                                              |\n| Internal certified seller & child account | `IsInternalCertifiedSellerAndIsChildAccount (AF) = True (T)`      | `Value STR (G)` or `Value (F)` | `T` and `F` indicate boolean values (True or False).                                                         |\n\nThese filters allow you to segment the data and ensure that each order category is accounted for correctly on the invoice.\n\n## 4. Compare the data in the financial report with the data in the Orders module\nAlthough the **financial report** is the official source for validating invoices, you can compare this information with the **order report** to get more details about the invoiced orders.\n\n### Exporting the orders report for review\nIn this section, you will see the process of exporting the generated report, including the formats available for download and how to access it later.\n\n1. In the VTEX Admin, go to **Orders > All Orders** or type **All Orders** in the search bar.\n2. Filter by **Authorized date** from the first day of the desired month to the first day of the following month, both at 12:00 AM.\n3. Click `Use my time zone` to disregard the time zone.\n4. Click `Apply`.\n5. Click `Export`.\n\nAfter downloading the report, use the **OrdersIDs** to compare the information with the financial report."}