Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Splitting Expenses and Bills

Hi,

 

I've single transaction appearing into quickbooks for which I need to split them for various expenses, bills and payroll. I've tried it with split option but it doesn't work. 

 

Please guide me with regards to splitting a single amount into multiple transactions.

6 Comments
Moderator

Splitting Expenses and Bills

Welcome to the Community, @Kridhar.

 

Splitting bank transactions in QuickBooks Online (QBO) is pretty easy. This can be done by going to the Banking page. Please refer to these steps:

 

  1. In QBO, go to the Banking menu at the left pane to get to the Banking page.
  2. From the For Review tab, select the transaction, then click the Split button.
  3. Choose the Categories (accounts) you want to split the transaction into.
  4. Enter the necessary information and hit Save and Add.

 

To learn more about the process, consider checking out this article: Assign, categorize, edit, and add your downloaded banking transactions.

 

Please leave a comment below if you have any other concerns or questions. I'll be here to help. Have a good one!

Level 1

Splitting Expenses and Bills

Hi @FritzF ,

 

I do agree and know that transaction can be splitted going into banking tab and split transaction. But what if they're of different nature as said in my last conversation. For example, out of $30,000 appearing in spent side of bank, $15K is for salary, $10K is for payment of bill and $5K is for advance to supplier. So, I can make the payment of salary but I'm unable to locate it to the outstanding bills(by name of supplier).

 

Can you guide me in this regard?

QuickBooks Team

Splitting Expenses and Bills

I appreciate the details that you gave, @Kridhar.

 

Allow me to provide additional insights about splitting expense transactions in QuickBooks Online.

 

When splitting expense entries in QuickBooks Online, the system only allows you to select one payee. Being able to choose multiple names are only available for income transactions.

 

To get your work done, you can exclude the downloaded bank transactions, then add and clear them manually. This way, you'll be able to split and reconcile the said entries.

 

Here's how you can exclude them:

  1. On the left panel, click on Banking.
  2. Refer to the Banking tab.
  3. Choose the account.
  4. Go to the For Review tab.
  5. Put a check mark on the expense transactions that needs to be excluded.
  6. Press on the drop-down arrow next to Batch actions.
  7. Click Exclude Selected.

I've got some links that can guide you in reconciling your accounts and fix reconciliation issues. Feel free to check them out:

You've got me here to help if you have any other questions or concerns. Have a nice day!

Level 1

Splitting Expenses and Bills

Thanks alot @BettyJaneB for getting into this.

 

Yes, you got the situation and exactly caught where I was facing issue.

 

However, I don't want to exclude the transaction and delete it and manually enter them as desired. As these will certainly won't be matching with my banking transaction. Can you help/guide other way?

Level 1

Splitting Expenses and Bills

?

Moderator

Splitting Expenses and Bills

Hello there, @Kridhar

 

I've read your conversations above, and you've mentioned that the expenses, bills, and payroll are of different nature. With this, splitting a single bank transaction for them is currently unavailable. It's because we're able to select only one payee when splitting them in the For Review tab.

 

As a workaround, I'd still suggest excluding the downloaded bank transaction. Then, manually enter those entries in your register and clear them. Doing so will help you reconcile your bank account properly. Just perform the steps provided by BettyJaneB above. 

 

In the meantime, I recommend visiting this website: QuickBooks Online Blog. This is the place where we share our new features and product innovations. 

 

Once reconciled, you can run the Reconciliation Report. It lets you view the beginning, ending balances, cleared, and uncleared transactions within a reconciliation period. You can also print and export it. For more details, visit this article: Generate Reconciliation Report

 

You can count on me if there's anything else you need. Take care always, @Kridhar

Need to get in touch?

Contact us