A comma-delimited import record separates the fields with commas and wraps each text field in double-quotes. The format string indicates the type of the following records with a keyword that begins with the @ character, followed by the term ASCII in parentheses. This is followed by a colon and a list of field identifiers, specifying which fields are expected in each record.
Below is an example of a format string defining a comma-delimited transaction record:
@ACCTLEDG(ASCII):ACCT,DATE(-1),REF,DESC,AMT,XACCT,REC
Here are two sample transaction records that use it:
"ADLER",05012005,111,"Simple Transaction",100.00,"BANK","991231"
"NEILSON",05132005,1112,"Another Example",15.00,"BANK"
Shown below is a same import file where the records are comma-delimited. A few format strings and import records are shown. This is not a file that will actually import because most records have been removed for brevity. Note the following:
Record fields must be in the order defined by the list of fields in the format string.
If there is no value for a field, there must still be a comma separator.
@HOMEHOME(ASCII):REPT,SEC,DESC "JR","","Journals" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "JR","Opening Entries Journal",1,"","OE","C","","" @ACCTNOTE(ASCII):ACCT,ANOTE "OE","Used for entering opening financial position into set of books" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "JR","Recurring Entries Journal",1,"","RE","C","","" "JR","Adjusting\Accrual Entries",1,"","AE","C","","" @ACCTNOTE(ASCII):ACCT,ANOTE "AE","Used by accountants for setting up year end AP and AR accruals, depreciation " "AE"," expenses " @HOMEHOME(ASCII):REPT,SEC,DESC "GL","","General Ledger" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Cash in Bank",1,"","1110","D","GL-D","BS-BANK" ... "GL","Cost of Goods - Hardware",1,"","4020","D","GL-D","IS-HARD" @ACCTNOTE(ASCII):ACCT,ANOTE "4020","Cost of Goods - Hardware" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Cost of Goods - Software",1,"","4025","D","GL-D","IS-SOFT" @ACCTNOTE(ASCII):ACCT,ANOTE "4025","Cost of Goods - Software" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Revenue Consulting",2,"","4030","C","GL-C","IS-SALES" @ACCTNOTE(ASCII):ACCT,ANOTE "4030","Revenue Consulting" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Revenue Training",2,"","4040","C","GL-C","IS-SALES" @ACCTNOTE(ASCII):ACCT,ANOTE "4040","Revenue Training" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Revenue Programming",2,"","4050","C","GL-C","IS-SALES" @ACCTNOTE(ASCII):ACCT,ANOTE "4050","Revenue Programming" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Depreciation & Amortization",1,"","6020","D","GL-D","IS-DEPN" @ACCTNOTE(ASCII):ACCT,ANOTE "6020","Depreciation & Amortization" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Advertising",1,"","6025","D","GL-D","IS-ADV" @ACCTNOTE(ASCII):ACCT,ANOTE "6025","Advertising " @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Printing",1,"","6026","D","GL-D","IS-PRINT" @ACCTNOTE(ASCII):ACCT,ANOTE "6026","Printing" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Training Equipment Leases",1,"","6030","D","GL-D","IS-LEASE" @ACCTNOTE(ASCII):ACCT,ANOTE "6030","Training Equipment Leases" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Training Equipment Maintenance",1,"","6040","D","GL-D","IS-LEASE" @ACCTNOTE(ASCII):ACCT,ANOTE "6040","Training Equipment Maintenance" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Office Equipment Maintenance",1,"","6041","D","GL-D","IS-LEASE" @ACCTNOTE(ASCII):ACCT,ANOTE "6041","Office Equipment Maintenance" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Insurance",1,"","6050","D","GL-D","IS-INSUR" @ACCTNOTE(ASCII):ACCT,ANOTE "6050","Insurance" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Office Supplies",1,"","6090","D","GL-D","IS-OSUP" @ACCTNOTE(ASCII):ACCT,ANOTE "6090","Office Supplies " @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Professional Fees",1,"","6100","D","GL-D","IS-FEES" @ACCTNOTE(ASCII):ACCT,ANOTE "6100","Professional Fees" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Postage",1,"","6110","D","GL-D","IS-POST" @ACCTNOTE(ASCII):ACCT,ANOTE "6110","Postage " @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Courier",1,"","6115","D","GL-D","IS-POST" @ACCTNOTE(ASCII):ACCT,ANOTE "6115","Courier" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Car Expenses",1,"","6116","D","GL-D","IS-TRAVEL" @ACCTNOTE(ASCII):ACCT,ANOTE "6116","Car Expenses " @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Rent",1,"","6120","D","GL-D","IS-RENT" @ACCTNOTE(ASCII):ACCT,ANOTE "6120","Rent" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Training Room Rent",1,"","6121","D","GL-D","IS-RENT" @ACCTNOTE(ASCII):ACCT,ANOTE "6121","Training Room Rent" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Training Salaries",1,"","6131","D","GL-D","IS-SAL" @ACCTNOTE(ASCII):ACCT,ANOTE "6131","Training Salaries" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Consultants Salaries",1,"","6133","D","GL-D","IS-SAL" @ACCTNOTE(ASCII):ACCT,ANOTE "6133","Consultants Salaries" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Programmer Salaries",1,"","6134","D","GL-D","IS-SAL" @ACCTNOTE(ASCII):ACCT,ANOTE "6134","Programmer Salaries" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Telephone",1,"","6300","D","GL-D","IS-PHONE" @ACCTNOTE(ASCII):ACCT,ANOTE "6300","Telephone" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Travel & Trade Shows",1,"","6340","D","GL-D","IS-TRAVEL" @ACCTNOTE(ASCII):ACCT,ANOTE "6340","Travel & Trade Shows " @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Bank Service Charges",1,"","6440","D","GL-D","IS-BC" @ACCTNOTE(ASCII):ACCT,ANOTE "6440","Bank Service Charges" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Interest",1,"","6445","D","GL-D","IS-BC" @ACCTNOTE(ASCII):ACCT,ANOTE "6445","Interest" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "GL","Business Income Taxes",1,"","6500","D","GL-D","IS-BTAX" "GL","",,"","","","","" "GL","Total GL Debits",1,"","GL-D","D","GL-PROOF","" "GL","Total GL Credits",2,"","GL-C","C","GL-PROOF","" "GL","",,"","","","","" "GL","Proof",3,"","GL-PROOF","D","","" @HOMEHOME(ASCII):REPT,SEC,DESC "AR","","Accounts Receivable" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "AR","EHD Computer Consultants",1,"","EHD","D","TAR","" @ACCTNOTE(ASCII):ACCT,ANOTE "EHD","EHD Computer Consultants Same" "EHD","265 Queensville Side Rd. E." "EHD","Anytown, Anywhere" "EHD","" "EHD","" "EHD","" "EHD","" "EHD","" "EHD","836-4733" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "AR","Gold Bank Emp. Pension Fund",1,"","GOLD","D","TAR","" @ACCTNOTE(ASCII):ACCT,ANOTE "GOLD","Gold Bank Same" "GOLD","Employee Pension Fund Division " "GOLD","11 Unger Street" "GOLD","Anytown, Anywhere" "GOLD","" "GOLD","" "GOLD","" "GOLD","" "GOLD","555-9898" "GOLD","555-9998" "GOLD","X" "GOLD","" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "AR","",1,"S","","","","" "AR"," Total Accounts Receivable",2,"","TAR","D","","1130" "AR","",2,"D","","","","" @HOMEHOME(ASCII):REPT,SEC,DESC "AP","","Accounts Payable" @REPTSETP(ASCII):REPT,DESC,COL,UL,ACCT,NB,TOTTO1,TOTTO2 "AP","Advantage Office Supplies",1,"","ADVANTAGE","C","TAP","" @ACCTNOTE(ASCII):ACCT,ANOTE "ADVANTAGE","Advantage Office Supplies" "ADVANTAGE","132 Stolly Street" "ADVANTAGE","Anytown, Anywhere" "ADVANTAGE","" "ADVANTAGE","" "ADVANTAGE","" "ADVANTAGE","" "ADVANTAGE","" "ADVANTAGE","" "ADVANTAGE","" "ADVANTAGE","555-9971" @ACCTLEDG(ASCII):ACCT,DATE(-1),REF,DESC,AMT,XACCT,REC,XDESC,DNOTE,KEY "1110",31121991,"","Bank Balance",975.61,"OE","1991-12","","","0" "1110",31121991,"","O\S deposit 27\12\90",1000.00,"OE","1991-12","","","1" "1110",31121991,"5679","O\S check Tri-Star 25\12\90",-550.00,"OE","1991-12","","","0" "1110",31121991,"5680","O\S check All Safe 26\12\90",-275.00,"OE","1991-12","","","1" "1110",31121991,"5681","O\S check HAL 26\12\90",-38.47,"OE","1991-12","","","0" "1110",31121991,"5682","O\S check Source 28\12\90",-985.73,"OE","1991-12","","","1" "1110",31121991,"5683","O\S check Micro 28\12\90",-4219.30,"OE","1991-12","","","0" "1110",01011992,"5684","Tri-Star Property",-3000.00,"6120","1992-01","Rent","","1" "1110",01011992,"5684","Tri-Star Property",-1000.00,"6121","1992-01","Rent","","1" "1110",05011992,"1","Deposit",6641.45,"EHD","1992-01","Pymt Invoice 1081 1083","","0" "1110",05011992,"1","Deposit",9876.59,"LINEAR","1992-01","Pymt Invoice 1087","","0" "1110",10011992,"2","Deposit",8776.65,"RAMJAK","1992-01","Pymt Invoice 1088","","1" "1110",15011992,"5685","Howe & Ware",-3500.00,"HOWE","1992-01","","","0" "1110",15011992,"5686","HAL Computer Distributors",-15000.98,"HAL","1992-01","","","1" "1110",15011992,"5687","Co-ordination Plus",-500.00,"6340","1992-01","June L.A. Compt.show deposit","","0" "1110",15011992,"5688","Sales Tax Remittance",-4545.45,"TAXREM","1992-01","","","1" "1110",18011992,"3","Deposit",9298.70,"NATIONAL","1992-01","Pymt Invoice 1089 1091","","0" "1110",20011992,"4","Deposit",18778.51,"TEX","1992-01","Pymt Invoice 1094","","1"