Create a Tonnage Report

This topic explains how to create a report of landfill/transfer station tickets you have entered in Trash Flow, usually as part of completing roll-off work orders.

Before You Begin

You must have entered some landfill or transfer station tickets when completing a work order or making a container charge. Those tickets need to have a variable rate bill code (usually per ton) so Trash Flow will data to include.

Context

It's usual to enter the landfill ticket number and weight when charging customers for roll-off work, even if some tonnage is included. Some of that information is included in the posting report and on customer bills, but the tonnage report was added as a way for companies to see

  • how much trash they are dumping;
  • which materials are being dumped;
  • how much customers are being charged; and
  • where the trash is going.

Create the Report

  1. Click Reports > Financial Reports > Tonnage Report.
  2. Use the data filtering options (Account Type, Sales Tax District, Source Co., Billing Group, Geographic Region, and Business) to pick which accounts should be included in the report.
  3. Pick the Start Date and End Date desired for the report.
  4. Use the Unit of Measure and/or Single Unit of Measure fields, if desired, to narrow down whether the report should include bill codes for tons, pounds, cubic yards, per item, etc.
  5. Leave Exclude Blank UOMs checked unless you are specifically looking for bill codes used incorrectly.
  6. Set Include Landfill Info to "Yes" if you want to see the specific landfill/transfer station where each load was dumped.
  7. Leave Landfill at "All" or choose a specific landfill/transfer station from the dropdown.
  8. Check Detail Charges if you want the report to list each individual ticket. If unchecked the report will show the total dollar amount and tonnage recorded for each placement, but not the individual transactions that make up those totals.
  9. Check Include Cost Charges only if you use cost-type bill codes to track landfill costs to your business.
  10. Check Show Report Criteria if you might need to later refer to what options were chosen to generate the report.
  11. Click OK to view the report.

Sample Report

This is the last page of a sample tonnage report. Every customer included will have the account name and number on a gray background. Below is the container address and one line for each ticket entered. In this example U-STORE-IT had two containers dumped on March 6th. The first job was work order 282870. When the driver dumped at the landfill he was given ticket MET1341686 showing that the load was 9.54 tons. This was over the customer's four ton weight limit so when someone in the office completed the work order they charged the customer $332.40. The customer's total for the week was 18.81 tons for $648.60. (If the customer had containers at a different address the tonnage report would list a subtotal for each address before showing the Customer Total.

The final section lists each variable rate bill code that had activity in the requested date range, the number of charges made with it, the total tonnage (or pounds, cubic yards, etc.) across all customers

See Also

Completing a Work Order