Regulus Payment Import File

This Help File Page was last Modified on 04/04/2015

<< Click to Display Table of Contents >>

Navigation:  Accounts Receivable System - The Receivables Module > Receivables - Maintenance Options > Pay Import > Regulus/Wells Fargo Import > Import Payments >

Regulus Payment Import File

This Help File Page was last Modified on 04/04/2015

Payment Import File formatting specifications for Regulus

 

The chart below provides the exact specifications for the Regulus Payment Import File.

 

Code

Field

Length

Align

Description

A

Subscriber ID

12

Right

Account Number

B

Amount Paid

10

Right

Amount Received (with 2 digit decimals)

C

Method of Payment

1

N/A

1 = American Express

2 = Cash

3 = Check

4 = Discover

5 = Electronic Transfer

6 = Master Card

7 = Visa

8 = Other

D

Check Number

10

Right

Customer check number

 

 

The Sample below illustrates how the data appears in a text file including the leading zeros where required.

 

AAAAAAAAAAAABBBBBBBBBBCDDDDDDDDDD (Reference Row – Do Not Include) 

 

000000001234000123.54110000001234

000000001235000078.58230000001024

000000023245000120.75140000000000

 

Each line ends with a carriage return and line feed (the same as Pressing 8 Enter)

No tabs or commas are required to separate the line item data elements