Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Level 7
January 16, 2019
Question

Why did my expense entry get split ? How do I fix this?

  • January 16, 2019
  • 2 replies
  • 70 views
No text available

2 replies

January 16, 2019

Hello crittersitterpet,

 

I wanted to help, however, I'd need to get more information to assist you better.

 

Are you looking at a report that shows split columns? When you say the expense entry get split, are you referring to the transaction in your Banking page?

 

Thanks in advance!  

May 7, 2024

I want my charges from quickbooks to automatically split into different departments/classes. I keep setting up a rule when it comes in from the bank but the expense the QB automatically creates does not allow the rule to work.

It sends the expense to "bank charges" which it is not and has no class/dept. I want all the QB fees broke out to my classes/departments.

How do I fix this?

 

Moderator
May 7, 2024

Let's make sure your charges are accurately assigned to your chosen category and classes, carolann.


In QuickBooks Online (QBO), you can create a bank rule that automatically categorizes transactions for you. However, if you want to manually categorize your transactions, you can turn the suggestions off. Here's how:

 

  1. Go to Transactions and choose Bank transactions.
  2. Click the small Gear icon beside the Export to Excel button.
  3. Uncheck the Enable suggested categorization box.





Then, we can also review the mapping of your bank rules so that the QuickBooks fees are designated to the appropriate classes and categories. Please refer to the steps below:

 

  1. Click the Gear icon and choose Rules.
  2. Select the rule and tap the Edit button below the ACTIONS column.
  3. Review the setup of your rules. Check the Category account and Split details. Make sure the right Class is selected.





     

     


Additionally, I'd also appreciate it if you could provide us a screenshot of how your rules are set up so that we can further check.

 

If you have more questions about setting up bank rules, carolann. Just tap the reply button below, and I'll circle back to you.

February 13, 2019

Hello crittersitterpet,

 

I wanted to make sure that your question gets answered. So, I came back to add more information.

 

If you're referring to your bank transaction that splits to multiple categories, we currently don't have a way to add/match them to an expense record. You'll need to exclude them and manually place the letter "R" in the register. This way it'll show that this expense was already been reconciled from your bank. To exclude them, please go to the For Review page and select the transactions. Then, click on Batch actions and choose Exclude Selected

 

Otherwise, expense transaction that has multiple line items will show split entries in some reports like Transaction List with Splits report. 

 

Let us know if you have any questions. We'll be right here to help. 

January 9, 2021

I am using AutoEntry to upload my invoices (purchases) in to QBO. And it is coming up split when each line is a purchase they do lot have freight or shipping.  Can you help me

QuickBooks Team
January 9, 2021

Let me share some information about splitting entries in QuickBooks Online (QBO), Mattsdugout.

 

If you are referring to splitting of your purchases is showing "split" on the report, this happens when the transactions have multiple line items. This is the reason why the freight or shipping items are showing as split when running the Transactions List by Vendor or Transactions List by Date report. This report will combine the total amount of your expense transaction. You can consider running these reports to show the list of your expense transactions.

 

You can also run the Transaction List with Splits report that'll show split transactions. Here's how to pull up this report:

  1. Go to Reports on the left side menu. 
  2. Type Transaction List with Splits in the search bar.
  3. Change the Report period.
  4. Click on Run report.

However, if you're running the Transaction Detail by Account report, it'll show you each amount of the accounts or items used to the transaction. That the reason you'll not see the split transactions. Feel free to visit our Expenses and vendors page for more insights about managing your expenses in QBO.

 

I'm just one click away if you need a hand with customizing your reports or any QBO related. I'll be here to ensure your success. You have a good one.