Skip to content

Workforce

Tag: reporting

Posted on October 17, 2022March 28, 2024

PBJ Reports: What you need to know

Nurse looking at a pb&j sandwich on her screen

Summary

  • The CMS requires long-term care facilities to submit quarterly Payroll-Based Journal Reports detailing direct care labor hours and payroll information.

  • PBJ reports include information such as work hours, work dates, job titles, and more.

  • PBJ information can be compiled and submitted to the CMS manually, or, time and attendance software can automatically build PBJ reports for you.


Nearly everybody loves PB&J sandwiches, save for people with severe peanut allergies of course. These deliciously gooey creations are packed with not only taste but nostalgia for the blissful freedom of childhood.

But I am not here to sing praises to the whimsical marriage of peanut and fruit. No, instead a more important topic must be discussed concerning an extremely close relative to the PB&J sandwich: the infamous PBJ Report.

 

What is a PBJ Report?

Payroll-Based Journal (PBJ) Reports are not scrumptious lunchtime meals, unfortunately. They are quarterly reports from long-term care facilities to the Centers for Medicare and Medicaid Services (CMS) detailing direct care payroll and staffing data.

This reporting began in 2010 with Section 6106 of the Affordable Care Act. In 2018, the CMS introduced the PBJ system to facilitate the process of collecting and gaining insight into direct care staffing.

Payroll-Based Journal Reports typically include the following information:

  • Employee ID
  • Labor classification/job title
  • Job title code
  • Pay type code (exempt, non-exempt, contract staff)
  • Hire date (optional)
  • Termination date (optional)
  • Work days and dates
  • Hours worked per day
  • Job/labor descriptions
  • Census data (optional)

Review the CMS’ PBJ Policy Manual for more details.

 

Why are PBJ Reports Necessary?

The broader answer to this question is that they help the CMS monitor staffing level issues within the long-term care industry. They also help increase the amount of freely accessible data available to the public for analysis. Lack of adequate staff in healthcare can have serious repercussions, and it is more commonplace than one would think with labor shortages persisting across the country.

More specifically, Payroll-Based Journal Reporting is necessary for nursing homes to maintain their Five-Star Quality Rating on the CMS’ nursing home compare website. A good rating is crucial for attracting patients and gaining referrals – something that can’t happen if a facility reports a lack of staff, or worse still, reports inaccurate staff hours.

The impact of accurate PBJ reporting cannot be overstated. In 2018, the CMS handed out 1,400 one-star reviews to nursing homes across the country for being insufficiently staffed. This came on the back of new regulation from the CMS stating that all long-term care facilities reporting four days or longer in a quarter with zero registered nurse hours on their PBJ report would receive a one-star rating. The previous cut-off was seven days.

Non-compliant PBJ reports may happen for a variety of reasons. For one, they could be due to healthcare facilities simply being understaffed. They could also occur due to manual calculation errors. Regardless, it’s essential that facilities figure out a streamlined way to record and report direct care worker hours accurately and honestly.

 

PBJ Submission

There are two methods for submitting a PBJ report to the CMS.

The first way is to manually enter all information into the CMS’ system via their website. This data would include info about employees, their hours paid to work, dates worked, and census information (optional).

Alternatively, you can skip all the manual work by using an automated time and attendance system for nursing homes or payroll system to create a report which you can then upload to the CMS website in XML file format. Seeing as the CMS’ reporting requirements are quite strict, you’ll need to ensure your report includes all the necessary data and is properly formatted according to CMS guidelines.

Registering to submit PBJ data requires several steps:

  • Obtain a CMSNet User ID
  • Obtain a PBJ QIES Provider ID for access to CASPER Reporting and the PBJ system
  • Register for QIES ID (If PBJ Corporate or Third-Party)

Review the CMS’ PBJ FAQ document for more information.

 

PBJ Report Deadlines

Below you can find the quarterly deadlines for PBJ submission to the CMS:

FISCAL QUARTER REPORTING PERIOD DUE DATE

1

October 1 – December 31 February 14
2 January 1 – March 31 May 15
3 April 1 – June 30 August 14
4 July 1 – September 30 November 14

 

Automate PBJ Reporting to the CMS

Creating and submitting PBJ reports does not need to be difficult or time-consuming. With the right systems in place, maintaining staff records and generating reports is actually quite simple. What’s difficult is finding and retaining the staff you need to maintain a five-star rating.

Webinar: How to Retain Hourly Employees

With Workforce.com, long-term care facilities can automate PBJ reporting to the CMS, freeing up hours of admin time to work on more pressing issues like employee turnover and short-staffing. The cloud-based timekeeping system maintains employee info like job codes, titles, and pay rates, while recording hours worked, breaks, and pay on a daily basis. And with a click of a button, you can create an accurate PBJ report and export it as an XML file.

For more information on PBJ Reporting visit the CMS website or review their PBJ policy manual. If you want to learn more about how to automate PBJ reports, contact us today, or, visit our long-term care page to find out how to comply with the CMS’ five-star quality rating system.

Posted on October 15, 2020October 11, 2021

How to put together effective workforce management reports

compliance; workforce management software

A lot of organizations are putting a good deal of money into HR technology systems, said Matt Stevenson, partner and leader of Mercer’s Workforce Strategy and Analytics practice. The first wave replicated paper-based systems and transformed them for online use, he said. The latest iteration of workforce management systems allows organizations almost an infinite amount of reporting.

”We have a lot of people asking us, ‘There’s too much here for us to really figure out. Can you tell us what we should and shouldn’t be reporting?’ ” Stevenson said.

Also read: Labor analytics add power to workforce management tools

He added that people in various departments look for different information in their workforce management reports. Operations professionals may focus on questions like, “How can this process be more efficient?” while those in the finance department may ask, “What’s the cheapest way to do this task?” And workforce management professionals focus on a different set of questions.

Stevenson had other thoughts about what workforce management professionals should be focusing on with reporting. 

What’s your problem? 

“Our finding is that it’s harder to come up with the questions than it is to draw answers from the system,” Stevenson said. “What’s also problematic is if you interrogate the data enough, it will eventually tell you what you want to hear. Which means if you [dig deeply enough] into a data set, you can find a data point that will confirm your hypothesis, even if it’s just not right. So that makes it a little bit hazardous.” 

For those approaching these expansive workforce management reporting systems, what’s important to remember is to know exactly what question they’re trying to answer or what problem they’re trying to solve, he added. Don’t approach this with intellectual queries that have no clear connection to solving a specific problem. 

Also read: A technology integration is an intervention to dissolve common payroll errors

He gave an example of a client with so much data, their mantra became that they would not gather any more data until they knew exactly what decision it would inform. “Data for the sake of data just makes it too hard,” he said. 

Follow the trends

While these HR systems and tools are good for reporting, another important use for them is a trends analysis of what has changed over the years, Stevenson said. From there, users can go about exploring what caused the trends or changes. 

For example, organizations could create workforce management reports to assess what mix of employees in each store gets the most profits. One way to do this would be to look at the most profitable store and copy their mix, but that would ultimately miss the point. 

A deeper trends analysis could help them explore questions like, “When this store/location added another employee, did it lead to more sales over time?” Looking across different store locations over a period of time this way, the person doing this analysis may realize that the staff mix or adding more staff might not be a significant factor for profitability at all. 

It could be something more straightforward, like the highest-performing store does the best because of its location, Stevenson said. “A jewelry store and rich neighborhood will sell more than the jewelry store in the middle of a field.” 

Also read: Cloud workforce management saves on costs, resources and time

He said the tougher question is, does it matter on how many people you have? Or is it something else? The answer depends on factors like the store’s business model and what it sells. Flexible HR systems allow users to answer these more complicated questions, and a skilled user can create their own reporting process in the tool to answer their own unique questions. 

A good, flexible reporting system will allow users to discover the right question for their own unique needs, Stevenson said. 

Finding the right questions 

To find the right questions, users can hire experts or talk to stakeholders of the organization, Stevenson said. But that on it’s own may not be the most efficient strategy.

“To be honest, most [users] just find themselves reacting to the data,” he said. They find themselves in a reactive cycle rather than a proactive cycle, and it’s hard to get out of that.

That’s the complicated part of these HR systems, Stevenson said. Users have all this extra data and the system can help with administrative tasks, but there’s so much data that reporting can become complicated. “There’s too much to report, and you have to put it in that extra effort to figure out what the right things are to report. And that’s not always straightforward.” he added.

The right sections to feature on your workforce management reports 

The categories to feature on an organization’s report depends on their industry, Stevenson said. For manufacturing, it may be all about having the right number of people to operate the machines. In hospitality, what’s more important is having employees with specific skills to perform certain tasks. 

Also read: How to avoid overstaffing through wage tracker software

For most industries the “workforce planning” and “compensation” categories are important, he added.  Organizations also are wanting to report on its diversity, equity and inclusion numbers. 

Ideally, there’d also be some data regarding productivity, even though that may be tough unless a company has a measurement to rely on that signifies productivity, he said. 

Reporting in the health care industry 

Health care can benefit  from these HR systems and reporting the most, Stevenson said. Lives are at stake, so if there’s a possibility that changing an HR model can save someone’s life, that’s a huge opportunity. 

Also read: Mental health provider persists through pandemic to continue patient counseling

For example, he said that Mercer recently found that when they joined operations data with HR data, they can predict 85 percent of the variance of things like the likelihood of picking up infections in a hospital. These are predictions and not explanations for what is happening, but they’re still helpful. 

“When we work with our hospital clients, we can tell them, ‘Here are the things we can predict based on the types of shifts, the characteristics of the staff, the number of hours people work, where they work [and] the flows of people coming in and out.’ Then we bring them operational data like, ‘[What] kind of patients do you have at any given time? What’s the case mix?’ ” he said. 

“What we’re trying to do now is convince clients to program this into their HR systems,” he added. This may allow them to narrow possible causes for why an event (like infection spreading through a hospital) is happening on the premises. 

How these HR solutions are maturing 

“It is my personal opinion that these systems will reach their full maturity when they’re more integrated with the other parts of the business, like financial systems and operational systems,” Stevenson said. “Because then you can compare the people with the financials and compare the people data with the operational data.”

Stevenson said that it wasn’t that long ago that these HR tasks were done on paper, and now we’re at the point where some people are complaining about the fact that their electronic records don’t match up to those in another HR system. 

He believes that at this future level of maturity, HR systems will be able to help answer people’s questions about what the right questions are and what’s the right data to collect. 

“I think we’re pretty far away [from maturity]. but just because you’re far away doesn’t mean you won’t get there fast,” Stevenson said. 

 


 

Webinars

 

White Papers

 

 
  • Topics

    • Benefits
    • Compensation
    • HR Administration
    • Legal
    • Recruitment
    • Staffing Management
    • Training
    • Technology
    • Workplace Culture
  • Resources

    • Subscribe
    • Current Issue
    • Email Sign Up
    • Contribute
    • Research
    • Awards
    • White Papers
  • Events

    • Upcoming Events
    • Webinars
    • Spotlight Webinars
    • Speakers Bureau
    • Custom Events
  • Follow Us

    • LinkedIn
    • Twitter
    • Facebook
    • YouTube
    • RSS
  • Advertise

    • Editorial Calendar
    • Media Kit
    • Contact a Strategy Consultant
    • Vendor Directory
  • About Us

    • Our Company
    • Our Team
    • Press
    • Contact Us
    • Privacy Policy
    • Terms Of Use
Proudly powered by WordPress