Newbie question about reports

Build and share your cool customized reports built w/ one sql, Chart.js and Lua

Moderator: Renato

Post Reply
bernier
New User
Posts: 4
Joined: Thu Feb 04, 2021 4:09 pm
Are you a spam bot?: No

Newbie question about reports

Post by bernier »

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
whall3y
Developer
Posts: 345
Joined: Fri Aug 21, 2020 5:44 pm
Are you a spam bot?: No

Re: Newbie question about reports

Post by whall3y »

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.
bernier
New User
Posts: 4
Joined: Thu Feb 04, 2021 4:09 pm
Are you a spam bot?: No

Re: Newbie question about reports

Post by bernier »

Thanks very much, not ideal, but yes, that would work for me.

Cheers,
Bernie
bernier
New User
Posts: 4
Joined: Thu Feb 04, 2021 4:09 pm
Are you a spam bot?: No

Re: Newbie question about reports

Post by bernier »

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.
whall3y
Developer
Posts: 345
Joined: Fri Aug 21, 2020 5:44 pm
Are you a spam bot?: No

Re: Newbie question about reports

Post by whall3y »

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.
bernier
New User
Posts: 4
Joined: Thu Feb 04, 2021 4:09 pm
Are you a spam bot?: No

Re: Newbie question about reports

Post by bernier »

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
whall3y
Developer
Posts: 345
Joined: Fri Aug 21, 2020 5:44 pm
Are you a spam bot?: No

Re: Newbie question about reports

Post by whall3y »

The reports I mentioned are built into the the application.
Attachments
Screenshot 2021-02-05 at 08.57.16.png
Screenshot 2021-02-05 at 08.57.16.png (116.29 KiB) Viewed 16251 times
rintxy
New User
Posts: 3
Joined: Wed Feb 20, 2019 8:52 am
Are you a spam bot?: No

Re: Newbie question about reports

Post by rintxy »

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?
whall3y
Developer
Posts: 345
Joined: Fri Aug 21, 2020 5:44 pm
Are you a spam bot?: No

Re: Newbie question about reports

Post by whall3y »

:-) Have looked at this...

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
arb
New User
Posts: 8
Joined: Wed Jul 29, 2009 5:05 pm
Are you a spam bot?: No

Re: Newbie question about reports

Post by arb »

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)
User avatar
Renato
MVP User
Posts: 699
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Newbie question about reports

Post by Renato »

To be able to answer such questions, it would be important to know which version you are working with.
Renato Forum Administrator
arb
New User
Posts: 8
Joined: Wed Jul 29, 2009 5:05 pm
Are you a spam bot?: No

Re: Newbie question about reports

Post by arb »

I'm using the latest stable (1.3.6)
User avatar
Renato
MVP User
Posts: 699
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Newbie question about reports

Post by Renato »

On Windows ? or on Linux ?

already tried with the latest version v1.5.0-RC.2
https://github.com/moneymanagerex/moneymanagerex
Renato Forum Administrator
whall3y
Developer
Posts: 345
Joined: Fri Aug 21, 2020 5:44 pm
Are you a spam bot?: No

Re: Newbie question about reports

Post by whall3y »

arb wrote: Mon Mar 29, 2021 7:34 am 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'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?
arb
New User
Posts: 8
Joined: Wed Jul 29, 2009 5:05 pm
Are you a spam bot?: No

Re: Newbie question about reports

Post by arb »

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'.
whall3y
Developer
Posts: 345
Joined: Fri Aug 21, 2020 5:44 pm
Are you a spam bot?: No

Re: Newbie question about reports

Post by whall3y »

arb wrote: Thu Apr 29, 2021 2:13 pm 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'.
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
Post Reply