Reports: Inclusion of Payables with tax and Receivables with Tax

At the end of the reporting period, we need to be able to find out the GST in the unpaid invoices and unpaid bills.

In AccountRight, this is the Receivables with Tax and Supplier with Tax reports.

The only way I can get this in Essentials for debtors (Where I only have 1 account that has no tax) is to run the GL for that sales account as accrual and then as cash, the difference is the amount that is in the debtors total.  Because we have started using Essentials this year, this is currently working although time consuming.

With the creditors this is a nightmare.  I have to print a list of the unpaid bills, then look at every bill ( i have four pages this month) and work out which have tax and which have no tax to work out my adjustment.

I have to do this at the end of every month for our reconciliations.  Surely you can add this report to Essentials.  I can see that this has been raised before, but the MYOB person who has responded by suggesting running the GST report as accrual and then cash obviously does not understand the problem.

Any essentials client who has an accountant trying to reconcile between accrual for their financial statements and cash BAS lodgements  will require this report at year end at a minumum. 

Can we please have an Unpaid invoices with Tax and Unpaid bills with Tax report in essentials.

'need a report to show the tax amount in the unpaid invoices and unpaid bills"