02_Monthly_Budget_Tracker.xlsx

	A	B	C	D	E	F	G	H	I	J
1	INCOME & EXPENSE TRACKER
2	Txn ID	Date	Description	Category	Type	Amount ($)	Payment Method	Reference	Status	Notes

3	TXN-0001	2024-11-10	Taxes – BlueStar Corp	Taxes	Expense	1,146.67	PayPal	REF-49535	Pending
4	TXN-0002	2024-07-24	Sales Revenue – NovaStar	Sales Revenue	Income	49,930.04	Bank Transfer	REF-74260	Reconciled
5	TXN-0003	2024-06-13	Rent – TechForge	Rent	Expense	4,501.37	Credit Card	REF-18609	Cleared
6	TXN-0004	2024-10-07	Maintenance – WaveLine	Maintenance	Expense	3,183.73	Cash	REF-59925	Reconciled
7	TXN-0005	2024-08-08	Insurance – Delta Ventures	Insurance	Expense	2,552.48	Bank Transfer	REF-95814	Reconciled
8	TXN-0006	2024-04-26	Software – NovaStar	Software	Expense	2,285.20	Cash	REF-69441	Pending
9	TXN-0007	2024-08-06	Misc – Keystone Partners	Misc	Expense	520.67	Cash	REF-59060	Cleared
10	TXN-0008	2024-02-13	Rent – ClearPath Inc	Rent	Expense	501.56	Check	REF-22656	Reconciled
11	TXN-0009	2024-10-27	Utilities – RapidFlow	Utilities	Expense	2,804.04	PayPal	REF-53207	Reconciled
12	TXN-0010	2024-12-06	Rental Income – YellowBridge	Rental Income	Income	18,003.10	Check	REF-16743	Pending
13	TXN-0011	2024-09-16	Travel – GlobalSync	Travel	Expense	562.82	Credit Card	REF-96079	Pending
14	TXN-0012	2024-10-11	Rent – LunarBridge	Rent	Expense	1,783.06	Bank Transfer	REF-46512	Reconciled
15	TXN-0013	2024-11-14	Software – TechForge	Software	Expense	4,233.52	PayPal	REF-13441	Reconciled
16	TXN-0014	2024-12-25	Salaries – YellowBridge	Salaries	Expense	943.06	Cash	REF-54541	Pending
17	TXN-0015	2024-10-16	Service Fee – Vertex Group	Service Fee	Income	43,558.20	Check	REF-19120	Cleared
18	TXN-0016	2024-04-20	Sales Revenue – MetroGrid	Sales Revenue	Income	37,432.53	Check	REF-69460	Pending
19	TXN-0017	2024-06-15	Travel – YellowBridge	Travel	Expense	1,592.60	PayPal	REF-88148	Cleared
20	TXN-0018	2024-11-12	Service Fee – BlueStar Corp	Service Fee	Income	8,291.79	Bank Transfer	REF-45665	Pending
21	TXN-0019	2024-07-31	Insurance – InnoCore	Insurance	Expense	3,055.03	Credit Card	REF-77154	Cleared
22	TXN-0020	2024-12-13	Software – Vertex Group	Software	Expense	598.90	PayPal	REF-73783	Reconciled
23	TXN-0021	2024-11-02	Salaries – BlueStar Corp	Salaries	Expense	1,141.57	Bank Transfer	REF-36794	Pending
24	TXN-0022	2024-05-28	Utilities – Keystone Partners	Utilities	Expense	3,832.60	Bank Transfer	REF-11013	Pending
25	TXN-0023	2024-09-29	Utilities – WaveLine	Utilities	Expense	689.47	Credit Card	REF-75570	Reconciled
26	TXN-0024	2024-01-22	Rent – NovaStar	Rent	Expense	2,015.50	Bank Transfer	REF-70260	Cleared
27	TXN-0025	2024-07-26	Maintenance – WaveLine	Maintenance	Expense	2,174.96	Check	REF-47947	Cleared
28	TXN-0026	2024-03-28	Salaries – ZenithPro	Salaries	Expense	4,832.69	PayPal	REF-70305	Reconciled
29	TXN-0027	2024-02-24	Rent – HorizonTech	Rent	Expense	2,211.72	Check	REF-87184	Pending
30	TXN-0028	2024-06-22	Rental Income – HorizonTech	Rental Income	Income	43,590.96	Cash	REF-32037	Cleared
31	TXN-0029	2024-06-27	Interest – LunarBridge	Interest	Income	25,742.63	Credit Card	REF-40968	Cleared
32	TXN-0030	2024-11-04	Supplies – EastWest Trading	Supplies	Expense	1,026.50	Bank Transfer	REF-33218	Reconciled
33	TXN-0031	2024-10-23	Insurance – Orion Systems	Insurance	Expense	3,784.51	PayPal	REF-94278	Reconciled
34	TXN-0032	2024-08-13	Shipping – ClearPath Inc	Shipping	Expense	1,614.89	Check	REF-67961	Reconciled
35	TXN-0033	2024-06-29	Supplies – Quantum Leap	Supplies	Expense	2,977.53	Bank Transfer	REF-50685	Pending
36	TXN-0034	2024-05-26	Salaries – ClearPath Inc	Salaries	Expense	331.61	Bank Transfer	REF-90610	Reconciled
37	TXN-0035	2024-01-22	Insurance – Orion Systems	Insurance	Expense	2,922.63	PayPal	REF-95437	Cleared
38	TXN-0036	2024-03-18	Maintenance – BlueStar Corp	Maintenance	Expense	2,404.36	Check	REF-23566	Pending
39	TXN-0037	2024-01-21	Interest – HorizonTech	Interest	Income	32,483.29	Check	REF-67595	Reconciled
40	TXN-0038	2024-05-24	Travel – MetroGrid	Travel	Expense	1,895.62	Check	REF-54350	Reconciled
41	TXN-0039	2024-02-03	Refund – Keystone Partners	Refund	Income	32,541.62	Bank Transfer	REF-83133	Reconciled
42	TXN-0040	2024-12-02	Supplies – TechForge	Supplies	Expense	1,297.38	Credit Card	REF-53694	Cleared
43	TXN-0041	2024-12-01	Travel – WaveLine	Travel	Expense	1,585.65	Check	REF-26901	Reconciled
44	TXN-0042	2024-11-25	Consulting – ZenithPro	Consulting	Income	28,166.64	Cash	REF-26750	Reconciled
45	TXN-0043	2024-09-17	Refund – LunarBridge	Refund	Income	33,687.57	Bank Transfer	REF-57526	Pending
46	TXN-0044	2024-09-05	Marketing – GlobalSync	Marketing	Expense	1,741.58	Credit Card	REF-28030	Cleared
47	TXN-0045	2024-02-21	Consulting – Quantum Leap	Consulting	Income	42,299.21	PayPal	REF-79013	Cleared
48	TXN-0046	2024-07-11	Maintenance – EastWest Trading	Maintenance	Expense	698.69	Credit Card	REF-33703	Reconciled
49	TXN-0047	2024-07-29	Misc – LunarBridge	Misc	Expense	2,216.48	Credit Card	REF-68222	Reconciled
50	TXN-0048	2024-04-29	Misc – RapidFlow	Misc	Expense	3,929.81	Credit Card	REF-50562	Pending
51	TXN-0049	2024-10-19	Travel – Orion Systems	Travel	Expense	3,407.62	Check	REF-46932	Pending
52	TXN-0050	2024-11-05	Utilities – EastWest Trading	Utilities	Expense	4,093.61	Cash	REF-16839	Reconciled
53	TXN-0051	2024-02-22	Travel – WaveLine	Travel	Expense	2,794.98	PayPal	REF-26341	Pending
54	TXN-0052	2024-09-19	Service Fee – EastWest Trading	Service Fee	Income	14,003.17	Check	REF-22021	Cleared
55	TXN-0053	2024-07-31	Travel – BlueStar Corp	Travel	Expense	4,655.84	Check	REF-75799	Pending
56	TXN-0054	2024-07-10	Software – HorizonTech	Software	Expense	4,972.90	Bank Transfer	REF-51770	Cleared
57	TXN-0055	2024-05-26	Utilities – PrimeAxis	Utilities	Expense	731.12	Credit Card	REF-71487	Pending
58	TXN-0056	2024-04-20	Sales Revenue – EastWest Trading	Sales Revenue	Income	1,440.69	PayPal	REF-89807	Reconciled
59	TXN-0057	2024-05-01	Rent – JetStream LLC	Rent	Expense	3,892.05	Bank Transfer	REF-16258	Cleared
60	TXN-0058	2024-08-22	Shipping – ClearPath Inc	Shipping	Expense	3,979.80	Bank Transfer	REF-75513	Reconciled
61	TXN-0059	2024-05-03	Refund – WaveLine	Refund	Income	26,011.10	Credit Card	REF-48177	Pending
62	TXN-0060	2024-10-19	Interest – NovaStar	Interest	Income	17,964.39	Credit Card	REF-97080	Reconciled
63	TXN-0061	2024-02-04	Interest – Quantum Leap	Interest	Income	48,745.40	PayPal	REF-76496	Reconciled
64	TXN-0062	2024-01-23	Rental Income – UniCore	Rental Income	Income	43,729.91	Check	REF-58929	Pending
65	TXN-0063	2024-06-25	Consulting – HorizonTech	Consulting	Income	39,531.74	Bank Transfer	REF-86271	Reconciled
66	TXN-0064	2024-10-06	Utilities – Keystone Partners	Utilities	Expense	269.46	Credit Card	REF-99742	Pending
67	TXN-0065	2024-03-10	Shipping – ClearPath Inc	Shipping	Expense	952.28	Check	REF-14847	Pending
68	TXN-0066	2024-01-22	Salaries – Keystone Partners	Salaries	Expense	3,965.99	Cash	REF-77552	Pending
69	TXN-0067	2024-11-27	Supplies – GlobalSync	Supplies	Expense	231.27	Cash	REF-56789	Cleared
70	TXN-0068	2024-07-07	Supplies – NovaStar	Supplies	Expense	666.15	Check	REF-67637	Pending
71	TXN-0069	2024-09-11	Utilities – LunarBridge	Utilities	Expense	2,506.21	PayPal	REF-44959	Cleared
72	TXN-0070	2024-04-02	Rent – RapidFlow	Rent	Expense	2,181.51	Cash	REF-52101	Cleared
73	TXN-0071	2024-06-05	Consulting – Orion Systems	Consulting	Income	33,215.50	PayPal	REF-65851	Cleared
74	TXN-0072	2024-06-29	Travel – TechForge	Travel	Expense	2,263.29	Check	REF-45986	Reconciled
75	TXN-0073	2024-07-26	Sales Revenue – LunarBridge	Sales Revenue	Income	33,723.60	PayPal	REF-99051	Cleared
76	TXN-0074	2024-12-13	Service Fee – ZenithPro	Service Fee	Income	42,509.13	Check	REF-14561	Cleared
77	TXN-0075	2024-07-06	Service Fee – LunarBridge	Service Fee	Income	39,036.51	Check	REF-84349	Cleared
78	TXN-0076	2024-07-08	Shipping – LunarBridge	Shipping	Expense	2,277.12	Check	REF-20077	Reconciled
79	TXN-0077	2024-06-09	Taxes – UniCore	Taxes	Expense	1,866.40	Cash	REF-42717	Cleared
80	TXN-0078	2024-09-22	Refund – MetroGrid	Refund	Income	9,709.38	PayPal	REF-25435	Pending
81	TXN-0079	2024-11-09	Misc – JetStream LLC	Misc	Expense	2,259.05	Check	REF-36237	Cleared
82	TXN-0080	2024-12-31	Rent – Orion Systems	Rent	Expense	2,287.61	Bank Transfer	REF-99381	Pending
83	TXN-0081	2024-10-04	Misc – JetStream LLC	Misc	Expense	371.45	Cash	REF-30644	Reconciled
84	TXN-0082	2024-03-03	Travel – GlobalSync	Travel	Expense	2,568.34	Credit Card	REF-41029	Pending
85	TXN-0083	2024-07-07	Consulting – Orion Systems	Consulting	Income	27,924.06	PayPal	REF-27009	Reconciled
86	TXN-0084	2024-09-02	Sales Revenue – Quantum Leap	Sales Revenue	Income	15,809.89	Check	REF-63665	Reconciled
87	TXN-0085	2024-11-24	Service Fee – ClearPath Inc	Service Fee	Income	48,632.80	Check	REF-71057	Reconciled
88	TXN-0086	2024-10-09	Utilities – UniCore	Utilities	Expense	4,395.90	PayPal	REF-33850	Cleared
89	TXN-0087	2024-01-29	Taxes – Delta Ventures	Taxes	Expense	4,558.03	PayPal	REF-30056	Pending
90	TXN-0088	2024-12-29	Utilities – HorizonTech	Utilities	Expense	1,647.17	Cash	REF-78012	Pending
91	TXN-0089	2024-10-09	Consulting – InnoCore	Consulting	Income	10,216.95	Credit Card	REF-91922	Pending
92	TXN-0090	2024-10-30	Interest – SkyPeak	Interest	Income	32,228.88	Credit Card	REF-32439	Reconciled
93	TXN-0091	2024-01-15	Maintenance – ClearPath Inc	Maintenance	Expense	253.91	Bank Transfer	REF-94076	Reconciled
94	TXN-0092	2024-10-19	Shipping – NovaStar	Shipping	Expense	1,093.50	PayPal	REF-93753	Cleared
95	TXN-0093	2024-11-24	Shipping – JetStream LLC	Shipping	Expense	2,750.61	Check	REF-42096	Reconciled
96	TXN-0094	2024-12-18	Supplies – BlueStar Corp	Supplies	Expense	2,295.04	Credit Card	REF-67619	Pending
97	TXN-0095	2024-11-06	Insurance – EastWest Trading	Insurance	Expense	1,059.91	Cash	REF-51853	Reconciled
98	TXN-0096	2024-07-08	Software – Quantum Leap	Software	Expense	697.29	PayPal	REF-23917	Pending
99	TXN-0097	2024-08-18	Insurance – HorizonTech	Insurance	Expense	656.48	Credit Card	REF-22689	Cleared
100	TXN-0098	2024-08-02	Software – HorizonTech	Software	Expense	4,327.61	Credit Card	REF-52917	Reconciled