Billing Sheets
A Billing Sheet is a specialized transaction form (page) in cieTrade.net, typically used with the waste brokerage business workflow model to capture all of the customer service charges and related hauler expenses associated with a specific monthly billing for waste services. The ListBillingSheets API returns a list of Billing Sheet "header records" with fields such as Invoice number, invoice date, customer, service location, hauler or vendor, billing period and other details as a JSON data table. Each row in the result set is an instance of an individual Billing sheet for one customer, location and hauler over a specified period. The details of a specific billing sheet can be produced from the ListBillingSheetCharges API.
Request Example
https://api.cietrade.net/ListBillingSheets?UserID=ExampleUser@gmail.com&DateFrom=5/21/2024&DateTo=6/12/2024&DateType=Invoice&Account=TargetAccount&Location=TargetLocation&Dept=DeptID&Status=Status&Vendor=VendorName
Query Parameters (Filters)
| UserID | cieTrade.net User Name. | Required | |
| Account | Target Account. Use exact company name as defined, the Account ID or blank value for all accounts. | Optional | |
| Location | Target Location or blank value for all locations of the specified Account parameter (above). Cannot have a value without an Account parameter. | Optional | |
| DateFrom | Start of date range. Optional, if not provided, it will default to 30 days prior to today's date. | Optional | |
| DateTo | End of date range. Optional, if not provided, it will default to Todays Date. | Optional | |
| DateType | Inquiry date type either "Invoice" or "Transaction". Sets whether the date filter is based off Invoice Date or Transaction Date. if not provided, it will default to Invoice Date | Optional | |
| Dept | Department Filter Example: “00” as it is stored in cieTrade, or Department Short Name. This parameter is Optional, no default value if not provided. | Optional | |
| Vendor | Hauler or vendor servicing account. Pass the exact company name as listed in cieTrade or the vendor’s account ID. Blank value defaults to all. | Optional | |
| Status | Status filter. Accepted values: ‘Open’, ‘Completed’, ‘Approved’, ‘Posted’, ‘Not Approved’, ‘Cancelled’ A blank value will default to all statuses. | Optional | |
| AsOf | Returns all records that were last updated on and after this date. If other filter options are provided, they will be ignored if an AsOf date is provided. | Optional |
Response Example
{
"invoice_no": "512535",
"group_invoice_no": "",
"account_name": "TARGET",
"location_name": "#1001 STAMFORD STORE",
"department": "ALLEGHENY",
"hauler": "BLACK TRUCKS",
"status": "OPEN",
"billing_reference": "",
"invoice_date": "2024-06-13",
"posting_date": null,
"due_date": "2024-06-28",
"sales": "165.00",
"cost": "105.00",
"profit": "60.00",
"weight": "0.000",
"total_qtyuom": "L",
"owner": "cieTrade Admin",
"transaction_date": "2024-05-01",
"billing_address1": "TARGET",
"billing_address2": "21 Broad St",
"billing_city": "Stamford",
"billing_region": "CO",
"billing_postal_code": "06901",
"BillingUDF1": "",
"account_id": "43686",
"notes": "",
"LastUpdated": "2026-10-22"
}