Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 9, 2025
Question

Can I match a bank transaction that is split between payroll and dividends to the corresponding payroll entry (the amounts will not be the same)?

  • October 9, 2025
  • 1 reply
  • 7 views

I don't seem to be able to match these as the amounts are not the same. I keep getting duplicate entries- 1 for the full payment made and another for the paye amount that has been processed through payroll. Is there any way around this as or do the bank transactions for PAYE and dividends need to be made seperately? Some have already been processed so I am trying to go back and reconcile them and the current account balance is out.

1 reply

Bryan_M
QuickBooks Team
October 9, 2025

I appreciate you for explaining the detailed scenario in your bank transactions, @cooganjill. Specifically, your payroll entries that keeps on getting duplicates, and you want to match them since it creates discrepancies in your records. I am here to help you clear things up.

 

To answer your question, you cannot match bank transactions that have different amounts. Since you already have an entry for this undertaking, you do not need to go and separate the bank transactions for PAYE and dividends. 

 

You can keep the balance of your book by excluding the duplicate entries. This option will clear up the excess amount that creates the imbalance in your account. 

 

Additionally, QuickBooks will avoid redownloading them since they are in the Exclude section, and they will see it as existing in the system, but it will not affect your book.

 

Here's how:

 

  1. In your Bank Transactions, go to the Posted section.
  2. Put a check mark next to those duplicate payroll entries.
  3. Once done, click the Undo button below.
  4. Go back to the Pending section.
  5. Place a check mark beside those transactions and choose the Exclude tab underneath.

 

I also recommend reaching out to your accountant on or before doing this to make sure your book will not be damaged and avoid excluding correct entries.

 

Having a balanced account will make sure the accuracy of your financial flow and generate correct data. Leave a comment below if you need additional assistance. Have a good one.

October 9, 2025

Thanks for the info Bryan. It is the PAYE entry in the books that I need to delete/exclude. The bank transaction is the total amount for PAYE and dividends and that shows in the books which is fine. Then there is a 2nd entry in the books from QB payroll for the PAYE amount. I thought by not reconciling these PAYE entries they would not be deducted from the balance but they are still being deducted. Can I do a journal entry to reverse them maybe? I've tried clicking on them to edit but it doesn't allow me. 

 

All advice very much appreciated!

 

Jill

QuickBooks Team
October 9, 2025

Yes, Jill. You can consider creating a journal entry to reverse the duplicate transaction.
 

However, please note that making adjustments to payroll-related transactions requires careful attention to avoid errors and to ensure they do not affect your year-end reports.
 

For this reason, we recommend collaborating with your accountant or bookkeeper before proceeding. They will ensure that the adjustments made are accurate, verify that your PAYE balance and payroll calculations are correct, and assist in properly reconciling your accounts.
 
If you have any questions or require additional assistance, please don't hesitate to leave a comment below.