Account Export Balances — Actuals.BCL File Format

This data transfer exports actual balances from the general ledger.

Note

This file is not compatible with eFinancials import functions and is designed to export to legacy systems.

ACTUALS.BCL Version 1

The first line of the file, which is VERSION 1, is used to identify the format. The basic file format is fixed length (SDF).

Field

Field Name

Type

Length

Description

1

Company  

Character

2

The first two characters of the EntityCompany ID

2

Project

Character

3

Characters 3, 4, and 5 of the EntityCompany ID

3

Account #

Character

15

Account number

4

Per01Chg

Numeric

12

2 decimals

5

Per02Chg

Numeric

12

2 decimals

6

Per03Chg

Numeric

12

 2 decimals

7

Per04Chg

Numeric

12

2 decimals

8

Per05Chg

Numeric

12

2 decimals

9

Per06Chg

Numeric

12

2 decimals

10

Per07Chg

Numeric

12

2 decimals

11

Per08Chg

Numeric

12

2 decimals

12

Per09Chg

Numeric

12

2 decimals

13

Per10Chg

Numeric

12

2 decimals

14

Per11Chg

Numeric

12

2 decimals

15

Per12Chg

Numeric

12

2 decimals

16

Beg Bal

Numeric

12

2 decimals (beginning balance)

See Also

Data Transfer File Formats Introduction

Accounts Overview

Account Export Tab

Account Export File Format Accounts.BCL

Account Export File Format eFinancials Fixed Length

Budgets File Format Budgets.BCL