Reports: Inclusion of Payables with tax and Receivables with Tax

26 Comments

Joanne_Groves
Partner
10 years ago
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"
- Steven_M
  Former Staff
  10 years ago
  Status changed:
  New
  to
  Open
  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.
- MMacc
  Experienced Partner
  8 years ago
  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
  Cover User
  7 years ago
  
  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!!!
Sachin
Experienced Cover User
6 years ago
We need the GST reconciliation reports to better the essentials reporting. for eg there is no debtors or creditors GST reports
- Pete747
  Contributing Partner
  6 years ago
  As with the GST in Accounts Receivable and Accounts Payable in Account Right, this type of report is needed. This is because where a business does not charge GST for all sales, and has Non GST Purchases, it is difficult if not impossible to calculate the amount of GST which should remain on the Balance Sheet at any time.
  These reports show a total of GST Included in each Invoice Outstanding at a partivcular date selected, which enables a proper reconciliation of GST to BAS.
  Can MYOB Please make this report a PRIORITY . it is needed MORE than some of the frills i see being applied to the software now. Please get serious,
  Thanks
  Peter.
SharonLawrence
Cover User
10 years ago
In MYOB Account Right you can do a report for payables or receivables "with tax". This is useful when the financials statements are prepared on an accruals basis, but GST is on a cash basis. In these situations, in order to reconcile your GST to your BAS you need to remove the GST on debtors and creditors, and in Account Right the payables/receivables "with tax" report gives you the GST to remove. In Essentials, you have to check every invoice on the list to see the GST as no such report exists.

Therefore my request to MYOB if for Essentials to have the "with tax" report available.
- SharonLawrence
  Cover User
  10 years ago
  Not sure that Curtis36 has made a comment on the right post?  Has nothing to do with my request
- SharonLawrence
  Cover User
  10 years ago
  I realize that you can do GST reports as cash or accruals. This wouldn't help me. At year end we need to know how much GST is in payables and receivables at 30/6 - sometimes this is easy because all sales have GST, but if it is a mixed business it is not. Using the GST reports will not tell me how much GST is in the receivables/payables at a point in time.
  
  Even if you look at the difference between the accruals and cash reports, what about the timing differences from the previous quarter? This will not work.
  
  Having the "with tax" report just like in Account Right is the simple solution. Thanks
- Ashleys
  Cover User
  7 years ago
  We really do need to be able to get this report as I would imagine most small business clients using MYOB have accurals based financials and cash based GST. This report is essential to be able to reconcile the GST accounts in the financials and pick up if there is any GST unclaimed from previous quarters.
  
  I note that both MYOB Account Right and Xero have the ability to get this report. Come on MYOB, surely it can't be too hard to create this report for Essentials!!!
Docca61
Former Staff
9 years ago
Hi if you are doing Accrual Accounting you need to be able to determine the GST on the Outrsatnding Debtors. At the momemt there is no GST Column. Not every invoice is potentaially 1/11 as there could be GST Free Sales or Exempt Sales etc.

This report is available in Account Right We need it in Essentials as well.
Receivables with Tax.xlsx13 KB
Docca61
Former Staff
9 years ago
To run your GST reports correctly if you are doing Accrual Accounting you need to be able to determine the exact amount of GST Credits your are entitled to just like you can in Account Right (Payables with Tax). It is not necessarily 1/11 GST as you may have purchased GST Free Item etc.
Payables with Tax.xlsx13 KB
- Ashleys
  Cover User
  7 years ago
  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!!!
Markjfco
Partner
7 years ago
Hi

My client prepares BAS's on a cash basis but the accounts are prepared on an accruals basis. Not all sales and purchases have GST on them.
I would like a reports as per the following Accountright 2017 reports
1. Receivable With Tax
2. Payable With Tax

How else can I quickly reconcile my GST accounts?
Thelocaltrade
Cover User
7 years ago
Hi there,

I used to regularly use the payables with tax report and receivables with tax report, however I have just moved to essentials and am very disappointed to find out they are no longer Available!

Please please bring them to essentials, they make reconciling my GST so much easier.

Thanks!
- Ashleys
  Cover User
  7 years ago
  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!!!
Vicky_Chen
Cover User
7 years ago
Hi MYOB Support Team,

I have asked for the function of GST showing on the Accounts Receivable account before with you. I wonder if I can ask it again? Please see the attached report-Transactions on Accounts Receivable account (Trade Debtors account). On the last column, there is no GST outstanding amount showing on debtors, it should be GST amount on Debtors report.

Also, the second attachment is extracted from MYOB AccountRight Live version, it is a report named Receivable with Tax under Reports - Index to Reports - Sales, it is showing GST outstanding on Debtors.

Could you tell me when this function will be available?

Kind regards, Vicky
GL Report - 2017-08-22 11-17_Account Receivables.pdf3 KB
Receivables with Tax.pdf275 KB
- Ashleys
  Cover User
  7 years ago
  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!!!
AngieCats
Cover User
7 years ago
I would also like this too! Especially when reconciling the accounting profit to the taxable profit
Ashleys
Cover User
7 years ago
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!!!