Billing review
Chemical billed by day
Priced chemical delivered each day. Hover a bar for details.
By customer
What's priced and what still needs a price. Click a column to sort.
Items that need a person
Every entry with no price yet, or that the system couldn't read. "See sheet" opens the ND Deliveries sheet at that cell.
By well
Each well or site for the month. Click a column to sort.
What the columns mean, and what's left out
- Chemical billed
- Gallons on each stop times that customer's price for the product on that date.
- Stop charges, no price
- Entries like "35 S&P/12": a stop charge plus propane for the flush water (1 gallon per 2 bbls). Counted here until a stop charge price is set for that customer.
- Special deliveries, no price
- Parts, pails, call-outs and other items from the sheet's special delivery columns.
- Chemical, no price
- Chemical delivered with no price for that customer and product.
- To review
- Plain "X" marks with no amount, and text the system couldn't read as an amount.
- Call-outs and rentals
- Call-out hours written on the sheet (for example "3 Hr Call Out") at the hourly rate, and day rates such as the mobile unit, once those rates are set.
- Left out
- "Did not treat" entries and voided stops, which are never billed. Stop charges, propane and parts are not in the dollar figures until their prices are set.
Gross profit
Chemical cost only: no labor, trucks, freight or overhead. Only products with a known recipe or cost are counted; the rest is listed below as not costed yet.
By customer
Margin is shown only on the part that can be costed. Click a column to sort.
By well
Each well or site for the month.
Products with no cost yet
All months since July. Each needs a recipe or a purchase cost before its margin can be shown.