Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Integration

Export a journal entry to an Excel file

You need to perform these steps only once for each client.
  1. Select
    Setup
    , then
    Journal Entry Accounts
    .
  2. Enter a unique number from
    2.00
     to
    99.99
     in the
    Journal entry reference number
    field.
  3. To make a single journal entry for all assets, mark the
    Create a single journal entry for all assets
     checkbox.
  4. To make journal entries based on an association, choose an
    Association
    :
    • Group (Default if enabled)
    • Location
    • Type
    • Division
    • Cost center
    • Department
    • Custom associations that maintain a list
  5. Mark the
    Journal entry to a Microsoft Excel file
     checkbox to have Fixed Assets CS create the journal entry in Microsoft Excel format.
  6. Choose a treatment that Fixed Assets CS should use to create the journal entry:
    • Book
    • Tax
  7. For each asset group and list item for the association, enter the journal entry description and general ledger account number.
  8. Enter the
    Offset
     account number.
  9. Select
    OK
    .
    Fixed Assets CS creates a Microsoft Excel journal entry file for each period that the client processes.
  10. To view journal entry information that's ready to export, select
    Tasks
    , then
    Display Journal Entry
    .
  11. To view the Excel journal entry transaction file:
    1. Open Windows Explorer and go to the client's data folder at
      C:\WinCSI\DeprData\‹client ID›
      .
      note
      • C:/ is the drive on which Fixed Assets CS is installed.
      • You can go to
        Setup
        ,
        User Preferences
        , then the
        Locations
         tab to check the location of your depreciation data. You can also select
        Other
         here to change the location in which that Fixed Assets CS creates export files for this client.
    2. Double-click the Excel file to open it and view the journal entry.
      note
      • The Excel export file is named
        DAAAAAMMMYY.xls
        .
        • AAAAA
           is the 1st 5 characters of the client ID.
        • MMM
           is the month of the current client's year end.
        • YY
           is the last 2 digits of the client's current year end.

This article applies to:

  • PRODUCT: Fixed Assets CS

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close