Basic Job Stats Tracker

Basic "Job Stats" Tracker

Keep track of:

Average invoice total (monthly/annually)
Average pages per job (monthly/annually)
Average $ per page per job (monthly/annually)

Invoice $ totals (monthly/annually)
Number of total jobs (monthly/annually)
Number of total pages (monthly/annually)

SPECIAL NOTE:

The yellow highlighted column has a preinserted "1" in the Job # column to prevent a division error message. Before hiding any unused columns, change the "1" to a "0" so that your form will reflect accurate job stats!

_______________________________________________________________________________________

General Instructions:

Put in job dates for the month you're entering jobs for.
Enter the 1) "Invoice Total"; 2) "Job Pages"; 3) "Total $ Per Page" for each job.
Hiding unused rows (optional)

Before you right click on and hide any rows not used, make sure that the "# of Jobs in Month" for those particular rows have been changed to 0.

Click on first row not used.

Hit the Shift key and the "down" arrow until all of the rows not used for that month are highlighted. (If you highlight one too many, just use your "up" arrow to un-highlight.)

Right click and choose "Hide."

This form can be customized with rows or columns added and new formulas created in whatever way you wish. The document is a .xtlm document, which means "template," that can be saved in the templates folder of your MS Office directory. When you have it customized as you wish and have saved it as your own template, you can then create a separate one of these documents for each year and rename them as working Excel documents with an .xlxs extension, and save them wherever on your hard drive is appropriate.

Sample screenshots (with actual download available below the screenshots):

Download

BASIC JOB STATS TRACKER TEMPLATE_mk.xltm

This form will download to your Downloads folder on your PC.