Skip to main content

Understanding the Orders Report

Walkthrough of the Orders report's 11 filters, summary tiles, and every column in the Orders detail table.

The Orders report gives you a complete view of every order (also called a transaction) — what was requested, its current status, how it was paid for, and every fee and charge that makes up its total.

ℹ️ Good to know: At the bottom of the report, an "Updated" card shows the last time the data refreshed — use it to confirm how current the numbers you're looking at are.

Step 1 — Filter Your Data

Across the top of the report are eleven filters. You don't have to use all of them — leave any filter blank and it simply won't narrow anything down.

Filter

What it does

Data Source

If your account pulls orders in from more than one source, this narrows the report down to a specific one.

Request Status

Filters by the order's status (like Reservation Request, Reservation Approved, On Rent, or Rental Ended). Supports selecting multiple statuses at once.

Requested Date

Filters to orders requested within a date range you choose. Defaults to "Previous 30 days" when you first open the report.

Rental Start

Filters to orders whose rental started within a date range you choose.

Rental End

Filters to orders whose rental ended within a date range you choose.

Location

Narrows the report to one or more specific yards or branches.

Customer

Narrows the report to one or more specific customers.

Order Type

Filters by the type of order, such as a rental versus a sale.

Shipping Type

Filters by how the order was fulfilled — delivery, pickup, or self pickup.

Payment Method

Filters by how the order was paid for.

Sales Rep

Filters to orders handled by a specific sales representative, where that's tracked.

Working with Date Filters

Requested Date, Rental Start, and Rental End are all date filters, and clicking any of them opens the same style of menu: a quick preset (Today, Yesterday, Previous 7 Days, and similar), a Fixed Date Range for an exact start and end date, or a Relative Date Range that automatically stays current as time passes.

Step 2 — Read the Summary Tiles

The tiles across the top break your filtered orders down several ways:

  • Grand Total — the combined value of every order in the filtered period.

  • Grand Total: Rental — the portion of that total from rental orders.

  • Grand Total: Sales — the portion from sales orders. Shows blank if there are no sales orders in the filtered period.

  • Orders — how many orders make up the filtered period.

  • Product Fees, Additional Fees, Taxes, Delivery Fees, Damage Waivers, Coupons or Discounts, Upcharges, and Refunds — each breaks out that specific charge type across the filtered orders.

Step 3 — Use the Orders Table to Find a Specific Order

Below the tiles, the Orders table lists every order behind those numbers, with dozens of columns you can scroll through, sort, or search. The main ones you can look up or sort by:

Column

What it tells you

Order Number

The unique identifier for the order.

Customer Name

Who placed the order.

Location Name

Which yard or branch the order came from.

Requested At

When the order was requested.

Rental Start At / Rental End At

When the rental began and ended.

Request Status

The order's current status.

Order Type

Rental, sale, or another order type.

All Shipping Types

How the order was or will be fulfilled.

Payment Method / Payment Method Detail

How the order was paid for, and any additional detail like the card type.

Product Names / Unit Numbers

Which products and specific units were on the order.

Total Quantity

How many units were on the order.

Subtotal

The order's value before fees and taxes.

Product Fees / Additional Fees

Fees tied to specific products or added to the order.

Tax Amount

Tax charged on the order.

Delivery Amount / Pickup Amount

Delivery and pickup charges on the order.

Damage Waiver Amount

The damage waiver fee charged, if applicable.

Cart Total

The order's total before any coupon is applied.

Additional Discount Amount

Any additional discount applied to the order.

Coupon Code / Coupon Discount Amount

The coupon used on the order, if any, and how much it discounted.

Grand Total

The order's final total after every fee, tax, and discount.

Billing Address / Delivery Address

Where the customer is billed, and where the order was or will be delivered.

Notes / Internal Notes

Notes on the order — Notes are customer-visible, Internal Notes are for your team only.

PO Number

The customer's purchase order number, if they provided one.

Sales Representative

Who on your team handled the order, where that's tracked.

Downloading Report Data

Every module on the report — tiles and the Orders table alike — has a menu in its top-right corner. Click it and choose the download option to export that module's results on their own, without needing to download the whole report.

Need Help?

Contact Quipli support ([email protected]) if you:

  • See an order total that doesn't match what you'd expect.

  • Notice an order stuck in a status that doesn't reflect what actually happened.

  • Need help reconciling this report against QuickBooks or another accounting system.

Did this answer your question?