Help please - NCG coded entry appearing in Sales portion of Tax Detail (Cash Net) report
Options
Cathi P
Member Posts: 19 ✭
On running a Tax Detail (Cash Net) report, one general journal item is appearing in the OUTPUTS/Sales portion of the report. The item is set against an expense account, and correctly coded (both in the entry and in the chart of accounts) as NCG. The other account used in the general journal entry was Payroll liabilities, because I have a payroll item set up to reimburse employees for company expenses through their payroll.
It is showing in the report as a negative amount, but sitting in OUTPUTS/Sales, instead of a positive amount and showing in INPUTS/Purchases. It also shows incorrectly in the Tax Detail (Cash Tax) report. These reports are all running on a cash basis.
Has anyone else seen this occur before, or have any idea of how to fix it?
I've done a data rebuild, then rang Tech help, who had me delete the transaction, then re-enter it for no change, and just advised me to check with my accountant (who may be able to advise another way to enter the transaction, but certainly can't answer why the report is incorrect). I've emailed them screenshots and the report, so hopefully they may come back with a reason and a solution, but I really want to get this solved so I can lodge my BAS (as it is already overdue).
I'm using Accounts Hosted, though Chrome, on a Mac (in Aus).
It is showing in the report as a negative amount, but sitting in OUTPUTS/Sales, instead of a positive amount and showing in INPUTS/Purchases. It also shows incorrectly in the Tax Detail (Cash Tax) report. These reports are all running on a cash basis.
Has anyone else seen this occur before, or have any idea of how to fix it?
I've done a data rebuild, then rang Tech help, who had me delete the transaction, then re-enter it for no change, and just advised me to check with my accountant (who may be able to advise another way to enter the transaction, but certainly can't answer why the report is incorrect). I've emailed them screenshots and the report, so hopefully they may come back with a reason and a solution, but I really want to get this solved so I can lodge my BAS (as it is already overdue).
I'm using Accounts Hosted, though Chrome, on a Mac (in Aus).
0
Comments
-
Can u please share screen shot.
shisuman2011@gmail.com
Regards
Shish0 -
Check the journal
Is the first line a debit or a credit?
Have the debit on the first line.
Debit expense NCG code
Cr Payroll Liability
Adrian
0 -
I think it would take me too long to blank out parts of the report that are confidential to make it worthwhile, sorry.0
-
Thanks for your suggestion Adrian. I had it that way originally, then found something else that suggested it should be the other way, so switched it around. Either way, in both situations it still showed in the wrong part of the report.
Is it just for bookkeeping reasons that it should be entered that way, or are there also technical effects?0 -
I had found if the journal started with a credit, Reckon allocated it to Sales and not expenses for GST purposes0
-
Thanks for your answer. I'll go back and double-check where I left it, and see if that makes a difference.0
Categories
- All Categories
- 6.9K Accounts Hosted
- 11 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 326 Point of Sale
- 2K Personal Plus and Home & Business
- 74 About Reckon Community