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

Cathi P

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).

Shish

Can u please share screen shot.

shisuman2011@gmail.com

Regards
Shish

Adrian_6974554

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

Cathi P

I think it would take me too long to blank out parts of the report that are confidential to make it worthwhile, sorry.

Cathi P

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?

Adrian_6974554

I had found if the journal started with a credit, Reckon allocated it to Sales and not expenses for GST purposes

Cathi P

Thanks for your answer. I'll go back and double-check where I left it, and see if that makes a difference.