Daily Transaction Spreadsheet

When it comes to Payroll Management, detail is key hence why we prefer to capture worked hours daily. For most, this is done via our online portal, Ezytime, or via Time & Attendance Software, but where neither of these is an option, we have available Daily Transaction Spreadsheets.

The reasons we run with this type of spreadsheet are:

• We capture your Timesheet Data and store it for you (it is a requirement of the Minimum Wage Act to record hours worked each day)
• When it comes to determining if it is an Otherwise Working Day for Public Holidays it provides us the data we need.
• The Holidays Act requires us to record the exact dates when someone takes leave. We must then record the payment (and calculations) for all Leave Days.
• It gives us full data to better answer any queries you may have.

The Timesheet is a Weekly Spreadsheet (you will get two if a Fortnightly pay frequency) broken down into Daily Tabs as per below. The spreadsheet will be dated correctly based on your Pay Frequency so please don't change any dates.

Data Entry

Just select the correct day for the hours worked and record them in the correct column. The Summary Tab shows what Hours we have recorded against an employee by Default. It is worth looking at this when entering in Leave Transactions to ensure you record the correct number of hours to match the payroll record, for example, if their default day is 8 hours and you enter 6 for Leave, we will pay 3/4 of a day.

The Notes Tab explains what each of the Heading means at the top of the spreadsheet, see below.

Each spreadsheet will be specific to every client.

In the example above, you would just enter under Ord the hours worked on that day. If you enter hours under the Leave columns the payroll will then pick up the correct date for that leave, thereby ensuring compliance.

Things not to do

• Don't put any dollar ($) sign in front of the numbers
• Don't write any text into the fields, only numbers
• Don't enter anything onto the Summary Page as that is not imported
• Don't change the column orders as we control this from within the payroll
• Don't change the file name or any dates, just record the units provided
• Don't record any hours worked for Salaried Employees, only hours worked on a Public Holiday and any leave

Things to Note

• If there is anything additional you need to tell us for a pay period, please record it in the e-mail body, don't write any notes into the spreadsheet as we don't open them.
• If you have a new employee who started after we generated the Timesheets, just add them onto the daily pages and what you wish to pay them. Ensure you enter their Employee Code and Name in the same format
• Depending on setup, we can populate the Spreadsheets with default hours so all you have to do is amend if required.
• If the spreadsheet has columns for Deductions, it does not matter what Day Tab you record them for.