This is pretty cool. I've been playing around with it for the last hour or so and I should be able to use this forecasting cash flows. Thanks!
I'm able to forecast cashflows for my checking account. Comparing it the spreadsheet I've been using, the numbers look the same, but there might be some lingering bugs. I'll run them side-by-side for a little bit before I ditch the spreadsheet.
All in all, this makes me more impressed with Moneydance. It is somewhat primitive, but the fact that you can access all of your data in Python (or Java) makes it incredibly powerful. I know this isn't for everyone, but now that I've gone through writing my first script, subsequent scripts should be much easier to create.
Here's the output I have for a test account:
Moneydance 2017 (1584)
Checking
20170122 9000.09
20170127 500.00 8500.09 Weekly Reminder (every Friday)
20170201 2000.00 6500.09 Cash
20170201 100.00 6400.09 Daily Reminder (every 13 days)
20170203 500.00 5900.09 Weekly Reminder (every Friday)
20170205 3500.00 9400.09 Monthly Income Reminder (5th & 20th)
20170210 500.00 8900.09 Weekly Reminder (every Friday)
20170210 4000.00 4900.09 Monthly Reminder (every 10th)
20170213 100.00 4800.09 Daily Reminder (every 13 days)
20170217 500.00 4300.09 Weekly Reminder (every Friday)
20170220 3000.00 1300.09 Stuff
20170220 3500.00 4800.09 Monthly Income Reminder (5th & 20th)
20170224 500.00 4300.09 Weekly Reminder (every Friday)
20170226 100.00 4200.09 Daily Reminder (every 13 days)
20170301 0.04 4200.05 Stuff
20170303 0.02 4200.03 Stuff
20170303 500.00 3700.03 Weekly Reminder (every Friday)
20170305 3500.00 7200.03 Monthly Income Reminder (5th & 20th)
20170310 500.00 6700.03 Weekly Reminder (every Friday)
20170310 4000.00 2700.03 Monthly Reminder (every 10th)
20170311 100.00 2600.03 Daily Reminder (every 13 days)
20170315 5000.00 -2399.97 Annual Reminder
20170317 500.00 -2899.97 Weekly Reminder (every Friday)
20170320 3500.00 600.03 Monthly Income Reminder (5th & 20th)
20170324 100.00 500.03 Daily Reminder (every 13 days)
20170324 500.00 0.03 Weekly Reminder (every Friday)
20170331 500.00 -499.97 Weekly Reminder (every Friday)
20170405 3500.00 3000.03 Monthly Income Reminder (5th & 20th)
20170406 100.00 2900.03 Daily Reminder (every 13 days)
20170407 500.00 2400.03 Weekly Reminder (every Friday)
20170410 4000.00 -1599.97 Monthly Reminder (every 10th)
20170414 500.00 -2099.97 Weekly Reminder (every Friday)
20170419 100.00 -2199.97 Daily Reminder (every 13 days)
20170420 3500.00 1300.03 Monthly Income Reminder (5th & 20th)
20170421 500.00 800.03 Weekly Reminder (every Friday)
The formatting here is messed up, but it gives you the general idea. There should be three columns after the date: debit, credit, balance, followed by the description. In this data set, all the 3500 are credits. As for the output, there are two transactions: ones that are entered in the checking account and reminders with an associated transaction. The balance is forecasted for the next three months.
Within the Python console, it looks better, but this is one of the areas that could be better. I wished the console used a monospaced font so there's proper alignment of columns. Oh well. I might play around with this some more to see if I can make it better, but for now it works good enough for me.