Share your ideas for improving MYOB Business. Vote on ideas and discuss them with the MYOB product development team.

Product Ideas

Report: Sales reconciliation - Hide zero balance customers

Cover User




6 Posts
Cover User
New Zealand


The Sales and Bills Reconciliation Reports both show customers with Nil balances or if an invoice dated in a previous month has been paid this month, then it shows as two transactions, one debit, one credit in seperate months.


Coulld we please have Reconciliton Reports that don't have Nil balances or at least an option to take off those with a Nil Balance. 


I have been told to use the Unpaid Bills report, but that lists every single transaction for each customer, which is not what I need.




"Reports - Bills Reconciliation And Sales REconciliation Report"

7 Posts
Cover User

It would be great to have this function, so that only current balances show.  Otherwise this report can become pages and pages long filled with irrelevant information.

MYOB Staff
24 Posts
MYOB Staff

I agree - In Essentials, currently ALL customers with a previous sales history show on the report and there's no way to filter by amount either, which means that the report is becoming too lengthy to read.
Would be a great enhancement please!!

2 Posts
Cover User

It is very hard to manage out standing debtors when list is so long.  Being able to export to Excel would able follow up comments to be added/reviewed on overdue accounts.

8 Posts
Cover User

I am having the same problem as MandyHamilton.  Sales Reconciliation Reports showing customers with nil balance and hence report is 13 pages long. Is there a way to take the option NOT to show customers with nil balances?  


5 Posts



All reports should have a "Hide Zero" balances option


It takes more time and cost for the customer to waste time explaining why some items are zero, and then export to Excel and delete zero lines.


We should only be talking about real business activity, not a reporting "feature"


Thank You