Skip to main content
February 25, 2021
Question

Hello, How do I match a bank feed payments to historical payroll data payments? Thanks, Hilary Burley

  • February 25, 2021
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

Rebecca R
February 25, 2021

Hey Hilary,

 

Thanks for being part of the QuickBooks family. Using QuickBooks Onine payroll to pay your employees and keep track of your payroll taxes is a fantastic choice and hope you're loving all the features at your disposal. Let me give you a hand with entering Historical Payroll Tax Payments and matching them to the bank feeds.

 

Historical Payroll Tax Payments help you to record tax payments for periods before you started using QBO Payroll. When you enter these payments through the Taxes menu, then Payroll Tax, you're not actually posting any debits or credits to the Chart of Accounts. If you want or need to do this you can create a Cheque or Expense by selecting the + New button in the upper left corner. You'll want to be sure that you're choosing the correct dates and bank account so that the transaction will appear as a match in the bank feed.

 

It's also important that the correct Category is chosen for the Expense line item. You'll want to choose from your tax liability/expense accounts. If you need a hand with choosing an account, your accountant or bookkeeper can help you out. Navigate to the My Accountant tab to send them an invitation to QuickBooks. You'll also see the Find a pro to help button, which you can use to navigate the database of QuickBooks-certified accountants that you can choose to work with. 

 

Once you've entered the Cheque or Expense you should have no problem finding it as a match when you navigate to the banking tab. You can check out our article on how to Categorize and match online bank transactions in QuickBooks Online if you need a refresher on this. If for some reason you're still unable to find a match, you can simply select the transaction in the bank feed and hit Exclude. This sends the transaction to the Excluded tab. Using the bank feeds is a great way to speed up the process of entering your transactions, but it's not necessary. The only difference you'll notice is that during reconciliation for this account, you'll have to manually check off the Expense or Cheque that you entered into QBO. 

 

I'm confident you'll have this figured out in no time, but don't hesitate to reach out with other questions that you come up with. Have a great day!