AuditDesktop enables you to import Trial balance and update accounts.
You can import three Trial balance types: Initial, Control, and
Previous.
-
Open the Statements tab and click the Trial
balance
button. -
Click Import and from the drop-down menu select the Trial balance
type that you want to import. -
The Import trial balance window gives access to the following
actions:
- Import data - opens the window for data
import.
Note that when setting up the specifications, you must set the
import mode to Append. - Update accounts - adds new accounts to existing ones.
- Clear existing accounts - clears the existing chart of accounts
and uses the chart of accounts from the imported trial balance. - Add to existing values - adds new sums without replacing the
existing ones. - Group accounts - groups trial balance accounts up to a specified
level.
The window has two different view modes, depending on the selected Trial
balance representation format. If you have chosen to work with
one-column trial balance, the Closing balance column will be divided
into Debit and Credit. If you are working with six-column trial
balance, the columns will be Opening balance, Turnover and
Closing balance, each divided into Debit and Credit.
- Once you are ready, click Save.
Data can also be imported with the Copy & Paste functions. Copying
is done from from spreadsheet. Copy the TB (Ctrl+C keyboard
shortcut) and select the first row in the account (you must select the
entire cell). Paste the data (Ctrl+V keyboard shortcut) and click
Save. Note that the decimal separators of the output data and the
program's settings must be identical.