Is there an option to exclude all zero balance accounts when printing off this report?

Hi Kitty:
Remove the check-marks from "Zero balance vendors" and "Fully paid transactions" on the report dialogue box. That should give you what you want.

All boxes are unchecked each time I print off this report but the report still prints off every single one that has zero balance.

Hi Kitty,

When a 'zero balance vendor' prints on the Open Payables report for you, are there any transactions listed for the vendor? If so, are the Current Balances 0.00 for all transactions, or are there sets of invoices and pre-payments that net to 0.00 but individually have non-zero current balances?

If there are non-zero transactions for a vendor, choosing to suppress zero balance vendors on this report will not hide these vendors, even if the total balance nets to zero. You need to match up the pre-payments to the invoices so that their respective current balances are zero. This can be done by creating a Manual check batch entry (non-printed) for 0.00 and apply to both the pre-payment and the invoice.

Support:
I think Kitty's expectation is reasonable (and literally accurate): "Exclude zero balance vendors" would indeed exclude any vendors where the net balance is zero. Could this be added as a feature request for the next version of Payables?

It will be great if the suggested feature can be added. Thanks Kitty

Suggestion has been added to suppress vendors with a net zero balance (as of the report date), even if there are offsetting and unmatched transactions.

We cannot suppress a vendor on the Open Payables report (that has the field Outstanding Balance = 0) if one of these offsetting transactions is dated after the report date (and thus is excluded from the report), because then the report totals will not match up to the GL. Only if the vendor balance is zero as of the 'calculated as of' report date.