Back to blog
# Payroll Journal Entry Template for QuickBooks (Free Excel & CSV Download)
Every payroll run generates the same problem: a summary report from your payroll provider and a general ledger that won't update itself. For solo bookkeepers and small firms processing payroll for multiple clients, manually translating that report into a properly structured QuickBooks journal entry — every two weeks, for every client — is where hours quietly disappear.
This template eliminates the formatting work. Download a pre-structured Excel or CSV file that maps directly to QuickBooks Online's journal entry import requirements. Fill in the figures, import, done.
---
## Download Your Free QuickBooks Payroll JE Template
Both formats below are structured to match QuickBooks Online's **Journal Entry import schema** exactly. The CSV is ready for direct import via the QuickBooks import tool. The Excel file includes column notes and a pre-built example entry you can overwrite.
| Format | Best For | Download |
|--------|----------|----------|
| `.CSV` | Direct QBO import, automation workflows | **[Download CSV Template](#)** |
| `.XLSX` | Manual editing, client-specific customization | **[Download Excel Template](#)** |
> **Compatibility note:** These templates are formatted for **QuickBooks Online**. If you're on QuickBooks Desktop, the column structure differs — the Class and Name columns behave differently across versions. [INTERNAL LINK: QuickBooks Desktop vs Online journal entry import differences]
No email required. No paywall.
---
## How to Use This Template
The template contains seven columns. Each maps to a specific field in QuickBooks Online's journal entry import. Here's what each column does and what belongs in it.
### Column Reference
| Column | QBO Field | What Goes Here |
|--------|-----------|----------------|
| `Date` | Journal Date | Payroll check date (not pay period end) |
| `Journal No.` | Journal Entry # | Optional — leave blank to auto-assign in QBO |
| `Account` | Account Name or Number | Exact name as it appears in your QBO Chart of Accounts |
| `Debit` | Debit Amount | Positive values only; leave blank if credit |
| `Credit` | Credit Amount | Positive values only; leave blank if debit |
| `Description` | Memo | Payroll period, employee name, or provider reference |
| `Name` | Customer/Vendor/Employee | Employee name for direct liability lines; leave blank for expense accounts |
| `Class` | Class | Only required if class tracking is enabled in QBO |
**Critical formatting rules:**
- The `Account` field must match your Chart of Accounts **character-for-character**, including capitalization and punctuation. A mismatch will cause an import error without a clear error message.
- `Debit` and `Credit` columns must never contain a value in the same row. One or the other — never both.
- Every journal entry must balance. Total debits must equal total credits before you attempt an import.
### Example: Recording a Standard Bi-Weekly Payroll
Here's a complete, balanced payroll journal entry for a hypothetical company with two employees on a bi-weekly pay cycle. This example covers gross wages, employer taxes, benefit deductions, and net pay — the accounts you'll see in nearly every payroll entry.
**Payroll scenario:**
- Pay period: June 16–June 30, 2025
- Check date: July 1, 2025
- Two employees, combined gross wages: $8,400.00
- Employee FICA (Social Security + Medicare): $642.60
- Federal income tax withheld: $924.00
- State income tax withheld: $310.00
- Employee health insurance deduction: $180.00
- Net pay (direct deposit): $6,343.40
- Employer FICA match: $642.60
- Federal unemployment (FUTA): $42.00
- State unemployment (SUTA): $126.00
#### The Journal Entry
```
Date | Journal No. | Account | Debit | Credit | Description | Name
-------------|-------------|----------------------------------|-----------|-----------|---------------------------------|-----
07/01/2025 | PR-2025-13 | Salaries and Wages Expense | 8,400.00 | | Payroll 6/16–6/30 |
07/01/2025 | PR-2025-13 | Payroll Tax Expense | 810.60 | | Employer FICA + FUTA + SUTA |
07/01/2025 | PR-2025-13 | Employee FICA Payable | | 642.60 | EE Social Security & Medicare |
07/01/2025 | PR-2025-13 | Federal Income Tax Payable | | 924.00 | Federal withholding |
07/01/2025 | PR-2025-13 | State Income Tax Payable | | 310.00 | State withholding |
07/01/2025 | PR-2025-13 | Health Insurance Payable | | 180.00 | EE benefit deduction |
07/01/2025 | PR-2025-13 | Net Payroll Payable | | 6,343.40 | Net direct deposit |
07/01/2025 | PR-2025-13 | Employer FICA Payable | | 642.60 | ER Social Security & Medicare |
07/01/2025 | PR-2025-13 | FUTA Payable | | 42.00 | Federal unemployment |
07/01/2025 | PR-2025-13 | SUTA Payable | | 126.00 | State unemployment |
```
**Totals: Debits $9,210.60 — Credits $9,210.60 ✓**
The entry is balanced. Gross wages plus employer-side payroll taxes equal the sum of all liability accounts.
#### A few things to pay attention to in this entry
**Why two expense accounts?** Gross wages (`Salaries and Wages Expense`) cover only what employees earned. Employer-side taxes — FICA match, FUTA, SUTA — are your client's additional cost and belong in a separate `Payroll Tax Expense` account. Lumping them together overstates labor costs in a single account and makes tax reconciliation harder. [INTERNAL LINK: employer vs employee payroll tax accounts in QuickBooks]
**The Net Payroll Payable account.** Rather than crediting the bank account directly, credit a clearing account (`Net Payroll Payable`). When the direct deposit batch actually clears the bank, you debit that liability and credit the bank. This keeps your payroll entry separate from the cash transaction and makes bank reconciliation far cleaner. [CITE: QuickBooks Online Help — record payroll transactions manually]
**Liability accounts must match your remittance schedule.** Federal and state tax payables should zero out when you remit. If you're recording payroll correctly but your 941 reconciliation is off, check whether you're splitting FICA correctly — employee FICA payable and employer FICA payable are two separate liabilities, both remitted together, but they originate from different sides of the entry.
---
## Tired of Manual Data Entry?
The template above works. The problem is the work that precedes filling it out: opening the payroll provider report, finding the right columns, mapping figures to accounts, and doing this without errors — every pay period, for every client on your roster.
That's the process **[Postbooks](https://postbooks.app)** automates.
Postbooks reads payroll summary reports directly from providers like Gusto, ADP, and Paychex, maps the figures to your client's Chart of Accounts, and generates a correctly structured, balanced journal entry — ready to review and post. No copy-paste. No manual account matching. No re-keying figures from a PDF.
For bookkeepers managing payroll entries across ten clients, that's the difference between an afternoon task and a fifteen-minute review queue.
[INTERNAL LINK: How Postbooks imports payroll reports from Gusto, ADP, and Paychex]
---
## Frequently Asked Questions
**Can I use this template with QuickBooks Desktop?**
Not directly. QuickBooks Desktop uses a different import format and doesn't support the same CSV schema as QBO. The account structure in this template will still serve as a reference, but you'll need to reformat the file for Desktop's import tool.
**What if my client uses a different payroll provider?**
The account structure and entry logic in this template apply regardless of provider. What changes is where you find the source figures — every payroll provider formats their summary reports differently. The template itself is provider-agnostic.
**Do I need to record a separate entry when taxes are remitted?**
Yes. This template records the payroll obligation — what is owed — not the cash payment. When you remit federal or state taxes, or when direct deposits clear, you'll post separate entries debiting the liability accounts and crediting the bank. [INTERNAL LINK: recording payroll tax remittances in QuickBooks]
**How do I handle mid-period corrections or voided checks?**
For a voided paycheck, reverse the original entry line-by-line using the same journal number with a "-R" suffix, then post a corrected entry. QuickBooks Online has a built-in reverse function on posted journal entries — use it rather than manually re-keying the reversal.
---
*Template last reviewed: July 2025. Tested against QuickBooks Online CSV import schema. Account names are examples — always match to your client's actual Chart of Accounts.*