-- Reference --

Sage Import Dialog Fields

Depending on the version that you are importing from and the import components that you selected, some of the fields/options may be disabled.

Field Description
Import current year This imports the current year balances.
Import prior year as current

This imports the prior year as the current year.

Note: When choosing this option, there will be no corresponding prior year information imported into the Working Papers file.

Use debit sign for imported acct.

Selecting this will set all categories of Sales and all categories of Capital & Reserves to be set as ’r;Debit’ in the Trial Balance.

Bank Account items will be set to ’r;Debit’ and VAT Liability items will be set to ’r;Credit’ regardless of whether or not this check box is selected.

Use department to build entity

This imports entity information when importing full General Ledger detail. Working Papers will use the department codes in the Sage file to build an entity corresponding to each department during the import.

The department codes are not contained in the Sage chart of accounts, so this option in not available when doing a Trial Balance import.

VAT Cash Accounting This option is to be selected if the company file has been set up to use VAT Cash Accounting.
Reverse ledger year end entries

Select this check box if:

  • Importing the prior year GL detail as current
  • If the final balance (prior year) reflects the results of year-end closing entries.

Selecting the box will reverse those entries and the general ledger will be imported displaying pre-closing balances.

Budget Data This imports the budget data into the client file.
Prior Year Data

This imports prior year balances into Working Papers.

Note: Any existing prior year data will be overwritten. To leave existing prior year balances untouched, leave the check box empty.

Import as yearly file

This option imports the data as a yearly file.

Note: This is supported in version 2007 and later.

Month in which financial year ends (1-12, searched if blank) The number of the month in which the fiscal year ends (1 for January, 2 for February, 3 for March, and so on). If left blank, Working Papers searches for it in the import file.