Procedure for Creating New Annual Accounting Spreadsheet

From Knox Makers Wiki
Revision as of 23:04, 19 July 2017 by Laz (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

THIS PROCEDURE IS NOW OBSOLETE. WE MAINTAIN FINANCIAL RECORDS IN QUICKBOOKS ONLINE NOW.

  • A key point for maintaining accurate financial records is to provide receipts for all dues and donations paid in cash. Electronic payments are recorded by the respective payment processors, so a record will exist for those items.
  • In order to track the financial performance of the organization, a google spreadsheet is maintained under the treasurer account for each year. Each book will have 13 sheets: 1 sheet for each month, and a summary sheet.
  • To set up a spreadsheet for a new year, make a copy of the spreadsheet and rename it for the appropriate year.
  • On the summary sheet, change the summary year in cell B1, and bring forward the final cash balance from the previous spreadsheet and enter it into the starting cash balance in cell E1.
  • Once the spreadsheet is set up, you should enter and annotate all transactions as described in the other procedures.