Level 7

Question

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

Forum|Forum|7 years ago
January 16, 2019
2 replies
70 views

No text available

QuickBooks Online

A

Anonymous

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!

S

spirittlk

I have Quickbooks for Mac Desktop. I have several items that are income. They are single account items. They are used in my sales receipts. I enter the data manually in a new receipt when I receive the payment. I enter item, rate, quantity - in a single line, no splits that I enter, and yet every single transaction shows up in the register with -split- in the account field. I have double checked to make sure each item is associated with only one account. In the majority of the cases, they are non-taxable items so even though there is a tax category associated with them they are non-taxable. I do not know if htis is a quickbooks bug or not but I can find no earthly reason 🙂 I even went through a series of debugging steps with chatGPT who finally gave up on it :)Any help is appreciated

J

Jayson_E

QuickBooks Team

I appreciate the time you took to share details about your split sales receipt transactions in QuickBooks Desktop for Mac, spirittlk. Let me help clarify why they're showing as "-Split-" and how to handle this.

In QuickBooks, a transaction will show as "-Split-" in the bank register if it contains multiple line items, even if those line items use the same item and account. This occurs because QuickBooks treats each line item as a separate entry within the transaction, leading to the designation of "-Split-" in the accounting field.

If you don't want your expense entries to be a split transaction, ensure that each entry only contains one line item.

You can also visit this article for further guidance on managing sales receipts in QBDT for Mac: Create sales receipts in QuickBooks Desktop for Mac.

Additionally, you can refer to this article for a helpful guide in navigating your QBDT for Mac: QuickBooks Mac User’s Guide.

We're always ready to help you with questions about QBDT for Mac. Don't hesitate to come back here. Have a great week ahead and take care.

A

Anonymous

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

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

Moderator

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:

Go to the Reports page.
Search for Transactions Detail by Account.
Select the date range from the Report period section.
From the Group by drop-down, choose Vendor.
Click Customize.
In the Rows/Columns section, click the Show column link.
Put a checkmark on Account.
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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO