Banking Reports

SmilinJack

WINDOWS 11 - Classic

We have multiple banks. Each having multiple accounts. Wanting to create a report showing total amount in each bank. I indicate the bank with the first three character of each account. IE:

BOA - Check

CHA - Check

BOA - CD

CHA - Saving

Thanks

Quicken Jasmine

Hello @SmilinJack,

Thanks for reaching out!

It sounds like you’re looking for a way to group and total your accounts by bank using a naming convention in Quicken. To make sure we’re on the right track, do all of your accounts consistently follow the three-letter prefix system, or are there any exceptions? Also, will this be a one-time report or something you’ll need to generate regularly? If it’s recurring, we may want to look at ways to make it easier to update. Additionally, are you looking to include only cash accounts like checking, savings, and CDs, or should investment and loan accounts be part of the total as well? Another thing to consider is whether you need just a high-level summary with totals per bank or a more detailed breakdown listing individual accounts grouped by bank. Finally, do you feel comfortable customizing reports in Quicken?

Let me know, and I’d be happy to help!

SmilinJack

Most accounts have the three-letter perfix. I can change all accounts. I would like to run the report monthly. I would like the reports to include investment. Detailed breakdown would help. I would be willing to customize reports.

Can reports work with a table of the three-letter prefix (Banks)? Only select the accounts that are in the table.

Thanks

q_lurker

Wanting to create a report showing total amount in each bank. 

You can create a customized Account Balances report where you select the accounts for a specific bank (Financial Institution) and the report will give you the total amount in that one FI (those selected accounts). You can save that as a report for that FI, and save a report of that construct for each applicable FI. So you might end up with 3, 4, … , 10 separate saved reports that you can access monthly. You might have one other report covering all the accounts to get that overall total. Your separate reports could have the detail (though for spending aka cash accounts I find that detail confusing - by Tags).

There is not any mechanism I know of to 'auto-select' a group of accounts based on a table or account names. Nor can you control the sequence of the accounts within the report other than by controlling the account name.

SmilinJack

Thanks, Sounds like that will work.

Thanks again

SmilinJack

q_lurker,

Your suggestion worked great. Time for me to learn the in's and out's of Quicken.

Thanks again😊