Payroll Hub
Run payroll in whichever provider you already trust, then drop the CSV into Kantivo and get a balanced journal entry posted to your books in seconds.
Overview
Kantivo doesn't try to be your payroll provider — it's accounting software, not a tax-filing service. What it does instead is talk fluently to the providers who already do payroll well. Run payroll wherever you run it; export the journal as CSV; let Kantivo turn it into clean double-entry accounting.
The flow:
- Hit Run Payroll — your provider's site opens in a new tab
- Process payroll there as you always do
- Export the payroll journal as a CSV
- Back in Kantivo, click Import Journal Entry
- Upload the file — balanced entries post to your ledger automatically
Choosing Your Provider
- Click Payroll in the sidebar
- Use the Your Payroll Provider dropdown at the top of the hub
- Pick your provider (Gusto, ADP, Patriot, OnPay, etc.) or Other / Custom
- Kantivo remembers the choice — no need to set it again
Each company in Kantivo can use a different payroll provider. If you run payroll across multiple entities, set the provider per company.
Running Payroll
- Click the Run Payroll in [Provider] card on the hub
- Your provider's page opens in a new browser tab — log in and run payroll as usual
- When you're done, export the payroll journal or payroll summary as CSV
- Come back to Kantivo to import
Importing the Journal
- Click Import Journal Entry on the Payroll Hub
- Pick your provider from the cards — Kantivo uses this to auto-detect columns
- Upload the CSV (drag-and-drop or file browser)
- Click Upload & Detect Columns
- Review the auto-mapped columns and adjust anything that's wrong
- Enter the pay period and payment date
- Click Preview Journal Entries to see the proposed double-entry transaction
- Sanity-check the summary (employee count, gross wages, taxes, net pay) — confirm debits = credits
- Click Post Journal Entries
Quick Re-Import
After your first import with a saved template, a Quick Re-Import shortcut appears on the Payroll Hub. Click it to:
- Skip straight to the upload step
- Auto-load your last-used template
- Bypass provider selection
Net result: biweekly or monthly payroll imports become a 30-second job.
Supported Providers
Pre-built templates ship with Kantivo for these providers:
| Provider | Template | Auto-detected columns |
|---|---|---|
| ADP | ADP Run Report | Employee Name, Gross Earnings, Federal W/H, OASDI/EE, Net Pay |
| Gusto | Gusto Payroll Summary | Name, Gross Pay, Federal Tax, Social Security, 401(k), Net Pay |
| Paychex | Paychex Payroll Journal | Employee, Gross, FIT, SIT, SS, Medicare, Net |
| QuickBooks Payroll | QuickBooks Payroll Summary | Employee, Gross Pay, Federal Withholding, Net Pay |
| Patriot Software | Patriot Software Payroll | Employee Name, Gross Pay, Federal Income Tax, Net Pay |
| OnPay | OnPay Payroll Report | Employee, Gross Wages, Federal Tax, Retirement, Net Pay |
| Square Payroll | Square Payroll Report | Team Member, Gross Pay, Federal Tax, Total Hours, Net Pay |
| SurePayroll | SurePayroll Report | Employee Name, Gross, Federal WH, FICA-SS, Net Check |
| Rippling | Rippling Payroll Export | Full Name, Gross Pay, Federal Income Tax, 401k Employee, Net Pay |
| Wagepoint | Wagepoint Payroll Report | Employee, Gross Earnings, Federal Tax, Net Pay |
Provider not listed? Pick Other / CSV. Kantivo will auto-detect common column names; whatever it doesn't catch, you map manually once and save as a reusable template.
Journal Entry Structure
Every payroll import becomes a balanced journal entry. A typical post looks like:
| Account | Debit | Credit | Description |
|---|---|---|---|
| 6600 Wages Expense | $10,000 | Gross wages | |
| 2200 Payroll Taxes Payable | $2,500 | Federal + state + FICA withheld | |
| 2300 Benefits Payable | $800 | Health, 401(k), other deductions | |
| 1000 Cash | $6,700 | Net pay to employees | |
| Totals | $10,000 | $10,000 | Balanced |
Kantivo maps your CSV columns to the right debit/credit accounts automatically and won't let you post if debits don't equal credits.
Saved Templates
- Save — tick "Save as template" during import and give it a name
- Use — pick it from the Saved Templates dropdown before uploading
- Delete — remove custom templates in the import wizard. Default provider templates are read-only.
Templates store the column-to-field mapping so you don't remap every pay run. Each company can carry multiple templates if you use multiple providers or export formats.
FAQ
Why doesn't Kantivo run payroll itself?
Payroll is a different product entirely — tax tables, filings, multi-state compliance, year-end forms. Gusto, ADP, and Patriot specialize in it. Kantivo's job is to be the cleanest, most affordable accounting layer, then talk fluently to the payroll experts. You get best-in-class on both sides instead of compromise on either.
What if my provider isn't in the list?
Any provider that can export to CSV (or Excel) works. Pick Other / CSV, map the columns once, save as a template.
My CSV columns don't match what got auto-detected. Now what?
Override any mapping in Step 2 of the wizard — each field has a dropdown listing all the columns in your file. Save the corrected mapping as a template and you're done forever.
How often should I import?
After every pay run — weekly, biweekly, or monthly. With Quick Re-Import wired up, it's a 30-second task.
What payroll accounts does Kantivo set up?
New companies get these accounts created automatically:
- 2200 Payroll Taxes Payable — withheld employee taxes
- 2300 Benefits Payable — withheld benefit deductions
- 6600 Wages Expense — gross wages
- 6700 Payroll Tax Expense — employer-side taxes
- 6800 Employee Benefits Expense — employer benefit contributions
Can different companies use different providers?
Yes. The provider selection lives per company, and so do the saved templates.
Employee Documents
HR documents live on the employee record where they belong — not in scattered folders or email threads.
Uploading
- Open an employee profile → Documents tab
- Pick a category (W-4, I-9, Offer Letter, Contract, ID/Passport, Certification, Performance Review, Disciplinary, Other)
- Click Upload File and choose the file
- It's saved instantly and appears in the list
Accepted Formats
PDF, PNG, JPG, GIF, Word (.doc/.docx), Excel (.xls/.xlsx), CSV, and plain text. Up to 15 MB per file.
Download & Delete
Click the download icon to grab a copy. Click the trash icon to delete permanently. Be careful with compliance-required documents like W-4s and I-9s — deletes are not recoverable.
Categories
- W-4 / I-9 — withholding and employment eligibility
- Offer Letter / Contract — hiring agreements
- ID / Passport — government-issued ID copies
- Certification — licenses, training records, credentials
- Performance Review / Disciplinary — internal records
- Other — anything else relevant to the employee