Filter
Top Products
A-9
Using Expense Templates and Custom Expense Reports
If a Section contains cells for prepaid (company paid) expenses, create an additional line
in the mapping table for “prepaid.” This will count as an additional Section in the mapping
table. The only data that differs in the prepaid Section (from the non-prepaid Section) is the
row/column numbers for the expense type.
Using Your Custom Expense Report
If you already have a custom Excel expense report, you can use it with a modified mapping
table. However, before you can create a Maptable.xls file that corresponds to your custom
Expense Report, you must first analyze the characteristics of your report.
Perform the following before you begin a custom mapping table:
• Print a copy of your custom expense report. Activate the Row and Column
Headings option in the Sheet settings of the Page Setup command. This enables
you to quickly determine the size of the Section(s), as well as the numbers for the
start rows and columns.
• On the printed copy, identify the data Sections. A Section is an area of data with
common row and column formatting. A yellow high lighter marking pen can make
it easy to see the Sections as you work with programming the mapping table. Your
custom Expense Report can contain any number of Sections, and the same data
can be repeated in any Section.
• On the printed copy, identify the type of Labels that apply to each Section. Each
Section can have only one kind of Fixed or Variable Label for rows and each
Section can have only one kind for columns.
• Place a copy of your custom Expense Report in the Templates folder (in the
Symbol Palm Terminal Desktop directory). Change the file name so it has the file
extension.xlt (which defines it as a Microsoft Excel Template). Make a note of the
exact file name so it can be defined in the mapping table file.
Programming the Mapping Table
Once you have analyzed the components of your custom Expense Report, you can
program the mapping table to fill the report with data from the SPT 1700 terminal.