QuickBooks HelpQuickBooksHelpIntuit

Matching payroll payments in QuickBooks Online

SOLVEDby QuickBooksQuickBooks Online Payroll73Updated June 15, 2022

Payroll Journals Setup Overview

The setup of your payroll accounts determines the journal entries that you use to record payroll expenses. Learn how you can easily add and match journal entries to transactions from your online bank account.

Default Settings

Payroll journals are assigned by the default accounts selected within the Employees tab.

  1. Go to Payroll and select Payroll Settings.
  2. Select Chart of Accounts from Business Settings.
  3. Select Default accounts to reveal the assigned accounts.

The accounts selected correspond directly with the payroll journals that are created when the pay run is finalised and submitted to QuickBooks Online.

These accounts are important when making sure the transactions from the bank are reflected properly in QuickBooks Online to credit the liability accounts.

Payroll Clearing Account - Adding Expense Transaction in Online Banking

To match the payments made for Payroll

  1. Go to Bookkeeping, select Transactions, then select Bank transactions (Take me there).
  2. Select the bank account you use for paying employees, then find and select the transaction.
  3. From the Transaction type dropdown, select Expense.
  4. From the Category dropdown, select the payroll account, for example, Payroll Clearing.
  5. From the GST dropdown, select an appropriate tax code, For example, Out of Scope.
  6. Select Confirm.

This will create a transaction to debit the bank account and credit the Payroll Clearing account. This process needs to be repeated if there are multiple line items from the bank comprising the original pay run amount for amounts paid.

To review your payments

After adding the payment(s), the Payroll Clearing account should have a balance of zero. To verify this,

  1. Go to Settings ⚙ and select Chart of accounts (Take me there).
  2. Find the account name and select Account history.

Super payments can also be added as an Expense, but the account selected is Superannuation Payables.
After adding the payment(s), the Superannuation Payables account should also have a balance of zero. To verify this,

  1. Go to Settings ⚙ and select Chart of accounts (Take me there).
  2. Find the account name and select Account history.

To add bank rules

Bank rules can be used to make the adding process easier. To add a bank rule:

  1. Go to Bookkeeping and select Rules (Take me there).
  2. Select New rule.

You can speed up the review process and categorise transactions automatically by setting up bank rules.

Bank Account as Payment Account – Matching Transaction in Online Banking

If you are using ABA files (bulk payment files) to pay your employees, you can change the default bank payment account to the bank account instead of the payroll clearing account.

This can make it a little easier because it allows you to match the payment from your bank account as opposed to having to add expenses to clear the payroll clearing account (the default setting).

  1. Go to Payroll and select Payroll Settings.
  2. Go to Chart of Accounts under Business Settings and select Default Accounts.
  3. Run the regular payroll.
  4. On the Transactions screen, you'll be able to match the journal entry to the payment made.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online EssentialsQuickBooks Online Payroll AdvancedQuickBooks Online Payroll StandardQuickBooks Online PlusQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this