Filter
Top Products
Page 232 Creating a Custom Expense Report
Using applications other than Microsoft Excel
You can use applications other than Microsoft Excel (such as Lotus 1-2-3 or Quattro Pro) to open
and manipulate the Expense data on your computer. The data file is named “Expense.txt,” and is
stored in the Expense folder, within the folder containing the communicator user data.
Expense data in the Expense.txt file is in tab-delimited format.
Expense file details
The Expense.txt file contains four groups of data. It will be easier to see these four distinct groups
of data if you open the file with a spreadsheet application.
Trips Shows the number of Expense application categories, and lists each one
followed by an “end” statement.
Currency Shows how many currencies were used for the Expense data, and lists the
countries that correspond to that currency.
Trip Shows the number of expenses by category, and lists the expenses for
each category.
Expenses Shows the total number of expenses, and lists them chronologically.