Accounts Example

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Edit some chart data using the tabs at the bottom of the sheet
2	Don't edit the lighly shaded cells (they contain formula's)
3	The countdown cells will change colors when attention is needed										scroll down, lots of stuff below
4	Google or YouTube "how to" anything you need to know about google sheets
5	Make a Copy and edit anything you want			(click "file/make a copy")
6	Links	cleared?	Account Name	Opened	closed	pos	Age	Balance	Limit	Util	Type	Status	Cut Date	Due Date	amount	Statement	Due	notes
7	autoloan		auto loan	Jun-14		134	133.9	$15,000	$20,000	75.0%	Installment	Open	7/5/2016	6/7/2016	$15,000
8
9	cap1	$500.00	Venture	Feb-14		138	137.7	$2,000	$20,000	14.6%	Revolving	Open	9/14/2016	9/30/2016	$2,000
10	cap1	$300.00	Quick Silver	Nov-13		141	140.7	$1,500	$10,000	7.7%	Revolving	Open	8/22/2016	8/25/2016	$1,500
11	BOA		BOA cash rewards	Nov-12		152	152.0	$500	$5,000	0.5%	Revolving	Open	6/7/2016	6/25/2016	$500
12	Chase		Chase amazon	Apr-14		135	135.5		$5,000	0.0%	Revolving	Open	8/23/2016	8/27/2016
13	Chase		Chase CSP	Jan-14		139	138.6		$2,000	0.0%	Revolving	Open	6/11/2016	8/21/2016
14	link		Barclay RMC	Apr-14	Apr-15	11	135.2		$1,500	0.0%	Revolving	Closed
15	link
16	link
17	link
18	link
19	link
20	link
21	link
22	link
23	link
24	link
25	link
26	link
27	link
28	link
29	options
30	prism
31	$2,000.00	$800.00	waiting to clear bank			715	840	$19,000	$63,500	29.9%	all FICO scored				$4,000	$1,200.00
32	$1,200.00	refreshed	10/20/2025 19:38:36					$19,000	$43,500	43.7%	all accounts
33								$19,000	$62,000	30.6%	all open accounts
34								$4,000	$43,500	9.2%	all revolving
35								$4,000	$42,000	9.5%	open revolving
36								Balance	Limit	152.0	oldest (months)
37										120.0	AAoA (months)
38										12.7	oldest (years)
39										10.00	AAoA (years)
40
41
42
43
44
45
46
47		refreshed	10/20/2025 19:38:36
48	card	amount	recurring charges		due date			due in
49	venture	$10	netflix		1/19/2016
50	venture	$15	credit check total		1/2/2016
51	Venture	$20	myfico		12/25/2015
52	CSP	$32	gym		1/7/2016
53
54
55
56	card	amount	bills	cleared?	due date			due in
57	venture	$50	cell		1/20/2016
58	venture	$100	dr		1/22/2016
59	venture	$50	dr2		1/20/2016
60	venture	$150	cable		1/23/2016
61	venture	$68	auto insurance		1/23/2016
62	venture	$320	IRS		1/23/2016
63		$814
64
65
66	11	Experian	Inquiries	date	fall off in...
67		EX	Chase	Mar-14	-112.5	month
68		EX	Amex	Oct-14	-105.9	month
69		EX	Chase	Oct-14	-105.9	month
70		EX	Cap One	Oct-14	-105.9	month
71		EX	Chase	Feb-15	-102.0	month
72		EX	Cap One	Feb-15	-102.0	month
73		EX	Barclay	Mar-15	-100.5	month
74		EX	Chase	Apr-15	-100.0	month
75		EX	Chase	Apr-15	-100.0	month
76		EX	Cap One	Nov-15	-93.2	month
77		EX	BOA	Nov-15	-92.7	month
78		EX	x
79		EX	x
80
81	1	TransUnion	Inquiries	date	fall off in...
82		TU	CapOne	Nov-15	-93.2	month
83		TU	x
84		TU	x
85		TU	x
86		TU	x
87		TU	x
88		TU	x
89		TU	x
90		TU	x
91		TU	x
92		TU	x
93		TU	x
94		TU	x
95
96	10	Equifax	Inquiries	date	fall off in...
97		EQ	Discover	May-14	-110	month
98		EQ	Discover	Jul-14	-109	month
99		EQ	Cap One	Oct-14	-106	month
100		EQ	Usaa	Oct-14	-106	month