Custom Report - Help!
I have two bank accounts - one where my salary comes in to, and the second which is used to pay all my direct debit bills. Each month a set amount goes across from my main account to my bills account so there is enough to pay everything.
For arguments sake, let's say that my salary is £2,000 and I transfer £1,000 every month to the bills account. That leaves me with a disposable income of £1,000 a month. However, my bills in a particular month might only be £900 so my disposable income would be £1,100 that month.
I'd like to setup a report that can show me that breakdown each month so that over the year I can look at it and say definitively my disposable income is a minimum of £1,000 per month.
I'm looking to buy a new house soon, and it would be great if I could be confident with an avg disposable income every month that is produced for me automatically.
Just to further complicate things, I get paid on the 15th of each month, but transfer the money into the 'bills account' on the 1st of the following month. Not sure if that makes the report more difficult?
Any help/suggestions would be greatly appreciated.
2 Posted by jbnyt on 08 Mar, 2012 02:25 AM
Try using the Transfers, Detailed report. I don't know if you can get it to show by month but you can run it Year to Date.
Support Staff 3 Posted by Angie Rauscher on 08 Mar, 2012 02:54 AM
"Transfers, Detailed" would provide you with a good drill-down of transactions, while the "Transfers" report can be grouped by month for a top-level picture. The different dates might make things a bit more complex, but I think if things are consistent with getting paid every 15 and making the transfer every 1, you should be okay.
Give it a try, let us know how it goes, and please let me know if I can be of further assistance,
Angie Rauscher
Moneydance Support
Angie Rauscher closed this discussion on 08 Mar, 2012 02:54 AM.
Angie Rauscher re-opened this discussion on 08 Mar, 2012 02:54 AM
4 Posted by jbnyt on 08 Mar, 2012 01:13 PM
I've been playing around with this and another suggestion would be to try either the Cash Flow or Detailed Cash Flow reports.
Edit: Maybe not, I need to investigate further.