Well, I'm our new troop treasurer, against my better judgement. The outgoing treasurer was an accountant, but a bit negligent tbh. I am not going to use the mess of QuickBooks that was left for me, I am planning on simplifying and hopefully using Excel or Google Sheets for all of the finance tracking - both to keep things more transparent (something that's been missing) and to make it easier for someone to take it on when I am finished.
We do have ISAs, but that's easy enough to track on Sheets. What I'm looking for is a spreadsheet that can track the big things - checking account, events, all of the outgoing and incoming money.
Scouting boards have lots of mentions of "we use a spreadsheet"...any chance anyone is willing to share their template with me? I don't want to take too much time re-inventing the wheel.
I haven't yet met with our committee, and I plan on asking them, but I'd also love to know what your committee's treasurer provides to you at meetings, and in what kind of format.
(Also, I am trying not to be frustrated with BSA or my local council, but I honestly can't believe that there's no standard software or widely-accepted processes for handling money within troops. Literally every Scouter I've talked to says their troop tracks finances differently. How is this not a class I can take at PTC or something?)