QuickBooks not handling split category expenditures correctly

MLC8 · ‎December 04, 2022

I am trying to analyze my expenditures; however, when I run the program it is treating split items as the total rather than showing the expense of the categorized line item.

for example: a -split- item where $130 was spent in category A and $20 in category B is showing up on my expenditure tab as $150 spent in each category. In other words if I run a report looking to see what was spent on category A It would erroneously report that I spent $150... even worse if I ask how much was spent in category A and B combined it would report I spent $300 ( $150 in category A and again $150 in category B)... how do I fix this going forward? do I have to manually account for all split charges? Why would it not simply report out the line item(s) within that "-split-" expenditure that are pertinent to the filter.

BigRedConsulting · ‎December 04, 2022

What report are you looking at where you see this happening?

Also, perhaps a screenshot or two will help get you a specific answer...

Carneil_C · ‎December 04, 2022

Welcome to the Community, @MLC8.

We'd love to help you achieve your goal, but I need more information to help me get on the same page. Could you tell me more about it? What specific report are you trying to run in QuickBooks Online? This way, I can provide you with an accurate resolution.

I appreciate any details you can provide. I'm looking forward to your reply. Have a great rest of the day!

MLC8 · ‎December 04, 2022

Hello, Thank you for the replies.

I am using the expenditures tab in Quickbooks Online and exporting filtered results to excel.

I have included screenshots to better describe the issue I am running in to. Picture 1 shows the filters I am running on the expenditures tab. Picture2 shows an example of a split expenditure showing up twice on the report. Picture 3 shows an expanded view of one of these items. As we can see both charges are under category A, each for a portion of the total 143.44; when exporting to excel these show up as shown in picture 2 indicating that I have 2 expenses for category A each for 143.44 ( which we know isn't the case). Now, this is an easy manual fix: just delete any identical rows in excel... but still cumbersome when analyzing year-to-date. However the problem compounds when I have a split charge of which only one line item is in the desired (filtered-for) category as shown in picture 4. Rather than show $20 for category A spent.... it shows the total $133.53. this is much more difficult to disentangle, requiring manual adjustment by opening each split charge and in QB seeing how much of the exported total is marked for category A and then writing that into excel. If there are any settings that can force only sums of the filtered-for category to display/export, or if there is a better tool on QB that I should be using that would be great! ( note, I need the line items within Category A not just the total spent over X time) thank you!

Topics

Training

Community

Resources

QuickBooks not handling split category expenditures correctly