B-9
Creating a Custom Expense Report
In the
Date
cell, enter the row or column number where all the date information will
be placed.
In the
Dates
cell, enter the number of blank columns (or rows) separating the date
fields. If there are no blank columns (or rows) between date entries, leave this
number set to zero.
In the
Start Day
cell, enter the day of the week that starts the expense reporting
period. Enter a three-character abbreviation for the day (e.g., Sun, Mon, Tue).
In the
Day
cell, enter the row or column number where all the day information will
be placed. If the dates are in a row, enter the row number. If the dates are in a column,
enter the column number.
12. Define whether the Section is in list format. This setting appears in the light purple
columns (18–19).
13. If the Section will present the data in a list format, enter the word “yes”. Otherwise,
enter the word “no”. The following diagram shows data presented in a list format:
If your section is in list format: enter the number of the row or column where the
expense description will be placed in the Expense Type cell. Expense amounts can be
entered in several different columns or rows if required by your template.
Expense
type labels
must all appear in the same column.
14. Enter the row or column numbers for the expense types that appear in the Section.
These settings appear in the aqua columns (20–48).
Summary of Contents for SPT 1700
Page 1: ...SPT 1700 Series Product Reference Guide...
Page 3: ...SPT 1700 Series Product Reference Guide 70 37544 02 Revision A April 2000...
Page 14: ...xii SPT 1700 Series Product Reference Guide...
Page 24: ...1 2 SPT 1700 Series Product Reference Guide...
Page 48: ...2 2 SPT 1700 Series Product Reference Guide...
Page 84: ...4 2 SPT 1700 Series Product Reference Guide...
Page 88: ...4 6 SPT 1700 Series Product Reference Guide...
Page 90: ...5 2 SPT 1700 Series Product Reference Guide...
Page 104: ...5 16 SPT 1700 Series Product Reference Guide...
Page 106: ...6 2 SPT 1700 Series Product Reference Guide...
Page 110: ...6 6 SPT 1700 Series Product Reference Guide...
Page 112: ...7 2 SPT 1700 Series Product Reference Guide...
Page 130: ...8 2 SPT 1700 Series Product Reference Guide...
Page 146: ...9 2 SPT 1700 Series Product Reference Guide...
Page 168: ...9 24 SPT 1700 Series Product Reference Guide...
Page 198: ...11 2 SPT 1700 Series Product Reference Guide...
Page 234: ...13 2 SPT 1700 Series Product Reference Guide...
Page 240: ...13 8 SPT 1700 Series Product Reference Guide...
Page 242: ...14 2 SPT 1700 Series Product Reference Guide...
Page 252: ...15 2 SPT 1700 Series Product Reference Guide...
Page 260: ...16 2 SPT 1700 Series Product Reference Guide...
Page 266: ...16 8 SPT 1700 Series Product Reference Guide...
Page 268: ...17 2 SPT 1700 Series Product Reference Guide...
Page 282: ...17 16 SPT 1700 Series Product Reference Guide...
Page 284: ...18 2 SPT 1700 Series Product Reference Guide...
Page 290: ...A 2 SPT 1700 Series Product Reference Guide Sample 1...
Page 291: ...A 3 Expense Templates Sample 2...
Page 292: ...A 4 SPT 1700 Series Product Reference Guide Sample 3...
Page 293: ...A 5 Expense Templates Sample 4...
Page 294: ...A 6 SPT 1700 Series Product Reference Guide...
Page 306: ...B 12 SPT 1700 Series Product Reference Guide...