invoice amount includes GST

  • 1
  • Question
  • Updated 3 years ago
  • Answered
I want to create an invoice in Reckon Online hosted that includes 3 columns (amongst others)

1. the price of the item or service excluding GST [Amount]
2. the GST applicable to that product or service [GST Tax Code]
3. the price of that product or service including GST [????]

I can see how to add 1 and 2 but I can't find how to add 3

Any help would be appreciated
Photo of David Flack

David Flack

  • 70 Points
  • frustrated

Posted 3 years ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 21,576 Points 20k badge 2x thumb
David, the short answer is you cant... you can only have a price column, a total amount column and a gst column... then depending on whether you tick the box at the bottom for Amts inc Tax - will determine if you see ex GST values of GST Inclusive values.   So the choice is to choose one or the other, generally a business selling retail would possibly choose inclusive values - but a business selling to another business would be more likely to choose ex GST values...
You can, edit an item and create a custom field "Net". The invoice default should be set to print with "amounts include tax",  now you can insert this column on the invoice.  NB keep in mind you need to update this field when updating prices. 
My clients find it useful to see the cost when invoicing for this I have setup a price level named "Cost"  mark all items, adjust price of marked items to be 0% higher/lower than it's cost and adjust. Depending how often your cost change, you can adjust the price level weekly monthly etc.
Now when creating an invoice you can click the price level and see the cost