Revenue Recognition

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	S	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CT
1
2	CRM Data>>									Contract/Invoice Data>>							Daily Revenue	Revenue>>>																																																																												Check
3	Opportunity Name	Account ID	Type	Contract Start Date	Contract End Date	Annual Contract Value	Total Contract Value	Close Date	Stage	Service Start Date	Service End Date	Invoice Number	Invoice Date	Invoice Amount	Payment Date	Payment Amt.	Calc	1/31/22	2/28/22	3/31/22	4/30/22	5/31/22	6/30/22	7/31/22	8/31/22	9/30/22	10/31/22	11/30/22	12/31/22	1/31/23	2/28/23	3/31/23	4/30/23	5/31/23	6/30/23	7/31/23	8/31/23	9/30/23	10/31/23	11/30/23	12/31/23	1/31/24	2/29/24	3/31/24	4/30/24	5/31/24	6/30/24	7/31/24	8/31/24	9/30/24	10/31/24	11/30/24	12/31/24	1/31/25	2/28/25	3/31/25	4/30/25	5/31/25	6/30/25	7/31/25	8/31/25	9/30/25	10/31/25	11/30/25	12/31/25	1/31/26	2/28/26	3/31/26	4/30/26	5/31/26	6/30/26	7/31/26	8/31/26	9/30/26	10/31/26	11/30/26	12/31/26	1/31/27	2/28/27	3/31/27	4/30/27	5/31/27	6/30/27	7/31/27	8/31/27	9/30/27	10/31/27	11/30/27	12/31/27	1/31/28	2/29/28	3/31/28	4/30/28

4	OnlyCFO Company	1	New Business	2/15/22	2/15/24	1,000,000	1,000,000	2/15/22	Closed Won	2/15/22	2/15/24	INV-001	2/15/22	1,000,000	3/17/2022	1,000,000	1,369.86		17,808	42,466	41,096	42,466	41,096	42,466	42,466	41,096	42,466	41,096	42,466	42,466	38,356	42,466	41,096	42,466	41,096	42,466	42,466	41,096	42,466	41,096	42,466	42,466	20,548	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
5	Company ABC	2	New Business	11/8/22	11/8/23	100,000	100,000	11/8/22	Closed Won	11/8/22	11/8/23	INV-002	11/8/22	100,000	12/8/2022	100,000	273.97		0	0	0	0	0	0	0	0	0	6,027	8,493	8,493	7,671	8,493	8,219	8,493	8,219	8,493	8,493	8,219	8,493	2,192	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
6	FTX	3	New Business	6/15/22	6/15/23	500,000	500,000	6/15/22	Closed Won	6/15/22	6/15/23	INV-003	6/15/22	500,000	7/15/2022	500,000	1,369.86		0	0	0	0	20,548	42,466	42,466	41,096	42,466	41,096	42,466	42,466	38,356	42,466	41,096	42,466	20,548	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
7	ADD data here>>>
8	Add more rows as needed
9
10
11
12	+Period Billings																		1,000,000	0	0	0	500,000	0	0	0	0	100,000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
13	-Revenue																		-17,808	-42,466	-41,096	-42,466	-61,644	-84,932	-84,932	-82,192	-84,932	-88,219	-93,425	-93,425	-84,384	-93,425	-90,411	-93,425	-69,863	-50,959	-50,959	-49,315	-50,959	-43,288	-42,466	-42,466	-20,548	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
14	Deferred Revenue																		982,192	939,726	898,630	856,164	1,294,521	1,209,589	1,124,658	1,042,466	957,534	969,315	875,890	782,466	698,082	604,658	514,247	420,822	350,959	300,000	249,041	199,726	148,767	105,479	63,014	20,548	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
15
16	ST Deferred																		500,000	500,000	500,000	500,000	979,452	936,986	894,521	853,425	810,959	863,836	812,877	761,918	698,082	604,658	514,247	420,822	350,959	300,000	249,041	199,726	148,767	105,479	63,014	20,548	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
17	LT Deferred																		482,192	439,726	398,630	356,164	315,068	272,603	230,137	189,041	146,575	105,479	63,014	20,548	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
18
19	Check																		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
20	Check																		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00