Nowsta Custom Reporting File Guide
For Nowsta to be able to create a Custom file for you, we require an example file that clearly outlines the setup of the columns and the specific information you would like to be able to pull from the Nowsta database. This example file can be created by your company using the following guide and templates linked within: Custom File Overview
There is a fee associated with the creation of any Custom File. Please reach out to firstname.lastname@example.org for more information and assistance.
It typically it takes an average of 3-4 business weeks for us to complete a customized file. Once we have received the appropriate file format, we will check it and submit it to our engineering team. Our Engineering Sprints run in 2 week intervals therefore the time frame for completion depends on when in that process the ticket is submitted.
All file templates must be in .csv format
Nowsta can only pull data for fields it already tracks
The Column headers can be named anything that suits your Payroll system but if these headers are different to what the field is called in Nowsta it is important that you detail which field this column relates to, as in the key example below.
Below is a list of some standard columns we can add to a payroll report. In addition, we can also support hard coded columns, where we set the column always to have a specific value.
A single column can only hold one value or can only be hardcoded to one value.
E.g We cannot have a single column in a report that shows a Position Pay Code in some rows and a Department Pay Code in other rows.
Formatting of values within a particular column ( time formatting, number of decimal places for a value, etc.) usually is something we can do.
Common Columns Related to Workers and Shifts
If there is a field that already exists in the Nowsta platform and you would like it to be included as a column in a payroll file, it is likely we can include it, but please note that this will need to be escalated to our Engineering Team for confirmation first.
Potential complicating factors
Below is a list of possible complications to consider when creating your file template that could require extra effort from our Engineering Team:
Row split modes
- regular hours
- overtime hours
- double-overtime hours
- spread-of-hours pay
- remaining additional pay (tips, reimbursements, travel pay, minimum hours pay)
Any kind of unusual rules around pay and overtime
E.g. a special way to calculate overtime
Any kind of complex logic
E.g. an external CSV file with multiple different pay codes that need to be mapped
Columns/data that aren’t included in this document
Was this article helpful?
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
We appreciate your effort and will try to fix the article