Hello there, I am new to jet report.
Please see attachment. A colleague made the file for me, which delivers to me the net change amount per account per month in a specific financial year.
I would like to change the file, or make another, that instead delivers to me the accumulated balance amount per account per month in a specific financial year.
I.e. for a P/L account the accumulated net change amounts for only the specific financial year, and for a B/S account the balance at any time.
E.g. for a cost account, the desired amount in month 5 = the total cost for month 1-5.
And e.g. for a bank account, the balance at any time by the end of the month.
In case it is only possible for the balance sheet account, I'll be happy with that.
Hope this all makes sense.
Thx in advance for any help.
Best regards, and enjoy your day!
Date
Votes
3 comments
-
Jet Reports Historic Posts hi
The formula which you have used wont work as there are many more changes required, if you want I can design this for you ..
Let me know if its done ..
Regards
Alex :)
Jet Report Specialist 2015 -
Jet Reports Historic Posts Hi Alex
Have no idea how to go forward, so great if you can make a design - all help is appreciated. I can't offer any payment though.
Many thx in advance.
/Stoffer -
Jet Reports Historic Posts Hi Stoffer,
It sounds to me like what you want is simply the ending balance at the end of each month. For Balance Sheet accounts this will be the summation of all transactions for all time and for Income Statement Accounts it will only be for the current year. Assuming that you are closing your years properly then the same logic should be able to be used for both (ie: a date filter of ..7/31/2014 will return the ending balance of a cash account as of July 31, 2014 and will also return the net change from January 1 - July 31 2014 for a sales account because previous years sales were closed out with a closing entries which should exclude them.
In the attached report I modified the date filter calculations in Rows 5 to remove the beginning dates so the filter should now just be in the format of ..<EndingDate>
Can you run the attached report and let me know if this is what you are looking for?
I hope it helps!
Please sign in to leave a comment.