Use the Lock Box to Enter Payments

This topic explains how to take a comma-separated value (CSV) list of payments and enter them in Trash Flow all at once.

Context

The Lock Box isn't used often anymore, but it provides a way to take a list of payments in a CSV file and import them into Trash Flow. Its original use was for customers who pay their trash bill at a bank branch. The bank then sends the hauler a list of new payments that can be imported into Trash Flow. The Lock Box function can also be used to enter electronic payments from sources like Square, Merchant Services, etc.

Before You Begin

You will need a CSV file with one payment per row. The columns should be set up as follows.

  • Column 1: Customer account number;

  • Column 2: Payment amount;

  • Column 3: Leave empty OR customer name;

  • Column 4: Check number.

Import the Payments

  1. Click Billing > Lock Box Update.
  2. A new window appears. Choose whether to Include name? and click OK.
  3. Choose the file to import and click OK to import the payments.
  4. Trash Flow shows a confirmation message with the total amount of payments reported. A detailed report of the payments then appears.

When You're Done

The payments will all be entered on the current business date on customer accounts.