# Import Payroll Transactions into QuickBooks Online

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: QuickBooks Online imports
- Canonical: https://simplebankconvert.com/blog/import-payroll-transactions-into-quickbooks-online

> How to import payroll transactions into QuickBooks Online from bank statement lines when an outside provider runs payroll, and record wages and taxes clearly.
When an outside provider runs payroll, import payroll transactions into QuickBooks Online in two parts. Record each pay run with a journal entry built from the provider's payroll report, showing gross wages, employer taxes and net pay. Then upload the bank statement as usual and match each payroll debit to that entry instead of adding it again.

## What outside payroll looks like on a bank statement

Outside payroll shows up on a bank statement as a few debits per pay run, not one line per employee's full wage. A provider such as a payroll service usually pulls the net pay it sends to employees, then pulls the payroll taxes it will pay on your behalf, and sometimes charges a separate service fee.

The exact pattern depends on the provider and on how employees are paid. Look at one month of statements and find the lines that carry the provider's name. A common shape is:

- **Net pay**, either one lump sum for everyone or one line per direct deposit.
- **Tax impound**, one debit covering the income tax withheld from employees plus the employer's share of payroll taxes.
- **Service fee**, a smaller debit for the provider's own charge, sometimes monthly rather than per run.
- **Paper checks**, if some employees are paid by check, which clear on different days as each person cashes them.

Write the pattern down once. Every later month will follow it, and knowing which line is which makes the review screen quick.

## Why can't the payroll bank lines alone record wages and taxes?

Payroll bank lines can't record wages and taxes on their own because the bank only sees the money that left the account, not what it was made of. A net pay debit of 4,100 hides the 5,000 of gross wages and the 900 withheld from employees. Categorizing that debit as "wages" understates wage expense.

The gap matters in several places. Your profit and loss report would show wages at the net figure, which is lower than what you actually paid in compensation. The tax impound debit would look like an expense, when much of it is money withheld from employees that you were holding for the tax authorities. And nothing in the books would show what you owe in payroll taxes between payday and the day the provider pays them.

A bank upload cannot fix this, because the upload only takes a date, a description and one amount per line. The detail has to come from somewhere else, and that somewhere is the provider's payroll report.

## Recording a payroll run with a journal entry from the provider's report

A journal entry is the standard way to record a pay run that happened outside QuickBooks. [Intuit's article on manually entering payroll paychecks](https://quickbooks.intuit.com/learn-support/en-us/help-article/write-checks/manually-enter-payroll-paychecks-quickbooks-online/L8Ibk0vix_US_en_US) says to create one after you pay employees outside QuickBooks, using the paycheck date as the journal date and the figures from your pay stubs or payroll report.

### Accounts to create first

The same article lists the accounts to set up before the first entry. It names two expense accounts, Payroll Expenses: Wages and Payroll Expenses: Taxes. It also names liability accounts for federal taxes (941/944), federal unemployment (940) and state taxes. Your state's names may differ. Create these once in the chart of accounts, and every later pay run uses them.

### A worked example

Here is one pay run for two employees. Every figure is made up for illustration, and the tax figures are simplified into one liability line to keep the example readable.

| Line | Account | Debit | Credit |
| --- | --- | --- | --- |
| 1 | Payroll Expenses: Wages (gross pay, both employees) | 5,000.00 | |
| 2 | Payroll Expenses: Taxes (employer share) | 400.00 | |
| 3 | Payroll Liabilities: Federal Taxes (941/944) | | 1,300.00 |
| 4 | Checking: net pay, employee A | | 2,450.00 |
| 5 | Checking: net pay, employee B | | 1,650.00 |
| | Totals | 5,400.00 | 5,400.00 |

Debits equal credits, which every journal entry needs. Line 3 is the 900 withheld from employees plus the 400 employer share. It sits in a liability account because the business owes it to the tax authorities until the provider pays it.

Intuit's article says you can combine several employees' totals into one entry. It makes one exception: net pay. Enter each paycheck on its own line rather than combining them, as lines 4 and 5 do. That way each line can meet its own bank debit or cleared check later.

### Getting the figures out of the report

Payroll providers usually let you export the pay run summary as a spreadsheet. If yours does, the guide to [importing Excel into QuickBooks](/blog/import-excel-into-quickbooks) shows how to tidy an exported sheet. That guide is about bank lines, so here you only need the totals from the sheet for the journal entry. Mac users who keep the report in Numbers can follow the steps for [importing a Numbers spreadsheet into QuickBooks Online](/blog/import-a-numbers-spreadsheet-into-quickbooks-online) to get a clean CSV out of it.

## Matching uploaded payroll debits so they aren't counted twice

Once the journal entry exists, the payroll money is already in the books, so the matching bank lines must not be added again. When you upload the statement, treat each payroll debit on the review screen as a match to the entry, or exclude it, rather than adding it as a new expense.

Using the worked example, the statement shows three lines from the provider for that run. Here is how each one is handled:

1. **Net pay 2,450.00 and 1,650.00.** These line up with lines 4 and 5 of the entry. On the review screen, look for QuickBooks suggesting a match to the journal entry and accept it. If it offers no match, exclude the bank line, because the entry already reduced the checking balance.
2. **Tax impound 1,300.00.** This is not part of the payday entry. It pays off the liability from line 3. The next section covers it.
3. **Service fee.** This is an ordinary expense with no journal entry behind it. Add it as an expense to an account such as payroll service fees.

If the bank shows net pay as one lump of 4,100 rather than two deposits, the two separate lines in the entry will not match it one to one. In that case, exclude the lump on review and rely on the entry. Check afterwards that the checking balance in QuickBooks agrees with the statement balance on that date.

The bank upload itself works the same as for any other month, and the guide to [importing bank transactions into QuickBooks Online](/blog/how-to-import-bank-transactions-into-quickbooks-online) walks through the screens.

## Payroll tax withdrawals that land days after payday

Payroll tax withdrawals often land a day or more after payday, because the provider collects the tax separately before paying it over. That debit is a payment of the liability you recorded in the journal entry, not a new expense. Record it against the payroll liability account so the balance owed drops back to zero.

On the review screen, add the 1,300.00 impound line with the category set to Payroll Liabilities: Federal Taxes (941/944), or whichever liability accounts your entry used. If the provider's report splits the impound between federal and state, split the bank line the same way. After the impound is recorded, the liability account for that pay run should show nothing left owing.

That zero is a useful check. Run a balance sheet at month end. If the payroll liability accounts carry a balance that doesn't match a pay run waiting to be paid, something was recorded as an expense when it should have cleared the liability, or a pay run is missing its entry.

### Cash paid to casual workers

Some small businesses pay an occasional helper in cash from a cash box rather than through the provider. That payment never touches the payroll report. The guide to [importing petty cash transactions into QuickBooks Online](/blog/import-petty-cash-transactions-into-quickbooks-online) covers recording cash spending, and your accountant can tell you whether the person should be on payroll at all.

## Does recording payroll in QuickBooks produce W-2 data?

No. Journal entries and bank lines record what payroll cost, but they do not produce the data for employees' W-2 forms. Intuit's manual payroll article says this directly: entering paychecks this way does not create the information you'll need for W-2s. Year-end forms come from your payroll provider.

That shapes what the entries are for. They keep your profit and loss right, show what you owe between payday and the tax payment, and let the bank account reconcile. They are not a payroll system. Keep the provider's reports for each run alongside the entries, because those reports are the record of each employee's pay and withholding.

### Older payroll years

If you are catching up on past years, the same entries work for each pay run, dated on each payday. For history that lived in QuickBooks Desktop before a move, the guide to [importing old bank statements into QuickBooks Desktop](/blog/import-old-bank-statements-into-quickbooks-desktop) covers bringing in earlier statements there.

Many statements are PDFs, and the bank upload needs a file. SimpleBankConvert is being built to turn a PDF statement into a CSV or QBO file, so the payroll debits arrive ready to match. Conversions haven't started yet, and [the get started page](/get-started) puts you on the list for when they do.