Mastering the Mid-Month: A Guide to Semi-Monthly Payroll Forecasting Models

Why Semi-Monthly Payroll Forecasting Models Deserve More Attention Than They Get

 

Semi-monthly payroll forecasting models are the structured methods finance teams use to predict payroll costs across 24 fixed pay periods each year — typically on the 15th and last day of every month.

If you’re evaluating which model fits your business, here’s a quick-reference breakdown:

Model Type	Best For	Key Feature
Calendar-based	Salaried teams	Fixed gross pay × 24 periods
Driver-based	Mixed workforces	Hours × wage rate + burden %
Rolling 13-week	Cash flow planning	Updates weekly from timesheets
Headcount/budget model	Annual planning	Salary + employer burden by dept.
Budget-to-actual	Variance tracking	Forecast vs. payroll register

About 19.8% of U.S. private businesses use a semi-monthly pay schedule. It sounds simple — pay everyone twice a month, done. But anyone who has managed payroll for a team with hourly workers, overtime, or split workweeks knows the reality is messier.

When a workweek crosses from one pay period into the next, overtime can’t always be paid on the first check. When February has 28 days or a payday lands on a Saturday, your numbers shift. These aren’t edge cases — they happen every single month.

That’s exactly why a solid forecasting model matters. Without one, payroll becomes a financial surprise instead of a planned expense. For small business owners already stretched thin, that kind of uncertainty hits hard — especially when payroll is typically the largest controllable cost on the books.

I’m Charlie Perrin, founder of Cloud Bookkeeping, and with over 24 years of experience helping small business owners build cleaner financial systems, I’ve worked directly with clients on semi-monthly payroll forecasting models to turn payroll from a stressful unknown into a predictable line item. In the sections below, I’ll walk you through exactly how these models work and how to choose the right one for your business.

Semi monthly payroll forecasting models: what they are and when to use them

A semi-monthly payroll forecast model estimates what your business will pay on each of its 24 annual payroll dates. Most semi-monthly schedules use either:

• The 1st and 15th of each month
• The 15th and last day of each month

If you want a deeper foundation on the pay cycle itself, start with our plain-English guide to how semi-monthly payroll works.

A good semi-monthly forecast helps answer:

• How much cash do we need before each payroll run?
• Which payrolls fall near rent, loan payments, tax deposits, or large vendor bills?
• How much overtime is likely this period?
• Are benefits, deductions, and employer taxes reflected correctly?
• What payroll cost should hit the income statement this month?
• What payroll liability should be accrued at month-end?

The best model depends on your workforce. Salaried professional services firms can often use a calendar-based model. Businesses with hourly staff—like restaurants, trades, or medical offices—need more detail because hours, overtime, and scheduling patterns vary.

Semi monthly payroll forecasting models vs. bi-weekly forecasts

Semi-monthly and bi-weekly payroll are often confused because both mean employees are paid about twice per month. For forecasting, however, they behave very differently.

Feature	Semi-Monthly Forecast	Bi-Weekly Forecast
Pay periods per year	24	26
Pay timing	Fixed calendar dates	Every two weeks on a weekday
Typical dates	15th and month-end	Every other Friday, for example
Cash flow pattern	Predictable by month	Two months may have three payrolls
Salaried payroll math	Annual salary divided by 24	Annual salary divided by 26
Hourly payroll complexity	Higher because periods vary	Often simpler because weeks align
Overtime tracking	Must track by workweek	Easier when pay period matches weeks
Benefits deductions	Often 24 deductions	Often 24 of 26 checks, depending on plan

Bi-weekly payroll is common, with about 43% adoption among private U.S. firms. While employees often prefer bi-weekly pay for weekly budgeting, semi-monthly pay simplifies monthly accounting and cash flow by eliminating “three-paycheck months.”

If you are choosing a schedule, it helps to compare how bi-weekly and semi-monthly pay cycles affect your business.

The main model types finance teams should evaluate

There is no single perfect payroll forecast model. The right answer is usually a combination of models.

Here are the main ones we evaluate with clients:

1. Calendar-based payroll model
   Best for salaried teams. It forecasts each semi-monthly payroll by dividing annual salary by 24 and assigning payments to fixed payroll dates.

2. Driver-based payroll model
   Best for hourly or mixed teams. It uses expected hours, pay rates, overtime assumptions, labor demand, and payroll burden percentages.

3. Headcount and budget model
   Best for annual planning. It forecasts payroll by employee, department, start date, raise date, bonus plan, and employer burden.

4. Rolling 13-week cash flow model
   Best for short-term cash management. It updates weekly using timesheets, open bills, accounts receivable, and upcoming payroll dates.

5. Budget-to-actual model
   Best for variance tracking. It compares forecasted payroll against the payroll register and general ledger after each run.

6. Department-level labor model
   Best for growing teams. It separates payroll by sales, operations, admin, field labor, management, or location.

7. Scenario planning model
   Best for decision-making. It answers “what if” questions regarding new hires, overtime increases, or mid-year raises.

For most small businesses, we recommend a practical hybrid: a 12-month headcount forecast for planning, paired with a rolling 13-week cash forecast for payroll timing.

Why semi-monthly forecasting matters for small-business cash flow

Payroll is a major cash event that often coincides with rent, loan payments, sales tax, and vendor bills. Semi-monthly forecasting helps you plan for:

• Payroll reserve needs before the 15th and month-end
• Payroll tax deposits and employer tax costs
• Benefits and retirement contributions
• Month-end accruals
• Working capital gaps and vendor payment timing
• Owner distributions and hiring decisions

For small businesses in San Antonio operating with lean teams and tight cash cycles, a clean forecast gives owners enough visibility to make decisions before payroll becomes a Friday afternoon emergency.

How to calculate semi-monthly payroll amounts accurately

Payroll forecasting starts with accurate gross pay. Then you add taxes, benefits, deductions, and other employer costs to get fully loaded payroll.

A basic semi-monthly pay calculator can help with wage conversions, but business forecasting needs more than a calculator. You need assumptions, timing, and controls.

Salaried employees: annual salary divided by 24

For salaried employees, the basic formula is simple:

Annual salary / 24 = gross semi-monthly pay

Example:

Annual Salary	Pay Periods	Gross Semi-Monthly Pay
$60,000	24	$2,500

So an employee earning $60,000 per year receives $2,500 gross per semi-monthly payroll before taxes, deductions, and benefit withholdings.

Your model should also handle exceptions:

• New hires starting mid-period
• Terminations
• Raises with effective dates
• Unpaid leave
• Salary changes
• Bonuses
• Commissions
• Retroactive pay adjustments

For example, if a raise starts on May 16, 2026, your model should apply the old rate to the first May payroll and the new rate to the second May payroll. It sounds obvious, but plenty of spreadsheet chaos begins with one raise entered in the wrong column.

Hourly employees: actual hours, variable workdays, and blended wage rates

Hourly payroll is where semi-monthly forecasting gets interesting.

Semi-monthly periods do not always contain the same number of workdays. A period may include 10 workdays, 11 workdays, or a different count depending on weekends, holidays, and month length. That means using a flat assumption like 86.67 hours per semi-monthly period can be useful for rough budgeting, but risky for actual forecasting.

For hourly employees, use:

Expected hours x hourly rate = regular gross wages

Then add overtime:

Overtime hours x overtime premium rate = overtime wages

Example:

Employee Type	Forecast Input	Calculation
Hourly employee	80 regular hours at $22/hour	$1,760
Overtime	5 OT hours at $33/hour	$165
Gross wages	Regular + overtime	$1,925

For better forecasting, group employees by role and use blended wage rates. For example:

Role	Expected Hours	Blended Rate	Forecast Wages
Technicians	320	$28	$8,960
Admin	160	$24	$3,840
Supervisors	120	$35	$4,200

Blended rates are helpful when exact schedules are not final yet. But once timesheets are available, the model should refresh with actual hours.

From gross payroll to fully loaded payroll cost

Gross wages are only part of payroll cost. For cash flow and budgeting, you need fully loaded payroll.

Common employer-side costs include:

• Social Security and Medicare taxes
• Federal and state unemployment taxes
• Workers’ compensation
• Health insurance contributions
• Retirement match
• PTO accrual
• Bonus accrual
• Payroll processing fees
• Other benefits or allowances

A simplified formula:

Gross wages + employer taxes + benefits + accruals + fees = fully loaded payroll cost

If gross payroll is $50,000 and your employer burden is 18%, loaded payroll is:

$50,000 x 1.18 = $59,000

The burden percentage varies by company, employee mix, benefits, and insurance costs. Some businesses use a planning burden of 12% to 18% for taxes and benefits, while companies with richer benefits or higher workers’ compensation costs may be higher.

For deduction timing and employee withholdings, see our guide to handling semi-monthly payroll deductions.

Solving the hard parts: overtime, split workweeks, holidays, and accrual timing

Semi-monthly payroll forecasting gets tricky because the calendar does not always line up with the workweek.

The biggest challenges include:

• Overtime based on the workweek, not the pay period
• Workweeks split between two semi-monthly periods
• Paydays falling on weekends or holidays
• Variable month lengths (like February vs. 31-day months)
• Month-end accruals for earned but unpaid wages

Semi monthly payroll forecasting models for overtime and split workweeks

Under federal wage and hour rules, overtime for non-exempt employees is calculated by workweek (a fixed seven-day period). A semi-monthly pay period, however, can end on any day of the week. This means a single workweek is often split between two pay periods.

For example, if a pay period ends on Friday, May 15, but the workweek runs Monday through Sunday, the overtime hours for that week cannot be fully calculated until Sunday, May 17. Consequently, the overtime premium must often be paid on the following paycheck.

Your model should include:

• Defined workweek start and end dates
• Expected hours by day and overtime thresholds
• Split-week flags and accrued overtime estimates
• Approval workflows and payroll register reconciliation

Do not forecast overtime using only semi-monthly totals. The weekly pattern is what determines actual overtime liabilities.

How to handle accrual timing across semi-monthly pay periods

On an accrual basis, payroll expense must be recorded when wages are earned, not just when cash is paid. At month-end, this creates an unpaid payroll accrual for days worked but not yet paid.

A robust model should estimate:

• Earned wages and employer payroll taxes not yet paid
• Benefits accrued but not yet invoiced
• PTO earned during the period
• Reversing entries for the next month

Without payroll accruals, one month may look artificially profitable and the next artificially expensive, complicating management decisions.

Your general ledger mapping should clearly separate gross wages, employer taxes, benefits, payroll liabilities, and cash disbursements. At Cloud Bookkeeping, we emphasize clean payroll accruals because they make financial statements honest and useful.

Accounting for weekends, holidays, and varying month lengths

If a fixed pay date falls on a weekend or bank holiday, most employers pay on the prior business day. Your payroll calendar must document these rules in advance.

Your model should account for:

• Weekends and bank holidays
• Early pay dates and processing deadlines
• February’s shorter length and leap years
• Months with 10 vs. 11 or more workdays

Texas employers should review pay frequency and payroll practices under applicable federal and state guidance. The state’s payroll frequency guidance is a useful reference point, but businesses should confirm specific obligations with professionals.

The practical forecasting rule: build a payroll calendar before building the numbers. If the dates are wrong, the forecast will be wrong.

Building a reliable semi-monthly payroll forecast model with data, assumptions, and automation

A payroll forecast is only as good as the data feeding it. If employee records, timekeeping, payroll registers, and accounting categories do not match, the forecast becomes a guessing game.

Core data inputs and assumptions to include

Your semi-monthly payroll model should include these inputs:

Input	Why It Matters
Employee roster	Confirms active employees
Department codes	Supports budget and reporting
Salary & Hourly rates	Drives fixed and variable compensation
Expected hours & Overtime	Forecasts hourly payroll and premium costs
PTO & Holiday calendar	Adjusts staffing, workdays, and accruals
Hiring & Termination plans	Forecasts future payroll growth and changes
Bonuses & Commissions	Captures incentive pay
Tax & Benefit assumptions	Estimates employer payroll taxes and benefit costs
Cash balance & Fees	Shows payroll coverage and vendor costs
Payroll calendar	Aligns payments with cash flow

For hourly businesses, timekeeping and schedule data are the most critical inputs. For salaried businesses, focus on salary, headcount, effective dates, and deductions.

How AI and automation improve semi-monthly payroll forecast accuracy

By May 2026, automation is essential for efficient payroll forecasting. Manual forecasting is repetitive, detail-heavy, and prone to errors.

Automation helps with:

• Importing timesheets and updating schedules
• Classifying payroll transactions
• Detecting overtime risk and flagging missing approvals
• Comparing forecast to actual payroll and explaining variances
• Modeling hiring or raise scenarios

AI is especially useful in rolling forecasts. For example, a business can use recent timesheets, open receivables, and upcoming bills to build a short-term cash view.

While automation reduces manual work and improves visibility, humans must still review assumptions, exceptions, and approvals.

Controls that keep the model audit-ready

To keep your payroll forecast reliable and easy to review, implement these controls:

• Locked assumptions tab and clear source-of-truth fields
• Change logs and role-based permissions
• Maker-checker reviews for major changes
• Payroll register tie-outs and budget-to-actual comparisons after each run
• Consistent department and class coding reconciled to the general ledger

For improving payroll workflows overall, our guide to making small business payroll more efficient is a good next step. Clean reporting starts with clean structure.

Using forecasts for budgeting, employee experience, benefits, and compliance

A payroll forecast is not just for finance. It affects owners, managers, employees, and compliance processes.

A strong forecast helps you:

• Build realistic budgets and plan hiring
• Avoid payroll cash crunches and control overtime
• Schedule staff effectively and communicate pay dates clearly
• Estimate benefits, deductions, and compliance requirements

Pros and cons of semi-monthly payroll forecasting

Semi-monthly payroll forecasting has real advantages, but it is not perfect for every team.

Pros	Cons
Aligns well with monthly budgets	Overtime is harder to track for hourly staff
Creates 24 predictable payrolls	Workdays vary by period
Easier benefits deduction timing	Split workweeks complicate cutoffs
Supports month-end reporting	Pay dates may shift for holidays
Fewer runs than bi-weekly payroll	Employees may prefer bi-weekly
Larger individual paychecks	Processing deadlines can be tight

Semi-monthly forecasting is a strong fit for salaried teams and professional services firms. It can be harder for companies with heavy hourly labor or variable scheduling, where the forecast model must be more detailed.

KPIs finance teams should track

We recommend tracking these payroll forecasting KPIs:

1. Forecast accuracy: Actual payroll compared to forecast payroll.
2. Payroll variance by period: Difference by pay date, department, or role.
3. Overtime percentage: Overtime hours or dollars as a percentage of total labor.
4. Payroll-to-revenue ratio: Labor cost compared to sales.
5. Fully loaded labor cost: Gross wages plus taxes, benefits, and other employer costs.
6. Labor cost per hour: Fully loaded labor divided by productive hours.
7. Headcount variance: Actual headcount compared to hiring plan.
8. Payroll cash coverage: Available cash divided by upcoming payroll cash need.
9. Late timesheet rate: Percentage of timesheets submitted after deadline.
10. Deduction errors: Benefits, garnishments, or retirement deductions requiring correction.
11. Off-cycle payments: Manual checks or emergency payroll corrections.
12. Accrued payroll accuracy: Month-end accrual compared to later actual payroll.

For small businesses, the most important KPI is payroll cash coverage. Knowing whether cash is ready before payday is often business-saving.

Impact on employee budgeting, deductions, and compliance

Semi-monthly payroll helps employees budget around fixed dates (like the 1st and 15th), aligning well with rent, mortgages, and monthly bills.

However, it also presents challenges:

• Paydays shift when dates fall on weekends or holidays.
• Hourly employees may see variable check amounts.
• Overtime may appear on a later check when workweeks split.

Because semi-monthly employees receive 24 checks per year, benefit deductions are taken 24 times annually, which is simpler than spreading monthly benefits across 26 bi-weekly checks.

Your forecast should also consider tax withholding, retirement contributions, garnishments, insurance premiums, PTO payouts, and employee classifications.

For broader system planning, review which payroll solutions may fit your small business.

Frequently Asked Questions about semi-monthly payroll forecasting models

How many pay periods are in a semi-monthly payroll forecast?

A semi-monthly payroll forecast has 24 pay periods per year. There are two paydays each month, commonly the 15th and the last day of the month, or the 1st and 15th.

For annual budgeting, that makes salaried payroll easier to spread across the year. For cash flow, it means every month has two payroll disbursements, unlike bi-weekly payroll, which has 26 pay periods and can create two months with three paychecks.

How do you forecast semi-monthly payroll for hourly employees with overtime?

Start with scheduled or expected hours by employee, role, or department. Then separate regular hours from overtime hours based on the defined workweek.

A reliable hourly forecast should include:

• Actual timekeeping data when available
• Scheduled hours for future dates
• Weekly overtime calculations
• Split workweek tracking
• Overtime premium rates
• PTO and holiday assumptions
• Manager approval status
• Accruals for earned but unpaid wages
• Exception review before payroll is finalized

The key is to forecast overtime by week, not simply by semi-monthly pay period total. This helps avoid missing overtime when a workweek crosses from one pay period into the next.

Is semi-monthly payroll better than bi-weekly for forecasting?

It depends on the workforce.

Semi-monthly payroll is often better for:

• Salaried teams
• Monthly budgeting
• Benefits deduction consistency
• Predictable cash planning
• Financial statement alignment

Bi-weekly payroll is often better for:

• Hourly teams
• Overtime-heavy businesses
• Employees who prefer every-other-week pay
• Workforces that schedule around weekly cycles

Semi-monthly creates 24 checks per year. Bi-weekly creates 26. Semi-monthly is often cleaner for monthly reporting, while bi-weekly is usually simpler for hourly overtime tracking.

Conclusion

Semi-monthly payroll can be beautifully predictable or surprisingly chaotic. The difference is the model behind it.

The best semi-monthly payroll forecasting models combine:

• A clear payroll calendar
• Accurate employee and rate data
• Actual timekeeping inputs
• Overtime and split-week controls
• Fully loaded payroll assumptions
• Month-end accrual logic
• Budget-to-actual review
• Automation where it genuinely helps
• Human review where judgment matters

For small businesses, payroll forecasting is not just an accounting exercise. It is cash flow protection, employee trust, and better decision-making rolled into one mid-month routine.

At Cloud Bookkeeping, we help small businesses build clear reporting systems, improve payroll visibility, and connect bookkeeping with practical advisory support. Led locally in San Antonio by Charlie Perrin, our team brings QuickBooks expertise, professional bookkeeping, and a steady hand to the numbers that matter most.

If you are deciding whether semi-monthly payroll is right for your business, or whether your current model needs a tune-up, contact us today and start by choosing the pay cycle that fits your team.