Services • Payroll Processing
Raw payroll data in. Clean reports out. Every time.
Eliminate the manual work: Export your payroll data. Click a button. Have your reports.
How many hours are you spending doing payroll? And how much do you trust the results?
Payroll errors aren’t just annoying, they’re expensive. A miscalculated commission or a missed overtime rule doesn’t just cost money, it costs trust. If your payroll process is held together by one person’s memory and cobbled-together spreadsheets, it’s time for a change.
The bottom line: Every pay period, you pay twice: once in wages, and once in the time it takes to get them right.
Structured
Rates, rules, and rosters live in their own tables, apart from each pay period’s data. Nothing is buried in a formula nobody can find.
Automated
Export your payroll data, click a button, and the calculations, reports, and cross-checks run themselves.
Tailored
Your pay types, your thresholds, your rules. Built around how you pay, not how a template thinks you should.
How I Build It
What data is needed?
Primary Data
Your Raw Payroll Data
This is your raw payroll data for the current pay period:
- Hours worked
- Cases done / calls made
- Routes driven
- Commission basis amount (e.g. AUM)
Metadata Lists
Dropdowns and Categories
These are infrequently changed lists that help define your other data:
- Employee Type
- Job Codes
- State Lists
- Day Types and Holidays
Metadata Lists
Rosters and Rules
These are the values that govern your data. Change them and automatically update your payroll:
- Mileage Rates
- Commission Thresholds
- Compensation Rates
- Overtime Rules
Where does it come from?
Primary Data
Power Query Import
Your raw data will be available via:
- Exported csv or xlsx files (most common)
- Manual work log
- Direct API connection to your software
Metadata Lists
Manual Data Entry
I’ll work with you to build the tables you need. With a few simple keystrokes you can:
- Add or remove entries
- Change prices and percentages
- No Excel knowledge required
What do you need to do with it?
Reports
Summary and Detail Reports
View the results for the current pay period as:
- Totals per employee or group
- Detailed breakouts for each employee
- Totals per type (e.g. salary, hourly, OT)
Dashboards
Payroll Trend Reports
See rolling results over multiple periods:
- YTD totals per employee
- Period-over-period payroll changes
- Payroll by region / category
Custom Output
Output Tailored to You
Receive the unique custom output you need:
- Emailed paystubs
- Data cross-checks
- Paychex uploads
Ideal for
Organizations processing payroll for a team where hours, rates, or rules vary; have commissions, overtime, tiered pay, or multiple pay types; or where the process requires manual calculation, cross-checking, and a significant investment of time.
FAQs
Is this a replacement for a payroll provider?
No. It's built to sit alongside whatever provider or system you use, cleaning up and automating everything on your side of the process.
Is employee data secure?
Yes. The entire process is under your control. It is your raw data, your spreadsheet, and you running the process. Nothing leaves the spreadsheet, unless you authorize it.
When building the spreadsheet, I can work with anonymized dummy data. As long as the data structure is the same as the real data, I don't need to see your sensitive data. We can do any troubleshooting via live calls, keeping the real data exclusively on your computers.