BusinessWorks File Layout

BusinessWorks allows you to import batch information from a coma-delimited ASCII import file. This file contains lines of information for one or more batches. The import file is a comma-separated variable (.cvs) file. Each record in the file must be terminated by a carriage return and line feed. The file must also be ended with a carriage return and line feed.

Field	Max Length	Value
Sequence #	3	A one-, two-, or three-digit integer. Format: N, NN, or NNN
Posting Date	8	Format: MM/DD/YY
GEN	3	This is a hard coded value that must be enclosed in quotation marks. Format: "GEN"
GL Transaction Reference		Must be enclosed in quotation marks.
Transaction Description		Must be enclosed in quotation marks.
GL Account		Must already exist in the chart of accounts.
Transaction Amount		Must contain a dollar amount or zero.

Example:

1,12/01/06,"GEN","AUTO12","Cash Receipts-AppFe",1010,160