Make your daily work tracking easier with the VA Shift & Earnings Tracker by I.T. Works DM University<\/strong>.<\/p>\n Designed for virtual assistants, freelancers, remote workers, and independent professionals, this Excel-based productivity application brings attendance tracking, working-hour calculations, and earnings summaries together in one convenient dashboard.<\/p>\n Spend less time recording and calculating your work hours manually. Keep your records organized and see your progress throughout the week and month.<\/p>\n Record your attendance using the MARK PRESENT TODAY<\/strong> button. The application records the date and your configured shift details in the Daily Log.<\/p>\n A duplicate-date check helps prevent accidentally adding another attendance entry for the same date.<\/p>\n Calculate working hours using your recorded start time, end time, and unpaid break duration.<\/p>\n Set your hourly rate and let the workbook calculate estimated earnings based on your recorded paid hours.<\/p>\n The default example is $5 per hour, with a 10:00 AM\u20132:00 PM shift and no unpaid break. You can change these settings to match your own schedule and pay arrangement.<\/p>\n View your attendance in a calendar layout. Use the selected month to review your recorded workdays and other attendance statuses.<\/p>\n Review recorded working hours and estimated earnings for a selected Sunday\u2013Saturday reporting week.<\/p>\n Review your monthly working hours, estimated earnings, and attendance totals. Change the reporting year to review another period, subject to the records available in your workbook.<\/p>\n Review and correct your shift records when needed. The Daily Log serves as the main record source for the dashboard and reports.<\/p>\n Adjust your hourly rate, default shift start and end times, and unpaid break duration to suit your working arrangement.<\/p>\n Your digital download package includes:<\/p>\n The supplied application is intended to be ready for use after the required first-time setup. You should not need to build the dashboard or create the attendance button yourself.<\/p>\n Important:<\/strong> Excel for the web cannot run VBA macros. Google Sheets and mobile spreadsheet apps are not supported for the one-click attendance functionality. Use desktop Microsoft Excel on Windows for the intended experience.<\/p>\n Depending on your Office security settings, downloaded macro-enabled files may display a security warning or have their macros blocked. Follow the included instructions and only permit macros in a workbook obtained from a source you trust. Never enable all macros globally just to use this product.<\/p>\n This is a digital productivity tool, not a payroll-processing service. Earnings are estimates based on the records and settings you enter. The workbook does not independently verify employer payments, taxes, deductions, overtime entitlements, or contractual pay rules.<\/p>\n Always check your records against your actual work agreement and payments. Keep a backup copy of your workbook, especially before making extensive edits.<\/p>\nWHAT CAN YOU DO WITH THE TRACKER?<\/h2>\n
1. One-Click Attendance<\/h3>\n
2. Automatic Working-Hour Calculations<\/h3>\n
3. Automatic Earnings Calculations<\/h3>\n
4. Monthly Attendance Calendar<\/h3>\n
5. Weekly Summary<\/h3>\n
6. Monthly Summary<\/h3>\n
7. Editable Daily Log<\/h3>\n
8. Customizable Settings<\/h3>\n
WHAT’S INCLUDED?<\/h2>\n
\n
WHO IS THIS FOR?<\/h2>\n
\n
SYSTEM REQUIREMENTS<\/h2>\n
\n
IMPORTANT PRODUCT NOTES<\/h2>\n