How can I show split categories in reports?

Ceryswyn

Hello,

I am maintain the financial records for a very small non-profit, using my Quicken account. I am trying to run a report but every transaction that has split lines just shows -split- for the category. I tag all my transactions with the event we were at, but the category is where the real information is that I need to report on (sales, donations, etc).

Is there a way to get it to show the category of split lines on a report?

I'm currently on version R57.26 Build 27.1.57.26 of Quicken.

I'm running the "Itemized Tags" report. Here is a small screenshot of the result, as you can see in the Category column it just says split which is not useful for me.

Any help is appreciated.

regards,

Ceryswyn.

Boatnmaniac

@Ceryswyn - Given the additional information you provided, I think the suggestion proposed by @volvogirl is probably the best solution for you. You can enter the receipts into the manual offline account (the intermediate holding account) with whatever transaction dates that you want and they will show up in reports with those dates. The deposits to the checking account then is nothing more than a transfer of funds from the manual offline account into the checking account and the date of that transfer deposit becomes moot relative to the year end category reports that you want/need.

For the manual offline account: Go to Add Account > Offline Account > Checking. Checking account would be my preference if I were to be faced with this situation but you can select Savings, instead, if you wish. Some people might suggest doing Add Account > Other Assets & Liabilities > Cash On Hand as another option but unless you are getting a lot of cash receipts this is one I probably would not consider. Still, any one of these options would work well for this process. You can name the account whatever you wish, just make sure not to set it up for downloads with an actual bank.

Tom Young

"but the category is where the real information is that I need to report on "

If that's the case then I'd use the Spending by Category report. You can "click through" for any particular Category to see all the detail in that Category and, If needed, you can subtotal on Tags within the Category.

Ceryswyn

https://community.quicken.com/discussion/comment/20446580#Comment_20446580

Hi Tom, Thanks for that suggestion. Will that show income and expenses? Or will I need to find a different report for the income side of things?

cheers,

Ceryswyn.

Tom Young

For income and expenses you should use the Income and Expenses by Category report. For some reason I overlooked the fact that your posted pictures were showing the income side of things and somehow figured you were only looking at expenses. The income and expense report will cover all your income and expense Categories.

Boatnmaniac

Income and Expense by Category will provide the high-level summaries for each category but does not show the individual transactions. Of course, you can always double click on any category income or expense number to drill down to see the transactions details behind the summary numbers but it does not provide a single report whereby you can see all of the transactions for each of the categories. This report is really good for seeing the summary numbers for each category over time when there are multiple time periods (i.e., weekly, monthly, quarterly, etc.).

The Itemized Categories report will show all of the individual income and expense transactions for each category in a single report. But this report will show all the data for a specific time period with specific dates. It will not provide the numbers for each category over time (i.e., weekly, monthly, quarterly, etc.)…just shows the single time period that was selected for that report.

Ceryswyn

Thank you both.

The problem I'm running into is that I need a report on income generated in a calendar year, but we have an event that occurs right at the end of the year and sometimes those funds aren't deposited to the bank until the new year. There have been cases where it's taken our treasurer a month or two to deposit funds and it mixes together funds from the end of one year with funds from the beginning of the next year.

I'm trying to find a good way to manage the data in Quicken so I can report on the income and expenses in the calendar year generated, rather than the date deposited to the bank. Any suggestions?

volvogirl

What you need to use is an intermediate holding account. Set up an account and call it something like Checks Received or Undeposited Payments. Then enter the payments into it. Then when you make the deposit to your bank account you transfer the total deposit amount to the new account. That way when you download your bank transactions the deposit will match. Or you should use the holding account if you receive payments in one year (like in Dec) but don't make the deposit until the next year (like Jan.).

Boatnmaniac

@Ceryswyn - Given the additional information you provided, I think the suggestion proposed by @volvogirl is probably the best solution for you. You can enter the receipts into the manual offline account (the intermediate holding account) with whatever transaction dates that you want and they will show up in reports with those dates. The deposits to the checking account then is nothing more than a transfer of funds from the manual offline account into the checking account and the date of that transfer deposit becomes moot relative to the year end category reports that you want/need.

For the manual offline account: Go to Add Account > Offline Account > Checking. Checking account would be my preference if I were to be faced with this situation but you can select Savings, instead, if you wish. Some people might suggest doing Add Account > Other Assets & Liabilities > Cash On Hand as another option but unless you are getting a lot of cash receipts this is one I probably would not consider. Still, any one of these options would work well for this process. You can name the account whatever you wish, just make sure not to set it up for downloads with an actual bank.

Ceryswyn

Thank you! Sounds like an easy and efficient way to do it.