Partner Zone
Partner Zone

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

MYOB Essentials

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

Joanne_Groves

4Posts

27Kudos

0Solutions

4 Posts
Partner
Australia

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.

Current Status: Open
Last Changed: April 2015

Hi @Joanne_Groves

Thank you for your idea in relation to Essentials and an Unpaid invoice and bills report with tax.

I would encourage other users that would like to see an unpaid invoice and bills report that will show the tax amount to vote and comment if required for this idea.

6 Comments
MYOB Moderator Steven_M
31,099 Posts
MYOB Moderator

Hi @Joanne_Groves

Thank you for your idea in relation to Essentials and an Unpaid invoice and bills report with tax.

I would encourage other users that would like to see an unpaid invoice and bills report that will show the tax amount to vote and comment if required for this idea.

Experienced Partner MMacc
13 Posts
Experienced Partner

I completely agree with Joanne.  I use those reports every quarter and at the end of every year to ensure the GST accounts are reconciled.  Essentials is so efficient but this is going to be a real pain if you can't produce a report that shows how much GST is in debtors & creditors.

Ashleys
7 Posts
Cover User

 

We badly need this report. Most small business clients using MYOB would have financials prepared on an accruals basis and GST prepared on a cash basis. For those clients this report is essential (isn't the name of this product MYOB ESSENTIALS?) to be able to properly reconcile GST accounts in the financials and pick up if there is any unclaimed GST from previous quarters.

 

I note that a 'with tax report' is available for the Sales Reconciliation and Bills Reconciliation reports in MYOB Account Right and Xero. Come on MYOB, surely this report would be easy to create for MYOB Essentials!!!

Em21213
1 Post
Cover User

Hi there, this would be very useful for our Practice as well.

Jemma1234
5 Posts
Cover User

I also think this would be great. It is painful going through every single transaction. 

Jemma1234
5 Posts
Cover User

Has there been any further progress with this. This is something that essentials is really lacking compared to MYOB AccountRight.