Laundromat Resource › Forums › Laundromats › New Owner – In need of excel spreadsheets for coin collections
-
AuthorPosts
-
-
August 10, 2021 at 11:15 am #6596
Hey Everyone,
New owner of The Laundry Lounge in Atlanta Georgia. I have been operating for a full week now and I am trying to move away from paper records for cash reconciliation/coin collections. I built a basic spreadsheet but I hope that someone on the board can provide me with a more advanced version.
What systems, processes or documents do you use during your daily operations? Drop me an email at [email protected]. I have a ton of documents to share as well. Thanks in advance.
-
August 19, 2021 at 10:01 pm #6697
Hi Chris, here is a version I use to to calculate my collections :
The main benefit is that it automates the allocation of the collection over the last x days. For example, if you did your first collection in three days, it will provide you with the average that was collected per day since your last collection. Additionally, there is functionality for a “modifier”. In my case, I use electricity bills as my modifier and allocate to each day based on how much electricity was used (I download this from my electricity provider). However, you can enter any modifier you would like.
You can enter the amounts you collect from Top Loaders, Front Loaders & Dryers in each column or you can add them all collectively to one column instead if you don’t want to see granular results. If you enter the data in columns G-I, everything else should auto-populate (e.g. graphs, pivot charts). I put dummy values in there for demonstration purposes. Hopefully this helps – let me know if you need anything adjusted. You can make a copy of the workbook so that you can enter your own values.
Sorry if this is a bit convoluted but hopefully it seems a little clearer when you start using the spreadsheet.
Best,
William-
October 10, 2021 at 9:45 pm #7120
William
Thanks for this spreadsheet
I’m taking over my store on Tuesday, and we will collect daily to get a feel for the store. What areas are the bottlenecks, and what’s not used
I Will play around with thisThank you
-
-
November 20, 2021 at 9:47 am #13306
Wow this excel is great! Thank you for sharing this resource~!
-
-
AuthorPosts
You must be logged in to reply to this topic.
Laundromat Resource › Forums › Laundromats › New Owner – In need of excel spreadsheets for coin collections