Newbie question about reports
Moderator: Renato
-
- New User
- Posts: 4
- Joined: Thu Feb 04, 2021 4:09 pm
- Are you a spam bot?: No
Newbie question about reports
Just switched to a Mac having always used Windows and Microsoft Money to manage finances.
At the end of my financial year I always printed a transaction report (list of all income and expenses transactions) grouped by category, with totals for each category and grand totals at the end.
Is there a similar report for MMEX please, I don't see one like it displayed on the 'Reports' web page at GitHub
Thanks for any help.
Cheers,
Bernie
At the end of my financial year I always printed a transaction report (list of all income and expenses transactions) grouped by category, with totals for each category and grand totals at the end.
Is there a similar report for MMEX please, I don't see one like it displayed on the 'Reports' web page at GitHub
Thanks for any help.
Cheers,
Bernie
-
- Developer
- Posts: 343
- Joined: Fri Aug 21, 2020 5:44 pm
- Are you a spam bot?: No
Re: Newbie question about reports
It's a good report to consider. I have raised a feature request. -- https://github.com/moneymanagerex/gener ... /issues/73
In the meantime you could:
1. Do a full transaction report between financial year start and end and sort by category (click on the category header), then print This will give you "a transaction report (list of all income and expenses transactions) grouped by category"
2.Access the categories/monthly report and adjust the start to the financial year start (it will be slightly wrong if year does not start on the 1st of cours)
3. Categories / Summary report can be filtered by financial year also but does not breakdown by month.
Hope that helps in some way.
In the meantime you could:
1. Do a full transaction report between financial year start and end and sort by category (click on the category header), then print This will give you "a transaction report (list of all income and expenses transactions) grouped by category"
2.Access the categories/monthly report and adjust the start to the financial year start (it will be slightly wrong if year does not start on the 1st of cours)
3. Categories / Summary report can be filtered by financial year also but does not breakdown by month.
Hope that helps in some way.
-
- New User
- Posts: 4
- Joined: Thu Feb 04, 2021 4:09 pm
- Are you a spam bot?: No
Re: Newbie question about reports
Thanks very much, not ideal, but yes, that would work for me.
Cheers,
Bernie
Cheers,
Bernie
-
- New User
- Posts: 4
- Joined: Thu Feb 04, 2021 4:09 pm
- Are you a spam bot?: No
Re: Newbie question about reports
What exactly are those two reports called please, presumably they are in the list on Github?
Last edited by bernier on Fri Feb 05, 2021 12:18 am, edited 1 time in total.
-
- Developer
- Posts: 343
- Joined: Fri Aug 21, 2020 5:44 pm
- Are you a spam bot?: No
Re: Newbie question about reports
For point 2, the report presents as default 12 months back from the current month. You would need to move it back to the start month you need - There are buttons on the report to do this.
-
- New User
- Posts: 4
- Joined: Thu Feb 04, 2021 4:09 pm
- Are you a spam bot?: No
Re: Newbie question about reports
Thanks, sorry I just realised that not having a date range would not be an issue, and I edited out the question from my reply!
So, now I just to need to know the names of the two reports you mentioned, and where I can find them, thanks
So, now I just to need to know the names of the two reports you mentioned, and where I can find them, thanks
-
- Developer
- Posts: 343
- Joined: Fri Aug 21, 2020 5:44 pm
- Are you a spam bot?: No
Re: Newbie question about reports
The reports I mentioned are built into the the application.
- Attachments
-
- Screenshot 2021-02-05 at 08.57.16.png (116.29 KiB) Viewed 14928 times
-
- New User
- Posts: 3
- Joined: Wed Feb 20, 2019 8:52 am
- Are you a spam bot?: No
Re: Newbie question about reports
Hello, I'm trying to use the Categories Summary Report but... total amounts seem very wrong. My date range is the whole time, and I'm using the transaction filter to check the results and they don't match (presumably the latter being correct).
I am doing something wrong? Could there be a bug in that report?
I am doing something wrong? Could there be a bug in that report?
-
- Developer
- Posts: 343
- Joined: Fri Aug 21, 2020 5:44 pm
- Are you a spam bot?: No
Re: Newbie question about reports
![Smile :-)](./images/smilies/icon_e_smile.gif)
Actually I think it is the Grand Total on the"Transaction Report" that is misleading when Transfers are include as they appear as two separate transactions A->B and B->A but both appear as debits from the source account. If you choose to just include Withdrawals and Deposits in the "Transaction" report that should give you a better result (assuming you use a simple 'Transfer' category for transfers).
Think we may need to consider clarifying this on the report and/or excluding transfers from the total
-
- New User
- Posts: 8
- Joined: Wed Jul 29, 2009 5:05 pm
- Are you a spam bot?: No
Re: Newbie question about reports
In contrast I am trying to find out why the Category | Monthly numbers are wrong and I think it's because the Transfers are not included.
I'd like to edit the sql but it's a built-in report. Is there anything like it in the repo I can try? CategoriesStatLast12Months doesn't allow change of date or selection of subset of accounts. (And the graph doesn't work, but I need the correct numbers more importantly)
I'd like to edit the sql but it's a built-in report. Is there anything like it in the repo I can try? CategoriesStatLast12Months doesn't allow change of date or selection of subset of accounts. (And the graph doesn't work, but I need the correct numbers more importantly)
- Renato
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Newbie question about reports
To be able to answer such questions, it would be important to know which version you are working with.
Renato Forum Administrator
-
- New User
- Posts: 8
- Joined: Wed Jul 29, 2009 5:05 pm
- Are you a spam bot?: No
Re: Newbie question about reports
I'm using the latest stable (1.3.6)
- Renato
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Newbie question about reports
On Windows ? or on Linux ?
already tried with the latest version v1.5.0-RC.2
https://github.com/moneymanagerex/moneymanagerex
already tried with the latest version v1.5.0-RC.2
https://github.com/moneymanagerex/moneymanagerex
Renato Forum Administrator
-
- Developer
- Posts: 343
- Joined: Fri Aug 21, 2020 5:44 pm
- Are you a spam bot?: No
Re: Newbie question about reports
I'm not sure why transfers would be included. They transfer out and in accounts and hence negate each other from a category expense perspective, because of this reason I always just use the 'Transfer' category for these anyway.
Why do you think the numbers are wrong? Do you have an example?
-
- New User
- Posts: 8
- Joined: Wed Jul 29, 2009 5:05 pm
- Are you a spam bot?: No
Re: Newbie question about reports
The difference comes when producing a report from a subset of accounts. In that case a transfer out to an account which is not a member of that subset should be considered as an 'expense'.
-
- Developer
- Posts: 343
- Joined: Fri Aug 21, 2020 5:44 pm
- Are you a spam bot?: No
Re: Newbie question about reports
Good point. Transfers in should therefore also be considered an 'income'. I have raised an issue to investigate this behavior.
https://github.com/moneymanagerex/money ... ssues/3350