EOL Asset DB – Expenses

The IT Assets Database was replaced by the IT Admins CMDB and is EOL / End of Life, no further development will be done on this project.

Expenses are something most IT departments have to deal with. They will influence your yearly budged planning and might even need attention way before they come up, if they even come up automatically – meaning you would need to a have solution in place that actively reminds you on them.

The IT Assets database can help you with this.

A rather simple structured Expenses module allows you to add and monitor your expenses. The data entry is designed for most cases and doesn’t need you to re-calculate yearly costs, rather then the database showing you your yearly total amount directly in an field under the table. This field Annual total will update depending on your currently shown rows – filter for all active expenses and you will see what your yearly operating costs are.

There are sub-table for expense types, expense codes and expense terms, while only the expense terms are pre-set and the factor in the pre-set is used as multiplicatior to calculate the annual cos by multiplying the amount of licenses times the renewal cost multiplied by the expense-term factor that is chosen.

Data field and reference overview

  • active / disabled
  • expense type (configurable in sub-table)
  • expense code (configurable in sub-table)
  • expense terms (configurable in sub-table)
  • charge to department
  • vendor
  • product
  • account number at the vendor
  • description
  • license amount and renewal cost
  • annual costs are calculated on the amount, renewal cost and terms (automatically)
  • contract number
  • PO ticket, PO number
  • contract start and end-date (for renewal purposes – display on the main menu)
  • purchase through notes
  • website / billing phone and account rep. notes
  • support info / renewal email notes
  • generic notes
  • budgeted
    • you can unset the field if it is not – this helps with your annual budget planning if needed
  • referenced in
  • Notes