Job Activity Detail - GST excluded from report

[Utopia]

Hi all,

I have generated a Job Activity (Detail) report for a specific job, however, for some reason it doesn't include the GST component in the report, therefore, not giving an accurate costing of the job.

I have viewed the filters, and cannot find anything for the GST component.  Because the report collects the amount from the general ledger code, I'm thinking it takes the amount excluding the GST.

Is there a way that I can add the GST somewhere in the report in order for the report to include the GST component.  At present, I have resorted to exporting the report onto Excel and add the GST portion to the report, which takes a lot of time.

Thank you

Michelle

[Steven_M · Accepted solution]

Hi @Utopia 

When you record a transaction against an account the GST portion of the transaction is filtered off to the linked GST accounts. For example, I record a tax-inclusive invoice for $110.00, the income account is impacted by $100 with $10 going to GST Collected account. 

In terms of job costing, job costing is done on the value that has gone against the profit and Loss account (income, cost of sales and expense). As the GST portion is syphoned out at the time of recording that transaction, the amount against the job would be the transaction income/expense account tax-exclusive value. As such, when reporting it will showing the tax-exclusive value with no option to add in the tax-inclusive amount.

[Utopia]

Thank you for your response Steven. Makes sense.  I will continue to add the GST component manually into my report.

Regards,

Michelle