Home → Suggestions →

Account Balance Report by month

• Edit

frankrader

25 Jan, 2012 04:43 PM

I can run a month by month Income and Expenses report but to get Account Balances I have to do a report for each month, 12 in all. I'd like one report with Account Balances for the period selected by month.

1. 1 Posted by -Kevin N. on 25 Jan, 2012 05:14 PM

   

   Hi Frank,
   I think that this is a good idea.
   Until it is implemented, you can run the Transactions Filter report on a individual account, sub-totaled by Month.
   It'll display all of the account's txns and unfortunately it won't be displayed side-by-side but it will give you an account's running balance over a period of time.
   HTH -Kevin N.

   • Edit

2. 2 Posted by Angie Rauscher on 30 Jan, 2012 11:26 PM

   

   Frank,

   Kevin's correct as to the best current work-around. I have created a feature request ticket for this issue. The ticket is attached to this discussion. By posting in this discussion your interest in the ticket has been registered. This is equivalent to voting for it, and you'll automatically be notified when we have updates.

   Angie Rauscher
   Moneydance Support

   • Edit

3. 3 Posted by ggruenstein on 20 Jan, 2013 04:31 PM

   

   I add my vote to the request to add time columns to account balances and net worth reports. Generally many reports will benefit from an option to add time interval columns.

   • Edit

4. 4 Posted by frankrader on 20 Jan, 2013 08:52 PM

   

   Thanks, Gad
   Moneype does what we want - Budget, Actual and Year to Date in one report, but does not do any fiscal year except calendar. If you are on a calendar year you can use Moneypie. Moneypie picks up the Budget entered into Moneydance, so that does not have to be entered again.

   I need a fiscal year of July 1 - June 30 which Moneydance can do, but not including Year to Date within the report.

   To an earlier comment posted another place, Moneydance is good about online support and collecting requests, slow about selecting some and updating Moneydance. Note the dates on our posts.

   • Edit

5. 5 Posted by troy.tudor on 23 Jan, 2015 07:51 PM

   

   Hi there,

   I've just migrated from MSM to MD and am immediatly missing a report that shows selected account balances (assets, credit, ...... etc) totaled by month.
   Without such a report I'm forced to track the balances month by month in a spreadsheet.
   So my vote to please. Hopefully not far now since this thread has been open since 2012.

   Thanks in advance

   • Edit

6. 6 Posted by ggruenstein on 23 Jan, 2015 11:24 PM

   

   Hi Troy
   I did such a report a while ago and use it very often. I will have to check
   how I can make it available.

   Gad

   • Edit

7. 7 Posted by troy.tudor on 30 Jan, 2015 07:48 PM

   

   Hi Gad

   I'd be very grateful if you can assist.

   I've asked the same question to MD support.
   They have no interest in providing such a report unless there is demand from users.

   Its definitely shame to have all the data sitting in the MD DB but being unable to adequately monitor ones liquid situation month on month without using excel.

   Thanks in advance for any assistance you can provide

   Thanks
   Troy

   • Edit

8. 8 Posted by frankrader on 03 Feb, 2015 08:11 PM

   

   A primary use of monthly balance information over several months is to compare several bank statement balances with Moneydance balances. If Moneydance and the bank are off, problems. With a year of bank statements it would be better to have a year of monthly balances on one report, rather than 12.

   If Moneydance is the choice to report to clubs it makes quarterly reports much better to have three months of balances on one report.

   I continue to favor this feature and hope it is added.

   • Edit

9. 9 Posted by ggruenstein on 03 Feb, 2015 11:13 PM

   

   Hi
   I wrote an extension that does that and I am in communication with md to
   get it published. In the extension you have options of start date, end date
   and period such as day,week,month,year. It shows the balance for each
   account (or optionally sub accounts) at the beginning of the period and a
   total of all. There is an option of showing difference per period or totals.

   • Edit

10. 10 Posted by frankrader on 03 Feb, 2015 11:15 PM

    

    Neat. Thanks!
    Can it handle a July>June fiscal year?

    • Edit

11. 11 Posted by Almond on 03 Dec, 2015 02:54 AM

    

    I would like to see account balances by month, too.

    • Edit

12. System closed this discussion on 19 Mar, 2016 04:55 AM.