GST for Event Stewards

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

Reeve.

Financial Policy Version 1.1 Available – Suggested Reading

To the Populous of Rowany,

We tend to have quite a lot of activities in the Barony. Many of these involve money as not much comes for free and people / organisations expect to get paid for things like venue hire.

Anyone dealing with money in relation to any kind of activity within the Barony should be aware of and adhere to our financial policy. This will ensure you understand how things work, things run smoothly, and everyone is happy (especially our Reeve whose job is difficult enough, the tax man, our B&B, my mum…  you get the picture).

Version 1.1 of our Financial Policy can be found at the following link:

http://rowany.lochac.sca.org/files/2014/02/Rowany-Financial-Policy-v1.1.pdf

Thanks to our Reeve, Jean-Christophe le Saussier, for creating this document.

YiS,
Jan

P.S.  All finance related posts (including those with other documents such as templates) can be found by using this site’s category Barony – Finances

New template for submitting financial reports after running events

To those running events in the Barony,

Our Reeve has created a new template which will help you prepare the financial report required when an event is run.

This should make things quicker and easier for those running events, and also means our Reeve receives the right information in a more ‘standard’ format, which will also make his life easier.

So, if you are running or going to run an event, please download the following file and use it for creating your financial report. File 1) is the template and file 2) contains the instructions.

1) http://rowany.lochac.sca.org/files/2014/01/TEMPLATE-Rowany-SCA-Lochac-Events-Financial-Report-01.txt
2) http://rowany.lochac.sca.org/files/2014/01/TEMPLATE-Rowany-SCA-Lochac-Events-Financial-Report-Instructions.txt

Note:

  • The files were created in Microsoft Office (Excel and Word) but will open in any compatible program (Open Office, Libre Office etc.)
  • The extension on the files were renamed to .txt for security reasons
  • As such, before the files will open correctly, you must change the filename for 1) back to .XLSX and 2) back to .DOCX

(change  “TEMPLATE-Rowany-SCA-Lochac-Events-Financial-Report-01.txt
to be        “TEMPLATE-Rowany-SCA-Lochac-Events-Financial-Report-01.xlsx
        AND
change  “TEMPLATE-Rowany-SCA-Lochac-Events-Financial-Report-Instructions.txt
to be       “TEMPLATE-Rowany-SCA-Lochac-Events-Financial-Report-Instructions.xlsx)

Thanks to our Reeve, Jean-Christophe le Saussier, for creating the template.

YiS,
Jan

P.S.  All finance related posts (including those with other documents such as policy) can be found by using this site’s category Barony – Finances