Depreciation Data Conversion—BNA Fixed Assets Desktop to Fixed Assets CS

Review information before the data conversion

Identify the clients to be converted and note their client IDs and file names in BNA Fixed Assets Desktop.
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 BNA Fixed Assets Desktop client data resides.
Note the entity type of the client (I = Individual, C = C Corporation, S = S Corporation, P = Partnership, and so on).
Note the current-year beginning and ending dates (found in the Basic Information tab in the Client Properties screen).

Create conversion files from BNA Fixed Assets Desktop data files—Step 1 create the export file

Open the BNA Fixed Assets Desktop program.
Open the BNA Fixed Assets client to be converted.
With the client open, select
Export to BNAFA Web
from the Asset menu.
Go to
Name
and enter a client ID then select
Next
. Also, record this ID as you'll need the ID in the “Create the conversion import file” procedure.
Select
Browse
, enter the same client ID you used in the previous step in the File name field, then select
Save
.
Note the data path and file name that show in the File name field, then select
Next
. This information is used in the “Create the conversion import file” procedure.
Select
Next
.
Select
Finish
to create the export file

Create conversion files from BNA Fixed Assets Desktop data files—Step 2 create the conversion file

To start the CS Conversions application, double-click
CS Data Conversions
on your desktop.
note
If you didn't install the shortcut, select
Start
on the Windows taskbar then select
All Programs
,
CS Professional Suite
, then
CS Data Conversions
.
Go to Conversion Type and select
Depreciation
.
Go to Competitor and select
BNA Fixed Assets Desktop
.
Go to the Input Data Folder and select
Browse
to navigate to the data path used in step 6 of the procedure to create the export file.
Select
Start
to start the conversion program.
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 7.
To import the converted data into Fixed Assets CS, select
Close
and then 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. If you didn't install the shortcut, select
Start
on the Windows taskbar then
All Programs
,
CS Professional Suite
,
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 BNA Fixed Assets Desktop 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 BNA Fixed Assets Desktop 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 BNA Fixed Assets Desktop.
note
To limit the number of files that show, 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 2 steps to create conversion files from BNA Fixed Assets Desktop (create export file and create conversion file).

Converted items—Known exceptions

Converted items—Activity

Converted items—Treatments

Converted items—Methods

Converted items—BNA Fixed Assets Desktop’s 175% declining-balance method

Converted items—Asset life

Converted items—Alternative Depreciation System (ADS) method

Converted items—Alternative Depreciation System, code ASL – MACRS Real

If the asset was acquired before May 13, 1993, the asset converts to Fixed Assets CS with a life of 31.5.
If the asset was acquired after May 12, 1993, the asset converts to Fixed Assets CS with a life of 39.

Converted items—BNA Fixed Assets Desktop straight-line AS

Converted items—Asset dispositions

Converted items—Inactive assets

Converted items—Listed property

Converted items—Asset ID

Converted items—Associations

Converted items—Section 168(k)

Converted items—Business use

Converted items—Section 179

Converted items—ITC basis reduction and ITC codes

Converted items—Amortization

Date in service

Converted items—Mid-quarter

Converted items—Monthly depreciation

Converted items—Switch to Straight-Line field

Items not converted

General information, such as company name, company acronym, 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 BNA Fixed Assets Desktop. You'll need to 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.
Client notes.
Data in the
Vehicles and Listed
tab.
Disposition information.
Information entered in the
Type of disposition
,
Property code
,
Gross sales price
, and
Disposition expense
and other disposal fields in the
Disposition
tab in BNA Fixed Assets Desktop.

Review the converted data

Make any necessary changes identified in the “Items not converted” section of this article.
Print the
Asset Depreciation Report
in BNA Fixed Assets Desktop.
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 BNA Fixed Assets Desktop 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