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.
Select
File
then
New Client
to create a new client in Fixed Assets CS.
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.
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
.

Get help