AP Transactions Import File Format Invoice.BCL

AP Transactions Import/Invoice Export — Invoice.BCL File Format

The Invoice.BCL file format is used for AP Transactions Import, Transfer to AP, and Invoice Export.

For AP Transactions Import, the file can be in comma separated (CSV) or fixed length (SDF) format.
For Transfer to AP and Invoice Export, the file is created in fixed length (SDF) format.

In any case, the file name is Invoice.BCL.

Note

For AP Transactions import, records should be in Vendor/Invoice ID order to import correctly as one invoice rather than as separate invoices for each PropertyCompany.

Invoice.BCL Import File Format

Field	Field Name	Length	Description
1	Voucher #	8	Enter a unique voucher number; for example, 00000084. If no entry is present, the import function assigns one.
2	Line #	2	The import function adds the line number. If you are creating a comma separated file (CSV), enter the number 1 in this field.
3	Vendor #	10
4	Transaction Date	8	Use the format YYYYMMDD.
5	Period	6	Use the format YYYYMM.
6	Invoice Date	8	Use the format YYYYMMDD.
7	Invoice #	15	If invoice numbers must be unique, this is a required field.
8	Source	2	Leave this field blank.
9	PO #	8	Not used.
10	Amount	12	This field is right justified with decimal. For example 123456789.12.
11	Company #	2	The first two characters of the PropertyCompany ID.
12	Property #Company #	3	The next three characters of the PropertyCompany ID.
13	Account #	15	The expense code.
14	Description1	15	This description is the line item description.
15	Due date	8	Use the format YYYYMMDD.
16	Status	1	P=Paid, R=Partially Paid, N=Normal, V=Void
17	Enclosure?	1	N

Samples:

SDF

00V000521 0022008080420080820080804august43008 PO3645 100.00010016050-011 GE Parts 20080804NN

CSV

00V00052,1,002,20080804,200808,20080804,august43008,,PO3645,100.00,01,001,6050-011,GE Parts,20080804,N,N