Column List for FACTS Import

For a spreadsheet to load onto the import screen for FACTS import, the spreadsheet must contain at least the columns below.

Note: You MUST use these EXACT names.

ActId

Date

ImportPaymentAmt

DepositAmount

Notes

Below is the FULL list of columns you can include if you wish; no other columns will be processed on the FACTS import.

Note: You MUST use these EXACT names.

ActId

Occasion

Date

ImportPaymentAmt

Batch

PmtMethod

PrintReceipt

LetterCode

PmtSendVia

DepositAmount

Notes

CumulativeRec