I am making a bookkeeping app.
4 List.
Budget
Expense
Projected Income
Actual Income.
Every time i create an entry weather it is an actual expense or projected income or any of the list.
You have to select Company, Year, Month. That way i can create a Dashboard where i display all this values in one gallery. By matching Company, Year, Month. This all works fine.
The logic i am struggling with is:
Closing Balance of Current Month = Opening Balance of Current Month + Profit of Current Month
Opening Balance of Current Month = Closing Balance of Previous Month.
Actual income and Actual Expense entries will be done on daily basis. So according to that closing balance should change. But at the end of the month how to do i make closing balance of current month as opening balance of next month.
I am not sure how to make columns for that.
