Create a Credit Report Export

This page explains how to create a credit report, a CSV file to show the average of charges and payments across a year, calculate how much time elapses between your charging customers and their paying it off, and comparing your revenue with any costs entered.

Context

This report is rarely run but it's available for companies that see it as useful. The CSV will always have the same columns in the same order, even if some of them are parts of Trash Flow you don't use. This is a list of the elements that affect this report's results.

  • The Credit Limit on a customer's Misc. tab. is set individually for each account. To most companies it means "it's fine if the customer owes us this much money or less; when it gets higher we need to collect some payment or stop service."
  • Charges and payments are pulled directly from customer accounts for all the revenue and aging calculations.
  • Materials are used by some companies to track how many tons of material each customer is dumping.
  • Costs refers here to "cost" bill codes used to track some of your operating expenses within Trash Flow. If the costs section is filled out when making container charges or completing work orders this report will use that information. See here for more information: Tracking Container Profitability.

Create the Report

  1. Click Reports > Financial Reports > Credit Report Export.
  2. Use the data filter fields to choose whether you want to include all customers or only a subset. The filters available here are Business, Billing Group, Sales Tax District, Geographic Region, Source Co., Business, and Include Ended.
  3. Click OK; Trash Flow will then ask you where to save the file and what to name it.

When You're Done

Open the CSV you created to review the report. Each row is a single customer account—the customer's name, account number, and whether they pay by Balance or by Invoice. Here's an explanation of the rest of the columns.

  • the customer's current Credit Limit;
  • their Maximum Credit—that is, the most money they owed you at any point in the year.
  • the average of all Charges, Payments, Materials, and Costs are calculated by dividing the total across the year by 12.
  • Avg. Days Credit/Cust, the average number of days between when you make a charge and when the customer pays it off.
  • a breakdown of how many months the customers were current and how many months they were late.
  • a further set of columns breaking down the information above for each of the past

See Also

Tracking Container Profitability

Enter Billing Codes