Skip to main content

Solutions

Law firms

Tax, audit & accounting firms

Corporations

Governments

Products

Legal

Trade & supply

Tax, audit & accounting

Corporate tax

Risk & fraud

Books

Recommended products

Questions? We are here to help.
Contact us

Purchase

Buy solutions

Buy books

Contact sales

Questions? We are here to help.

Resources

Insights

Events

Product training

Product communities

Developers

Compare trial balances
Search
Search Garden Advanced Support Help and Support.

This article applies to:

  • Subject: Trial balance

Import trial balance data from a spreadsheet

Follow these steps to import trial balance data from a spreadsheet into AdvanceFlow.
  1. In AdvanceFlow, open the engagement you want to import the trial balance data into.
  2. Select the
    Trial Balance
     tab,
    Data
    , then
    Import
    .
  3. Select
    Browse for file
    , select the spreadsheet file with the trial balance data you want to import, then
    Open
    , and
    Next
    .
  4. Use the
    Select worksheet
     dropdown to select the worksheet that contains the data.
  5. Choose how you want to handle duplicate accounts from the following options:
    • Display as errors
      : If duplicate account numbers exist, you'll be prompted to choose between renumbering the duplicate account number or excluding the duplicate account number from the imported file.
    • Import first account
      : If duplicate account numbers exist, the first account is imported.
    • Import last account
      : If duplicate account numbers exist, the last account is imported.
  6. Mark the
    Exclude accounts with zero balances
     checkbox you don't want to include zero balance accounts in the import.
  7. Select
    Next
    .
  8. Define data in each column of the trial balance.
    1. Map each spreadsheet column by specifying the column title (Type) for each column in the table.
    2. Select a column heading in the table, then choose the applicable title from the dropdown. Available column titles include:
      Available columns for mapping
      Column title
      Additional selections
      Notes
      Not Used
      n/a
      The application will not import any data from this column.
      Account Number
      n/a
      This is a required column. Account numbers can contain up to 65 characters.
      Account Description
      n/a
      This is a required column. If the account description for an existing account is different from the description in the spreadsheet, the application updates the description using the information in the spreadsheet during the import. Account descriptions can contain up to 120 characters, including spaces.
      Account Grouping
      Account grouping code or subcode
      AdvanceFlow adds new custom codes and subcodes to the Account Groupings screen.
      The selected engagement must include at least one account grouping for this column to be visible. If you do not see the Account Grouping column for the current engagement, you must add or import account groupings to the engagement.
      Tax Information
      Tax Code, Tax Subcode, M-3 Tax Code, M-3 Tax Subcode or Property Code
      AdvanceFlow adds new custom tax subcodes and M-3 subcodes to the client Tax Code setup. You can assign property code units to a column only if the tax code is already assigned to an existing column.
      When transferring data to a tax application, a property code can be used to designate the input screen location for multiple-unit entities.
      For example, if you're transferring utilities expenses for a farm to the UltraTax CS Farm input screen and the tax code for the first unit's utilities is 632 and the property code is 1, you'd transfer the second unit's utilities with a tax code of 632 and a property code of 2.
      Unadjusted Balance
      Current Period only and Amount Type (DR/CR, DR, CR)
      N/A
      Budget Balance and Adjusted Budget Balance
      Period end date or Year for the current year and prior years available and Amount Type (DR/CR, DR,CR)
      N/A
      Adjusted Balance, Report Balance, Federal Tax Balance, State Tax Balance, Other Balance, and Proposed Balance
      Prior period and years available and Amount Type (DR/CR, DR, CR)
      N/A
    3. Select the
      Omit
       checkboxes for any rows of data that you do not want to include in the import.
    4. Select
      Done
      .
    You can access all other areas of AdvanceFlow during the import process.
If you're importing data into a trial balance that already exists, AdvanceFlow updates and appends the existing data during the import process.
Example:
Existing trial balance
  • Account 101 - 10,000
  • Account 102 - 20,000
Import spreadsheet
  • Account 102 - 14,000
  • Account 103 - 5,000
End result
  • Account 101 - 10,000
  • Account 102 - 14,000
  • Account 103 - 5,000
Sample spreadsheet
Download and save this sample trial balance spreadsheet. It includes Account Classification codes, subcodes, current-year unadjusted balance, and prior-year adjusted balance. You can modify the formatting, columns, and data to fit your needs.

Related Content