I want to create an expense tracker for an event but not good with excel </3
Our take
I am putting together a decently sized event with 9 other people so 10 total. I want create an expense tracker that will mainly let me select 1, multiple, or all people that have paid for an expense. Ideally it should funnel into another sheet that when the event is over it will tally up exactly what each person is owed back when the event is over and it keeps track of who paid for what and who didnt pay for certain items. We want to make everyone whole again before splitting the profit evenly so no worries in needing to calculate certain percentages back. Essentially if 1 person pays for an expense out of pocket they should be made whole first before distributing actual net profit, we think its just easier to understand that way. That is the main gist, other small features I would want to add is like dates to go back and see who paid for what on which day to have a track of deadlines being on time or missed. Can anyone appoint me to some good videos/tutorials and let me know some tips or templates to make this happen?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Could someone help me setup Excel as an Expenses Tracker app?Ok, so I would like to create an Excel worksheet tracking my expenses. While I do know how to create a data validation for a drop-down menu for the expenditure's category (e.g. food, travel etc.), I need help in creating a "formulaic sheet" where if I add on Income it will add accordingly to the balance I had left. I am well aware this is probably not making much sense. ENglish is my second language so please understand. submitted by /u/DonnyUssi [link] [comments]
- Looking for project tracking ideasHi, As the title suggests I’m trying to create an Excel sheet that tracks the progress of various projects. Essentially, I was given a messy excel document to look after. I don’t have particularly advanced skills and nor do I want to spend too much time on this. So… One sheet lists projects as rows and they all have a reference code. There is a column designated for “action updates” where people overwrite progress each month. Other columns exist for project status, dates etc. My idea was to create another sheet which also lists the projects but acts as an action/change history log. I attempted to have a drop down through grouped cells that would act as a historic list of all changes and action updates around each project. The row with the corresponding project number would act as a “live view”, so using an X look up to display this data on the original sheet. Is there a better way to create something like this? There must be loads of ways to do something like this, but I just can’t think which way to do it!! Thank you for any help!!! submitted by /u/Formal_Disk_3760 [link] [comments]
- How do you keep an income & expense tracker in Excel from getting messy over time?I’m trying to track income, expenses, and profit in Excel, but after a few weeks it starts getting messy and harder to maintain. I want to keep it simple and fast to update daily, without turning it into a complex system. How do you structure your sheets to keep things clean long-term? Any tips on layout or formulas would be really helpful. submitted by /u/MemoryLegal9756 [link] [comments]
- Personal life tracker : data structure and essential functionsThis might be silly… but I want to get better at Excel and I figured the best way to do that is to "gamify" my life. I’m planning to build one massive workbook to track everything: -Personal Finances: Budgeting vs. actual spend. -Media Tracker: Books read, movies watched, and ratings. -Health/Habits: Gym days, water intake, or sleep. Has anyone else done this? I’d love to hear your tips on structure. Specifically: -Do you keep everything in one giant file or separate ones? - What are some "must-have" functions for a dashboard like this? - Any screenshots or templates you’re proud of and willing to share? I’m not new to excel, I use it for work and school already, but trying to get better submitted by /u/arabellys [link] [comments]