madrivereric

For one of my Woodbadge tickets I made a pretty comprehensive unit financial tracking spreadsheet tool which keeps track of unit finances and helps promote good fiscal practice. It tracks cash on hand, money on deposit with a checking account and council as well as tracking reimbursable expenses (e.g. parents buy something for the unit and the unit them pays them back) as well as unit sold items (unit buys something, like pinewood derby cars or scout books and then resells them at a future time). It also has the ability to assign expenses to different categories for budgeting/financial reporting. The spreadsheet works on nearly any spreadsheet (Excel, open office/open docs, google sheets, etc.) and all of the formulas are documented. It has some sanity checking to prevent most errors and the spreadsheet is segregated into data fields and formula fields. If something gets messed up with the formulas, one can simply recopy the data into a fresh sheet and they're usually back in business. It uses a check book like entry method and usually folks find it pretty easy to use. I've gotten good feedback from non-financial folks as well as financial professionals. Link to spreadsheet: https://docs.google.com/spreadsheets/d/1rbKRRKE7jhgWSCuPMHHMjxCy82k5Ge7aAjcMZcoRPxM/edit?usp=sharing Eric