Import data

Import trial balance

The
Trial Balance
 screen displays manual journals along with imported journals. You can view general ledger information imported into ONESOURCE Corporate Tax. It provides an audit trail for tracking the source data of calculations. Data can be sorted, filtered, and exported to Microsoft Excel.
A trial balance can be used to prepare a report showing how source data is mapped to tax accounts in the template, which helps you determine if your mapping is correct. It can also help you prepare an audit trail report that lists each form label in your tax return and shows the accounts in your trial balance that generates these amounts.
Imported Amount
 and
Total
 reflect the signage as processed by the import. ONESOURCE Corporate Tax expects that credits are negative and debits are positive. Signage can be automatically reversed during import.
  1. Select
    Imports
    , then
    Trial Balance
    .
  2. Use the dropdowns to select the import you want to work with:
    Option
    Details
    Dataset
    Choose a dataset from the
    Dataset
    dropdown list. Filtered data persists from one session to the next.
    Entity
    Select an entity from the
    Entity
     dropdown list, based on the dataset you selected.
    Import Type
    Select an import type based on your selections in the
    Dataset
     and
    Entity
     dropdown lists.
    • Code
       displays the ITR code for each account code.
    • Account Description
       displays the ITR description for each account code.
    • Total
       adds together the imported amount and the journal adjustment to show the net amount for journals after adjusting. This amount flows to your calculations.
    • Select
      Imported Amount
       to open the system trial balance journal.
    • Journal Adjustment
       shows the net amount of journals made against a general ledger account and lets you drill down to the appropriate journals. Select the hyperlinked amount to open the relevant journal.

This article applies to:

  • Product: ONESOURCE Trusts
  • Subject: Import,Trial balance