Understand the Trial balance dataset
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 (account_id) | The identifier for the account. Data type: String Required: Yes |
Account name (account_main_description) | The name or description for the account. Examples: Cash; Property, plant and equipment; Sales Data type: String Required: Yes |
Financial group number (financial_group_number) | The number for the financial group the account is assigned to in the grouping structure. This information is not provided by the client and is used to automatically map accounts to financial groups. Accounts currently assigned to groups may be reassigned when you import this data field. Data type: String Required: No |
Current year balance (current_year) | The current year balance. Data type: Money Required: No |
Prior year balance (prior_year) | The prior year balance. Data type: Money Required: No
|
Prior year 2 balance (prior_year_two) | The balance for prior year 2. Data type: Money Required: No
|
Prior year 3 balance (prior_year_three) | The balance for prior year 3. 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: Money Required: No |
Prior year 4 balance (prior_year_four) | The balance for prior year 4. Data type: Money Required: No |
Current year - consolidated balance (consolidated_current_year | The consolidated balance for the current year. If you assign this field, you must also assign a corresponding parent balance for the current year. Data type: Money Required: No |
Prior year - consolidated balance (consolidated_prior_year) | The consolidated balance for the prior year. If you assign this field, you must also assign a corresponding parent balance for the prior year. Data type: Money Required: No |
Prior year 2 - consolidated balance (consolidated_prior_year_two) | The consolidated balance for prior year 2. If you assign this field, you must also assign a corresponding parent balance for prior year 2. Data type: Money Required: No |
Prior year 3 - consolidated balance (consolidated_prior_year_three) | The consolidated balance for prior year 3. If you assign this field, you must also assign a corresponding parent balance for prior year 3. Data type: Money Required: No |
Prior year 4 - consolidated balance (consolidated_prior_year_four) | The consolidated balance for prior year 4. If you assign this field, you must also assign a corresponding parent balance for prior year 4 Data type: Money Required: No |
Current year - parent balance (parent_current_year) | The parent balance for the current year. If you assign this field, you must also assign a corresponding consolidated balance for the current year. Data type: Money Required: No |
Prior year - parent balance (parent_prior_year) | The parent balance for the prior year. If you assign this field, you must also assign a corresponding consolidated balance for the prior year. Data type: Money Required: No |
Prior year 2 - parent balance (parent_prior_year_two) | The parent balance for prior year 2. If you assign this field, you must also assign a corresponding consolidated balance for prior year 2. Data type: Money Required: No |
Prior year 3 - parent balance (parent_prior_year_three) | The parent balance for prior year 3. If you assign this field, you must also assign a corresponding consolidated balance for prior year 3. Data type: Money Required: No |
Prior year 4 - parent balance (parent_prior_year_four) | The parent balance for prior year 4. If you assign this field, you must also assign a corresponding consolidated balance for prior year 4. Data type: Money Required: No |
Current year - January balance (current_year_january) | The current year balance for January. Data type: Money Required: No |
Current year - February balance (current_year_february) | The current year balance for February. Data type: Money Required: No |
Current year - March balance (current_year_march) | The current year balance for March. Data type: Money Required: No |
Current year - April balance (current_year_april) | The current year balance for April. Data type: Money Required: No |
Current year - May balance (current_year_may) | The current year balance for May. Data type: Money Required: No |
Current year - June balance (current_year_june) | The current year balance for June. Data type: Money Required: No |
Current year - July balance (current_year_july) | The current year balance for July. Data type: Money Required: No |
Current year - August balance (current_year_august) | The current year balance for August. Data type: Money Required: No |
Current year - September balance (current_year_september) | The current year balance for September. Data type: Money Required: No |
Current year - October balance (current_year_october) | The current year balance for October. Data type: Money Required: No |
Current year - November balance (current_year_november) | The current year balance for November. Data type: Money Required: No |
Current year - December balance (current_year_december) | The current year balance for December. Data type: Money Required: No |
Current year - quarter 1 balance (current_year_first_quarter) | The current year balance for the first quarter. Data type: Money Required: No |
Current year - quarter 2 balance (current_year_second_quarter) | The current year balance for the second quarter. Data type: Money Required: No |
Current year - quarter 3 balance (current_year_third_quarter) | The current year balance for the third quarter. Data type: Money Required: No |
Current year - quarter 4 balance (current_year_fourth_quarter) | The current year balance for the fourth quarter. Data type: Money Required: No |
Prior year - January balance (prior_year_january) | The prior year balance for January. Data type: Money Required: No |
Prior year - February balance (prior_year_february) | The prior year balance for February. Data type: Money Required: No |
Prior year - March balance (prior_year_march) | The prior year balance for March. Data type: Money Required: No |
Prior year - April balance (prior_year_april) | The prior year balance for April. Data type: Money Required: No |
Prior year - May balance (prior_year_may) | The prior year balance for May. Data type: Money Required: No |
Prior year - June balance (prior_year_june) | The prior year balance for June. Data type: Money Required: No |
Prior year - July balance (prior_year_july) | The prior year balance for July. Data type: Money Required: No |
Prior year - August balance (prior_year_august) | The prior year balance for August. Data type: Money Required: No |
Prior year - September balance (prior_year_september) | The prior year balance for September. Data type: Money Required: No |
Prior year - October balance (prior_year_october) | The prior year balance for October. Data type: Money Required: No |
Prior year - November balance (prior_year_november) | The prior year balance for November. Data type: Money Required: No |
Prior year - December balance (prior_year_december) | The prior year balance for December. Data type: Money Required: No |
Prior year - quarter 1 balance (prior_year_first_quarter) | The prior year balance for the first quarter. Data type: Money Required: No |
Prior year - quarter 2 balance (prior_year_second_quarter) | The prior year balance for the second quarter. Data type: Money Required: No |
Prior year - quarter 3 balance (prior_year_third_quarter) | The prior year balance for the third quarter. Data type: Money Required: No |
Prior year - quarter 4 balance (prior_year_fourth_quarter) | The prior year balance for the fourth quarter. Data type: Money Required: No |
Current year - month 1 balance (current_year_first_month) | The current year balance for the first month of the financial year. Data type: Money Required: No |
Current year - month 2 balance (current_year_second_month) | The current year balance for the second month of the financial year. Data type: Money Required: No |
Current year - month 3 balance (current_year_third_month) | The current year balance for the third month of the financial year. Data type: Money Required: No |
Current year - month 4 balance (current_year_fourth_month) | The current year balance for the fourth month of the financial year. Data type: Money Required: No |
Current year - month 5 balance (current_year_fifth_month) | The current year balance for the fifth month of the financial year. Data type: Money Required: No |
Current year - month 6 balance (current_year_sixth_month) | The current year balance for the sixth month of the financial year. Data type: Money Required: No |
Current year - month 7 balance (current_year_seventh_month) | The current year balance for the seventh month of the financial year. Data type: Money Required: No |
Current year - month 8 balance (current_year_eighth_month) | The current year balance for the eighth month of the financial year. Data type: Money Required: No |
Current year - month 9 balance (current_year_ninth_month) | The current year balance for the ninth month of the financial year. Data type: Money Required: No |
Current year - month 10 balance (current_year_tenth_month) | The current year balance for the tenth month of the financial year. Data type: Money Required: No |
Current year - month 11 balance (current_year_eleventh_month) | The current year balance for the eleventh month of the financial year. Data type: Money Required: No |
Current year - month 12 balance (current_year_twelfth_month) | The current year balance for the twelfth month of the financial year. Data type: Money Required: No |
Current year - first half balance (current_year_first_half) | The balance for the first half of the current year. Data type: Money Required: No |
Current year - second half balance (current_year_second_half) | The balance for the second half of the current year. Data type: Money Required: No |
Prior year - first half balance (prior_year_first_half) | The balance for the first half of the prior year. Data type: Money Required: No |
Prior year - second half balance (prior_year_second_half) | The balance for the second half of the prior year. Data type: Money Required: No |
Prior year 2 - first half balance (prior_year_two_first_half) | The balance for the first half of prior year 2. Data type: Money Required: No |
Prior year 2 - second half balance (prior_year_two_second_half) | The balance for the second half of prior year 2. Data type: Money Required: No |
Prior year 3 - first half balance (prior_year_three_first_half) | The balance for the first half of prior year 3. Data type: Money Required: No |
Prior year 3 - second half balance (prior_year_three_second_half) | The balance for the second half of prior year 3. Data type: Money Required: No |
Prior year 4 - first half balance (prior_year_four_first_half) | The balance for the first half of prior year 4. Data type: Money Required: No |
Prior year 4 - second half balance (prior_year_four_second_half) | The balance for the second half of prior year 4. Data type: Money Required: No |
Current year - planning balance (current_year_planning | The planning balance for the current year. Data type: Money Required: No |
Prior year - planning balance (prior_year_planning | The planning balance for the prior year. Data type: Money Required: No |
Prior year - month 1 balance (prior_year_first_month) | The prior year balance for the first month of the financial year. Data type: Money Required: No |
Prior year - month 2 balance (prior_year_second_month) | The prior year balance for the second month of the financial year. Data type: Money Required: No |
Prior year - month 3 balance (prior_year_third_month) | The prior year balance for the third month of the financial year. Data type: Money Required: No |
Prior year - month 4 balance (prior_year_fourth_month) | The prior year balance for the fourth month of the financial year. Data type: Money Required: No |
Prior year - month 5 balance (prior_year_fifth_month) | The prior year balance for the fifth month of the financial year. Data type: Money Required: No |
Prior year - month 6 balance (prior_year_sixth_month) | The prior year balance for the sixth month of the financial year. Data type: Money Required: No |
Prior year - month 7 balance (prior_year_seventh_month) | The prior year balance for the seventh month of the financial year. Data type: Money Required: No |
Prior year - month 8 balance (prior_year_eighth_month) | The prior year balance for the eighth month of the financial year. Data type: Money Required: No |
Prior year - month 9 balance (prior_year_tenth_month) | The prior year balance for the ninth month of the financial year. Data type: Money Required: No |
Prior year - month 10 balance (prior_year_ninth_month) | The prior year balance for the tenth month of the financial year. Data type: Money Required: No |
Prior year - month 11 balance (prior_year_eleventh_month) | The prior year balance for the eleventh month of the financial year. Data type: Money Required: No |
Prior year - month 12 balance (prior_year_twelfth_month) | The prior year balance for the twelfth month of the financial year. Data type: Money Required: No |
Prior year 2 - month 1 balance (prior_year_two_first_month) | The prior year 2 balance for the first month of the financial year. Data type: Money Required: No |
Prior year 2 - month 2 balance (prior_year_two_first_month) | The prior year 2 balance for the second month of the financial year. Data type: Money Required: No |
Prior year 2 - month 3 balance (prior_year_two_third_month) | The prior year 2 balance for the third month of the financial year. Data type: Money Required: No |
Prior year 2 - month 4 balance (prior_year_two_fourth_month) | The prior year 2 balance for the fourth month of the financial year. Data type: Money Required: No |
Prior year 2 - month 5 balance (prior_year_two_fifth_month) | The prior year 2 balance for the fifth month of the financial year. Data type: Money Required: No |
Prior year 2 - month 6 balance (prior_year_two_sixth_month) | The prior year 2 balance for the sixth month of the financial year. Data type: Money Required: No |
Prior year 2 - month 7 balance (prior_year_two_seventh_month) | The prior year 2 balance for the seventh month of the financial year. Data type: Money Required: No |
Prior year 2 - month 8 balance (prior_year_two_eighth_month) | The prior year 2 balance for the eighth month of the financial year. Data type: Money Required: No |
Prior year 2 - month 9 balance (prior_year_two_ninth_month) | The prior year 2 balance for the ninth month of the financial year. Data type: Money Required: No |
Prior year 2 - month 10 balance (prior_year_two_tenth_month) | The prior year 2 balance for the tenth month of the financial year. Data type: Money Required: No |
Prior year 2 - month 11 balance (prior_year_two_eleventh_month) | The prior year 2 balance for the eleventh month of the financial year. Data type: Money Required: No |
Prior year 2 - month 12 balance (prior_year_two_twelfth_month) | The prior year 2 balance for the twelfth month of the financial year. Data type: Money Required: No |
Prior year 3 - month 1 balance (prior_year_three_first_month) | The prior year 3 balance for the first month of the financial year. Data type: Money Required: No |
Prior year 3 - month 2 balance (prior_year_three_second_month) | The prior year 3 balance for the second month of the financial year. Data type: Money Required: No |
Prior year 3 - month 3 balance (prior_year_three_third_month) | The prior year 3 balance for the third month of the financial year. Data type: Money Required: No |
Prior year 3 - month 4 balance (prior_year_three_fourth_month) | The prior year 3 balance for the fourth month of the financial year. Data type: Money Required: No |
Prior year 3 - month 5 balance (prior_year_three_fifth_month) | The prior year 3 balance for the fifth month of the financial year. Data type: Money Required: No |
Prior year 3 - month 6 balance (prior_year_three_sixth_month) | The prior year 3 balance for the sixth month of the financial year. Data type: Money Required: No |
Prior year 3 - month 7 balance (prior_year_three_seventh_month) | The prior year 3 balance for the seventh month of the financial year. Data type: Money Required: No |
Prior year 3 - month 8 balance (prior_year_three_eighth_month) | The prior year 3 balance for the eighth month of the financial year. Data type: Money Required: No |
Prior year 3 - month 9 balance (prior_year_three_ninth_month) | The prior year 3 balance for the ninth month of the financial year. Data type: Money Required: No |
Prior year 3 - month 10 balance (prior_year_three_tenth_month) | The prior year 3 balance for the tenth month of the financial year. Data type: Money Required: No |
Prior year 3 - month 11 balance (prior_year_three_eleventh_month) | The prior year 3 balance for the eleventh month of the financial year. Data type: Money Required: No |
Prior year 3 - month 12 balance (prior_year_three_twelfth_month) | The prior year 3 balance for the twelfth month of the financial year. Data type: Money Required: No |
Prior year 4 - month 1 balance (prior_year_four_first_month) | The prior year 4 balance for the first month of the financial year. Data type: Money Required: No |
Prior year 4 - month 2 balance (prior_year_four_second_month) | The prior year 4 balance for the second month of the financial year. Data type: Money Required: No |
Prior year 4 - month 3 balance (prior_year_four_third_month) | The prior year 4 balance for the third month of the financial year. Data type: Money Required: No |
Prior year 4 - month 4 balance (prior_year_four_fourth_month) | The prior year 4 balance for the fourth month of the financial year. Data type: Money Required: No |
Prior year 4 - month 5 balance (prior_year_four_fifth_month) | The prior year 4 balance for the fifth month of the financial year. Data type: Money Required: No |
Prior year 4 - month 6 balance (prior_year_four_sixth_month) | The prior year 4 balance for the sixth month of the financial year. Data type: Money Required: No |
Prior year 4 - month 7 balance (prior_year_four_seventh_month) | The prior year 4 balance for the seventh month of the financial year. Data type: Money Required: No |
Prior year 4 - month 8 balance (prior_year_four_eighth_month) | The prior year 4 balance for the eighth month of the financial year. Data type: Money Required: No |
Prior year 4 - month 9 balance (prior_year_four_ninth_month) | The prior year 4 balance for the ninth month of the financial year. Data type: Money Required: No |
Prior year 4 - month 10 balance (prior_year_four_tenth_month) | The prior year 4 balance for the tenth month of the financial year. Data type: Money Required: No |
Prior year 4 - month 11 balance (prior_year_four_eleventh_month) | The prior year 4 balance for the eleventh month of the financial year. Data type: Money Required: No |
Prior year 4 - month 12 balance (prior_year_four_twelfth_month) | The prior year 4 balance for the twelfth month of the financial year. Data type: Money Required: No |
Prior year 2 - January balance (prior_year_two_january) | The prior year 2 balance for January. Data type: Money Required: No |
Prior year 2 - February balance (prior_year_two_february) | The prior year 2 balance for February. Data type: Money Required: No |
Prior year 2 - March balance (prior_year_two_march) | The prior year 2 balance for March. Data type: Money Required: No |
Prior year 2 - April balance (prior_year_two_april) | The prior year 2 balance for April. Data type: Money Required: No |
Prior year 2 - May balance (prior_year_two_may) | The prior year 2 balance for May. Data type: Money Required: No |
Prior year 2 - June balance (prior_year_two_june) | The prior year 2 balance for June. Data type: Money Required: No |
Prior year 2 - July balance (prior_year_two_july) | The prior year 2 balance for July. Data type: Money Required: No |
Prior year 2 - August balance (prior_year_two_august) | The prior year 2 balance for August. Data type: Money Required: No |
Prior year 2 - September balance (prior_year_two_september) | The prior year 2 balance for September. Data type: Money Required: No |
Prior year 2 - October balance (prior_year_two_october) | The prior year 2 balance for October. Data type: Money Required: No |
Prior year 2 - November balance (prior_year_two_november) | The prior year 2 balance for November. Data type: Money Required: No |
Prior year 2 - December balance (prior_year_two_december) | The prior year 2 balance for December. Data type: Money Required: No |
Prior year 3 - January balance (prior_year_three_january) | The prior year 3 balance for January. Data type: Money Required: No |
Prior year 3 - February balance (prior_year_three_february) | The prior year 3 balance for February. Data type: Money Required: No |
Prior year 3 - March balance (prior_year_three_march) | The prior year 3 balance for March. Data type: Money Required: No |
Prior year 3 - April balance (prior_year_three_april) | The prior year 3 balance for April. Data type: Money Required: No |
Prior year 3 - May balance (prior_year_three_may) | The prior year 3 balance for May. Data type: Money Required: No |
Prior year 3 - June balance (prior_year_three_june) | The prior year 3 balance for June. Data type: Money Required: No |
Prior year 3 - July balance (prior_year_three_july) | The prior year 3 balance for July. Data type: Money Required: No |
Prior year 3 - August balance (prior_year_three_august) | The prior year 3 balance for August. Data type: Money Required: No |
Prior year 3 - September balance (prior_year_three_september) | The prior year 3 balance for September. Data type: Money Required: No |
Prior year 3 - October balance (prior_year_three_october) | The prior year 3 balance for October. Data type: Money Required: No |
Prior year 3 - November balance (prior_year_three_november) | The prior year 3 balance for November. Data type: Money Required: No |
Prior year 3 - December balance (prior_year_three_december) | The prior year 3 balance for December. Data type: Money Required: No |
Prior year 4 - January balance (prior_year_four_january) | The prior year 4 balance for January. Data type: Money Required: No |
Prior year 4 - February balance (prior_year_four_february) | The prior year 4 balance for February. Data type: Money Required: No |
Prior year 4 - March balance (prior_year_four_march) | The prior year 4 balance for March. Data type: Money Required: No |
Prior year 4 - April balance (prior_year_four_april) | The prior year 4 balance for April. Data type: Money Required: No |
Prior year 4 - May balance (prior_year_four_may) | The prior year 4 balance for May. Data type: Money Required: No |
Prior year 4 - June balance (prior_year_four_june) | The prior year 4 balance for June. Data type: Money Required: No |
Prior year 4 - July balance (prior_year_four_july) | The prior year 4 balance for July. Data type: Money Required: No |
Prior year 4 - August balance (prior_year_four_august) | The prior year 4 balance for August. Data type: Money Required: No |
Prior year 4 - September balance (prior_year_four_september) | The prior year 4 balance for September. Data type: Money Required: No |
Prior year 4 - October balance (prior_year_four_october) | The prior year 4 balance for October. Data type: Money Required: No |
Prior year 4 - November balance (prior_year_four_november) | The prior year 4 balance for November. Data type: Money Required: No |
Prior year 4 - December balance (prior_year_four_december) | The prior year 4 balance for December. Data type: Money Required: No |
Prior year 2 - quarter 1 balance (prior_year_two_first_quarter) | The prior year 2 balance for the first quarter. Data type: Money Required: No |
Prior year 2 - quarter 2 balance (prior_year_two_second_quarter) | The prior year 2 balance for the second quarter. Data type: Money Required: No |
Prior year 2 - quarter 3 balance (prior_year_two_third_quarter) | The prior year 2 balance for the third quarter. Data type: Money Required: No |
Prior year 2 - quarter 4 balance (prior_year_two_fourth_quarter) | The prior year 2 balance for the fourth quarter. Data type: Money Required: No |
Prior year 3 - quarter 1 balance (prior_year_three_first_quarter) | The prior year 3 balance for the first quarter. Data type: Money Required: No |
Prior year 3 - quarter 2 balance (prior_year_three_second_quarter) | The prior year 3 balance for the second quarter. Data type: Money Required: No |
Prior year 3 - quarter 3 balance (prior_year_three_third_quarter) | The prior year 3 balance for the third quarter. Data type: Money Required: No |
Prior year 3 - quarter 4 balance (prior_year_three_fourth_quarter) | The prior year 3 balance for the fourth quarter. Data type: Money Required: No |
Prior year 4 - quarter 1 balance (prior_year_four_first_quarter) | The prior year 4 balance for the first quarter. Data type: Money Required: No |
Prior year 4 - quarter 2 balance (prior_year_four_second_quarter) | The prior year 4 balance for the second quarter. Data type: Money Required: No |
Prior year 4 - quarter 3 balance (prior_year_four_third_quarter) | The prior year 4 balance for the third quarter. Data type: Money Required: No |
Prior year 4 - quarter 4 balance (prior_year_four_fourth_quarter) | The prior year 4 balance for the fourth quarter. Data type: Money Required: No |
Prior year 2 - planning balance (prior_year_two_planning) | The planning balance for prior year 2. Data type: Money Required: No |
Prior year 3 - planning balance (prior_year_three_planning) | The planning balance for prior year 3. Data type: Money Required: No |
Prior year 4 - planning balance (prior_year_four_planning) | The planning balance for prior year 4. Data type: Money Required: No |
