Financial Dashboard.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Section	Classification	Account Type	Account Sub Type	Account	Id	Name	AccountSortOrder	AccountJoin	Company
117	Balance Sheet	Asset	Fixed Asset	Vehicles	2019 Nissan (708268)	115	2019 Nissan (708268)	15036	2019 Nissan (708268)	Unique Solutions
118	Balance Sheet	Asset	Fixed Asset	Vehicles	2019 Transit Cargo Van (17348)	113	2019 Transit Cargo Van (17348)	15037	2019 Transit Cargo Van (17348)	Unique Solutions
119	Balance Sheet	Asset	Fixed Asset	Vehicles	2022 GMC Colorado (311122)	114	2022 GMC Colorado (311122)	15038	2022 GMC Colorado (311122)	Unique Solutions
120	Balance Sheet	Asset	Fixed Asset	Vehicles	2023 GMC 1500 (148649)	116	2023 GMC 1500 (148649)	15039	2023 GMC 1500 (148649)	Unique Solutions
121	Balance Sheet	Liability	Accounts Payable	AccountsPayable	Accounts Payable (A/P)	43	Accounts Payable (A/P)	20007	Accounts Payable (A/P)	Unique Solutions
122	Balance Sheet	Liability	Credit Card	CreditCard	AMEX	77	AMEX	20513	AMEX	Unique Solutions
123	Balance Sheet	Asset	Accounts Receivable	AccountsReceivable	Accounts Receivable (A/R)	45	Accounts Receivable (A/R)	11009	Accounts Receivable (A/R)	Unique Solutions
124	Balance Sheet	Asset	Accounts Receivable	AccountsReceivable	Bad Debt Reserve	156	Bad Debt Reserve	11022	Bad Debt Reserve	Unique Solutions
125	Balance Sheet	Asset	Fixed Asset	AccumulatedDepletion	Accumuated Depreciation - Equipment	151	Accumuated Depreciation - Equipment	15047	Accumuated Depreciation - Equipment	Unique Solutions
126	Balance Sheet	Asset	Fixed Asset	AccumulatedDepreciation	Accumulated Depreciation - Vehicle	153	Accumulated Depreciation - Vehicle	15047	Accumulated Depreciation - Vehicle	Unique Solutions
127	Profit and Loss	Expense	Expense	OfficeGeneralAdministrativeExpenses	Allocated Corporate Overhead	133	Allocated Corporate Overhead	60136	Allocated Corporate Overhead	Unique Solutions
128	Profit and Loss	Expense	Cost of Goods Sold	CostOfLaborCos	Raw Materials	130	Allocated Direct Wages	50119	Allocated Direct Wages	Unique Solutions
129	Balance Sheet	Liability	Other Current Liability	GlobalTaxPayable	Arizona Department of Revenue Payable	71	Arizona Department of Revenue Payable	20771	Arizona Department of Revenue Payable	Unique Solutions
130	Balance Sheet	Asset	Bank	Checking	Chase Bank	143	Chase Bank	10139	Chase Bank	Unique Solutions
131	Profit and Loss	Expense	Other Expense	OtherMiscellaneousExpense	Bad Debt Expense	21	Ask My Accountant	80177	Ask My Accountant	Unique Solutions
132	Profit and Loss	Expense	Expense	BadDebts	Shipping	136	Bad Debt	60151	Bad Debt	Unique Solutions
133	Profit and Loss	Revenue	Income	SalesOfProductIncome	Billable Expense Income	32	Billable Expense Income	40163	Billable Expense Income	Unique Solutions
134	Profit and Loss	Revenue	Income	SalesOfProductIncome	Billable Expense Income ( 31 )	31	Billable Expense Income ( 31 )	40164	Billable Expense Income ( 31 )	Unique Solutions
135	Profit and Loss	Revenue	Income	SalesOfProductIncome	Billable Expense Income ( 33 )	33	Billable Expense Income ( 33 )	40165	Billable Expense Income ( 33 )	Unique Solutions
136	Balance Sheet	Asset	Bank	Checking	First Fidelity	144	First Fidelity	10163	First Fidelity	Unique Solutions
137	Profit and Loss	Revenue	Income	SalesOfProductIncome	Billable Expense Income ( 34 )	34	Billable Expense Income ( 34 )	40166	Billable Expense Income ( 34 )	Unique Solutions
138	Profit and Loss	Revenue	Income	SalesOfProductIncome	Billable Expense Income ( 35 )	35	Billable Expense Income ( 35 )	40167	Billable Expense Income ( 35 )	Unique Solutions
139	Profit and Loss	Revenue	Income	SalesOfProductIncome	Billable Expense Income ( 36 )	36	Billable Expense Income ( 36 )	40168	Billable Expense Income ( 36 )	Unique Solutions
140	Profit and Loss	Revenue	Income	SalesOfProductIncome	Billable Expense Income ( 37 )	37	Billable Expense Income ( 37 )	40169	Billable Expense Income ( 37 )	Unique Solutions
141	Balance Sheet	Liability	Long Term Liability	OtherLongTermLiabilities	Capitalized Financing Fees	121	Capitalized Financing Fees	23073	Capitalized Financing Fees	Unique Solutions
142	Balance Sheet	Asset	Bank	CashOnHand	Cash on hand	42	Cash on hand	10139	Cash on hand	Unique Solutions
143	Profit and Loss	Expense	Cost of Goods Sold	SuppliesMaterialsCogs	Direct Labor	124	Consumables	50144	Consumables	Unique Solutions
144	Profit and Loss	Expense	Cost of Goods Sold	SuppliesMaterialsCogs	Cost of Goods Sold	40	Cost of Goods Sold	50147	Cost of Goods Sold	Unique Solutions
145	Profit and Loss	Expense	Cost of Goods Sold	CostOfLaborCos	Manufacturing Supplies	7	Contractors	50147	Contractors	Unique Solutions
146	Balance Sheet	Liability	Other Current Liability	DeferredRevenue	Deferred Revenue	147	Deferred Revenue	20800	Deferred Revenue	Unique Solutions
147	Balance Sheet	Asset	Other Asset	OrganizationalCosts	Deferred Tax Asset	160	Deferred Tax Asset	18790	Deferred Tax Asset	Unique Solutions
148	Balance Sheet	Liability	Other Current Liability	FederalIncomeTaxPayable	Deferred Tax Liability	161	Deferred Tax Liability	20800	Deferred Tax Liability	Unique Solutions
149	Profit and Loss	Expense	Cost of Goods Sold	CostOfLaborCos	Production Equipment Maintenance	87	Direct Wages	50155	Direct Wages	Unique Solutions
150	Profit and Loss	Expense	Other Expense	Depreciation	Research and Development	150	Depreciation Expense - Equipment	80206	Depreciation Expense - Equipment	Unique Solutions
151	Profit and Loss	Expense	Other Expense	Depreciation	Miscellaneous	152	Depreciation Expense - Vehicle	80207	Depreciation Expense - Vehicle	Unique Solutions
152	Profit and Loss	Expense	Cost of Goods Sold	CostOfLaborCos	Freight In	98	ER Taxes	50159	ER Taxes	Unique Solutions
153	Profit and Loss	Expense	Cost of Goods Sold	CostOfLaborCos	Depreciation on Production Equipment	131	ER Taxes Allocation	50160	ER Taxes Allocation	Unique Solutions
154	Profit and Loss	Expense	Expense	PayrollExpenses	Direct Wages-1	93	Direct Wages-1	60171	Direct Wages-1	Unique Solutions
155	Profit and Loss	Revenue	Income	DiscountsRefundsGiven	Interest Income	48	Discounts given	40192	Discounts given	Unique Solutions
156	Balance Sheet	Liability	Credit Card	CreditCard	Divvy CC	67	Divvy CC	20559	Divvy CC	Unique Solutions
157	Profit and Loss	Expense	Expense	OfficeGeneralAdministrativeExpenses	Fixed Expense	89	Fixed Expense	60185	Fixed Expense	Unique Solutions
158	Balance Sheet	Asset	Fixed Asset	Vehicles	GMC Yukon (254731)	117	GMC Yukon (254731)	15096	GMC Yukon (254731)	Unique Solutions
159	Profit and Loss	Expense	Expense	TaxesPaid	Income Tax Expense	162	Income Tax Expense	60184	Income Tax Expense	Unique Solutions
160	Balance Sheet	Asset	Other Current Asset	LoansToOthers	Intercompany Receivable	122	Intercompany Receivable	12119	Intercompany Receivable	Unique Solutions
161	Profit and Loss	Revenue	Other Income	InterestEarned	Interest Expense	108	Interest Income	70232	Interest Income	Unique Solutions
162	Balance Sheet	Liability	Other Current Liability	LoanPayable	Intuit Loan	99	Intuit Loan	20826	Intuit Loan	Unique Solutions
163	Balance Sheet	Asset	Other Current Asset	Inventory	Inventory Asset	41	Inventory Asset	12124	Inventory Asset	Unique Solutions
164	Profit and Loss	Expense	Cost of Goods Sold	SuppliesMaterialsCogs	Inventory Adjustment	17	Job Supplies	50180	Job Supplies	Unique Solutions
165	Profit and Loss	Expense	Expense	Utilities	Rent Expense	132	Melio Service Fees	60193	Melio Service Fees	Unique Solutions
166	Balance Sheet	Asset	Other Current Asset	LoansToOthers	Note Receivable	123	Note Receivable	12131	Note Receivable	Unique Solutions
167	Balance Sheet	Equity	Equity	OpeningBalanceEquity	Opening Balance Equity	30	Opening Balance Equity	30197	Opening Balance Equity	Unique Solutions
168	Balance Sheet	Liability	Other Current Liability	GlobalTaxPayable	Out Of Scope Agency Payable	72	Out Of Scope Agency Payable	20842	Out Of Scope Agency Payable	Unique Solutions
169	Balance Sheet	Equity	Equity	OwnersEquity	Owner's Investment	23	Owner's Investment	30200	Owner's Investment	Unique Solutions
170	Balance Sheet	Equity	Equity	OwnersEquity	Owner's Pay & Personal Expenses	22	Owner's Pay & Personal Expenses	30201	Owner's Pay & Personal Expenses	Unique Solutions
171	Balance Sheet	Asset	Other Current Asset	LoansToOthers	Payroll Advance	110	Payroll Advance	12145	Payroll Advance	Unique Solutions
172	Balance Sheet	Liability	Other Current Liability	PayrollClearing	Payroll Clearing	102	Payroll Clearing	20850	Payroll Clearing	Unique Solutions
173	Balance Sheet	Liability	Other Current Liability	PayrollTaxPayable	Payroll Liabilities	54	Payroll Liabilities	20851	Payroll Liabilities	Unique Solutions
174	Balance Sheet	Asset	Other Current Asset	OtherCurrentAssets	Payroll Refunds	146	Payroll Refunds	12150	Payroll Refunds	Unique Solutions
175	Balance Sheet	Liability	Other Current Liability	GlobalTaxPayable	Pennsylvania Department of Revenue Payable	73	Pennsylvania Department of Revenue Payable	20857	Pennsylvania Department of Revenue Payable	Unique Solutions
176	Profit and Loss	Expense	Expense	OfficeGeneralAdministrativeExpenses	Travel Expenses	145	Professional Development	60229	Professional Development	Unique Solutions
177	Profit and Loss	Expense	Other Expense	OtherMiscellaneousExpense		49	Reconciliation Discrepancies	80267	Reconciliation Discrepancies	Unique Solutions
178	Balance Sheet	Equity	Equity	RetainedEarnings	Retained Earnings	25	Retained Earnings	30220	Retained Earnings	Unique Solutions
179	Profit and Loss	Revenue	Income	SalesOfProductIncome	Sales Revenue	26	Sales	40254	Sales	Unique Solutions
180	Profit and Loss	Revenue	Income	SalesOfProductIncome	Sales of Product Income	39	Sales of Product Income	40256	Sales of Product Income	Unique Solutions
181	Balance Sheet	Liability	Long Term Liability	NotesPayable	SBA Loan Payable	119	SBA Loan Payable	23156	SBA Loan Payable	Unique Solutions
182	Balance Sheet	Liability	Long Term Liability	NotesPayable	Sallyport Advances	75	Sallyport Advances	23160	Sallyport Advances	Unique Solutions
183	Balance Sheet	Asset	Other Asset	SecurityDeposits	Security Deposits	158	Security Deposits	18865	Security Deposits	Unique Solutions
184	Balance Sheet	Asset	Other Asset	OtherLongTermAssets	Service Contract - GMC Yukon	120	Service Contract - GMC Yukon	18867	Service Contract - GMC Yukon	Unique Solutions
185	Profit and Loss	Revenue	Income	SalesOfProductIncome	Shipping Income	109	Shipping Income	40263	Shipping Income	Unique Solutions
186	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	Startup Costs - LAC	163	Startup Costs - LAC	15159	Startup Costs - LAC	Unique Solutions
187	Profit and Loss	Expense	Expense	UnappliedCashBillPaymentExpense	Software Licensing Fees	44	Unapplied Cash Bill Payment Expense	60245	Unapplied Cash Bill Payment Expense	Unique Solutions
188	Profit and Loss	Revenue	Income	UnappliedCashPaymentIncome	Dividend Income	50	Unapplied Cash Payment Income	40271	Unapplied Cash Payment Income	Unique Solutions
189	Balance Sheet	Asset	Other Current Asset	OtherCurrentAssets	Uncategorized Asset	3	Uncategorized Asset	12181	Uncategorized Asset	Unique Solutions
190	Profit and Loss	Revenue	Income	SalesOfProductIncome	Uncategorized Income	1	Uncategorized Income	40275	Uncategorized Income	Unique Solutions
191	Balance Sheet	Asset	Other Current Asset	UndepositedFunds	Undeposited Funds	24	Undeposited Funds	12183	Undeposited Funds	Unique Solutions
192	Profit and Loss	Expense	Expense	OfficeGeneralAdministrativeExpenses	Variable Expense	90	Variable Expense	60263	Variable Expense	Unique Solutions
193	Profit and Loss	Expense	Expense	OfficeGeneralAdministrativeExpenses	Vehicle Purchase Expense	118	Vehicle Purchase Expense	60264	Vehicle Purchase Expense	Unique Solutions
194	Profit and Loss	Expense	Cost of Goods Sold	CostOfLaborCos	Subcontractor Fees	159	Vendor Professional Services	50247	Vendor Professional Services	Unique Solutions
195	Balance Sheet	Liability	Long Term Liability	NotesPayable	Verde Clean Intercompany Loan	46	Verde Clean Intercompany Loan	23185	Verde Clean Intercompany Loan	Unique Solutions
196					Non-operating Expenses				Interest Paid	Unique Solutions
197		Expense	Expense		Advertising and Promotion				Guaranteed Payments to Partners - Rivera	Unique Solutions
280	Balance Sheet	Asset	Bank	Savings	MMA (3896)	154	MMA (3896)	10180	Chase Bank:MMA (3896)	Unique Solutions
281	Profit and Loss	Expense	Expense	AdvertisingPromotional	Advertising	4	Advertising & Marketing	60144	Variable Expense:Advertising & Marketing	Unique Solutions
282	Balance Sheet	Asset	Bank	Savings	Savings (9117)	103	Savings (9117)	10221	Chase Bank:Savings (9117)	Unique Solutions
283	Balance Sheet	Asset	Bank	Savings	Savings (9125)	107	Savings (9125)	10222	Chase Bank:Savings (9125)	Unique Solutions
284	Profit and Loss	Expense	Expense	PayrollExpenses	Workers' Compensation	129	Allocated Indirect Wages	60135	Fixed Expense:Payroll Expenses:Allocated Indirect Wages	Unique Solutions
285	Profit and Loss	Expense	Expense	PayrollExpenses	Retirement Contributions	127	Allocated Officer Wages	60136	Fixed Expense:Payroll Expenses:Allocated Officer Wages	Unique Solutions
286	Balance Sheet	Asset	Bank	Savings	Savings (3504) FFB	141	Savings (3504) FFB	10220	First Fidelity:Savings (3504) FFB	Unique Solutions
287	Profit and Loss	Expense	Expense	PayrollExpenses	Severance Pay	128	Allocated Taxes (ER)	60137	Fixed Expense:Payroll Expenses:Allocated Taxes (ER)	Unique Solutions
288	Profit and Loss	Expense	Expense	Auto	Maintenance	126	Auto Repairs & Maintenance	60151	Fixed Expense:Car & Truck:Auto Repairs & Maintenance	Unique Solutions
289	Balance Sheet	Asset	Bank	Checking	Checking (2029)	29	Checking (2029)	10140	Chase Bank:Checking (2029)	Unique Solutions
290	Balance Sheet	Asset	Bank	Checking	Checking (9760)	106	Checking (9760)	10141	Chase Bank:Checking (9760)	Unique Solutions
291	Profit and Loss	Expense	Expense	BankCharges	Office Supplies	6	Bank Charges & Fees	60152	Variable Expense:Bank Charges & Fees	Unique Solutions
292	Balance Sheet	Asset	Bank	Checking	Payroll Checking (9778)	104	Payroll Checking (9778)	10200	Chase Bank:Payroll Checking (9778)	Unique Solutions
293	Balance Sheet	Asset	Bank	Checking	Income (3474) FFB	139	Income (3474) FFB	10170	First Fidelity:Income (3474) FFB	Unique Solutions
294	Balance Sheet	Asset	Bank	Checking	Operations (3431) FFB	138	Operations (3431) FFB	10189	First Fidelity:Operations (3431) FFB	Unique Solutions
295	Balance Sheet	Liability	Other Current Liability	PayrollTaxPayable	CSE	80	CSE	20781	Payroll Liabilities:CSE	Unique Solutions
296	Balance Sheet	Asset	Bank	Checking	Payroll (3466) FFB	140	Payroll (3466) FFB	10198	First Fidelity:Payroll (3466) FFB	Unique Solutions
297	Profit and Loss	Expense	Expense	Auto	Fuel	5	Car & Truck	60164	Fixed Expense:Car & Truck	Unique Solutions