Budget Import File Format

Overview:

The input record must be 140 characters in the following format
 
Column Size (Width) Description
A 8 Leave Blank
B 6 OBJ
C 5 Leave Blank
D 35 Leave Blank
E 30 Description of Transfer with date: Example: FY19 F100 FR 20180905
F 10 Your ID: Example: TD017478
G 12 Short Description: Example: F100 FRREV
H 1 Debit "D" or Credit "C"
I 13 Amount with no decimals, commas or symbols (,.$) 13 numbers
J 19 Leave Blank
K 1 Letter "B" for Budget
L 1 Expense "E" or Revenue "R"
M 55 Long Account (Full Account)

Details

Article ID: 67363
Created
Fri 11/16/18 12:48 PM
Modified
Wed 1/16/19 1:43 PM