Common Scenarios

Use this section to review common fixed asset import scenarios and the values required for each one.

Scenario 1: Importing Brand New Assets

You have just purchased a batch of office furniture and want to add them to WorkBook.
  1. Set Initial Value to the purchase price.
  2. Set Existing Asset Account number to the GL account where the purchase was originally recorded.
  3. Set First Depreciation Date and Next Depreciation Date to the same date (the date depreciation should begin). Set Depreciations Completed to 0.
  4. Provide all GL accounts either directly or through an existing asset group.

Scenario 2: Migrating Assets with Depreciation History

You are migrating assets from another system. These assets have been depreciating for some time.
  1. Set Initial Value to the original acquisition cost.
  2. Set Accumulated Depreciation to the total depreciation recorded to date.
  3. Set Current Book Value to the current net value (or let WorkBook calculate it).
  4. Set First Depreciation Date to when depreciation originally started.
  5. Set Depreciations Completed to the number of periods already depreciated.
  6. Set Next Depreciation Date to the next upcoming depreciation date.
  7. Provide Existing Accumulated Depreciation GL Account number (required when accumulated depreciation > 0).

Scenario 3: Creating Assets with a New Group

You need to import assets that belong to a group that doesn't exist yet in WorkBook.
  1. Set Asset Group Name and optionally Asset Group Description.
  2. Set the Depreciation Method and related parameters.
  3. Provide all five GL accounts:
    • Asset, Accumulated Depreciation
    • Depreciation Expense
    • Revaluation
    • Disposal.

All assets sharing the same group name and parameters will be assigned to the same new group.

Scenario 4: Adding Assets to an Existing Group

You want to add assets to a group that already exists.
  1. Set Asset Group ID to the ID of the existing group, or set Asset Group Name to the exact name.
  2. You do not need to provide GL accounts. They are inherited from the group.
  3. Make sure the depreciation parameters match the existing group configuration, or omit them where allowed.