Question

Splitting a transaction to multiple suppliers

6 replies
21 views

Hi,

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?

Ex:

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.

Thanks

QuickBooks Online - International

M

MirriamM

QuickBooks Team

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:

In the left menu, click Banking/Transactions.
Go to the Banking tab.
Select the account from the list.
Locate the duplicate.
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!

H

hollie_corbiereAuthor

@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

H

hollie_corbiereAuthor

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

Sign up

Login with SSO

Let's get you signed in

Login with SSO