I created a report using the General Report Manager.
I haven’t tested the foreign currency conversion.
The accounts are sorted by name, and a subtotal is inserted whenever the first four characters of accounts change.
Note: For some accounts, I use a period at the beginning of the account name so that my most important accounts always appear at the top. This period is not taken into account during sorting.
Total accounts sorted by account with breakdown (Subtotal)
Moderator: Renato
- Renato
- MVP User
- Posts: 939
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
- Contact:
Total accounts sorted by account with breakdown (Subtotal)
Renato Forum Administrator (I'm not a developer)
- Renato
- MVP User
- Posts: 939
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
- Contact:
Re: Total accounts sorted by account with breakdown (Subtotal)
Here is an improved version:
Renato Forum Administrator (I'm not a developer)
-
Dandy
- New User
- Posts: 17
- Joined: Thu Feb 17, 2022 7:28 pm
- Are you a spam bot?: No
- Contact:
- Renato
- MVP User
- Posts: 939
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
- Contact:
Re: Total accounts sorted by account with breakdown (Subtotal)
Since the language is English, I chose this display option.
The fact that this looks a little odd with negative numbers is an HTML issue.
Can I assume that you like this analysis and find it useful?
Period ( . ): Common in Germany, Austria, Italy, Spain, and large parts of Europe and South America (e.g., 1,000,000).
Comma ( , ): Standard in English-speaking countries (U.S., U.K., Australia, Canada) as well as in China, Japan, and India (e.g., 1,000,000).
Narrow space / space ( ): Recommended by the international ISO standard. Used in France, Sweden, Finland, and in academic contexts (e.g., 1 000 000).
Apostrophe ( ' ): Standard format in Switzerland and Liechtenstein (e.g., 1'000'000).
The fact that this looks a little odd with negative numbers is an HTML issue.
Can I assume that you like this analysis and find it useful?
Period ( . ): Common in Germany, Austria, Italy, Spain, and large parts of Europe and South America (e.g., 1,000,000).
Comma ( , ): Standard in English-speaking countries (U.S., U.K., Australia, Canada) as well as in China, Japan, and India (e.g., 1,000,000).
Narrow space / space ( ): Recommended by the international ISO standard. Used in France, Sweden, Finland, and in academic contexts (e.g., 1 000 000).
Apostrophe ( ' ): Standard format in Switzerland and Liechtenstein (e.g., 1'000'000).
Renato Forum Administrator (I'm not a developer)
-
Dandy
- New User
- Posts: 17
- Joined: Thu Feb 17, 2022 7:28 pm
- Are you a spam bot?: No
- Contact:
Re: Total accounts sorted by account with breakdown (Subtotal)
"Yes, I like it.Renato wrote: Tue Aug 11, 2026 12:53 pm Can I assume that you like this analysis and find it useful?
For my needs, I would prefer subtotals to be calculated after each account group (e.g., Bank, Credit, Cash, Assets)."
- Renato
- MVP User
- Posts: 939
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
- Contact:
Re: Total accounts sorted by account with breakdown (Subtotal)
That would be a different kind of analysis; as far as I can tell, this information is already available in the overview, though the foreign currencies are displayed a bit “strangely” there.
I was missing a summary broken down by bank that would allow me to easily check my bank statement.
I also noticed that the valuation of the foreign currencies was missing.
I was missing a summary broken down by bank that would allow me to easily check my bank statement.
I also noticed that the valuation of the foreign currencies was missing.
Renato Forum Administrator (I'm not a developer)
Who is online
Users browsing this forum: No registered users