Trial balance described

When importing a trial balance from a CSV or Excel file, you must map the fields, so the trial balance data is displayed properly in the engagement. This topic describes the fields within the Trial balance dataset. For more information on importing transaction data from CSV files, see Import the trial balance from a CSV or Excel.

Field Usage
Account Number

An identifier for the account where the entry has been recorded. Must match the chart of accounts. Examples: "1001" or "Bank Account 1".

Note that this field is used as the unique identifier for each data row in a trial balance.

Data type: Text

Required: Yes
Account Name

Identifier description for the account group where the entry has been recorded. Examples: "Cash", "Property, plant and equipment".

Data type: Text

Required: Yes
Financial Group Number

The number for the financial group the account is assigned to in the default grouping structure.

Accounts currently assigned to fields may be reassigned when you import this field.

Data type: Text

Required: No

CY

The current year balance.

Note that if your engagement is externally consolidated, you will see both a Parent balance - CY and a Consolidated balance - CY field. If you assign one of those fields, you must also assign the other.

Data type: Text

Required: No
PY

The prior year balance.

Note that if your engagement is externally consolidated, you will see both a Parent balance - PY and a Consolidated balance - PY field. If you assign one of those fields, you must also assign the other.

Data type: Text

Required: No

 
PY - 2

The balance for two years prior.

Note that if your engagement is externally consolidated, you will see both a Parent balance - PY 2 and a Consolidated balance - PY 2 field. If you assign one of those fields, you must also assign the other.

Data type: Text

Required: No

 
PY - 3

The balance for three years prior.

Note that if your engagement is externally consolidated, you will see both a Parent balance - PY 3 and a Consolidated balance - PY 3 field. If you assign one of those fields, you must also assign the other.

Data type: Text

Required: No
PY-4

The balance for four years prior.

Note that if your engagement is externally consolidated, you will see both a Parent balance - PY 4 and a Consolidated balance - PY 4 field. If you assign one of those fields, you must also assign the other.

Data type: Text

Required: No