Fix misallocated payroll taxes in QuickBooks Online — in 30 seconds.
Before you begin, have ready:
Your QBO General Ledger (Employee View) export — Excel or CSV
Know which account holds your Field Labor wages (usually 50010 or similar)
Know which account holds your payroll taxes to reallocate (usually 50050)
The payroll date for this journal entry
🌿
ADP Tax Allocator
QBO Journal Entry Generator
Tool:
1
Upload
2
Configure
3
Review
4
Download
1
Upload Your File
Export your QBO General Ledger (Employee View) from Reports → Accountant Reports → General Ledger, and upload it here. The tool will calculate the correction JE (the delta between wrong and correct).Upload your QBO General Ledger (Employee View) — same export as usual. The tool will build a complete correct JE from scratch — no tax account selection needed.
The tool detected your file format. Select the wage account (source of correct class distribution) and the tax account to reallocate. Then confirm the payroll date.Select the wage account and the tax expense account from your file — the total is calculated automatically. Then enter just the payable account name for the credit side (that account won't appear in the GL export).
Select Accounts to Reallocate
Choose the accounts from your file — works with any Chart of Accounts.
Whose debits show how hours/wages are distributed across classes
Currently posted to the wrong class — will be reallocated by wage %Account to debit for each division's share of employer taxes
Liability account for the total credit — e.g. "Payroll Taxes Payable". This is a balance sheet account and won't appear in your GL export.
3
Review Employee Data
Verify the data looks correct before generating. The "Where taxes are now" column shows the wrong class ADP defaulted to. "Where they should go" shows the correct allocation based on each employee's wage distribution.These are the divisions wages were posted to. The tax amount will be split proportionally across divisions based on each employee's wage percentage.
Employee
Division(s) Where Wages Were Posted
Gross Wages
Where Taxes Are Now (incorrect)
Tax Amount
Where They Should Go
4
Journal Entry Summary
This is your correction by division. DEBIT lines add taxes to that division; CREDIT lines remove them. The entry balances because debits = credits.This is your complete Journal Entry. Each division is DEBITed for its share of payroll taxes. The CREDIT goes to your payable account. Balanced when debits = credit total.
Division
Wages Paid Here
Taxes Currently Posted Here
Correct Tax Amount
Change Needed
Journal Entry Action
Division / Account
Wages Paid Here
% of Total
Tax Amount
Journal Entry Action
📋 Tax Account Name for QBO Import
Must match your QBO Chart of Accounts exactly. If QBO shows the full path (e.g. "Payroll Expenses | Field Labor:Field Labor Taxes"), enter just the account name (e.g. "Field Labor Taxes").