Unto the Populace of Rowany does the Reeve send Greetings,
It has been brought to my attention that there is some confusion over how to calculate the GST component for event reporting.
The good news is there’s not much calculation required by you. The total amount collected from the event fee (Cell E27) is divided by 11 to create a value in cell J28 (GST collected).
To fill out “GST paid”, add up the amount of GST you paid from receipts or invoices (hall hire, food, miscellaneous) and enter it there. Remember that the original receipts or invoices must still go to the Reeve for filing and double checking purposes.
“GST Liability” should automatically be calculated by the spreadsheet. If not, the liability is the difference between the amount of GST collected and the amount of GST paid (or, in spreadsheet cell terms “=J28-J29″).
I hope this clarifies the matter satisfactorily.
Yours in Service
Jean-Christophe le Saussier