Collections MAX

There are two file layouts.  One for credit cards and one for checks.

Sample for credit cards

"Date","Ref Num","Invoice","Card Holder","Amount","Status","Authcode","Errorcode","Reason"
"2010-02-18 09:45:31","222222222","33333333","KELLY REEVES","135.00","Approved","014550","","AP"

Sample for checks

(With checks (ACH) you need to open the return file in Excel and delete any empty columns.  Then re save it.)

Tran ID,Tracking Tran ID,Trans Status,Account,Check No,Ref,Name,SSN/ID,IHID,Import ID (Private Data),Type,Debit,Credit,Action,Schedule,Check Date,Eff Date,SC,Added By,Updated Date,Source,Source Date
55555555,56666655,Returned,******9166,,,MARK MAGUIRE,,442712,,TEL,$265.00 ,$0.00 ,Debit,,2/17/2010,2/17/2010,1,yourcompany,2/18/2010,crgg021710buyt.csv,2/17/2010 14:15