create report of category transactions including GST

  • 1
  • Question
  • Updated 3 weeks ago
Hi. I am using Reckon Accounts Home & Business 2018. I want to create a spending by category report that shows the GST inclusive amount paid for each transaction. It is not obvious how to do that. Can anyone help me? Thanks.
Photo of Andrew Body

Andrew Body

  • 80 Points 75 badge 2x thumb

Posted 4 weeks ago

  • 1
Photo of Diver Dave

Diver Dave

  • 3,818 Points 3k badge 2x thumb
Andrew, the easiest way to achieve that is to record each GST transaction as a split transaction - eg 110, cost category 100, gst 10, then run areport on the expense category.  It's also woth have the GST amount as a transfer to a GST accrual account to keep track of the aggregate GST paid.
Photo of Andrew Body

Andrew Body

  • 80 Points 75 badge 2x thumb
Hi Dave. Thanks for your reply.  When I run the report for the spending category I get a GST exclusive report.  Is there a way to produce a GST inclusive report?
Photo of Diver Dave

Diver Dave

  • 3,818 Points 3k badge 2x thumb
Strange, Andrew.  I set my Reports up years ago, and it only nominates Category, but reports the Gross Amount, with a link to the Split Transaction.  Have you tried a Report on the Payee?