Depreciation Data Conversion—Sage Fixed Assets to Fixed Assets CS

Review information before the data conversion

Identify the clients you want to convert and note their client IDs and file names in Sage Fixed Assets. Clients you convert need to be in the Sage Fixed Assets program; having the fas.db file alone without the client existing in Sage Fixed Assets won't work.
Identify the client IDs you'll use in Fixed Assets CS. If you'll integrate your depreciation client data with UltraTax CS® and/or Accounting CS®, the client IDs need to match.
Note the drive and path where the Sage Fixed Assets client data resides.
Make sure the Fixed Assets CS Conversion utility is installed on the same machine as Sage Fixed Assets.
Note the current calculation period and ending date by reviewing the
Current Through Date
field in the asset’s Detail View. Before you convert your client data, verify that the current depreciation has been calculated for all of the client’s assets in Sage Fixed Assets.

Create conversion files from Sage Fixed Assets data files

To start the CS Conversions application, run the Fixed Assets CS Data Conversion utility you installed to the same location as Sage Fixed Assets is installed.
Go to Conversion Type and select
Depreciation
.
Go to Competitor field and select
FAS Asset Accounting – Version 2007.x and later
.
Go to Input Data Folder and select
Browse
to go to the location where your data is stored.
Select
Start
to start the conversion program.
Select the
fas.db
database file then select
Open
.
In the client list, select the client you want to convert then select
OK
.
The client’s data is converted and a Client Data Transfer Report is prepared.
When the process is complete, select
OK
.
To process another client, repeat steps 5 through 8.
To import the converted data into Fixed Assets CS, select
Close
and go to the “Import the conversion file into Fixed Assets CS” section.

Import the conversion file into Fixed Assets CS

Double-click
Fixed Assets CS
on your desktop to start the program.
note
If you didn't install the shortcut, select
Start
on the Windows taskbar and select
All Programs
,
CS Professional Suite
, then
Fixed Assets CS
.
Select
File
then
New Client
to create a new client in Fixed Assets CS.
note
If applicable, you'll need to complete the
Current fiscal year end
and
Short years
fields in the New Client window exactly as the information was entered in Sage Fixed Assets to ensure that the processing periods and depreciation calculation in the 2 applications match.
Select
Utilities
,
Import Asset Data
, then
ASCII file
. If the path specified in the
Location of import
file field isn't the location of your Sage Fixed Assets client data, select
Change Location
  and go to the correct location.
Enter the name of the conversion file you want to import or select the dropdown for a list of conversion files that are available in the specified location. The name of the conversion file is in the
XXXXXXXXXXX.DSW
format, where
XXXXXXXXXXX
is the client’s file name from Sage Fixed Assets.
note
To limit the number of files that appear, select
Only include files with DSW extensions
. The conversion program truncates file names longer than 11 characters.
Select
Import
to transfer the files.
When the import is complete, select
Done
.
Repeat steps 2 through 6 for each client you’ve created a conversion file for. For any client whose conversion file hasn't yet been created, repeat the procedures in the “Create conversion files from Sage Fixed Assets data files” section.

Converted items—Known exceptions

Converted items—Activity

Converted items—Treatments

Converted items—Methods

Converted items—MACRS 25 assets

Converted items—MACRS formula vs tables

Converted items—MACRS 150% DB method

Converted items—Alternative Depreciation System (ADS) method code AD

Converted items—Declining-balance methods: DC, DE, and DI

Converted items—Sage Fixed Assets ACRS straight-line codes SA and ST

Converted items—Indian reservation

Converted items—Asset dispositions

Converted items—Inactive assets

Converted items—Listed property

Converted items—Associations

Converted items—Section 168(k)

Converted items—Business use

Converted items—Section 179

Converted items—Mid-quarter

Items not converted

General information, such as client ID, company name, fiscal year-end dates, and short-year information. You'll need to manually enter this information when you add the client.
General ledger account numbers. GL asset account, GL depr. / amort. exp. acct., and GL accum. depr. / amort. acct. numbers in the Detail tab in Sage Fixed Assets. You must set up the journal entry accounts in Fixed Assets CS to create asset cost and corresponding depreciation journal entry information.
Customized depreciation reports. Custom reports are available in Fixed Assets CS.
Custom depreciation methods.
Asset notes.
Asset images.
Asset history information.
ITC basis reduction and ITC code.
Amortization code section number.
Disposition information. Information entered in the Partial Disposal, Cash Proceeds, Non-Cash Proceeds, and Expenses of Sale fields on the Disposition screen in Sage.

Review the converted data

Make any necessary changes identified in the “Items not converted” section of this document.
Print the
Depreciation Expense Report
in Sage Fixed Assets.
Print the
Tax Asset Detail Report
in Fixed Assets CS.
Compare the totals for basis, accumulated depreciation, and current depreciation expense.
Print and review the
Client Data Transfer Reports
.
note
These reports are created for each client to identify any differences in the data that resulted from the conversion process. Most items included on the report are strictly informational; however, you may need to manually update certain items (such as abbreviations and truncations) in Fixed Assets CS. In most instances, no action is required.
You can print or view these reports using My Computer or Windows Explorer to navigate to the folder in which the client’s original Sage Fixed Assets data and conversion files are stored. Double-click the
XXXXXXXXXXX_D.PDF file
, where XXXXXXXXXXX represents the client ID. Note that if the client ID is more than 11 characters, only the first 11 characters appear.
We recommend that you print and review the Client Data Transfer Reports and store the reports with the client files in your office. These reports are PDF files. To view and print the reports, use Adobe® Reader®. To install Adobe Reader, select
Help
,
On the Web
, then
Adobe Reader
in Fixed Assets CS, which opens the Adobe website from which you can download and install the Reader.

Get help