Transcript Proofreading Job Tracker Template 2.0 for Google Sheets™

The Dashboard sheet provides an overview of your work history using summary boxes and various charts.

At a glance, find out how many jobs and pages you've proofed, how much you've earned, how many hours you've worked, and more.

Visualize your earnings over time, compare your clients by pages received or percentage of pages annotated, and see a breakdown of the pages you've read by proceeding type.

Data filters along the top allow you to drill down to review the history for a specific client, turnaround, proceeding type, etc.

The Status sheet helps you keep track of what's on your plate.

The top left area tallies the jobs and pages due over the next three days and beyond, and it calculates what you still need to do and how long it should take.

The top right area shows the billing status of recent jobs so you know how much money you have coming in.

The bottom area lists your outstanding jobs. Each job has a countdown timer that will change from green to orange to red as your deadline approaches. As you work and update your status, you can see your progress bar fill up and an estimate of how much more time the job will take.

You can click the buttons on your Status sheet to open custom sidebars interfaces.

​

The New Job Sidebar enables you to quickly add a new job. No need to leave your Status sheet when a job comes in or add rows to the Job Log if there aren't enough. The dropdowns even default to your most-used options.

​

The Job Update Sidebar has two sections. The top part helps you to easily update your progress on a job to see how much time you have left. The bottom section finalizes details for a completed job and removes it from the Status sheet.

The new Client Details sheet lists job information for a single client, which can be filtered by year received, year paid, if they are current, and/or if they are unpaid.

The Job Details sheet lists job information for a current job selected by Priority. These details can be copied and pasted into your client e-mails on receipt and return.

The Invoice sheet generates an invoice for a selected client's outstanding jobs, which can be automatically saved to your Google Drive as a PDF. You can even add your logo!

• Calculations now load instantly!
• Expanded Dashboard with more snapshot boxes and charts
• Time fields on sidebars now default to 9:00 AM instead of midnight so they can be disregarded
• Multiple Upcharges can be added per job
• Notes added to some column headings to provide helpful information and instructions
• Protections added to some sheets and ranges to prevent accidental changes
• Clients can be "archived" to remove them from dropdown menus and Dashboard charts
• Access to a sample workbook containing several years of fictitious data to use as an example

Upgraded Status Sheet:

• Breakdown of jobs and pages for 7 days and beyond, including estimated hours to go by day
• Complexity listed for each job, showing the Category and any Upcharge(s)
• Progress bar fills for each job as it is completed
• Hours To Go estimates available for jobs before they are started if there is enough Job Log data available

You will now receive an Easy-to-navigate user guide PDF with instructions, FAQs, troubleshooting advice, and helpful tips for using Google Sheets