Open Quickbooks Point of Sale
Click “Employees” -> “Time Clock Summary”
Click the “Modify” option
Click “Filter Data”
1. Modify dates to appropriate payroll dates
2. Select ALL login names
3. Select YOUR store
4. Click “RUN” report
Click the “EXCEL” tab to the right of the print tab
The “EXCEL” file will generate, add a “CONVERTED”, “PAYRATE”, and “TOTAL” column. Insert the correct information for all columns! The “TOTAL” column would equal ( = ) the “CONVERTED” column times ( * ) the “PAYRATE” column.
After all information is correctly entered, “SAVE” the file in attached format (ex. 1.11.15 – 1.27.15).
TIME TO TURN IN!
Email your completed payroll excel spreadsheet to “email@example.com” by 10:00am on the payroll due date.
Local stores will receive their paychecks on payday, and the out of town stores will receive their checks up to one day early. If you receive your paychecks before payday, it is the manager’s responsibility to ensure paychecks are not distributed until 4PM on payday. For every paycheck from your store deposited before 4PM on payday you will receive a write-up because it is your responsibility to hold paychecks until payday at 4PM.