Skip to main content
A
arkvalleyinfo
January 16, 2019
Question

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

  • January 16, 2019
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

A
Anonymous
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!  

C
carolannpea1
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?

 

C
CamelleT
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.

A
Anonymous
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. 

N
neversitsstill
October 31, 2019

I am having the same issue and I called Quick books and they couldn't even fix it. If they can't fix it I will cancel my subscription. I am simply inputting expenses for my business that have already been paid in full. Now and then Quickbooks decides to combine some of them. No rhyme or reason. Sometimes it's the same vendor. Sometimes they were paid on the same credit card, Sometimes they were paid on the same day. But in none of the examples above is it consistent. There are others paid t the same vendor, same day, same card etc and are not clumped together. 

This is very annoying. I simply want a running list of expenses, with as many details as possible listed individually. I can input 10 of them and suddenly I look up and is combined several and now says "split" and has added the totals of the items it's combined. 

So far I am no liking Quick books and hope they let me out of my subscription tomorrow if they can't fix it. After 30 plus minutes on the phone she offered to send me articles that might help. I said, not acceptable. I prefer she just explain it to me. She then admitted she had no idea what the issue was. The employee sais she would need to call me back tomorrow when someone was there who might know the answer. 

    M
    Mark_R
    October 31, 2019

    This isn't the kind of experience we want you to have, and I'm here to make it up with you, @neversitsstill.

     

    The reason why your expense entries are showing "split" on the report is that the transactions have multiple line items. Let me share a few information and help you from there.

     

    The Transactions List by Vendor or Transactions List by Date report will show you the word "split" if the transaction has multiple items. 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.

     

    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's why you're seeing the same vendor, credit card, and day. If you want to show each account or item used, you can customize the report. Here's how:

     

    1. Go to the Reports page.
    2. Search for Transactions Detail by Account.
    3. Select the date range from the Report period section.
    4. From the Group by drop-down, choose Vendor.
    5. Click Customize.
    6. In the Rows/Columns section, click the Show column link.
    7. Put a checkmark on Account.
    8. Click Run report.

    Here's an article to learn how to customize reports: Customize your Reports in QuickBooks Online.

     

    I've attached screenshots below to show the difference in the reports.

     

    In case you want to memorize reports, you can check out this article for your future reference: Memorize Reports.

     

    Please know that you can always get back to this post if you have further questions. I'll be more than happy to answer them for you.

    Terms & ConditionsAccessibility statement