AnsweredAssumed Answered

Financial report script

Question asked by jimmyfix on Apr 3, 2010
Latest reply on Apr 6, 2010 by jimmyfix


Financial report script


Hello everyone,


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.