Hi,
I am working on a monthly budget tracker. I have inline databases for Income & Expenses. Each one shows the name of the payment/transaction, date, amount, and account from which it will be deposited/debited. The account property has a relation linking it to an Accounts gallery view database that has a page for each account I have.
I will update Income & Expenses monthly and input my daily spending every day. I also have a current balance transaction listed in the Income database to show money rolling over from the previous month.
Can anyone help me with formulas to automate each account page to show me the following:
Current account balance based on Income-Expense up until & including today.
The amount that is due to leave the account this week.
I'd appreciate any advice on how to do this even if there isn't a formula fix, happy to hear all suggestions.
Thanks In Advance :)
