Using iMIS AR Importer

To implement the AR Importer:

Make sure you are licensed for AR Importer.
Format AR data for import.
Perform the import.
Verify the import.

To enable the iMIS AR Importer module

As with all iMIS modules, you must have this system enabled on the iMIS System Setup level. If necessary, open the System Setup window (select File > System Setup) and edit your iMIS licensing to enable the iMIS AR Importer.

To format AR data for import

The transaction format is tab- or comma-delimited input, with various types of records allowed in a single stream. The import file must contain a single batch header record, followed by any number of cash payment records. There should not be any empty lines between record entries.

📘
Note
You can use the AR Importer for accrual dues billing.

The major transaction formats include the following:

All records

#	Field Name	Data	Comments
1	Record Type		Identifies the type of record
2	Batch Number	10 chars, all upper case

Batch header

#	Field Name	Data	Comments
1	Record Type	BH	Always "BH"
2	Batch Number	10 chars, all upper case
3	Batch Date	Date	Date of batch (mm/dd/yy)
4	Batch Description	60 chars
5	Control Count	Numeric	Optional
6	Control Amount	Monetary	Total of the batch of payments
7	Cash Account Code	10 chars, all upper case	Code assigned through the Set up cash accounts window. Indicates the cash account into which the funds were deposited.

Cash payment record

#	Field Name	Data	Comments
1	Record Type	PAY	Always "PAY"
2	Batch Number	10 chars, all upper case	Optional. If blank, defaults to batch header's batch number.
3	System	AR
4	Customer ID	10 chars, customer ID	Can substitute with Major Key, if prefixed with \* (asterisk)
5	Date	Date	Optional. If blank, defaults to batch header date.
6	Invoice	Alphanumeric	The invoice number. If you need to enter a payment towards an invoice and the Auto Apply option is not enabled in the AR/Cash Set up module window, this option is required. If you need to import a prepayment, this option is not required, even if the Auto Apply option is not enabled.
7	Amount	Individual payment amount	Total amount of the check or credit card payment. Do not enter a $ (dollar sign).
8	Check/CCType	Check number or credit card type	Optional
9	CCNumber	Credit card number	Optional
10	CCExp	Credit card expiration date	Optional
11	Name on CC	Name on credit card	Optional
12	CCAuthorize	Credit card authorization code	Optional
13	Name	60 chars for audit trail	Optional but important. This value is printed on the transaction report to identify the customer.
14	Comment	255 chars	Optional but important. This value is printed on the transaction report and related inquiries to explain the transaction, such as "Dues Payment" or "Subscription Payment".

Example AR Import File