| |
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.
- 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.
- 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.
- Expense Codes - this is a look-up table used to categorize a particular
expense. Expense code is specified when recording expense information.
- 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.
- 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."
|
|