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
2	Balance Sheet	Liability	Long Term Liability	NotesPayable	2014 Chevrolet Van	204	2014 Chevrolet Van	23042	2014 Chevrolet Van	QR Solutions
3	Balance Sheet	Liability	Long Term Liability	NotesPayable	FFB Loan (0432)	215	FFB Loan (0432)	23125	FFB Loan (0432)	QR Solutions
4	Balance Sheet	Liability	Long Term Liability	NotesPayable	FFB Loan (1290)	228	FFB Loan (1290)	23126	FFB Loan (1290)	QR Solutions
5	Balance Sheet	Liability	Long Term Liability	NotesPayable	FFB LOC (9782)	201	FFB LOC (9782)	23124	FFB LOC (9782)	QR Solutions
6	Balance Sheet	Liability	Accounts Payable	AccountsPayable	Accounts Payable (A/P)	70	Accounts Payable (A/P)	20015	Accounts Payable (A/P)	QR Solutions
7	Balance Sheet	Liability	Credit Card	CreditCard	AMEX	167	AMEX	20519	AMEX	QR Solutions
8	Balance Sheet	Liability	Long Term Liability	OtherLongTermLiabilities	Capitalized Financing Expense	132	Capitalized Financing Expense	23077	Capitalized Financing Expense	QR Solutions
9	Balance Sheet	Liability	Credit Card	CreditCard	AMEX Platinum	191	AMEX Platinum	20520	AMEX Platinum	QR Solutions
10	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	AS510B-US 20IN SCR	139	AS510B-US 20IN SCR	15042	AS510B-US 20IN SCR	QR Solutions
11	Balance Sheet	Asset	Accounts Receivable	AccountsReceivable	Accounts Receivable (A/R)	36	Accounts Receivable (A/R)	11017	Accounts Receivable (A/R)	QR Solutions
12	Balance Sheet	Asset	Accounts Receivable	AccountsReceivable	Bad Debt Reserve	219	Bad Debt Reserve	11034	Bad Debt Reserve	QR Solutions
13	Balance Sheet	Asset	Fixed Asset	AccumulatedDepreciation	Accumulated Depreciation - Equipment	210	Accumulated Depreciation - Equipment	15051	Accumulated Depreciation - Equipment	QR Solutions
14	Balance Sheet	Asset	Fixed Asset	AccumulatedDepreciation	Accumulated Depreciation - Furniture	234	Accumulated Depreciation - Furniture	15052	Accumulated Depreciation - Furniture	QR Solutions
15	Balance Sheet	Asset	Bank	Checking	Chase	213	Chase	10147	Chase	QR Solutions
16	Balance Sheet	Asset	Fixed Asset	AccumulatedDepreciation	Accumulated Depreciation - Vehicle	212	Accumulated Depreciation - Vehicle	15053	Accumulated Depreciation - Vehicle	QR Solutions
17	Profit and Loss	Expense	Cost of Goods Sold	CostOfLaborCos	Raw Materials	185	Allocated Direct Wages	50131	Allocated Direct Wages	QR Solutions
18	Balance Sheet	Liability	Other Current Liability	GlobalTaxPayable	Arizona Department of Revenue Payable	116	Arizona Department of Revenue Payable	20780	Arizona Department of Revenue Payable	QR Solutions
19	Balance Sheet	Asset	Bank	Checking	FFB	214	FFB	10186	FFB	QR Solutions
20	Profit and Loss	Expense	Other Expense	OtherMiscellaneousExpense	Bad Debt Expense	20	Ask My Accountant	80186	Ask My Accountant	QR Solutions
21	Profit and Loss	Revenue	Income	SalesOfProductIncome	Billable Expense Income	28	Billable Expense Income	40171	Billable Expense Income	QR Solutions
22	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	Brush Pro MH200 Brush Machine	140	Brush Pro MH200 Brush Machine	15067	Brush Pro MH200 Brush Machine	QR Solutions
23	Balance Sheet	Asset	Bank	CashOnHand	Cash on hand	38	Cash on hand	10147	Cash on hand	QR Solutions
24	Profit and Loss	Expense	Cost of Goods Sold	SuppliesMaterialsCogs	Direct Labor	153	Consumables	50162	Consumables	QR Solutions
25	Profit and Loss	Expense	Cost of Goods Sold	SuppliesMaterialsCogs	Cost of Goods Sold	31	Cost of Goods Sold	50166	Cost of Goods Sold	QR Solutions
26	Profit and Loss	Expense	Cost of Goods Sold	EquipmentRentalCos	Quality Control Costs	190	Equipment Rental - COGS	50188	Equipment Rental - COGS	QR Solutions
27	Balance Sheet	Liability	Credit Card	CreditCard	Chase CC (0368)	174	Chase CC (0368)	20559	Chase CC (0368)	QR Solutions
28	Balance Sheet	Liability	Credit Card	CreditCard	Chase CC (0623)	85	Chase CC (0623)	20560	Chase CC (0623)	QR Solutions
29	Balance Sheet	Liability	Credit Card	CreditCard	Chase CC (6898)	100	Chase CC (6898)	20561	Chase CC (6898)	QR Solutions
30	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	Equipment 8/1	193	Equipment 8/1	15110	Equipment 8/1	QR Solutions
31	Profit and Loss	Expense	Expense	SuppliesMaterials	Chemicals	37	Chemicals	60171	Chemicals	QR Solutions
32	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	ET610 100C-15-SW	138	ET610 100C-15-SW	15106	ET610 100C-15-SW	QR Solutions
33	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	Fiber Pro 20	134	Fiber Pro 20	15125	Fiber Pro 20	QR Solutions
34	Profit and Loss	Revenue	Income	SalesOfProductIncome	Service Revenue	187	Consumables Income	40194	Consumables Income	QR Solutions
35	Profit and Loss	Expense	Cost of Goods Sold	CostOfLaborCos	Manufacturing Supplies	6	Contractors	50168	Contractors	QR Solutions
36	Profit and Loss	Expense	Cost of Goods Sold	CostOfLaborCos	Production Equipment Maintenance	97	Direct Wages	50178	Direct Wages	QR Solutions
37	Balance Sheet	Liability	Other Current Liability	DeferredRevenue	Deferred Revenue	207	Deferred Revenue	20817	Deferred Revenue	QR Solutions
38	Balance Sheet	Asset	Other Asset	OrganizationalCosts	Deferred Tax Asset	231	Deferred Tax Asset	18805	Deferred Tax Asset	QR Solutions
39	Balance Sheet	Liability	Other Current Liability	StateLocalIncomeTaxPayable	Deferred Tax Liability	230	Deferred Tax Liability	20812	Deferred Tax Liability	QR Solutions
40	Profit and Loss	Expense	Cost of Goods Sold	CostOfLaborCos	Freight In	165	ER Taxes	50182	ER Taxes	QR Solutions
41	Profit and Loss	Expense	Other Expense	Depreciation	Research and Development	209	Depreciation Expense - Equipment	80223	Depreciation Expense - Equipment	QR Solutions
42	Profit and Loss	Expense	Other Expense	Depreciation	Depreciation Expense - Furniture	233	Depreciation Expense - Furniture	80224	Depreciation Expense - Furniture	QR Solutions
43	Profit and Loss	Expense	Cost of Goods Sold	CostOfLaborCos	Depreciation on Production Equipment	177	ER Taxes Allocation	50183	ER Taxes Allocation	QR Solutions
44	Profit and Loss	Expense	Other Expense	Depreciation	Miscellaneous	211	Depreciation Expense - Vehicle	80225	Depreciation Expense - Vehicle	QR Solutions
45	Profit and Loss	Revenue	Income	DiscountsRefundsGiven	Interest Income	65	Discounts given	40208	Discounts given	QR Solutions
46	Profit and Loss	Revenue	Income	DiscountsRefundsGiven	Discounts/Refunds Given	66	Discounts/Refunds Given	40209	Discounts/Refunds Given	QR Solutions
47	Balance Sheet	Liability	Credit Card	CreditCard	Divvy	121	Divvy	20582	Divvy	QR Solutions
48	Profit and Loss	Expense	Expense	OfficeGeneralAdministrativeExpenses	Fixed Expense	163	Fixed Expense	60218	Fixed Expense	QR Solutions
49	Balance Sheet	Liability	Long Term Liability	NotesPayable	Flatbed Truck Loan	216	Flatbed Truck Loan	23136	Flatbed Truck Loan	QR Solutions
50	Balance Sheet	Asset	Other Asset	OtherLongTermAssets	GMC 1500 Service Agreement	149	GMC 1500 Service Agreement	18842	GMC 1500 Service Agreement	QR Solutions
51	Profit and Loss	Expense	Expense	Insurance	Utilities Expense	161	Health Insurance	60229	Health Insurance	QR Solutions
52	Profit and Loss	Expense	Expense	OfficeGeneralAdministrativeExpenses	Hydration	206	Hydration	60230	Hydration	QR Solutions
53	Balance Sheet	Liability	Other Current Liability	FederalIncomeTaxPayable	Income Tax Payable	229	Income Tax Payable	20863	Income Tax Payable	QR Solutions
54	Balance Sheet	Liability	Long Term Liability	NotesPayable	Intercompany Note Payable	74	Intercompany Note Payable	23151	Intercompany Note Payable	QR Solutions
55	Balance Sheet	Asset	Other Current Asset	LoansToOthers	Intercompany Receivable	160	Intercompany Receivable	12159	Intercompany Receivable	QR Solutions
56	Profit and Loss	Revenue	Other Income	InterestEarned	Interest Expense	114	Interest Income	70273	Interest Income	QR Solutions
57	Balance Sheet	Asset	Other Current Asset	Inventory	Inventory Asset	32	Inventory Asset	12163	Inventory Asset	QR Solutions
58	Profit and Loss	Expense	Cost of Goods Sold	SuppliesMaterialsCogs	Warranty Expense	16	Job Supplies and Small Equipment	50223	Job Supplies and Small Equipment	QR Solutions
59	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	Karcher Scrubber	154	Karcher Scrubber	15149	Karcher Scrubber	QR Solutions
60	Balance Sheet	Liability	Other Current Liability	LoanPayable	Loan Payable - 1690MJRO, LLC	175	Loan Payable - 1690MJRO, LLC	20874	Loan Payable - 1690MJRO, LLC	QR Solutions
61	Profit and Loss	Expense	Expense	Utilities	Rent Expense	141	Melio Service Fees	60240	Melio Service Fees	QR Solutions
62	Balance Sheet	Liability	Long Term Liability	NotesPayable	Note Payable - Paul Sarzoza	59	Note Payable - Paul Sarzoza	23166	Note Payable - Paul Sarzoza	QR Solutions
63	Balance Sheet	Equity	Equity	OpeningBalanceEquity	Opening Balance Equity	35	Opening Balance Equity	30244	Opening Balance Equity	QR Solutions
64	Balance Sheet	Liability	Long Term Liability	NotesPayable	Operating Lease Liability	221	Operating Lease Liability	23171	Operating Lease Liability	QR Solutions
65	Balance Sheet	Liability	Other Current Liability	GlobalTaxPayable	Out Of Scope Agency Payable	117	Out Of Scope Agency Payable	20886	Out Of Scope Agency Payable	QR Solutions
66	Balance Sheet	Equity	Equity	AccumulatedAdjustment	Owner Distribution	64	Owner Distribution	30249	Owner Distribution	QR Solutions
67	Balance Sheet	Equity	Equity	OwnersEquity	Owner's Investment	22	Owner's Investment	30248	Owner's Investment	QR Solutions
68	Balance Sheet	Equity	Equity	OwnersEquity	Owner's Pay & Personal Expenses	21	Owner's Pay & Personal Expenses	30249	Owner's Pay & Personal Expenses	QR Solutions
69	Balance Sheet	Equity	Equity	OwnersEquity	Partner Contribution - Paul Sarzoza	62	Partner Contribution - Paul Sarzoza	30251	Partner Contribution - Paul Sarzoza	QR Solutions
70	Balance Sheet	Equity	Equity	OwnersEquity	Partner Contribution - Steven Vizzerra	60	Partner Contribution - Steven Vizzerra	30252	Partner Contribution - Steven Vizzerra	QR Solutions
71	Balance Sheet	Asset	Other Current Asset	LoansToOthers	Payroll Advance	101	Payroll Advance	12187	Payroll Advance	QR Solutions
72	Balance Sheet	Liability	Other Current Liability	PayrollClearing	Payroll Clearing	115	Payroll Clearing	20892	Payroll Clearing	QR Solutions
73	Balance Sheet	Liability	Other Current Liability	PayrollTaxPayable	Payroll Liabilities	48	Payroll Liabilities	20894	Payroll Liabilities	QR Solutions
74	Balance Sheet	Asset	Other Current Asset	OtherCurrentAssets	Payroll Refunds	106	Payroll Refunds	12191	Payroll Refunds	QR Solutions
75	Balance Sheet	Asset	Fixed Asset	Vehicles	Pohle EZ GO - 5132728	151	Pohle EZ GO - 5132728	15177	Pohle EZ GO - 5132728	QR Solutions
76	Balance Sheet	Asset	Fixed Asset	Vehicles	Pohle EZ GO - 5325270	152	Pohle EZ GO - 5325270	15178	Pohle EZ GO - 5325270	QR Solutions
77	Profit and Loss	Expense	Expense	OfficeGeneralAdministrativeExpenses	Environmental Compliance Expense	123	Postage and Delivery	60272	Postage and Delivery	QR Solutions
78	Balance Sheet	Asset	Other Current Asset	PrepaidExpenses	Prepaid Expenses	237	Prepaid Expenses	12195	Prepaid Expenses	QR Solutions
79	Balance Sheet	Asset	Other Current Asset	PrepaidExpenses	Prepaid Insurance	235	Prepaid Insurance	12196	Prepaid Insurance	QR Solutions
80	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	Pressure Washer Trailer	150	Pressure Washer Trailer	15183	Pressure Washer Trailer	QR Solutions
81	Profit and Loss	Expense	Expense	OfficeGeneralAdministrativeExpenses	Travel Expenses	203	Professional Development	60276	Professional Development	QR Solutions
82	Balance Sheet	Liability	Other Current Liability	LoanPayable	QuickBooks Capital	124	QuickBooks Capital	20907	QuickBooks Capital	QR Solutions
83	Profit and Loss	Expense	Other Expense	OtherMiscellaneousExpense	Reconciliation Discrepancies	39	Reconciliation Discrepancies	80316	Reconciliation Discrepancies	QR Solutions
84	Balance Sheet	Equity	Equity	RetainedEarnings	Retained Earnings	2	Retained Earnings	30273	Retained Earnings	QR Solutions
85	Balance Sheet	Asset	Other Asset	OtherLongTermAssets	ROU Operating Lease Asset	220	ROU Operating Lease Asset	18899	ROU Operating Lease Asset	QR Solutions
86	Profit and Loss	Revenue	Income	SalesOfProductIncome	Sales Revenue	1	Sales	40306	Sales	QR Solutions
87	Profit and Loss	Revenue	Income	SalesOfProductIncome	Sales of Product Income	30	Sales of Product Income	40308	Sales of Product Income	QR Solutions
88	Profit and Loss	Expense	Cost of Goods Sold	SuppliesMaterialsCogs	Sales Tax	208	Sales Tax	50276	Sales Tax	QR Solutions
89	Balance Sheet	Liability	Long Term Liability	NotesPayable	SBA Loan	119	SBA Loan	23204	SBA Loan	QR Solutions
90	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	SC 351	135	SC 351	15196	SC 351	QR Solutions
91	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	SC250 WITH FAST CH	137	SC250 WITH FAST CH	15197	SC250 WITH FAST CH	QR Solutions
92	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	SC750 28C ECOFLEX	136	SC750 28C ECOFLEX	15198	SC750 28C ECOFLEX	QR Solutions
93	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	Scrubber Rider	157	Scrubber Rider	15204	Scrubber Rider	QR Solutions
94	Profit and Loss	Revenue	Income	SalesOfProductIncome	Shipping Income	195	Shipping Income	40312	Shipping Income	QR Solutions
95	Profit and Loss	Expense	Expense	OfficeGeneralAdministrativeExpenses	Social Responsibility	217	Social Responsibility	60299	Social Responsibility	QR Solutions
96	Profit and Loss	Revenue	Income	SalesOfProductIncome	Rental Income	188	Supplies and Sundries Income	40315	Supplies and Sundries Income	QR Solutions
97	Balance Sheet	Asset	Fixed Asset	MachineryAndEquipment	Sweeper IPC Eagle	158	Sweeper IPC Eagle	15210	Sweeper IPC Eagle	QR Solutions
98	Profit and Loss	Revenue	Income	DiscountsRefundsGiven	Tax Reimbursement	72	Tax Reimbursement	40318	Tax Reimbursement	QR Solutions
99	Profit and Loss	Expense	Expense	CostOfLabor	Trailer clean	86	Trailer clean	60309	Trailer clean	QR Solutions
100	Profit and Loss	Expense	Expense	UnappliedCashBillPaymentExpense	Software Licensing Fees	71	Unapplied Cash Bill Payment Expense	60302	Unapplied Cash Bill Payment Expense	QR Solutions