Financial report script
I have a question that must have been dealt with somewhere before but for the life of me I can't find it.
I have a simple debit credit list setup and I want to create a report that will show strarting and ending balances for each month and a YTD balance as well. Most of that I have achieved. My question is how to create a report that will take the ending balance of one month and automatically use that as the starting balance for the next month. Right now I can sort by Month name and get running totals for that month but I need to have the start balance for one month be the ending balance from the month before. I guess I already said that though.
I have been using Filemaker for some time but I am entirely self taught and this one may need me to set variables which I have not learned to do yet.
Any help would be appreciated.