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:

  1. Hit Run Payroll — your provider's site opens in a new tab
  2. Process payroll there as you always do
  3. Export the payroll journal as a CSV
  4. Back in Kantivo, click Import Journal Entry
  5. Upload the file — balanced entries post to your ledger automatically
Why split it this way? Embedded payroll inside an accounting platform usually costs $2K–5K/month in platform fees. Kantivo's hub gets you the same end result (correct payroll entries in your books) at zero added cost — and you keep working with the provider you already know.

Choosing Your Provider

  1. Click Payroll in the sidebar
  2. Use the Your Payroll Provider dropdown at the top of the hub
  3. Pick your provider (Gusto, ADP, Patriot, OnPay, etc.) or Other / Custom
  4. 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

  1. Click the Run Payroll in [Provider] card on the hub
  2. Your provider's page opens in a new browser tab — log in and run payroll as usual
  3. When you're done, export the payroll journal or payroll summary as CSV
  4. Come back to Kantivo to import
Where to find the CSV export: Most providers stash it under a "Reports" section. Look for "Payroll Journal," "Payroll Summary," or anything with an Export to CSV / Download button. The exact location varies by provider.

Importing the Journal

  1. Click Import Journal Entry on the Payroll Hub
  2. Pick your provider from the cards — Kantivo uses this to auto-detect columns
  3. Upload the CSV (drag-and-drop or file browser)
  4. Click Upload & Detect Columns
  5. Review the auto-mapped columns and adjust anything that's wrong
  6. Enter the pay period and payment date
  7. Click Preview Journal Entries to see the proposed double-entry transaction
  8. Sanity-check the summary (employee count, gross wages, taxes, net pay) — confirm debits = credits
  9. Click Post Journal Entries
Save the mapping as a template. Tick "Save as template" during import and give it a name. Next pay period, pick the template and you skip the entire mapping step.

Quick Re-Import

After your first import with a saved template, a Quick Re-Import shortcut appears on the Payroll Hub. Click it to:

Net result: biweekly or monthly payroll imports become a 30-second job.

Supported Providers

Pre-built templates ship with Kantivo for these providers:

ProviderTemplateAuto-detected columns
ADPADP Run ReportEmployee Name, Gross Earnings, Federal W/H, OASDI/EE, Net Pay
GustoGusto Payroll SummaryName, Gross Pay, Federal Tax, Social Security, 401(k), Net Pay
PaychexPaychex Payroll JournalEmployee, Gross, FIT, SIT, SS, Medicare, Net
QuickBooks PayrollQuickBooks Payroll SummaryEmployee, Gross Pay, Federal Withholding, Net Pay
Patriot SoftwarePatriot Software PayrollEmployee Name, Gross Pay, Federal Income Tax, Net Pay
OnPayOnPay Payroll ReportEmployee, Gross Wages, Federal Tax, Retirement, Net Pay
Square PayrollSquare Payroll ReportTeam Member, Gross Pay, Federal Tax, Total Hours, Net Pay
SurePayrollSurePayroll ReportEmployee Name, Gross, Federal WH, FICA-SS, Net Check
RipplingRippling Payroll ExportFull Name, Gross Pay, Federal Income Tax, 401k Employee, Net Pay
WagepointWagepoint Payroll ReportEmployee, 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:

AccountDebitCreditDescription
6600 Wages Expense$10,000Gross wages
2200 Payroll Taxes Payable$2,500Federal + state + FICA withheld
2300 Benefits Payable$800Health, 401(k), other deductions
1000 Cash$6,700Net pay to employees
Totals$10,000$10,000Balanced

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

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:

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

  1. Open an employee profile → Documents tab
  2. Pick a category (W-4, I-9, Offer Letter, Contract, ID/Passport, Certification, Performance Review, Disciplinary, Other)
  3. Click Upload File and choose the file
  4. 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