This document describes how to use the Timesheets app to record details of time booked to various projects, plus any associated expenses which may have been incurred. By recording this data for all staff, Speakeasy is better able to provide up to date reports on project expenditure.
Launch the membership app from Microsoft Teams. There is a “Timesheets” tab available via the “Speakeasy…Contact Details and Activity” team. See the screenshot below:
The app should appear. See the example screenshot below:
Recording Timesheet Entries
To add timesheet entries, click on the timesheet entry, but don’t click the red submit button at this stage. The following screen should appear:
To add a new timesheet entry, click the “+” at the top right-hand side of the screen. The following screen should appear:
Complete the date, project details and any notes that help explain how time is spent, then click the tick in the tip right-hand side of the screen to save the details. The app will then show all recorded timesheet entries, together with a total of hours booked, which appears near the bottom of the screen. See the example below:
To edit an existing entry, simply click on it, make any changes, then click the tick in the top right-hand side of the screen, which is similar to the technique used for creating new timesheet entries.
Recording Expense Entries
Recording expenses is similar to that for timesheets. Click on the “Expenses” tab at the bottom of the app screen. The following screen will appear:
To add a new expense entry, click the “+” at the top right-hand side of the screen. The following screen should appear:
If completing a mileage expense, the “Cost” field will not be editable. Instead, a mileage field will appear. A mileage cost is then calculated and displayed in the “Cost” field. See the screenshot below, which shows the cost based upon a £0.35 per mile expense rate.
The rate can be changed by an administrator with permission to edit the Timesheets app – the rate is stored in the variable “varPencePerMileRate” and can be edited via the App OnStart method.
Existing expense entries can be modified by clicking on an entry, modifying the details and clicking the tick at the top right-hand side of the screen to save.
A summary of all time and expense details recorded against a timesheet can be seen by clicking on the “Summary by Project” tab at the bottom of the app screen. A screen similar to the following will appear:
Time and expenses are summarised into projects, and grand totals are displayed, which will have the same values as the totals displayed in the “Timesheet Entries” and “Expenses” tabs.
Submitting a Timesheet
To submit a timesheet, click on the red button on the application home screen:
Assigning a Timesheet Administrator
Timesheet administrators are assigned by accessing the Speakeasy Contacts App, navigating to a staff/volunteer contact and editing the details Click on the “Other Settings” tab. The “Can Administer Timesheets” should be visible and can be changed to “On”. See the screenshot below, taken from the Speakeasy Contacts Phone App:
Changing the Default Hourly rate of a Staff Member
The default hourly rate can be changed by accessing the Speakeasy Contacts App, navigating to a staff/volunteer contact and changing the “Project Current Hourly Rate” value. When a new timesheet is created at the start of the next new month, the timesheet will use the new value. See the screenshot above.
Calculating Project Salary Costs
When a salary is paid, a transaction for the gross salary amount will appear in Xero, Speakeasy’s accounting package. As part of the process of reconciling this transaction in Xero, the salary needs to be broken down into costs per project. The timesheet application has been modified (October 2023) to make this easier to do. Once a new set of gross salary transactions appear in Xero, note each value and launch the Timesheets application. Edit the filters on the home screen to show the relevant timesheets (e.g. reconciling of September 2023 timesheets will typically take place in October, so change the month filter to “September” so that the September timesheets can be seen). Click the pencil icon – see the example screenshot below:
A screen similar to the following screen will appear:
Edit the actual gross salary for the given staff member, using the relevant value from the Xero transaction. Save the value by clicking the tick at the top right hand corner of the application. Next, click on the chevron of the timesheet to see the timesheet details. Administrators will now see an additional “Project Salary Costs” tab. Click on this tab. A screen similar to that given below will be displayed:
The “Project Salary Costs” tab shows a breakdown of the costs to each project. The app calculates this using the following formulas (previously done by hand by a staff member):
- Project #1 cost = HrsWorkedOnProject#1 * HourlyRate
- Project #2 cost = HrsWorkedOnProject#2 * HourlyRate
The individual values should then be transferred back into Xero as part of the transaction reconciliation process.
Note: the values in the “Project Salary Costs” differ from those in the “Summary by Project” tab – those in the “Summary by Project” tab also account for Speakeasy’s overheads and it is these costs that are included in any trustees reports.