user since '92 | Quicken Windows Premier - Subscription | Windows 11 Pro version 22H2
Add percentage usage column to the view in Property & Debt
edited November 2019 in Reports (Windows)
As the credit card usage % is a key metric most credit bureaus, I was wondering if there is a report that shows this % per credit card or is there a way to custom build this? Thanks in advance
There is no direct report in Quicken. With that said, you do have the components needed to calculate the CCU% if desired in a spreadsheet. From the Property & Debt tab, Debt sub-tab lists the Credit Limit, Available and Balance. All that is needed to calculate. Of course your numbers will not exactly match as your data is "real-time" and the reporting agencies are about a month behind.
Using Excel the results would show the following:
user since '92 | Quicken Windows Premier - Subscription | Windows 11 Pro version 22H20
A problem with that report is that the "Balance" number includes all future transactions. So if you've schedule a future payment in the credit card Account the report overstates your "Available" number.
> @Tom Young said:
> A problem with that report is that the "Balance" number includes all future transactions. So if you've schedule a future payment in the credit card Account the report overstates your "Available" number.
We can easily pull the credit usage that doesn't include the future transactions. We just need a calculation based on the credit limit.
Doing it in Excel is based on the available data in the debt tab. But we have to pull the data out of quicken every time.0
Vote on Ideas!
A Community Moderator changed this discussion to an Idea.
Ideas are brought to the attention of the programmers for consideration.If you would like to see this enhancement made in a future version of Quicken please don't forget to vote on it.Locate the big blue box near the top of this webpage (or page 1 for long discussions) and click the "Up" triangle under the voting count.
Wait a moment for the vote count to be registered and updated before you continue.
The little triangle changes from grey to black when you have registered your vote.
Every vote counts!
For additional information about idea posts please read https://community.quicken.com/discussion/7849425/creating-and-voting-for-ideas-in-the-community#latest
tnx @GeoffG - was basically taught to never spend what we don't have -
QWin Deluxe Subscription - Win100
I would love to have this on the main accounts display on the left side of the screen. Because that display has current-day values, it wouldn't have the 'future dated transaction' problem (and I do that a lot as that's how I plan my payments). Have it able to toggle off and on so users that aren't interested don't see it, and those that do not only have percentages per card but a total line with percentages as well so the overall picture can be seen.
Card Limit Balance CCU
VISA X1234 $10,000.00 $6,240.00 62.4%
MC X5678 $10,000.00 $3,160.00 31.6%
TOTAL $20,000.00 $9,400.00 47.0%0
Thanks to all previous commenters0