Appendix > Appendix > Format Requirements for Importing Transactions > Bank Reconciliation File Format Requirements > External File Format Requirements for the BR Activity Header
External File Format Requirements for the BR Activity Header
The table below contains the external file format requirements for the BR Activity Header.
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Field Length2
 
Character Position
(Fixed-Length Format)3
 
Data Type
1
* Header Identifier
1
1
Char-Caps
2
* Bank Account Code
6
2
Char-Caps
3
* Check/Doc Number
20
8
Char-Caps
4
* Payee Description
50
28
Character
5
Memo Description
50
78
Character
6
Payee Address 1
35
128
Character
7
Payee Address 2
35
163
Character
8
Payee City
35
198
Character
9
Payee State
35
233
Char-Caps
10
Payee Zip Code
35
268
Character
11
Payee Country
35
303
Character
12
Bank Account Transfer To4
 
6
338
Char-Caps
13
* Activity Type 0=Check
1=Deposit
2=Deduction
3=Addition
4=Bank Charge
5=Transfer
6=Void
1
344
Numeric
14
Category Type5
 
6
345
Char-Caps
15
Check Printed? 0=N/A
1=No
2=Yes
1
351
Numeric
16
* Activity Date6
 
10
352
Date
17
Activity Amount7
 
17
362
Numeric
 
* End of Record
2
379
 

1 This number is for reference purposes only and will not appear in the actual text file.

2 If the file format is tab or semi-colon delimited, any characters over the specified length are cut off at the length limit. If the file format is fixed length (column position) each field must be the exact length shown in the Maximum Field Length column.

3 If the field doesn’t start in the character position specified it will create an error and potentially prohibit the transaction from being imported.

4 This field is required only for Transfer type activity.

5 The Category Type is the same as a Category Code.

6 If the Transaction Date is invalid, an error will be printed on the Import Error Report. If the Transaction Date is left blank, it will be imported as zeros.
If the date is in correct format, but contains a typographical error, it will be imported as is.This means that if the text reflects a date of 01/01/1900, it will be imported as is, because the format is correct. Dates with the year entered as prior to 1900 will generate an error.

7 The Transaction Amount must be entered for transfer activity. For all other types, this amount is calculated based on the detail. The Transaction Amount consists of a plus (+) or minus (-) sign, followed by 11 digits, a decimal point, and 2 decimals. If this amount is a transfer type, it must be positive.

Published date: 06/04/2021