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
78 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

S

spirittlk

It sounds like you’re encountering a peculiar issue within QuickBooks for Mac Desktop where single-account items in your sales receipts are being marked as ‘-Splits-’ in the account field in the register. Let's perform some troubleshooting steps to get this resolved, spirittlk.

We can double-check the setup of the item by going to the List menu and choose Items. From there, ensure that each item is linked to the correct account and there are no sub-items or additional settings that might be causing this. Once done, check the sales receipt templates and verify the items are associated with the correct account. Let me guide you on how:

Go to Lists and select Templates.
Review the template you are using for the sales receipts.
If everything is correct, press OK.

If you need to customize the form template, you can check out this article: Customize form templates in QuickBooks Desktop for MAC.

Once done, manually enter a sales receipt with a forced split to verify if QuickBooks is handling them correctly. Then revert to the original method to see if the ‘-Split-’ label still appears. This could sometimes reset or correct internal settings.

If the same thing happens, make sure that you are running the latest version of QuickBooks for Mac Desktop to fix bugs and improve functionality. To learn more about this one, check out this article: Update QuickBooks Desktop to the latest release.

If the problem persists, it could be there's damaged data in the company file you're working with. We can use the QuickBooks verify and rebuild tools to find the most common data issues in a company file and fix them. To troubleshoot the issue, follow the steps and details in this article: Verify and rebuild data in QuickBooks Desktop for Mac.

To learn more about managing items in QuickBooks Desktop for Mac, refer to this article: Add, edit, and delete items in QuickBooks Desktop.

Moreover, you can visit this article about managing sales receipts in QuickBooks Desktop for Mac: Create sales receipts in QuickBooks Desktop for Mac.

If you have any further questions about managing your sales receipts or any QuickBooks-related concerns, just add them to the thread. The Community always has your back to help you with your concerns, spirittlk.

Thank you for trying. I'm going to give up as there is a lot on my plate. There is no "Template" option under the lists menu in Mac 2024 for desktop 🙂 I truly appreciate your help but while it is an inconvenience it isn't worth taking up more of our time since there's not a quick answer 🙂

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