A fully configurable time sheet system which allows for employee time tracking, workflows, time sheet approvals, invoicing and payroll processes.
The system is pretty straight forward to configure. It supports a basic workflow of employees submitting timesheets to their supervisor, who then approves or denies the time sheet. Once approved the time sheets go over to the accounts receivable queue (we call it the Invoicing Queue) so that the customer can be invoiced. From there if needed it goes to the payroll queue so that expenses can be paid back to the employee. There’s even a setting for making all invoices that someone submits go to the invoicing queue in case you have hourly employees that you need to handle.
When clients are entered into the system, there is security setup on the clients so that only employees who are working with those clients can see them in their drop down. This makes the drop down smaller for employees and keeps any third party contractors that are working for you from seeing your entire client list.
The system is configured to allow for retainer projects that get billed automatically and it drops in reminder time sheets to the invoicing queue so that those invoices are invoiced at the beginning of each month. Reminders are also sent to employees automatically if they have overdue time sheets or if they are working on retainers and they need to get their time sheets in at the end of the month.
This section describes how to install the plugin and get it working.
- Upload the contents of the zip file to the
- Activate the plugin through the ‘Plugins’ menu in WordPress
- Configure the settings through the settings page.
- Begin documenting customers, projects and employee access through the various settings pages.
Can I add more workflows?
No, not at this time.
Is the Payroll workflow mandatory?
No, if you don’t configure any expense types, and you don’t configure any employees to force their time sheets to payroll then the payroll queue will not be shown.
Is the Invoicing workflow mandatory?
Depends how you look at things. If you don’t approve anyone for the invoicing queue, but then configure the system for parallel queues for Invoicing and Payroll then the payroll queue will still work but the invoicing queue won’t be used.
Is the Approval Queue mandatory?
Yes, there’s no way to get invoices into the invoicing and/or payroll queues without someone approving them.
Why is there a fraction shown after the approval and invoicing queues?
The first number shown is the number of non-retainer time sheets which are pending. The second number is then number of time sheets on projects which are marked as retainer projects. The approval may have a third number up there. That is the number of time sheets which are under embargo. The payroll queue doesn’t have a different between retainer and non-retainer time sheets so there’s just a single number showing that queue.
Is there a way to turn off all the retainer settings as we don’t need them?
Not at this time. If we get some requests to make that an option we’ll look into it.
Can I change the headings on the expenses section?
No you can’t. If you would like this feature added contact us and we’ll add it to our backlog.
When do retainer reminders get sent out?
They are sent out on the last day of the month.
When do reminders for late time sheets get sent out?
They are sent out on Monday mornings.
What is a work week defined as?
You can configure it to start on whatever day you’d like. By default it’ll configure itself for the week starting on Monday, but you can change it. It wouldn’t be recommneded to change it after starting to use it, as the old timesheets won’t be updated.
How do employees start getting reminders about retainer time sheets being do?
As soon as they create a time sheet for a retainer project, they’ll start getting the reminders.
How do employees stop getting reminders about retainer time sheets being do?
If they stop submitting time sheets for 60 days or more, then they will no longer receive the retainer reminders.
If there’s multiple emails of the same time which need to be sent, will they be sent one at a time?
No, the emails are combined before they are sent out. This helps minimize the number of emails so the employees don’t get a flood of emails. If the same email subject is queued for an employee within 5 minutes the employee won’t get the email until another 5 minutes has passed.
Can time sheets which have been sent to the invoicing queue be rejected?
Yes. If an employee has the approval queue and the invoicing queue then they will be able to reject time sheets from the invoicing queue.
Can time sheets which have been sent to the payroll queue be rejected?
Yes they can. Depending on how you have your queue workflows being done this could cause odd things to happen to the timesheet. So be careful.
How many clients does the system support?
As many as you need.
How many employees does the system support?
As many users as WordPress supports in the system.
Where are the settings located?
The settings are located under the Time Sheets parent menu. This includes the Global settings which are only available to people with the “manage_settings” WordPress settings (admins for example) as well as the “My Settings” page which is available for all users.
Is there are specific system requirements?
No. We run this for our business on a database with a single CPU core and a web server with a single CPU core (two machines) and the performance is exactly as expected (your mileage may vary). If you see performance problems please let us know.
I have multiple web servers, but I only want to run the email jobs on one, can I?
Yes you can. Add the code “define( ‘TIMESHEETS_SKIP_CRON’, false );” to your wp-config.php. This will stop that web server from processing the email messages. Just make sure that you do not put this setting on every web server otherwise you won’t get the messages on any server.
Contributors and Developers
“Time Sheets” is open source software. The following people have contributed to this plugin.Contributors
- Fixed a bug in the setup.php file with object collation
- Fixed a bug in the setup.php file with the database object versioning
- Adjusted error message when rejecting time sheet from the invoicing menu
- Fixed a bug when rejecting time sheet from the invoicing menu
- Fixed a bug when spliting a time sheet
- Added Edit Project to the top drop down menu
- Made Edit Client, Add Project and Edit Project take the current Client when a timesheet has been saved, or when on the Manage Client page
- Allow for queueing of future changes to the monthly billing page
- Add regular_interval column to timesheet_recurring_invoices_monthly_archive table
- Fixed the date picker on the time sheet entry and My Dashboard screens
- Display invoice ID on the time sheet when there is an invoice ID
- Made the comments on the approval queues wider
- Fixed a bug in the settings.php
- Added the number of hours used to the warning about being over hours.
- Aligned two halfs of the approval and invoicing menuts
- Enabled invoicing menu to select the retainer type as wanted
- Fixed a couple of undefined index errors
- Sends reminder email to the time sheet owner 3 days after a timesheet has been rejected (and every 3 days after that), if the time sheet hasn’t been resubmitted
- Sends reminder email to the time sheet rejector 7 days after a timesheet has been rejected (and every 7 days after that), if the time sheet hasn’t been resubmitted
- Put a couple of line feeds at the bottom of all emails so that email warning messages inserted by corporate email systems look cleaner
- Made the emails on comments include a hyperlink for the ticket number being sent out
- Had to use a different variable in the URL field do to some weirness in email with the old URL parameter, updated show_timesheet to account for this
- Only create automatic time sheets for projects which are active
- Changed the comment email to include the name of the person who entered the command and the name of the person who entered the timesheet
- Removed test text from the time sheet screen
- Added non-billable hours to payroll timesheet list
- Fixed duplicate primary key error when rejecting timesheets from the invoicing menu
- Added option to enter comment and not send email
- Changed a blank value for sales person id to a value of None in the invoining report
- Fixed the URL for the project properties screen to view time sheets
- Removed users from the menus when their WordPress role is set to “No role for this site”
- Fixed archiving errors for the approval/invoicing/payroll queue
- Removed some line feeds at the end of the files
- Added Non-Billage time to timesheet with the ability to enable or disable these new fields as needed
- Added archiving for sent emails
- Added truncating for email queue archive (to keep hard drive space usage in check)
- Configured to send email on every comment or rejection
- Fixed archive errors when rejecting a timesheet
- Added invoice nunber to payrol queue
- Introduces setting to allow multiple retainers per client
- Added invoiced date to the search options on the closed timesheets screen
- Changed the closed timesheets screen
- Fixed database error when approving timesheets in parallel queue mode, when writing timesheet to the archive (error would only show up when two inserts were happening within the same milisecond, so it depended on the web servers speed)
- Added sales person and technical sales person to closed timesheet search
- Added sales person and technical sales person when viewing the timesheet
- Fixed a big where all time sheets showed a warning that there was already a timesheet for that project for that week
- Did the checks for duplicate projects for a week for a user on updates as well as new timesheets
- Fixed the bug where new time sheets were being saved twice
- Forced rollback to 1.22.2 due to a bug where new timesheets were saved twice
- Fixed technical consultant field in the invoicing menu
- Removed a SQL Statement that was showing
- Added a tertiary sort order for the index menu
- Deletes any auto-close entries that are queued when a project is update, if the project is setup to not auto-close
- Fixed the setting “Override Site Wide Date Format” always showing an error that is wasn’t set
- Updated the info, warnings and errors to use the admin notices messages instead of the update-nag message type
- Added the ability to prevent having multiple time sheets for a single week for a single project for a single user (this check is only done when submitting new time sheets)
- Added a setting to switch between a warning and an error for duplicate time sheet for a project/week/user
- Fixed the showing off a prior timesheet when submitting a new time sheet and that time sheet has an error (the entire new time sheet process needs to be restarted now)
- Removed a rouge > from the top of the client and project list on the Approval/Invoicing/Payroll queues
- Changing the way the archive tables are created
- Changed the archive setup code to only one once, not every time.
- Made products with no hours and that are inactive show up in the notes field on the approving and invoicing queues
- Removed the setting of the varibles used as global variables
- Fixed close timesheet search from throwing a permissions error when used by someone who doesn’t have approver and invoicer rights
- Notes on the settings page which settings are missing which causes a message to be shown on the admin page
- Added auditing capture for all user actions and screens so that a history of all changes that can be initiated by the user are captured into _archive tables. This tables may grow large over time and may need to be maintained.
- Fixed a bug where the invoicing queue was appearing in the admin menu for all users
- Matched logic on approval queue and the payroll queue to match the invoicing queue
- Fixed a bug where the invoicing queue wasn’t appearing on the admin menu
- Fixed a bug where the invoicing menu wasn’t appearing
- Changed the way checking to see if settings need to be updated after an upgrade is handled
- Removed the duplicate queries, using global variables for them
- Only send retainers entered emails when retainers are entered, not each cycle
- Update the math used to check is a project is over hours, so that retainer projects alert correctly instead of every time
- Allow admin to set if users can reject time sheets
- Changed where timsheet rejection and auditing comments are saved
- Allow person who creates the time sheet to be able to reject the time sheet if the time sheet has not been approved.
- Made the project notes on a timeread editable (making changes here will NOT update the project notes) so that you can copy from the notes if needed
- Changed the way nonce was being done as it wasn’t working on embedded pages
- Made the fields on a new time sheet not remember the values from previous entries
- Made the width of the text boxes on the My Dashboard, Approval and Invoicing menu wider
- Fixed an “Undefined index” warning when creating a new timesheet, after clicking to save the timesheet
- Made the overtime fields hideable, if they are 0 hours and the setting to hide them is enabled
- Made the OT settings dependant on each other in the UI
- Added the total hours and total expenses to the invoicing list
- Changing to new Date format help URL
- Fixed a bug causing quarterly recurring invoices to be run each day of the first month of the quarter
- Added some debugging information to the recurrnet job function (output won’t ever be seen)
- Fixing a LOT of “Undefined index” warnings from PHP
- Changed Monthly retainers to recurring invoices
- Added ability to have Weekly, Monthly, or Quarterly recurring invoices (insteaded of just Monthly)
- Changed the cron for monthly invoices (might need to disabled and reinable the plugin because of this)
- Switching get_current_user_id for wp_get_current_user in the code base
- Switched a few called to the variable $user_id to $user_id->ID
- Fixing a couple of “Undefined index” warnings from PHP
- Made the top record approval button always visable instead of it being dynamic
- Added Last Billed Day to Approval and Invoicing menus
- Removed extra text from the approval screen
- Added a total number of hours to the My Time Sheet Dashboard
- Added a total number of hours and expenses to the Approval menu
- Made the top record approval button always visable instead of it being dynamic
- Adding currency to all expense fields other than mileage
- Adding distance metric to show either Miles or Kilometers on the time sheet
- Added currency and distance metric to settings screen
- Added check to the startup to throw an error on the admin screen in the currency or distance metric isn’t recorded
- Added currency values to the payroll queue screen
- Added distance metric to the payroll queue screen
- Fixing drop down menu URL
- Using the client ID that was last edited for the next project, edit project, etc.
- Changing the URL from ./admin.php?entry_timesheet to ./admin.php?show_timesheet
- Changing saving of a timesheet to be done before the content of the admin page is loaded so that the counters in the admin bar are correct when any user saves a timesheet
- Changes the saving and time sheet entry functions based on the new method of saving
- There’s a few extra functions that need to be cleaned up later
- Fixed a missing “TR” tag on the approval queue page
- Added the number of hours used, and the expense total to the approval queue page
- Fixed the embargo check box on the time sheet entry page
- Made Auto Close a project the default when creating a new project
- Changed the way the options are processed for a new project
- When a time sheet is rejected the hours used are removed from the project
- Recalulicate hours used for each project (depending on how many partial hours were entered on each time sheet this could show a large difference)
- Fixed bug where time sheets weren’t updated correctly.
- Added the the ability to have overtime listed as a seperate line item on each timesheet
- Made the abilitly to have overtime an option setting for the system
- Added in an option to have a multiplier for Overtime for counting hours purposes for a project (1 hour of OT counts against a project as 1.5 hours of time for example). The multiplier can be adjusted as needed
- Changed the datatype for total hours used on a project from BIGINT to NUMERIC(12,2) to account for the modifier
- Project properties now shows the hours used with a decimal
- Recalulicate hours used for each project based on the new data type (depending on how many partial hours were entered on each time sheet this could show a large difference)
- Added emails when a comment is added for a closed time sheet
- Changed the way you can stop multipe servers from doing backround jobs by adding “define( ‘TIMESHEETS_SKIP_CRON’, false );” to the wp-config.php file.
- Fixing cron checks
- Force the monthly notices to be inserted once (only used if the site is hosted on multiple servers)
- Fixed a bug when timesheets which are rejected when being invoiced weren’t being removed from the queue even though they were rejected
- Fixed a bug where retainers would be closed automatically
- Automatically marked all retainers as active projects again
- Added a Taxi/Rideshare expence column to the timesheet and database
- Corrected the top button on the approval screen
- Added in the ability for projects to be closed automatically when all the hours on the project are used
- Open projects that were auto-closed if a time sheet is rejected
- Enabled a setting to set new project to be auto-closed
- Fixed monthly job which resets the hours available on retainer projects
- Fixed a bug where having notes visable on closed timesheets would prevent the project for the closed timesheet from being shown.
- Added tracking notes to be added to completed time sheets
- Added the ability to reject a timesheet when ading note which sends the comment to the person who entered the timesheet
- Added a setting to the display tab to allow hiding or showing of notes on completed time sheets as needed
- Rejecting a completed time sheet requires a reason
- Made the Global Settings page tab driven, allowing the settings page to be smaller and more focused
- Fixed the closed invoices search screen to show and hide the client and project columns correctly
- Fixed declaration of variables in the main file
- Make new project active by default
- Added customer permissions to the “Add Customer” screen as well as the edit customer screen
- Removed client and project columns from “Closed Timesheets” screen if there’s only one active project in the system
- Removed client search option on the “Closed Timesheets” screen if there’s only one active project in the system
- Added a “My Settings” option to show partial notes on the time sheet on the “Closed Timesheets” screen, and updated that screen to account for this checkbox
- Fixed ability to embed search and new timesheets in a page and have them show up correctly, under other content
- Fixed having no ClientId when hiding the client and project drop down menu.
- Fixed the Timesheet_Search shortcode
- Fixed an query being used by the closed timesheets screen
- Fixed an issued where the ability to hide the client and project when there’s only one available wasn’t working
- Added the ability to search and view closed time sheets.
- Changed our URL from dcac.co to dcac.com.
- Added feature to alert when a project is close to runnning out of hours (you define close).
- Added settings fields to support when a project is running out of hours.
- Changed alert when project is running out of hours to only queue email on timesheet viewing (when the timesheet is open).
- Fixed a bug where the enbarged timesheets were shown on the approval page by default.
- Changed approval screen to show either embargoed timesheets or non-embargoed time sheets
- Allow Monthly edit screen to have line breaks
- Make project notes on the timesheet bigger.
- Changed the way that the message on startup to thrown if a needed setting is missed
- Added Technical Sales Person to Client and Project
- Fixed bug where new timesheets when saves and closed aren’t showing propertly
allowing them to be double saved.
- Updating My Time Sheet Dashboard quantity shown in real time as the timesheets are saved
- Projects are deactivated when a timesheet is marked as a closed project
- Added a New Time Sheet link under the My Time Sheet Dashboard link
- Added client management under the My Time Sheet Dashboard link
- Removed New Time Sheet from the New menu unless the My Time Sheet Dashboard link is not shown
- Fixed bug to approve imbargoed time sheets
- Fixed updated code
- Added Sales Person dropdown to Client and Project
- Added Sales Person to invoicing queue
- Added Sales Person priority to settings page
- Added check for sales person setting to main screen
- Removed test from the entry form.
- Fixed monthy retainer emails and resetting of clients.
- Fixes the approvals menu so embargoes time sheets can be updated correctly.
- In the approval menu, clicking approve, reject or hold will set all time sheets to that settings.
- Fixed review screen so it works from all approval menus.
- Week Complete field on My Dashboard is now centered.
- Fixed permissions on dashboard so regular users couldn’t see other people time sheets.
- Fixed dashboard so search worked properly.
- Change “Setup Approval Teams” so it doesn’t show debug information when adding a team member.
- Fixed permissions on Manage Clients screen so the Manage Clients permissions actually work.
- Added PO Number to new project screen.
- No code change, but some updated gaphics to push down and a new readme.
- Added po number as a project field and display it on the invoicing screen.
- Added Hours to My Dashboard and to Payroll Queue.
- Fixing My Settings so it works for people who are only Invoing Queue users.
- Fixing 1.6.8 so it actually works.
- Allow invocing users to decide to put the “Record Invoicing” button at the top of the list all the time.
- Make monthly retainers not show up in the payroll queue at the top of the month.
- Removed comments from time_sheets_cron.email_retainers_due in a vauge attempt to make it work correctly each month.
- Changed size of currency fields to support larger amounts.
- Fixed bug where timesheet queues weren’t being loaded in parallel correctly, and timesheets could be sent to the payroll queue twice.
- Fixed bug where the submit button wasn’t visible on new time sheets
- Fixed bug where all timesheets were being sent to payroll queue
- Changed label in the admin bar to My Time Sheet Dashboard
- Removed Submit button if viewing another users time sheet
- Added logic to prevent updating another users time sheet
- Fixed bug where the Project drop down doesn’t work in the time sheet screen.
- Fixed bugs in query of My Dashboard where it was showing all employees at initial load instead of just that persons.
- Changed text in My Dashboard if not matches are found.
- Display project name when project is over hours
- Rename Old Timesheets to My Dashboard
- Add additional filters to My Dashboard (all employees, my time sheets, specific team member, all team members, filter by client and project)
- Display employees client notes and project names on My Dashboard
- Updated screenshot of My Dashboard (Screenshot 2)
- Fixed bug where the payrol queue is showing more invoices then it should if you are using parallel workflows.
- Added the ability to split the queue process so that Payroll can be processed before invoicing.
- Hack to make the dates on the entry page correct on matter what timezone it is. This isn’t a perfect fix, but it’ll do for now.
- Made the week start date configurable.
- Added checks for the new setting on startup.
- Resetting the cron so that the cron jobs fire at the correct time after the 1.5.13 upgrade.
- Added clarity to the screens granting access to parts of the system.
- Fixed the crons so that weekly reminders go out on Monday instead of being based on the time that the plugin was last updated.
- Corrected minimum required version of WordPress to 4.7.0.
- Fixed issue with employees who need to always need to go to payrol queue, and the project was set to skip the invoicing queue didn’t make it into the payrol queue.
- Added Hold option to approver menu.
- Disable save new project button disabled after saving, to prevent duplicate projects from being saved.
- Better cleaning of single quotes in text fields to get rid of the escape chatacter that wordpress and PHP like to stick in there.
- Changed label on filter button for invoincing menu.
- Added submit buttons above the approval and invoicing lists when the list is long.
- Fixed sorting issues on various employee lists.
- Added Display Name to client permissions page and sorted by Display Name.
- Adding option to My Settings page for people who have access to the Invoicing queue to allow custom sorting of the output for easier invoicing based on user needs.
- Fixed problem with invoicing menu not saving changes.
- Changed label on filter button for invoincing menu.
- Removed un-needed/un-used functions from primary file.
- Remove clients with no active project from time sheet client list.
- Fixed label on submit button on approval queue.
- Added ability to set project as flat rate billing do time sheets bypass the invoicing queue.
- Updated FAQ
- Added ability to create a new time sheet from the “New” menu in the admin bar (who can see that menu).
- Resolved additional potential cross site scripting vunerabilities.
- Removed some un-needed code (the calls had already been moved to common, but the old functions were still sitting there).
- Added a setting to remove the embargo feature if it isn’t needed.
- Little cleanup in the client list code for the client management screens.
- Resovled issue with monthly cron job not updating retainer hours.
- Fixed possible cross site scripting in old timesheet list.
- Added feature to allow for hiding client and project dropdown if only one client and project are available.
- Included pollyfil.js and all needed files.
- Changed to internal jquery not external.
- Set the date picker for all date fields.
- Fixed formatting issue in settings
- Converted monthly notes to text box to minimize space being used by them while allowing for basically as much text as is desired.
- Clean up errors to make them more visible.
- Add data cleanup to date fields when searching and viewing client list.
- Fixed split time sheet from the approval menu.
- Added calendar popup to time sheet entry.
- Added warning when time sheet isn’t starting on a Monday.
- Allow admin to customize date format.
- Allow admin to allow users to specify their own date format.
- Changed client and project notes to text boxes to minimize space being used by them while allowing for basically as much text as is desired.
- Updated FAQ
- Fixed issue where time sheets weren’t saving or throwing an error message. They save now.
- Fixed Pier Diem days field converting to an integer. Now accepts decimals.
- Added option “Open Time Sheets” to header.
- Added ability to put new time sheet within a page using shortcut code timesheet_entry.
- Added ability to put new time sheet within a page using shortcut code timesheet_search.
- Increased security on the new and search time sheet pages due to the public short codes being available for use.
- Added setting to support the link redirection that needs to happen when using the timesheet_search shortcut code.
- Fixed menu for editing client not working correctly.
- Changed Edit Client Permissions to Edit Client and added the ability to change a client’s name.
- Max hours on retainer projects now adjust monthly based on the hours used plus the available hours per month so the project alerts are accurate for retainer projects.
- Max hours on retainer projects not editable anymore.
- Major code refactoring.
- Cleaning up display names and user names.
- Fixed bug in invoicing where if time sheets were given an invoice number, but not marked as processed they could loose their invoice number when working on other invoices.
- Added ability to turn off notes and expenses sections for teams.
- Added ability to add a backup approver for teams (perfect for approvers who take vacations, or have an assistant).
- Added screen to manage those who can add customers and projects.
- Added per diem city to time sheets.
- First release