Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Simple Bills/Finance Tracker setup

Topic Labels: Automations Base design Data
837 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Shannon_Bradley
7 - App Architect
7 - App Architect

Hello all, this may be one of those things where I am trying to think too complicated 😉

I have a base for my finances -I just need to list my recurring bills, my paydates, and have an output showing a running total of how much $$ needs to be in my account to cover those things.

So Table 1 has the Expense

Shannon_Bradley_0-1716179709207.png

Table 2 has Income dates

Shannon_Bradley_1-1716179811488.png

Table 3 Budget then has a record for every payment, linking to the Expense and the PayDate. I manually create each record and link the PayDate to the one most appropriate (so the date of the next PayDate). I then Group based on that next paydate. Once the payment clears my account I check it off as complete.

Shannon_Bradley_2-1716179915079.png

So the goal is that here for the "current" bill cycle May 17th I still need to keep $295.14 in the relevant bank  account. For the next bill cycle I will need $2783.67; but since that IS the paydate and I know the $$ coming in will cover that, I don't need to worry about it yet.

So I'm not budgeting in the traditional sense, just tracking how much $$ needs to be in the correct account at any given time. I don't need reminders, I don't need breakdowns and reporting. Just the current needed total.

I would LIKE to be able to have these records auto-create based on their frequency, and link to the correct "bill cycle paydate" though that part is easy enough.

I've been through Universe and there isn't anything this simple - yet complex apparently lol.  Am I overthinking it? Do I need to continue every few months to spend hours creating ands linking records?

 

0 Replies 0