Company Info

Sage 100 Contractor 3-3-1 & 2 Cash Receipts


Import Cash Receipts directly into Sage 100 Contractor. Simply download your cash receipts into Excel, review and apply cash receipt information and import directly into Sage 100 Contractor 3-3-1 & 2 Cash Receipts.

Are you tired of manually keying in Cash Receipts one by one into Sage 100 Contractor? Would you rather download your cash receipts, fill in the blanks in Excel and import the details directly into Sage 100 Contractor? The following integration template allows you to do just that. It mimics every feature and function of the 3-3-1 & 2 Cash Receipts data entry form.

Key Features:

Import Template Download:

Endpoint Table:

FieldReferenceData TypeTabExampleDescription
filetypeRequiredARCRHeaderARCR(File Type Code)
chkactRequired **NumericHeaderDeposit Bank Account
chkdepnoRequiredString (20)HeaderDeposit Number
actgdteRequiredDateHeaderyyyy-mm-ddPosting Date
chkdteRequiredDateHeaderyyyy-mm-ddCash Receipt Date
chkdscrptRequiredString (50)HeaderCash Receipt Description
invtypeRequired **String (1)HeaderC=Contract;S=ServiceInvoice Type
jobclnnumRequired ** (1) (2)NumericJob / Service Client No
invnumRequired ** (2)String (20)Invoice Number
chknumString (20)Check No
pdamtRequiredNumeric (9,2)Check Paid Amount
ovrpmtNumeric (9,2)Check Overpayment Amount
dsctknNumeric (9,2)Discount Amount
er_pymtNumeric1=yes;0=noElectronic Pmt Flag
er_refno(3)String (16)Electronic Pmt Ref No
er_payor(3)String (103)Electronic Pmt Payor Name
er_paytyp(3) **String (1)3-American Express; 4-Visa; 5-MasterCard; 6-Discover; C-ACH; O-OtherElectronic Pmt Type
er_last4(3)String (4)Last 4 digits of credit cardElectronic Pmt Last 4 CC

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
(1) Enter jobnum if invtype="C" and clnnum if invtype="S"
(2) Job / Service Client No and Invoice Number must be unique in Sage 100 Contractor
(3) If Electronic Payment Flag (er_pymt) = 1 then the field is required

File Example:
filetype,chkact,chkdepno,actgdte,chkdte,chkdscrpt,invtype,jobclnnum,invnum,chknum, pdamt ,ovrpmt,dsctkn,er_pymt,er_refno,er_payor,er_paytyp,er_last4
ARCR,1000,"222_1",2017-05-01,2017-05-01,"work order pmt","S","1001","1","000222",250.5,,,0,"","","",""
ARCR,1000,"222_2",2017-05-01,2017-05-01,"contract pmt","C","20020","S1IV","000223",200,,,0,"","","",""

System Requirements

Requires the Sage 100 Contractor Data Integration Suite