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

Payroll Online, How to Manage Payroll Online With NimbleSchedule – Customizable Payroll Export FileRunning 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.

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

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

Menchie’s

It was hard to keep Menchie’s young and mostly part-time staff informed about shift changes, until Menchie’s discovered Ximble’s easy-to-use smartphone app.

Fast Fix

Ximble’s easy-to-use scheduling tool allows Fast Fix employees to remotely access shift information, and integrates with their Point of Sale and Payroll systems.

Spry Health

When spreadsheets became too complicated, Spry Health sought simple, cost-effective timekeeping software so they could concentrate on growing their business.

Spirited Gifts

Since switching to Ximble, Spirited Gift no longer struggle with employees turning up at the wrong time, for the wrong shifts.

Re-bath of South Florida

Re-bath required timekeeping software that was simple, flexible, and that could grow with their business.

Vastrm

When they outgrew their own internal system, Vastrm chose Ximble to track their part-time and contracted employees, both in and out of the office.

Excellence Martial Arts

All that Excellence Martial Arts were looking for was basic employee timetracking, with payroll reporting. Ximble’s cost-effective software was the ideal solution.

Collab Inc

Manual timesheets were a poor fit for Collab, and with no easy to feed the data into Gusto they began looking for a viable solution to their scheduling and time tracking headaches.

Carolina Moves

Follow Carolina Moves’ journey as they transitioned from using an archaic time tracking and data entry methods to using something that could optimize their processes and integrate with Gusto.

Bearings Bike Shop

Read how inaccurate time keeping methods forced Bearing Bike Shop to approximate working hours leading to significant losses over the year, until implementing Ximble.

Mermaid Life Chameleon

Needing a simplistic solution to their scheduling and time tracking needs, Mermaid Life didn’t want a solution that would over deliver and overcharge for what they required.

Krein Knives

Outgrowing spreadsheets, Krein Knives now needed a time tracking solution that could accurately track irregular working hours and automate as much of the administrative process as possible.

Garmentory

Looking for automation and simplicity, Garmentory turned towards Ximble in hopes of resolving their time tracking woes.

Novvia

With their eyes set on rapid growth, Novvia needed to implement a scheduling solution that could effectively scale as the business grew while integrating with the existing payroll system.

Story2

Discover how Story2 resolved their time tracking and payroll problems by implementing Ximble into their arsenal of tools and integrating it with their payroll platform, Gusto.

CareCentric Pty Ltd

Spreadsheets lacked the scalability and flexibility that CareCentric Pty Ltd needed as they grew and needed something that would be responsive to their changing needs.

Bou Cou Dancewear

Struggling with varying availability of staff, scheduling for multiple store fronts and managing payroll, Bou Cou Danceware needed a solution to their scheduling and time tracking needs.

Best Pets Veterinary Hospital

Constantly fighting wasted time from data entry errors, outdated methods of scheduling and time tracking were taking their toll. Discover how Ximble helps them overcome their challenges.

Hook SEO

Read how Ximble helped Hook SEO with their time tracking and scheduling problem when they noticed too much time was being wasted on data entry.

National Strategic

After a rapid increase of employees, National Strategic’s dependence on spreadsheets for time tracking was no longer viable. Find out how Ximble solved their problems.

miR Diagnostics

Find out how miR Diagnostics implemented Ximble’s time tracking features for their employees and how it improved their payroll operations through the Gusto integration.

Followell Fotography

Effective time tracking in and out of the office and Gusto integration was important for this photography company. Find out how Ximble stepped up to meet the challenge.

CARP

Ximble provided an inexpensive and user friendly solution to CARP’s time tracking and Gusto integration needs. Find what won them over and how it bettered their operations.

iLoveKickboxing

Discover how the time tracking and extensive feature of Ximble helped improve ILKB’s operations with the Gusto integrations and ximbleChat platform without breaking the bank.

Techpoint1

A tech savvy company that integrates technology into your offices and homes. With their skill and knowledge, they turn your ideas into reality.

Wise Owl Animal Hospital

An animal hospital that combines traditional and modern medicine to provide superior animal care. They raise awareness and provide advice on excellent pet care.

Armstrong Property Management

A property management consulting that specializes in home real-estate. They offer an abundance of services to property owners.

Parsaco

A restaurant consulting company that helps you take your business to the next level. With the best advisors, they can help you expand your business.

Liquid Consulting

A consulting company that strives to become your food processing partner. Comprised of skilled technicians and employees to improve your business.

Alta Animal Hospital

Find out how Alta Animal Hospital do away with printed shift calendars and move to a 100% mobile platform.

Montefiore

Read how Ximble helps Montefiore eliminate the need for multiple spreadsheets and calendars.

Rudy’s Pub & Grill

By utilizing Ximble, Rudy’s Pub & Grill has seen a 60% decrease in missed shift from schedule confusion.

TouchSupport

Learn how TouchSupport was able to manage employees at multiple locations with ease and save 8 hours a week by using Ximble.

Try Ximble for 14 days free

No credit card required. Cancel any time.