We get a lot of questions on this topic. Users want to remove rows that in sum equal to zero, but find that they are unable to exclude them from the report. This is due to OneStop Reporting’s logic, which is based on transactions from the accounting system.

When OneStop Reporting retrieves data in reports, we query/retrieve at the transaction level. If two transactions sums to zero (credit/debit), the row will still be shown in the report. If you apply amounts different to zero as a filter, the report does not pick up transactions with amount = 0, but if the sum of multiple transactions becomes 0, this is not filtered out in the report. This is because we import data based on transactions in the database and not on sums.