Showing results for 
Search instead for 
Did you mean: 
Created with Sketch. If you are prompted to "Enter Payroll service key" when running payroll, please update your product to 2023. You can download, install and activate 2023 here: Install QuickBooks Desktop
Level 1

Splitting a transaction to multiple suppliers


I am new to using Quickbooks Online so I hope that this is not a silly question. I have a bank transaction (EFT) that is a lump sum for paying all of our subcontractors. I would like to split this transaction and apply it to each of the appropriate amounts to the subcontractors such that at year end we will be able to create the correct T4A's for each. Ideally I would like to upload a journal entry from Excel into Quickbooks for this. Is this something that is possible to do?



Currently recorded as:

Bank -$10,000

Payroll Expense $10,000


Would like to record as:

Bank -$10,000

Person A - Payroll expense $2,000

Person B - Payroll expense $5,000

Person C - Payroll expense $3,000


I hope this makes sense.




6 Comments 6

Splitting a transaction to multiple suppliers

Thanks for reaching out to us, @hollie_corbiere. I'm here to help you in recording your transactions.


Right now, the option to import a Journal entry and split your transactions from bank feeds to multiple suppliers is unavailable in QuickBooks Online (QBO). In the meantime, you can manually enter a Journal entry to record the payroll expense for each supplier, then exclude the bank transaction showing on your bank feeds to keep your records in order.


To exclude your bank transaction, here's how:


  1. In the left menu, click Banking/Transactions.
  2. Go to the Banking tab.
  3. Select the account from the list.
  4. Locate the duplicate.
  5. Tick the box for the transactions you wish to remove and press the Exclude menu. 


Once done, the transaction will move to the Excluded section.


To know more about removing duplicate entries, I recommend visiting this article:  Exclude a bank transaction you downloaded into QuickBooks Online.


We recognize that each company has unique needs, and I can see how the feature you're looking for would benefit and empower your business. Thus, I encourage you to submit feedback to our Product Development Team. 


For future reference, here's an article that you can check for the best practices when reconciling your account: Reconcile an account in QuickBooks Online. It also provides information on what to do when encountering challenges during the reconciliation process.


If there's anything else you need help with, let me know by adding a comment. I'm more than happy to assist you. Have a great day!

Level 1

Splitting a transaction to multiple suppliers

@MirriamM , thank you for your response. I have tried to use a manual journal entry to apply the payroll expenses to each of the individuals but even when I put their names in it does not then apply the amounts to their T4A amounts? Is there something I am doing incorrectly?


My journal entry looks like this:

Account - Amount - Description - Name

Payroll expense  - (-$10,000)

Payroll expense - $2,000 - October 15th Payroll - Person A

Payroll expense - $3,000 - October 15th Payroll - Person B

Payroll expense - $5,000 - October 15th Payroll - Person C


Is there another way that I could break out the payroll expenses to the individuals so as to correct the amounts to be recorded on their T4A's?


Thank you

Level 1

Splitting a transaction to multiple suppliers

@MirriamM to have the amounts be applied to the specific suppliers, will I have to create bills for each of the amounts for each of the pay periods and then split the payroll amounts? I am looking for a solution for the entries that have already been made and not applied to the specific suppliers as well as a solution going forward to make sure that the T4A's can automatically be generated correctly at eh end of each year.


I hope this makes sense,



Alex M
QuickBooks Team

Splitting a transaction to multiple suppliers

Hi there hollie_corbiere,


Entering it as a bill and payment or an expense should have it applied to the correct supplier n order for it to be included on the T4A form, so I recommend trying to change one of the prior entries to either an expense or a bill and payment as a test. Then if it has the desired effect, you can then change the other entries to that process, and use it for upcoming entries moving forward.


If you have any other questions, feel free to reach out here.

Level 1

Splitting a transaction to multiple suppliers

Hi Alex,

Thanks for your insights. Can I create one bill per supplier to correct all the historical splits?


Person A

Oct 15 payroll - $2000

Oct 31 payroll - $1000

Sept 15 payroll - $1000


Or will I need to create separate bills for each pay period. 


And if I create these bills how then do I match them to the transactions that have already been booked, which are currently booked as total amounts (hitting the cash account and the payroll expense accounts for each pay period for all the suppliers?)





Alex M
QuickBooks Team

Splitting a transaction to multiple suppliers

Hi there hollie-corbiere,


In order to know if you should be entering this as a one-time adjustment or once per pay, as well as which accounts you need to affect to make the adjustment correctly, you'd need to reach out to your accountant. Their accounting knowledge will be able to guide you in making sure your books can be balanced while making the adjustments. You can invite your accountant to your books in the My accountant tab. There's also a Find a pro to help button in this section that can help you find a local accountant that has experience with QuickBooks Online.


If you have any other questions, feel free to reach out here.

Need to get in touch?

Contact us