I would love some assistance in setting the workflow up, I got to the part of setting up the data validation code in the Expense column, but still couldn’t get everything to populate. I curbed the work for the time being, the Credit Card balance “snapshot” is the biggest hole I needed to fill. My “expenses” are all on my card balances, we have 3 cards that we use for certain categories of our lives. So my expense categories are almost arbitrary at first glance, since they all are encompassed in my credit card balance.
Now that’s not to say that budgeting for all categories of life is actually arbitrary, but I think I actually need two different sheets, one is a sheet that’s tracking my monthly expenses by category , and the other sheet to track the total balance of each card along with my paychecks. From the examples of your Paycheck Expense workflow, it looks like it does indeed solve that problem, but I do worry because I feel like it’s going to be counting all individual categories of expenses as well the total balances on credit card statements.
For the time being, I did find a solution utilizing your Credit Card Settings & Income Settings workflows in conjunction with Tiller’s Projected Balances sheet.
If you do not want this posted please let me know, however this isn’t really changing any of your card so I thought it would be ok. But do not want to cross any lines.
I’m basically using this sheet to reference your two sheets.
Starting Balance This is referencing total checking accounts sheet.
Payment & Credit Cycle Flow This used to be the Yearly Recurring Expenses section, but I am able to have specifics months and days, making it easier for me to accomplish the goals that I’m trying to achieve.
This is where your Credit Card Settings sheet has been invaluable to me. I have all cells referenced for the upcoming balances due and then the current picture of where all of my statements are sitting.
I then have your Income Settings sheet to reference the next payday and amount for paychecks that are incoming (for the 2nd pay day, I just referenced the above cell and +14).
The red savings text is actually the only number that needs to be manipulated. This is basically for me to enter what amount of savings I could theoretically put into our high yield account. The hardest part about living on cards is making sure we have enough cash in our accounts to pay off the balances when all cards are due.
Balances after upcoming/current statements This is the final part that tells me where we’re sitting with our finances, it references the 17th of each month (this is when the 3rd credit card balance is due) and give me a snapshot of how our account health is looking. This is also where I use the red text savings input to make sure I never put too much into savings before our statement is due.
So, as you can see, it’s clunky, but it’s working for now. I would love to able to track our actual categorical expenses somehow too. It’d be even better to be able to have a dashboard that can look at all of that (your Paycheck Expenses is the closest thing!)
Anyway, if you’d like me to detail the recurring expenses part where I got stuck, I’d be happy to as well!
Thank you again for all of your hard work, these solutions alone have been an IMMENSE help and with our peace of mind as we financially plan for the future.