{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Overview","Credit Card Statement Template","CC Rec Single Transaction","Grid Sample","4-7-3 Credit Card Rec","Mapping Diagram","misc"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":18,"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":73,"n_cols":7,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Version: 2024-12-17"]
[]
[null,"Accounts Payable - 4-7-3 Credit Card Receipts"]
[]
[null,"The following template should be used to import Journal Entries into Sage 100 Contractor.  "]
[]
[null,"File Layout Specification"]
[]
[null,"Header Layout"]
[]
[null,"Column","Reference","Data Type","Tab","Example","Description"]
[null,"COL1","Required",null,null,"APCCR","(File Type Code)"]
[null,"COL2","Required",null,null,"H","(Header Record)"]
[null,"COL3","Required (1)","String (20)","Header","123_abc","Transaction Reference"]
[null,"COL4","Required **","Numeric","Header",null,"Credit Card Account"]
[null,"COL5","Required **","Numeric","Header",null,"Credit Card Sub Account"]
[null,"COL6","Required","date","Header","YYYY-MM-DD","Transaction Date"]
[null,"COL7","Required","String (50)","Header","CC Transaction Desc","Transaction Description"]
[null,"COL8","Required (2)","String (50)","Header",null,"Payee"]
[null,"COL9","** (2) (3)","Numeric","Header","Invoice/Payment Created","Vendor Recnum"]
[null,"COL10",null,"String (50)","Header",null,"usrdf1"]
[null,"COL11",null,"String (50)","Header",null,"usrdf2"]
[null,"COL12",null,"Text","Header",null,"Notes"]
[null,"COL13","(4)","Date",null,null,"Posting Period"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"COL: a placeholder must be provided for each column even if no value is provided"]
[null,"(1) Transaction Reference must be unique for each line item."]
[null,"(2) Payee should be left blank if a Vendor Recnum is entered and will default to the Vendor Name. If both a Payee and Vendor No are entered the Payee value will be ignored and defaulted to the Vendor Name."]
[null,"(3) If you enter a vendor, a paid invoice is created. If you look in 1-3 Journal Transactions, you see that two journal transactions have been created. This is a typical journal transaction and a record of the payment (the paid invoice)."]
[null,"(4) If posting period is left blank then the Transaction Date will be used as the posting period"]
[]
[null,"Detail Layout"]
[null,"COL1","Required",null,null,"APCCR","(File Type Code)"]
[null,"COL2","Required",null,null,"D","(Detail Record)"]
[null,"COL3","Required","String (20)","Header","123_abc","Transaction Reference"]
[null,"COL4","Required **","Numeric","Header",null,"Ledger Acct Recnum"]
[null,"COL5","**","Numeric","Detail",null,"Sub Account Recnum"]
[null,"COL6",null,"String (50)","Detail",null,"Line Description"]
[null,"COL7","** (1)","Numeric","Detail","(Vendor Recnum Required)","Part No"]
[null,"COL8",null,"String (10)","Detail",null,"Unit of Measure"]
[null,"COL9",null,"Numeric (12,4)","Detail",null,"Quantity"]
[null,"COL10","(2)","Numeric (15,6)","Detail",null,"Price"]
[null,"COL11","(3)","Numeric (9,2)","Detail","(Enter 0 or Blank if Qty and Price entered)","Total Amount"]
[null,"COL12",null,"String (50)","Detail",null,"User Defined 1"]
[null,"COL13","**","String (20)","Detail","WIP / Direct Exp *","Work Order No"]
[null,"COL14","**","Numeric","Detail","WIP / Direct Exp *","Job No"]
[null,"COL15","**","Numeric","Detail","WIP / Direct Exp *","Phase No"]
[null,"COL16",null,"String (50)","Detail","WIP / Direct Exp *","Description"]
[null,"COL17","**","Numeric (15,3)","Detail","WIP / Direct Exp *","Cost Code"]
[null,"COL18","**","Numeric","Detail","WIP / Direct Exp *","Cost Type"]
[null,"COL19",null,"Text","Detail","WIP / Direct Exp *","Notes"]
[null,"COL20","**","Numeric","Detail","Equip Exp **","Equip No"]
[null,"COL21",null,"String (50)","Detail","Equip Exp **","Description"]
[null,"COL22","**","Numeric (15,3)","Detail","Equip Exp **","Cost Code"]
[null,"COL23","**","Numeric","Detail","Equip Exp **","Cost Type"]
[null,"COL24",null,"Text","Detail","Equip Exp **","Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"COL: a placeholder must be provided for each column even if no value is provided"]
[null,"(1) Part No is only allowed if a Vendor No is entered in the Header."]
[null,"(2) Price may not be a negative value. If the line amount is negative you must make the \"Quantity\" negative"]
[null,"(3) The Total Amount field will be automatically calculated based on the Quantity and Price entered. If Quantity and Price are not entered then a value must be provided."]
[null,"WIP / Direct Exp * - Required if the lgract (Col 4) is assigned to [3 - WIP Assets] or [13 - Direct Expense] account type"]
[null,"Equip Exp** - Required if the lgract (Col 4) is assigned to [14 - Equip/Shop Expense] account type"]
[]
[null,"File Example:"]
[null,"CCR,H,\"CC123\",\"2250\",\"1156\",\"7/15/2020\",\"lunch\",\"CPK\",,\"\",\"\",\"\",\"\""]
[null,"CCR,D,\"CC123\",6001,,\"lunch\",,\"\",,,34.56,,\"1\",2,3,\"4\",5,6,\"7\",8,\"9\",10,11,\"12\""]
[null,"CCR,H,\"CC124\",\"2250\",\"1156\",\"7/16/2020\",\"drill bits\",\"Owens Hardware\",,\"\",\"\",\"\",\"\""]
[null,"CCR,D,\"CC124\",6001,,\"drill bits\",,\"\",,,125,,\"\",,,\"\",,,\"\",,\"\",,,\"\""]
[null,"CCR,H,\"CC125\",\"2250\",\"1156\",\"7/17/2020\",\"office supplies\",\"Office Max\",,\"\",\"\",\"\",\"\""]
[null,"CCR,D,\"CC125\",6001,,\"office supplies\",,\"\",,,45,,\"\",,,\"\",,,\"\",,\"\",,,\"\""]

{"sheet":"Credit Card Statement Template","index":1,"n_rows":20,"n_cols":26,"rows_kept":20,"cut":false,"hidden":false,"merged":[[7,1,7,4],[7,21,7,25],[7,14,7,20]]}
["Sample Credit Card Bank Statement Receipts Form"]
[]
[]
[null,"Credit Card Issuer Account: *",2250]
[null,"Credit Card Sub Account: *","1156"]
[]
[null,null,null,null,{"$f":"SUM(E9:E9954)","v":396.22}]
[null,"Bank Statement Columns",null,null,null,null,null,null,null,null,null,null,null,null,"Use if the Ledger Acct is a [13 - Direct Exp] account type ",null,null,null,null,null,null,"Use if the Ledger Acct is a [14 - Equip/Shop Exp] account type "]
[null,"Transaction\nDate *","Transaction\nReference *","Transaction Description *","Transaction\nAmount *","Ledger\nAccount *","Ledger\nSub-Account","Payee *","Vendor\nRecnum","UOM","Qty","Unit Price","Part No","User\nDefined 1","Work Order No","Job No *","Phase No","Job Description *","Job Cost Code *","Job Cost Type *","Job Notes","Equip No *","Equip Description *","Equip Cost Code *","Equip Cost\nType *","Equip Notes"]
[null,"2019-12-31","CC1219_1","PPL*TEAM Const 8004707870 CA",15.95,6001,null,"CitiBank"]
[null,"2019-12-28","CC1219_2","THE HOME DEPOT #0603 TUSTIN CA",5.36,6001,null,"CitiBank"]
[null,"2019-12-24","CC1219_3","OTL*SCORESENSE.COM 8552591783 TX",29.95,6002,null,"CitiBank"]
[null,"2019-12-22","CC1219_4","STARBUCKS STORE 05741 IRVINE CA",24.75,6025,null,"CitiBank"]
[null,"2019-12-21","CC1219_5","APPLE.COM/BILL 866-712-7753 CA",0.99,6026,null,"CitiBank"]
[null,"2019-12-20","CC1219_6","AMZN MKTP US*TV61P6GK3 AMZN.COM/BILL WA",14.49,6050,null,"CitiBank"]
[null,"2019-12-19","CC1219_7","DBT CTR OF ORANGE COUN NEWPORT BEACH CA",225,5001,null,"CitiBank"]
[null,"2019-12-02","CC1219_8","UBER TRIP 8005928996 CA",8.89,6070,null,"CitiBank"]
[null,"2019-11-13","CC1219_9","76 - UNITED PACIFIC #5 IRVINE CA",59.23,6072,null,"CitiBank"]
[null,"2019-11-08","CC1219_10","CITY OF LAGUNA BEACH I LAGUNA BEACH CA",3,6002,null,"CitiBank"]
[null,"2019-11-07","CC1219_11","UBER TRIP 8005928996 CA",8.61,6070,null,"CitiBank"]

{"sheet":"CC Rec Single Transaction","index":2,"n_rows":18,"n_cols":21,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,9,15,15],[15,16,15,20],[12,2,12,3]]}
["4-7-3 Credit Card Receipt Single Transaction"]
[]
[]
[null,"Credit Card Account: *",2250]
[null,"Credit Card Sub Account: *","1156"]
[null,"Transaction #: *","AB123"]
[null,"Invoice Date: *"]
[null,"Description: *"]
[null,"Vendor:"]
[null,"Payee: *"]
[null,"UDF1:"]
[null,"UDF2:"]
[null,"Notes:"]
[null,"Posting Period:"]
[]
[null,null,null,null,null,null,null,null,null,"Use if the Ledger Acct is a [13 - Direct Exp] account type ",null,null,null,null,null,null,"Use if the Ledger Acct is a [14 - Equip/Shop Exp] account type "]
[null,"Ledger\nAccount *","Ledger\nSub-Account","Line Description","UOM","Qty","Unit Price","Part No","User\nDefined 1","Work Order No","Job No *","Phase No","Job Description *","Job Cost Code *","Job Cost Type *","Job Notes","Equip No *","Equip Description *","Equip Cost Code *","Equip Cost\nType *","Equip Notes"]
[null,6000,1,"test line","ea",4,5,111,"udf"]

{"sheet":"Grid Sample","index":3,"n_rows":11,"n_cols":25,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Sample Template"]
[]
[]
[null,"Col 1","Col 2","Col 3","Col 4","Col 5","Col 6","Col 7","Col 8","Col 9","Col 10","Col 11","Col 12","Col 13","Col 14","Col 15","Col 16","Col 17","Col 18","Col 19","Col 20","Col 21","Col 22","Col 23","Col 24"]
[null,"APCCR","H","trnnum","crlgract","crsubact","trndte","dscrpt","payee1","vndnum","usrdf1","usrdf2","ntetxt","postprd"]
[null,"APCCR","D","trnnum","lgract","subact","dscrpt","prtnum","untdsc","linqty","linprc","dbtamt","usrdf1","wrkord","jobnum","phsnum","jcdscrpt","jccstcde","jccsttyp","jcnotes","eqpnum","eqdscrpt","eqcstcde","eqcsttyp","eqnotes"]
[]
[]
[null,"APCCR","H","JE #1",2506,null,"2020-07-15",null,"Marriot Dining"]
[null,"APCCR","D","JE #1",1000,null,"Record Meal Reimb",null,25000]
[null,"APCCR","D","JE #1",6040,null,"Record Meal Reimb",25000]

{"sheet":"4-7-3 Credit Card Rec","index":4,"n_rows":60,"n_cols":2,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["AP 4-7-3 Credit Card Receipts Mappings"]
[]
["The Credit Card Receipts data entry form is simply a modified Journal Transaction entry form.  The following mapping shows the correlation between the two forms."]
["If you are entering credit card receipts you will use the existing Journal Entry Form template."]
[]
[]
[]
[null,"Credit Card Receipts Header"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Journal Transactions Header"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Credit Card Receipts Details"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Journal Transactions Details"]

{"sheet":"Mapping Diagram","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"misc","index":6,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["1 - Open"]
["2 - Cleared"]
[]
[]
["0 - Adjust"]
["1 - Check"]
["2 - Dep"]