Contractor payments and pay reports made easy with Beebole

Streamline contractor payments with Beebole

Table of Contents

If you have a team of contractors, paying them in a timely manner is a must. You need a speedy workflow to review submitted hours, analyze your contractors’ work, and set up a payment to them. Many contractors work on hourly arrangements. That means it’s important to not only measure their time, but pay them according to their hours. With Beebole, this is a breeze.

In this blog post, we’ll walk through reviewing and approving contractor hours, running time and cost reports, and exporting billing and payroll data all without leaving Beebole. It’s a workflow that your contractors will never see, but is sure to delight them while working with you.

Note that all of the below steps can be used for any user type on Beebole, such as running payroll for your own employees.

Setting up your Beebole account for contractor payments

Before we get started, it’s important to look at how contractors are configured in your Beebole account. When adding a person to Beebole, you should assign their user role, which could be employee, team leader, contractor, etc. However, if you want to run reports that only include contractors (or any other role for that matter), you should create a group.

First, create groups using the Group Settings module on the Settings page. Groups might be departments, offices, or any other designation you’d like to use to filter people in reports.

Create departments, branches, and other groups to organize employees in Beebole.

Then, add a person to a group using the Groups module on an individual’s page. In the example below we navigated to James Foster’s page and added him to the group “Contractors”.

Assign users to as many groups as you need for advanced reporting.

Next, let’s define the costs for each contractor. Click on a contractor’s name to be taken to their individual page. Locate the Standard Cost module or add it to the screen by clicking “Customize” in the top right corner. Drag and drop it anywhere on the screen. Note that features like costs and billing are only relevant for Project Tracking users.

Use the drop down menu to select a unique cost per hour, cost per task, or no cost. Fill in the cost and currency. If there are existing time records for this contractor, a message will appear asking if you want to update the rate for these previous records.

Set costs for your employees for more accurate budgeting and profit analysis.

Note that you could also use the Billing Methods module for this exercise. Billing methods and standard costs are two independent rates that can be defined for any purpose. Most organizations use them to capture how much they pay their employees or contractors (standard cost) and how much they bill their customers (billing methods), but others use only one or the other.

Reviewing and approving hours in Beebole

Once a contractor has tracking and submitted hours in Beebole, their manager will receive a notification to approve the time. Hours can be reviewed in the Approval panel on the home page. If the panel is not visible, click “Customize” in the top right corner and drag and drop it anywhere in your dashboard.

Quickly review and approve employee timesheets in a few clicks.

Hours awaiting approval will appear here under the Submitted tab. Select the timeframe you want to review hours for using the date menu at the top of the module. You can review single days, weeks, months or a full quarter. Click the arrow beside a contractor’s name to open a more detailed view of their hours.

Tick the boxes to the left of the hours you want to approve or reject. You can select all of a contractor’s hours by ticking the box beside their name, or the box at the top of the module to select all hours for all contractors. Then click “Approve” or “Reject”.

This is a simple example of how to approve and manage hours, but there are a few more advanced features that might be useful to you. You can read more about approving, rejecting and locking hours here.

Running reports to generate payslips

In Beebole it’s easy to run reports that can be used to generate payslips for contractor payments or to run payroll for your employees. Start by adding a Report module to your home screen. You can also run reports on a company, project, or individual person’s page, but note that the report will only display data related to that entity.

  1. Click “Change this report” at the top of the module. Select the timeframe you’d like to run the report for and give it a name.
  2. Under “What information do you want to show?” you can select what types of time to include in the report. For our purposes we’ll choose Working time.
  3. Create your columns. You can add unlimited columns and choose from over forty types of data. In this case, let’s add columns for Person, Project, Hours, and Costs in that order.
  4. If you are running this report specifically for contractors, click to “Add a Group or Custom Field” and select the Contractors group from the list.
  5. Choose the status of the hours you wish to include in the report. In this case, select Approved.
  6. Finally, choose the currency of your report and click “Run the report” at the top of the module.
Build highly customized reports on costs and billing.

The resulting report will look something like this:

Get detailed cost reports by client, person and project.

You can click on any name in this report to drill down and view only the hours for the selected person. Add a date column to these reports if that information is needed for your payslips.

Click through reports to drill down and gain increased detail and insight.

Exporting your payment data

Once you have the final version of the report including all of the desired data, you can export in multiple ways. Click the icons in the top right corner of the Report module to export to a PDF, CSV, Microsoft OneDrive or Google Drive. Note that the latter options are only available to Google Suite and Microsoft email users, respectively.

When exporting as a PDF, you can use the Export Settings module to add customized branding, headers and footers. Read more about creating branded reports here.

Export customized, professional looking branded reports.

If you need to further manipulate this data, create more advanced reports, or merge it with additional data sources then we recommend Beebole’s integrations for Google Sheets and Excel. They will allow you to seamlessly link real time data from your Beebole account with these tools and take advantage of all of their powerful reporting capabilities. Collaborate with teammates and automate periodic emails with updated reports.

Pay your contractors efficiently starting today

Now that you’re finished preparing the data, it’s time to send payments. Ultimately, this step will vary for every company depending on your payment platform of choice. While we’ve generated the payment data, you’ll need a third party tool to help you process and send the contractor payments.

Ultimately, you’ll need to assess what options exist in your chosen payment platform. Here are a few things to consider to get the most from what we’ve already prepared:

  • Automation options – Many payment platforms help you automate this process with an uploaded file. For example, PayPal’s Mass Payments feature accepts a CSV file to batch your payments.
  • Attachments – With this tutorial, you learned how to export a PDF with payment information. It’s a great idea to not only send this to your contractor, but to attach it in your payment tool. Many payment apps allow you to do just that for formal documentation.

As you can see in this post, it’s easy to leverage your Beebole data to prepare payment information. From approval to output, this workflow helps keep your contractors paid accurately and on time.

Ready to save time and simplify contractor payments?

Try Beebole for free. No commitment. Or schedule a quick call with our sales team so we can better understand your business needs.

Photo by Kenny Eliason on Unsplash

The experts who have written or contributed to this article are independent from Beebole, and their contribution doesn't serve as endorsement for our company/tool or their past/present organizations, employers, or associates.
Andrew Childress is a former FPA & CFO with a passion for simplifying, understanding, and analyzing financial data. He founded the FP&A consulting firm Beyond a Number to show others that great financial planning really starts once you go beyond the spreadsheets and numbers, and truly understand the data in front of you.

Comments

Related posts

Python for finance: Unlocking the power of data analysis

Published: 2023/7/4 | Yves J. Hilpisch

Are you exploring the intriguing world of python for finance? Whether you aspire to work in the financial industry, or wish to advance your existing career, mastering Python is a key step forward. In today’s fast-paced financial arena, Python programming is a crucial skill that top institutions seek in their professionals. Dive into this article […]

Read more

Building a PWA for Android and iOS: Tutorial and live example ?

Published: 2017/9/27 | Miguel Guardo

Mobile web apps (known as Progressive Web Apps or PWA) can be a cheaper and totally viable replacement to native apps in many domains. As it’s been proved elsewhere, native apps require a costly launch and maintenance cycle. Google is betting strong on PWAs by implementing Service Workers and although iOS is not reacting that […]

Read more

How to build an automated report in Excel with Power Query: The time tracking dashboard

Updated: 2020/9/11 | Andrew Childress

When it comes to maximizing productivity and saving time, automated reports in Excel with Power Query are key. That’s why we created this tutorial on YouTube, where you can see how to build a time tracking dashboard with Power Query. Reporting automation allows managers and controllers to have business metrics dashboards up to date in […]

Read more