Help please - NCG coded entry appearing in Sales portion of Tax Detail (Cash Net) report

  • 1
  • Problem
  • Updated 2 weeks ago
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).
Photo of Cathi P

Cathi P

  • 426 Points 250 badge 2x thumb
  • frustrated

Posted 2 weeks ago

  • 1
Photo of Shish

Shish

  • 80 Points 75 badge 2x thumb
Can u please share screen shot.

shisuman2011@gmail.com

Regards
Shish
Photo of Cathi P

Cathi P

  • 426 Points 250 badge 2x thumb
I think it would take me too long to blank out parts of the report that are confidential to make it worthwhile, sorry.
Photo of Adrian

Adrian

  • 3,270 Points 3k badge 2x thumb
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

Photo of Cathi P

Cathi P

  • 426 Points 250 badge 2x thumb
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?
Photo of Adrian

Adrian

  • 3,270 Points 3k badge 2x thumb
I had found if the journal started with a credit, Reckon allocated it to Sales and not expenses for GST purposes
(Edited)
Photo of Cathi P

Cathi P

  • 426 Points 250 badge 2x thumb
Thanks for your answer. I'll go back and double-check where I left it, and see if that makes a difference.