Report to forecast near term cash flow

[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 1091 times

[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:

[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.

[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

[Nikolay]

https://github.com/moneymanagerex/gener ... /issues/72