NACM Export

The NACM Export is found at Accounting / Transfers / Export. This creates a text file which National Association of Credit Management (NACM) members can submit to report customer aged balances to banks or other entities.

The Output File Path determines where the file will be saved. Choose Select to tag certain Customers or Cust Class to choose the applicable Customer Classification(s).

Columns

Columns in the file created include:

Column Where to Find Information/Additional Details
  1. Customer ID
  2. Customer Name
  3. Address 1
  4. Address 2
  5. City
  6. State 
  7. Zip Code
  8. Phone Number
Customer's Profile tab
  1. Open Date
Date Opened (MM/YY) from Customer's Credit tab
  1. Report Date
System date when the file was created
  1. Last Sale Date
Most recent Invoice date (MM/YY)
  1. Balance
Total Regular - (Unapplied Cash + Prepay)
Customer's Monthly Balances tab
  1. Current
Open Invoices 0 or fewer days due less (UAC + Prepay)
  1. 1-30 Days Past Due
Open Invoices 1-30 days past due
  1. 31-60 Days Past Due
Open Invoices 31-60 days past due
  1. 61-90 Days Past Due
Open Invoices 61-90 days past due
  1. 91+ Days Past Due
Open Invoices 91 or more days past due

Columns M-Q above can be seen on the Customer Balances report (Accounting Reports / Accounts Receivable / A/R Status) with the Aged Balances 120 Day Style selected: