Page 202
Creating a Custom Expense Report
15.
Mark a Section for prepaid expenses (yellow column).
If a row in the map
table is for prepaid (company paid) expenses, type a “yes” in the
cell on that Section’s row. Type “no” in all the cells of this column
that do not pertain to prepaid expenses.
16. Repeat steps 9 through 15 for each Section that you have defined
for your custom Expense Report.
17.
Map Expense Report Options dialog (magenta section).
The Expense
Report Options dialog has five fields where you can fill in data for
the header on your expense report. Use this section to specify the
row and column on your template where this information will be
mapped.
Because header data is not related to any particular Section, you
have to fill in only one row. If the item does not appear on your
template, leave these cells blank.
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 organizer user
data.
Expense data in the Expense.txt file is in tab-delimited format.
Summary of Contents for III
Page 1: ...Handbook for the Palm III Organizer ...
Page 8: ...Page viii Handbook for the Palm III Organizer ...
Page 10: ...Page 2 About This Book ...
Page 44: ...Page 36 Entering Data in Your Palm III Organizer ...
Page 182: ...Page 174 Setting Preferences for Your Organizer ...
Page 188: ...Page 180 Maintaining Your Organizer ...
Page 200: ...Page 192 Frequently Asked Questions ...
Page 212: ...Page 204 Creating a Custom Expense Report ...
Page 222: ...Page 214 ...