{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Overview","Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"version: 2022-011-04"]
[]
[null,"Accounts Receivable - 3-3-1/2 Cash Receipts"]
[]
[null,"The following template should be used to import one or more cash receipts into Sage 100 Contractor.  "]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Field","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","ARCR","Header","ARCR","(File Type Code)"]
[null,"chkact","Required **","Numeric","Header",null,"Deposit Bank Account"]
[null,"chkdepno","Required","String (20)","Header",null,"Deposit Number"]
[null,"actgdte","Required","Date","Header","yyyy-mm-dd","Posting Date"]
[null,"chkdte","Required","Date","Header","yyyy-mm-dd","Cash Receipt Date"]
[null,"chkdscrpt","Required","String (50)","Header",null,"Cash Receipt Description"]
[null,"invtype","Required **","String (1)","Header","C=Contract;S=Service","Invoice Type"]
[null,"jobclnnum","Required ** (1) (2)","Numeric",null,null,"Job / Service Client No"]
[null,"invnum","Required ** (2)","String (20)",null,null,"Invoice Number"]
[null,"chknum",null,"String (20)",null,null,"Check No"]
[null,"pdamt","Required","Numeric (9,2)",null,null,"Check Paid Amount"]
[null,"ovrpmt",null,"Numeric (9,2)",null,null,"Check Overpayment Amount"]
[null,"dsctkn",null,"Numeric (9,2)",null,null,"Discount Amount"]
[null,"er_pymt",null,"Numeric",null,"1=yes;0=no","Electronic Pmt Flag"]
[null,"er_refno","(3)","String (16)",null,null,"Electronic Pmt Ref No"]
[null,"er_payor","(3)","String (103)",null,null,"Electronic Pmt Payor Name"]
[null,"er_paytyp","(3) **","String (1)",null,"3-American Express; 4-Visa; 5-MasterCard; 6-Discover; C-ACH; O-Other","Electronic Pmt Type"]
[null,"er_last4","(3)","String (4)",null,"Last 4 digits of credit card","Electronic Pmt Last 4 CC"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"(1) Enter jobnum if invtype=\"C\" and clnnum if invtype=\"S\""]
[null,"(2) Job / Service Client No and Invoice Number must be unique in Sage 100 Contractor"]
[null,"(3) If Electronic Payment Flag (er_pymt) = 1 then the field is required"]
[]
[null,"File Example:"]
[null,"filetype,chkact,chkdepno,actgdte,chkdte,chkdscrpt,invtype,jobclnnum,invnum,chknum, pdamt ,ovrpmt,dsctkn,er_pymt,er_refno,er_payor,er_paytyp,er_last4"]
[null,"ARCR,1000,\"222_1\",2017-05-01,2017-05-01,\"work order pmt\",\"S\",\"1001\",\"1\",\"000222\",250.5,,,0,\"\",\"\",\"\",\"\""]
[null,"ARCR,1000,\"222_2\",2017-05-01,2017-05-01,\"contract pmt\",\"C\",\"20020\",\"S1IV\",\"000223\",200,,,0,\"\",\"\",\"\",\"\""]

{"sheet":"Template","index":1,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sample Template",null,"Note: you may delete any column from this template that is not used or needed other than the Required Columns"]
[]
[]
[null,"ARCR","Deposit Bank Account","Deposit Number","Posting Date","Cash Receipt Date","Cash Receipt Description","Invoice Type","Job / Service Work Order Client No","Invoice Number","Check No","Check Paid Amount","Check Overpmt Amount","Discount Amount","Electronic Pmt Flag","Electronic Pmt Ref No","Electronic Pmt Payor Name","Electronic Pmt Type","Electronic Pmt Last 4 CC"]
[null,"ARCR","Numeric","String (20)","Date","Date","String (50)","String (1)","Numeric","String (20)","String (20)","Numeric (9,2)","Numeric (9,2)","Numeric (9,2)","Numeric","String (16)","String (103)","String (1)","String (4)"]
[]
[]
["First Line of File==>","filetype","chkact","chkdepno","actgdte","chkdte","chkdscrpt","invtype","jobclnnum","invnum","chknum","pdamt","ovrpmt","dsctkn","er_pymt","er_refno","er_payor","er_paytyp","er_last4"]
[null,"ARCR",1000,"222_1","2017-05-01","2017-05-01","work order pmt","S",2,"2017504-001","000222",250.5,null,null,0]
[null,"ARCR",1000,"222_2","2017-05-01","2017-05-01","contract pmt","C",2017008,"ART1","000223",125,null,null,0]