Draftworx Wiki

Appearance

Importing Your Trial Balance (Desktop) ​

What it is: The process of bringing a client's account balances into Draftworx Desktop from an accounting system or spreadsheet, so they can be linked and used to generate the Annual Financial Statements.

What it's for ​

The Working Trial Balance is the foundation of every set of financial statements in Draftworx. Before you can link accounts or open the statements, you need to load the client's trial balance data. Draftworx Desktop supports direct connections to popular accounting systems as well as manual imports from Excel and other formats.

How to do it ​

Importing from an Excel Spreadsheet (DX006) ​

  1. On the Working Trial Balance, select Spreadsheet.
  2. Browse to the Excel file (.xlsx, .xls, or .csv) and click Open.
  3. Assign each required column: Account Number (must be unique), Account Name, Debit, and Credit.
    • If debit and credit amounts are in one column as positive/negative values, assign that single column to both Debit and Credit.
  4. Confirm the starting row (first active data row) and select Import.

Importing Directly from Sage Business Cloud (DX020) ​

  1. Select Direct Import, then Sage Business Cloud.
  2. Enter your Sage One login credentials and log in.
  3. Select the entity to import from.
  4. Optionally tick Import Monthly Balances for a monthly breakdown; leave unticked for yearly. Tick Automatically Link Accounts to have Draftworx suggest link numbers.
  5. The date range defaults to the financial year set up in the client file — adjust if needed.

Importing from Sage One (DX017) ​

  1. Select Sage, then Sage One.
  2. Enter login credentials and select the relevant entity.
  3. Select Import.

Importing from Pastel Evolution (DX022) ​

  1. Select Sage, then Pastel Evolution, then OK.
  2. Enter your Evolution database credentials.
  3. Select the database, adjust dates if needed, choose the import option, and import.

Other Supported Sources ​

All other import methods follow the same general pattern of selecting the relevant source and following the on-screen prompts:

SourceMethod
Pastel Partner / ExpressSage → Pastel Partner/Express
QuickBooks (Direct)Direct Import → QuickBooks
QuickBooks DesktopQuickBooks → Desktop
QuickBooks OnlineQuickBooks → Online
XeroDirect Import → Xero
CasewareSage → Caseware
PalladiumSage → Palladium
OtherWorking Trial Balance → Other options

Source ​

https://draftworx.helpjuice.com/desktop/draftworx-desktop-importing-your-trial-balance

Walkthrough ​

Key Scribe guides (12 total — see source bundle for all):