
Use the following steps to reconcile payroll:
- Print out your payroll register.
- Match each hourly employee’s time card to the pay register.
- Make sure the pay rates and salaries for each employee are correct.
- Check that you took all deductions out of employee paychecks.
- Make entries in the general ledger according to your payroll register.
What is benefit reconciliation?
What is benefit reconciliation? Benefit reconciliation, also known as health insurance reconciliation or premium reconciliation, is when premium bills are reviewed against a company’s payroll deductions to check for potential discrepancies.
How do you reconcile payroll?
Additionally, you should double-check your math by confirming that an employee’s gross pay on your payroll register is equal to their pay rate multiplied by the total number of hours worked. When you’re reconciling payroll for a specific pay period, you’ll need to look at your employee’s time cards or timesheets for that span of time.
Should your business automate its benefits reconciliation process?
While you have the option of manual benefits reconciliation, businesses can save time and headaches by hiring a payroll partner to automate your benefits reconciliation process and determine what actions need to be taken to correct any errors. Not sure if you need to offer health insurance at all?
How do I reconcile payroll with Form 941?
You’ll also reconcile payroll quarterly using Form 941 and annually at year-end when you print your employees’ W-2s. 2. How do I reconcile my 941 to payroll? Look at your payroll register for a specific quarter. Compare that pay data with what you’ve entered in Form 941 for that given period. Fix any discrepancies. 3.
What is benefit reconciliation?
What is the purpose of a payroll deduction spreadsheet?
Do carriers use their own employee identifications?

How do you reconcile insurance?
To reconcile, you compare two amounts: the premium tax credit you used in advance during the year; and the amount of tax credit you qualify for based on your final income. You'll use IRS Form 8962 to do this. If you used more premium tax credit than you qualify for, you'll pay the difference with your federal taxes.
How do I reconcile payroll deductions?
How to do a payroll reconciliationStep 1: Review your payroll register for accuracy. ... Step 2: Check pay rates & salaries. ... Step 3: Double-check hours entered. ... Step 4: Make sure deductions are correct. ... Step 5: Complete general ledger entries. ... Step 6: Run a payroll tax report and remit taxes due.
What Does reconcile mean in payroll?
What is payroll reconciliation? During payroll reconciliation, you compare the current period's payroll amount with the figures listed in your payroll ledger to ensure that both the records match. This acts as a final check to make sure your processed amounts will be accurate.
How do you reconcile receipts?
Next, let's take a look at the steps you must take to reconcile invoices.Step 1: Get Organized. The first thing you want to do in the invoice reconciliation process is to organize all of your invoices. ... Step 2: Begin Matching. ... Step 3: Mark Off Each Line. ... Step 4: Circle the Discrepancies. ... Step 5: Add Up Your Invoices.
How do you audit a payroll reconciliation?
Payroll audit proceduresLook at the employees listed on your payroll. Review your employees listed on your payroll. ... Analyze your numbers. ... Verify time is correctly labeled. ... Reconcile your payroll. ... Confirm tax withholdings, remittance, and reports are accurate.
What is general ledger reconciliation?
A general ledger reconciliation is an activity performed by accountants to verify the integrity of account balances on the company's general ledger.
How often should payroll reconciliation be?
How often should you reconcile payroll? You should reconcile payroll during each and every pay period, at least two days before pay day. This helps you avoid any delays with employee paychecks. You'll also reconcile payroll quarterly using Form 941 and annually at year-end when you print your employees' W-2s.
Why is reconciliation important in payroll?
The payroll reconciliation process helps you keep accurate accounting records, which are necessary for tax filing and measuring financial health. You check that the transactions in your books equal the payroll register. When you reconcile payroll, also make sure you recorded the correct amount for each employee.
What are the six steps necessary for computing employee pay?
Use these six steps to determine a pay rate for new employees.Write a job description. A job title isn't enough. ... Consider experience and training. Determine the minimum experience and education necessary for the position. ... Check out industry rates. ... Factor in benefits and perks. ... Set a salary range. ... Be flexible.
What are the 3 types of reconciliation?
Given below are some other reconciliation types that we normally come across in the financial world.Credit card reconciliation. Credit card reconciliation is similar to bank account reconciliation. ... Balance sheet reconciliation. ... Cash reconciliation.
What is an example of reconciliation?
Reconciliation definition Reconciliation is the act of bringing people together to be friendly again or coming to an agreement. An example of reconciliation is two siblings who mend their relationship after a period of fighting.
What is the process of reconciliation?
Bills described as reconciliation bills can pass the Senate by a simple majority of 51 votes or 50 votes plus the Vice President's as the tie-breaker. The reconciliation procedure also applies to the House of Representatives, but it has minor significance there, as the House does not have a supermajority requirement.
Health insurance payments reconciliation? — PayrollTalk
I have a big spreadsheet. The first few columns are the employee's name, effective date, coverage, and premium. Then the columns are paired up with each month's "Due" and "Invoiced", with totals and the difference all the way at the end (So I can see YTD Due and Invoiced, plus see any difference between the two).
Simplifying the Reconciliation Process for Healthcare Claims ...
According to the Council for Affordable Quality Healthcare, only 10 percent of claim payments are completed electronically. As the deadline to comply with the Patient Protection and Affordable Care Act’s (PPACA) mandate for electronic payments draws near, the healthcare industry will be entering somewhat uncharted territory.
Benefits Reconciliation 101
Timing BCAF generates around the 3rd weekend of the month. Alight files are loaded on the 5th business day of the month. Reconciliation processes are 30 days behind. If there is data conflict, ticket timing will delay your recon further.
The Headaches of Employee Benefits Billing and Invoice Reconciliation
Why They Happen and How to Cure Them! Employee benefits are crucial for employees and employers alike. When you offer benefits, it demonstrates a long-term investment in your staff and provides ...
OneSource | University of Georgia
Author: Debbie Farmer Last modified by: Tim Booth Created Date: 9/18/2012 12:52:04 PM Other titles: Benefit Recon Tasks Addt'l Tools 'Addt''l Tools'!Print_Titles 'Benefit Recon Tasks'!Print_Titles
MONTHLY BILLING RECONCILIATION PROCESS FOR HEALTH, DENTAL, LIFE & LTD
7 C. State Share Transfer Form (CFN 552-0335, Appendix E): Complete a State Share Transfer (example E-1) any time the department owes for a missed state share for an employee or owes more than what was pulled from payroll. (i.e. switched to a higher priced plan) 1.
What is benefit reconciliation?
Benefit reconciliation ™ ( also referred to as premium reconciliation or health insurance reconciliation ) is a monthly review of premium invoices against your company's payroll deductions to check for any discrepancies. Your company's benefits enrollment information and payroll deductions spreadsheet may contain employee's name, effective date, coverage, and premium cost. The goal is to ensure there are no under-or-over payments, that employees are enrolled in correct insurance plans, and that you're not paying premiums for terminated employees. The point person for this process will then determine what action needs to be taken to rectify any errors. This process i s is typically done by HR Benefits Specialist or someone in Accounting.
What is the purpose of a payroll deduction spreadsheet?
The goal is to ensure there are no under-or-over payments, that employees are enrolled in correct insurance plans, and that you're not paying premiums for terminated employees.
Do carriers use their own employee identifications?
Our carriers use their own unique employee identifications. How would these match up to employee data within our payroll system?
Why do employers need to do group billing reconciliation?
Bottom line is that employers seek to make group billing reconciliation more efficient and save them from wasting unnecessary time, money, and resources. Instead, they would rather redirect these resources towards a more productive means to further their organizational objectives.
Who holds the power to reconcile group billing?
Insurance carriers typically hold most of the power when it comes to group billing reconciliation. They send invoices for the benefits they offer to the company, and the client has to pay them.
Why is group billing reconciliation so difficult?
Until recently, HR departments from the client couldn’t just seamlessly share their data with the carrier’s finance department. Adjustments were simply called in, emailed or attached via a sticky note to the original invoice.
What is the main issue with employee benefits billing?
The main issue with employee benefits billing resides in the current challenge that is group billing reconciliation: in other words, managing and keeping accurate records of HR discrepancies between the carrier’s payment cycles, payroll deductions and the current enrollment records.
Why are benefits packages important?
Benefits packages are essential to any company’s relationship with its staff, and they encourage positive ventures and commitment to the company. Taking this all into consideration, it’s really too bad that processing the billing of employee benefits can be a deterrent.
Why do companies offer benefits?
When you offer benefits, it demonstrates a long-term investment in your staff and provides crucial services that employees and their families may not be able to afford on their own. That’s why health, dental, life, disability, retirement and/or other employee benefits can attract and retain top-tier talent, helping your company to grow and thrive.
Can HR transfer employee status?
Current database and accounting programs couldn’t communicate to transfer all changes in employee status’ in one fell swoop. Rather, HR would have to connect with each and every department of the company to verify the right changes were made and were consistent to the current enrollment status of the business. This creates an incoherent series of communications that places an unnecessary burden on HR accountants and benefits administrators who always seem behind in their work, creates greater error for inconstancies and inaccuracies in enrollment records and produces significant waste in productivity.
When should you reconcile payroll?
You should reconcile payroll during each and every pay period, at least two days before pay day. This helps you avoid any delays with employee paychecks. You’ll also reconcile payroll quarterly using Form 941 and annually at year-end when you print your employees’ W-2s.
What is payroll reconciliation?
Payroll reconciliation is when you compare your payroll register with the amount you’re planning to pay out to your employees to confirm those numbers match. The simplest way to think about it is double-checking your math to ensure that you pay your employees correctly. Payroll reconciliation should happen frequently.
How many days before pay day do you have to cut employee checks?
You’ll need to do it: Every pay period before you cut employee checks—ideally, at least two days prior to your pay day. Quarterly when you submit Form 941 with your quarterly federal tax return. Once per year during tax time when you confirm that your payroll data matches each employee’s Form W-2.
When reconciling payroll for a specific period, do you need to look at your employee's time cards?
When you’re reconciling payroll for a specific pay period, you’ll need to look at your employee’s time cards or timesheets for that span of time. Check to see if their hours are entered correctly and confirm that the hours on their timesheet match what’s in your payroll register.
What happens if you make mistakes in payroll?
Avoid fines and penalties. Making mistakes with payroll not only destroys morale, it can also lead to penalties from the Internal Revenue Service (IRS).
Why do you need payroll?
This payroll process might sound groan-worthy, but it helps with everything from preparing for taxes to monitoring your business expenses —not to mention ensuring that you pay your employees correctly.
When do you submit payroll taxes?
You’ll submit these payroll taxes either on a monthly or semi-weekly schedule. You should have determined which deposit schedule you planned to use at the beginning of each calendar year. Your payroll tax reports are submitted via Form 941 on a quarterly basis.
Can you be out of health insurance at the end of the month?
Unless you have a lot of activity on your plan (hiring, firing, etc.), you shouldn't be out by much at the end of the month. If you pay semi-monthly, the only difference should be in additions and deletions from coverage.
Is payroll talk a substitute for accounting?
The information posted on PayrollTalk is for informational purposes only and is not intended to substitute for obtaining accounting, payroll, tax, or financial advice from a professional accountant.
Do payroll systems automatically keep track of under deductions?
Most good payroll systems automatically keep track of under deductions - some will even automatically make the recoveries as wages become available. The real money is in the vendor payments, and there is (IMO) a real need to audit these costs.
What is benefit reconciliation?
Benefit reconciliation ™ ( also referred to as premium reconciliation or health insurance reconciliation ) is a monthly review of premium invoices against your company's payroll deductions to check for any discrepancies. Your company's benefits enrollment information and payroll deductions spreadsheet may contain employee's name, effective date, coverage, and premium cost. The goal is to ensure there are no under-or-over payments, that employees are enrolled in correct insurance plans, and that you're not paying premiums for terminated employees. The point person for this process will then determine what action needs to be taken to rectify any errors. This process i s is typically done by HR Benefits Specialist or someone in Accounting.
What is the purpose of a payroll deduction spreadsheet?
The goal is to ensure there are no under-or-over payments, that employees are enrolled in correct insurance plans, and that you're not paying premiums for terminated employees.
Do carriers use their own employee identifications?
Our carriers use their own unique employee identifications. How would these match up to employee data within our payroll system?
