Monthly Report

Checklist

Complete Checklist for the month.

Pick up and fix anomalies as best you can before the reports are finalised.

Reports from MoneyWorks

All these reports are opened in Excel and then “saved as a web page”* on Kate’s Machine:

My Documents| KTHT | MANUAL KTHT | accounts | files | monthly-reports | 2009-10

Use the name format exactly as the existing ones in the folder, so they sort into order, yyyy-mm so they look something like this:

profit-loss-2010-03.html

There is currently one MoneyWorks report to do for each month, and some graphs. More later**

Profit & Loss Comparison

For the month.  EG May 09  to May 09

Tick in the dialogue box:

  • Omit Zero balances
  • Show departments
  • Cash Basis***

Graphs

Account enquiries for relevant months, and make graphs. Currently doing EX and IN Make into jpg images Ctrl Prnt scr & paste in paint into Paint. Save using format in folder.

Email The Cubby

Email to The Cubby to let everyone know the month is done.

Receivables and Payables

These reports can be done any time to make sure our invoices are up to date. If we do several monthly months in one go (as can happen!!) then only the current month needs the Receivables and Payables reporting.

Aged Debtors
[ View by Status -> Receivable ] Fix any that might need fixing. Then print using report. [Report -> Receivables and Payables – Aged debtors – Tick Omit Zero Balances and Show outstanding Invoices]

Unpaid Creditor Invoices
[ View by Status -> Payable] Fix any that might need fixing. Then print using report. [Report -> Receivables and Payables ]

Finance Manager assessment

Walter will write a word doc on the report with any comments or plans. How the month went financially. Walter& Kate, Finance Manager & CEO will discuss and there may be another note with plans. These go to the same folder as the html docs above. Name: finance-report-2010-03.doc

  • Summary
  • Amount of drawings
  • Note anomalies
  • Comment & Analysis
  • What is needed with admin

File and put reports online

Reply to the month report in the Cubby email with a link to the analysis.

Filing

The reports are printed and filed in the hangar.

Note that the folder in the KTHT MANUAL can be synced with the files online.

<<<<<<>>>>>>>

* They are saved as a web page through excel as they print well that way. Pdfs would be ok too if they can be formatted nicely. Perhaps there is some work to do on the page layout system.

** More reports later to consider:

Trading Budget
[Find the report bottom of Profit & Loss list.] This needs some tweaking to work to show the cost of sales etc.

Job and ride numbers per venue

Can be done manually now – a Custom report to create.

*** Cash Basis means we count money invoiced even if they or we have not paid.

Leave a Reply