Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

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›
      .
    2. Double-click the Excel file to open it and view the journal entry.

This article applies to:

  • Product: Fixed Assets CS
Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close