I have 1 custom report that has generated and entered double transactions, positive & negative. How do I correct this problem?

Hi there, Joseph.
 

Can you clarify what specific data you selected while customizing a report? Please know that the data that will show in your report will depend on the filters you applied and the columns you added during customization.

QuickBooks Online (QBO) is a double-entry system where every transaction (like an expense) hits at least two accounts (the Bank and the Expense category). If the report is not filtered correctly, it shows both sides (the positive and the negative) at once, which cancels out to zero.
 

This happens on specific report because of the Split View display. This is where the report is set to show "All" accounts. Example, for a $100 gas station trip, the report shows +$100 in the Fuel Expense account and -$100 in the Checking account.

To stop the double effect, you need to only show one side of the transaction (usually the "Distribution" or " Expense" side)

Here's how:

1. Open the custom report and click Customize.
2. Go to the Filter section.
3. Find the Distribution Account filter.
4. Instead of "All," select the specific account(s) you actually want to see (e.g., just your Expense accounts).
   
5. Click Run Report.
    

Let me know if you have any other concerns or if you're referring to something else. We're always right here to help. 

Hi @josephhiggins4,

I just wanted to follow up to check if the resolution we provided helped resolve your issue.

Please let us know if everything is now working as expected or if you're still experiencing any problems.

We'll be glad to assist further if needed.