Need consulting for database design

joern.bock · 2021-01-25T18:20:30.079Z

Can anyone help me create a proper data model for a family financial forecast. Here’s what I have in mind: my wife and I have different accounts and we know what regular expenses and income we have for the next few months. On top of that, we have unscheduled expenses. We monitor all of that on a monthly basis. And we only look at categories, that’s enough for us. For this purpose I have created the following tables:

Account
Category
Booking

In Booking I create each planned booking with the assignment

date
Total amount
account
Category

So far so good. But now I am missing a good idea, how to calculate the balance of my account for each month. In the end I want to get the following display:

2021-01-22_17-00-191098×533 55.7 KB

And it should also be possible to change the planned expenses, so that then also the balance of the account adjusts.

Can someone help me with this. I thought I needed to create a table where I have an entry for each month and account for the total planned bookings per category. But I can’t get it to work. Maybe there is a much better approach.

I will gladly pay for a consulting hour.

Neil_Williams · 2021-01-25T20:23:03.956Z

Hi @joern.bock

What information are you going to have in the account and the category data-types? That will better help you and I both with creating a suitable Database

system · 2021-04-05T18:20:31.384Z

This topic was automatically closed after 70 days. New replies are no longer allowed.