Page 1 of 1

Report to forecast near term cash flow

Posted: Sun Aug 16, 2020 8:44 pm
by mikhailo2608il
I had a desire for a report to forecast my cash flow for the next month. The Upcoming Transactions pane on the MMEX home page does not forecast far enough ahead for my desires. The built-in Cash Flow report when the Monthly option is selected gives you the aggregate information but I wanted detail lines as well as the total. I hope other MMEX users find this helpful. And I would appreciate your telling me if you find any errors. Thank you very much.
NEAR_TERM_CASH_FLOW.txt
SQL query for forecasting cash flow for next 31 days
(1 KiB) Downloaded 560 times

Re: Report to forecast near term cash flow

Posted: Fri Aug 21, 2020 6:37 pm
by whall3y
There is a bug as it includes any Transfers in the near term expenses. It assumes only Deposit and Withdrawal are valid values for TRANSCODE.

Think it should be more like this:

Re: Report to forecast near term cash flow

Posted: Thu Aug 27, 2020 12:41 pm
by mikhailo2608il
Thanks for paying attention. I did not have any Transfer transactions in my Recurring Transactions and completely overlooked the possibility of Transfer transactions in my SQL query. Thanks for pointing out this omission and posting a correction.

Re: Report to forecast near term cash flow

Posted: Tue Jan 19, 2021 6:14 pm
by HelenB
HI

I am new to MMEX but have managed to get the Cash Flow report discussed here to work :-) THis is just what I was looking for - EXCEPT I would also like to add the running total - Can I ask you more learned users help me - what code would I need to add to the SQL to be able to add this feature? THANKS SO MUCH :-)

I realise I have another request too - How can I split the report to show just one account?

Sorry to be a pain ;-)

Re: Report to forecast near term cash flow

Posted: Wed Jan 20, 2021 10:10 am
by Nikolay