Expense Tracking Application Info

HostedDatabase.com's Expense Tracking application helps organize business expenses by employees needing to keep accurate records for budget and reimbursement purposes. The business data is contained in a database consisting of a primary data table, secondary data tables, and look-up tables. Here is a break-down of all groups of information maintained by the application.

  1. Projects - the primary data group is the Employees table. This table contains data elements that describe the employee logging the expense records such as name, contact information, and notes.
  2. Project Tasks - the secondary data group is the Expenses table. This table keeps a detailed record of all expenses including short description, expense date, expense code, amount, payment method, etc.
  3. Expense Codes - this is a look-up table used to categorize a particular expense. Expense code is specified when recording expense information.
  4. Payment Methods - this is a look-up table used to specify how the expense was paid for by the employee, e.g. cash, credit card, etc. Payment method is specified when recording expense information.
  5. Projects - this is a look-up table used to classify expenses by project (if any). Project is specified when recording expense information.

Note that the primary and secondary tables in the Expense Tracking application each have three (3) user-defined custom fields so you may store business data that is specific to your own business. One of the first tasks you should perform prior to using your application is to populate all the look-up tables mentioned above with data values specific to your business. You should also modify your application properties to specify your custom fields if you have any. Click HERE to download our "Applications Getting Started Guide."

 
 

Copyright ©1999-2008 AMULET Development Corp. All rights reserved.