How to Manage Payroll Online With NimbleSchedule – Customizable Payroll Export File

Running a successful business operation simply demands less time spent on administrative things, staff management and payroll processing and more time and attention dedicated to the actual work. If your company hires an HR team with experts whose sole role is to manage payroll, then you can rely on them to resolve any issues along the way. But even then, having an easy to use and flexible payroll online system that allows your company to spend the least possible time on the payroll process and focus on other, more important, activities is the best possible scenario.

NimbleSchedule seamlessly integrates with leading payroll processing systems such as ADP, TRAX Payroll, Gusto, Paychex Preview and a couple of others. This allows our clients to select from a wide variety of third party systems, thus ensuring that payroll is processed quickly and easily. For those that prefer running the payroll through some other methods, we also provide a built-in payroll report file which clients can easily export to a CSV format. Running payroll online has never been easier than with our system.

This time we decided to take the things to the next level and provide our clients with complete control over how our payroll export file looks: from naming the columns the way a client wants, selecting the order and format of all fields to selecting what kind of data should be included. In other words, our payroll online export system now allows complete customization.

Customizable Payroll Export File - Easily Manage Payroll Online

As you can see on a sample screenshot above, managing the type of data that you wish to include in your export file when handling payroll processing is quite easy. You can label each column the way you wish, without any limitations; you can select the exact type of data you wish to fill into that column, and you can select the right format you might need. If you’re operating a US based business, then, for example, for any kind of data format you can select the mm-dd-yyyy format, while, if you are running a European company, you can select dd-mm-yyyy or even dd.mm.yyyy. However, these are just some of the examples from many different choices.

If a CSV export file is particularly useful in your company in order to manage payroll processing, then you can completely customize the output of that file through the Payroll Settings section in our Settings/Configuration zone. Once you’re there, and you have the CSV output selected at the top of that page, you’ll have an option to customize the elements of the payroll online export file. Here’s the list of all the available fields.

 

Field typeField format
First nameDefault
Middle nameDefault
Last nameDefault
Full nameDefault | First name Last name | First name, Last name | Last name First name | Last name, First name | First name Middle name Last name
Employee IdDefault
Job CodeDefault
LocationDefault
PositionDefault
First nameDefault
DepartmentDefault
Pay groupDefault
Pay rateDefault
NotesDefault
Break startDefault | Time – 24h format | Time – 12h format
Break endDefault | Time – 24h format | Time – 12h format
Clock-in (date & time)Default | Time – 24h format | Time – 12h format | Date (mm/dd/yyyy) | Date (mm/dd/yy) | Date (dd/mm/yyy) | Date (dd/mm/yy) | Date (dd/mm) | Date (mm/dd) | Date (dd.mm.yyyy) | Date (dd.mm.yy) | Date (mm.dd.yyyy) | Date (mm.dd.yy)
Clock out (date & time)Default | Time – 24h format | Time – 12h format | Date (mm/dd/yyyy) | Date (mm/dd/yy) | Date (dd/mm/yyy) | Date (dd/mm/yy) | Date (dd/mm) | Date (mm/dd) | Date (dd.mm.yyyy) | Date (dd.mm.yy) | Date (mm.dd.yyyy) | Date (mm.dd.yy)
Break lengthDefault | Hours – Decimal number (e.g. 5.7h) | Minutes – Total number (e.g. 45m) | Hours:Minutes (e.g. 5:18)
Regular hoursDefault | Hours – Decimal number (e.g. 5.7h) | Minutes – Total number (e.g. 45m) | Hours:Minutes (e.g. 5:18)
Weekly overtime hoursDefault | Hours – Decimal number (e.g. 5.7h) | Minutes – Total number (e.g. 45m) | Hours:Minutes (e.g. 5:18)
Double time hoursDefault | Hours – Decimal number (e.g. 5.7h) | Minutes – Total number (e.g. 45m) | Hours:Minutes (e.g. 5:18)
Regular hours totalDefault
Overtime hours totalDefault
Double time totalDefault
TotalDefault

Once you select the type of data you need to include in your export file, you can re-order some of the items by using the arrow icons to move one or more of your columns more to the left or more to the right of your CSV file. This customized export file will be available once you run a detailed payroll online report, while in the summary report, you’ll have the default export file with all the fields included in the on-page report as well.

If you have any comments or suggestions, please feel free to reach out to our team. We’d love to hear back from you!

Karin Jakovljevic

About the author

Karin Jakovljevic

Karin Jakovljevic is the head of marketing at Ximble, a powerful, cloud-based workforce management system, simplifying employee scheduling and time tracking for retailers, restaurants and small businesses.

Success Stories

Case Study: Property Management

Discover how Ximble helped Armstrong Property Management optimize scheduling, improve time tracking, and integrate with existing software.

Case Study: Urgent Care

Read how Montefiore needed a user friendly employee self-management solution that supported multiple locations and integrations.

Case Study: Restaurant

How did Rudy’s Pub & Grill tackle managing multiple locations over multiple devices, while increasing employee access to shift availability?

Case Study: Customer Services

Effectively scheduling a global workforce across multiple time zones with ease requires a dynamic approach. So how did Ximble help Touch Support?

Try Ximble for 14 days free

No credit card required. Cancel any time.

close close
close close