Warning

Product support for the Creative Solutions Accounting platform ended on September 30, 2020.

Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.

If you use Fixed Assets CS and Creative Solutions (CSA) Trial Balance CS, you can eliminate most of the effort required to make periodic journal entries in Trial Balance CS by importing those journal entries. This procedure also helps ensure that your general ledger balances coincide with your Fixed Assets CS depreciation detail records.

Setting up file locations in CSA

• For Write-Up CS or Trial Balance CS users: Choose Setup > User Preferences > File Locations. In the Fixed Assets data path field, specify the drive and folder where your Fixed Assets CS client data files are stored.
• Write-Up CS users only: Choose File > New Client or File > Client Properties. In the General Ledger tab of the Client Properties dialog, choose the appropriate selection in the Journal for Fixed Assets CS JE field.

Setting up file locations in Fixed Assets CS:

Choose Setup > User Preferences > File Locations and mark the CS Accounting Products option. Enter the appropriate paths for both Creative Solutions Accounting and CSA client data.

Steps in Fixed Assets CS:

Perform these steps prior to importing the journal entry transaction files into CSA. You only need to perform these steps once for each client.

1. Open the client in Fixed Assets CS.

   Note: The client ID in Fixed Assets CS must be the same as the client ID in CSA. The client ID should be no greater than eleven characters.

2. Choose File > Print and print the Book or Tax Group Summary Report (depending on which treatment balances you wish to use to make the journal entry). Use the report to verify that each asset group's cost and accumulated depreciation beginning balances for the current period coincide with the beginning balances for the corresponding accounts in CSA. If you are basing the journal entries on an association other than Group (Location, Division, etc.), print either the Book or Tax Asset Detail report and choose the options to sort and subtotal the report based on this association.
3. Choose Setup > Journal Entry Accounts.
4. Assign a unique number from 2.00 to 99.99 in the Journal entry reference number (x.xx) field at the top of the dialog. The program will use this number when the transaction is posted to CSA.
5. To make a single journal entry for all assets, mark the Create a single journal entry for all assets checkbox.
6. Mark the Journal entry for Creative Solutions Accounting checkbox to have Fixed Assets CS create the journal entry transaction files to be imported into CSA.

   Note: The checkbox is available only if the program and client data paths for CSA have been entered correctly in the Setup > User Preferences > File Locations tab in Fixed Assets CS.

7. Click the option in the Treatment group box (either Book or Tax) that the program should use to create the journal entry.
8. Mark the Journal entry to a Microsoft Excel file checkbox, if desired. When the client data is closed, Fixed Assets CS will create an export file named DAAAAAMMMYY.xls, where AAAAA is the first five characters of the client ID, MMM is the month of the current client's year end, and YY is the last two digits of the client's current year end. The export file is created in the client's depreciation data folder, which is in X:\WinCSI\DeprData folder by default, where X is the drive letter where the data is stored.
9. For each asset group, enter the journal entry description and the applicable general ledger account number.
10. Enter the CSA offset account number in the Offset field.

    Note: You must have a CSA offset account for the client to reflect purchase and sale activity. We suggest you use Account #999 and or create a new general ledger account "Fixed Assets CS Depreciation Offset." This is a clearing account that is cleared when the journal entry is made.

11. Click OK to close the Journal Entry Accounts dialog.
12. Fixed Assets CS automatically creates journal entry transaction files for each period that the client processes in Fixed Assets CS. To view journal entry information that is ready to be imported into CSA, choose Tasks > Display Journal Entry.
13. Close the Fixed Assets CS client.

Steps in CSA:

1. Open the client in CSA.
2. If you have enabled the General Ledger only module on the client, in the General Ledger tab of File > Client Properties, choose the appropriate selection in the Journal for Fixed Assets CS JE field if you are using multiple journals and have checked the option to Use separate journals in transaction data entry.

   Note: The journal information from Fixed Assets CS for a Trial Balance CS or General Ledger / Trial Balance CS client will be imported as an Adjusting entry in the Trial Balance Adjusting Journal Entries window. You can view and modify these entries in the Adjusting Journal Entries window or in the split-screen view of the Trial Balance window.

3. To import the journal entry transaction files from Fixed Assets CS, choose Utilities > Import Fixed Assets CS Journal Entries.

Additional Notes:

• You may import the journal entry information at any interval that is appropriate for the selected General Ledger or Trial Balance client.
• The imported information automatically overwrites any depreciation journal entries that may already be on file for the client in the current period.

Was this article helpful?

Yes No

Submit