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!

@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

@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,

Hollie

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.

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?)

Thanks,

Hollie

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.