Financial Report Sample Data.xlsx

	A	B	C	D
1	Account Number	Description	Category	Account Type
2	100000	Cash	Current Assets	Assets
3	100100	Accounts receivable	Current Assets	Assets
4	100200	Inventory	Current Assets	Assets
5	100300	Prepaid expenses	Current Assets	Assets
6	100400	Short-term investments	Current Assets	Assets
7	110000	Long-term investments	Fixed (Long-Term) Assets	Assets
8	110100	Property, plant, and equipment	Fixed (Long-Term) Assets	Assets
9	110200	(Less accumulated depreciation)	Fixed (Long-Term) Assets	Assets
10	110300	Intangible assets	Fixed (Long-Term) Assets	Assets
11	120000	Deferred income tax - AS	Other Assets	Assets
12	120100	Other Assets	Other Assets	Assets
13	200000	Accounts payable	Current Liabilities	Liabilities
14	200100	Short-term loans	Current Liabilities	Liabilities
15	200200	Income taxes payable	Current Liabilities	Liabilities
16	200300	Accrued salaries and wages	Current Liabilities	Liabilities
17	200400	Unearned revenue	Current Liabilities	Liabilities
18	200500	Current portion of long-term debt	Current Liabilities	Liabilities
19	210000	Long-term debt	Long-Term Liabilities	Liabilities
20	210100	Deferred income tax - L	Long-Term Liabilities	Liabilities
21	210200	Other Liabilities	Long-Term Liabilities	Liabilities
22	300000	Owner's investment	Owner's Equity	Owner's Equity
23	300100	Retained earnings	Owner's Equity	Owner's Equity
24	300200	Other	Owner's Equity	Owner's Equity
25	400000	Wholesale	Revenue	Revenues
26	400100	Distributor	Revenue	Revenues
27	400200	Export	Revenue	Revenues
28	500000	COS - Labor Burden	COGS	Expenses
29	500100	COS - Materials	COGS	Expenses
30	500200	COS - Subcontractors	COGS	Expenses
31	500300	COS - Equipment	COGS	Expenses
32	500400	COS - Other Costs	COGS	Expenses
33	500500	COS - Commissions	COGS	Expenses
34	500600	COS - Prize Fund	COGS	Expenses
35	500700	COS - Prize Fund Constr.	COGS	Expenses
36	500800	COS - Referral Fund	COGS	Expenses
37	500900	COS - Repair Fund	COGS	Expenses
38	510000	Expense re-imbursement	Other Expenses	Expenses
39	510100	Inactive Job Costs	Other Expenses	Expenses
40	510200	Auto Expense - Tolls/Parking	Other Expenses	Expenses
41	510300	Miscellaneous Const. Expenses	Other Expenses	Expenses
42	510400	Rental Yard/Storage	Other Expenses	Expenses
43	510500	Quality Assurance	Other Expenses	Expenses
44	510600	SPU Training	Other Expenses	Expenses
45	510700	Training Travel Expenses	Other Expenses	Expenses
46	510800	Share Of Corporate Overhead	Other Expenses	Expenses
47	510900	Showroom Amortization	Other Expenses	Expenses
48	520000	Payroll - Construction Admin	Payroll	Expenses
49	520100	P/R Taxes - Construction Admin	Payroll	Expenses
50	520200	Workers Comp - Const.Admin	Payroll	Expenses
51	520300	Health Insurance Const.Admin	Payroll	Expenses
52	520400	Payroll-Admin/Accounting	Payroll	Expenses
53	520500	Payroll Sales	Payroll	Expenses
54	520600	P/R - 401M Expense	Payroll	Expenses
55	520700	P/R Taxes Sales/Admin	Payroll	Expenses
56	530000	Liability Insurance	Insurance	Expenses
57	530100	Insurance - Auto/Property	Insurance	Expenses
58	530200	Insurance - Health	Insurance	Expenses
59	530300	Insurance - Liability/Umbrella	Insurance	Expenses
60	530400	Insurance - Life	Insurance	Expenses
61	530500	Insurance-Workers Comp	Insurance	Expenses
62	540000	Co-op Advertising fee	Marketing	Expenses
63	540100	Direct Advertising Expense	Marketing	Expenses
64	540200	Canvassing	Marketing	Expenses
65	540300	Home Show Branch Directed	Marketing	Expenses
66	540400	Sweepstakes Contributions	Marketing	Expenses
67	550000	Delivery / Postage	Office Supplies	Expenses
68	550100	Office Security	Office Supplies	Expenses
69	550200	Office Supplies	Office Supplies	Expenses
70	550300	Office Apparel	Office Supplies	Expenses
71	550400	Printing	Office Supplies	Expenses
72	560000	Truck Lease Interest (ENT)	Vehicle Leases	Expenses
73	560100	Truck Lease Insurance	Vehicle Leases	Expenses
74	560200	Truck Lease Maintenance	Vehicle Leases	Expenses
75	560300	Auto Milage Allow Mgmt	Vehicle Leases	Expenses
76	570000	T&E - Meals & Entertainment	Travel & Entertainment	Expenses
77	570100	T&E - Airfare	Travel & Entertainment	Expenses
78	570200	T&E - Lodging	Travel & Entertainment	Expenses
79	580000	Sales - Fleet Depreciation	Depreciation Expense	Expenses
80	580100	Depreciation Expense	Depreciation Expense	Expenses
81	590000	Rent/Lease Office Equipment	Renting Office Space	Expenses
82	590100	Rent - Office	Renting Office Space	Expenses
83	600000	Telecommunications	Telecommunications	Expenses
84	600100	Telecomm - Broadband	Telecommunications	Expenses
85	610000	Sealer Material	Equipment	Expenses
86	620000	Fuel Expense - Const.Admin	Fuel	Expenses
87	630000	Education	Employee Investment	Expenses
88	640000	Professional Fees - Legal	Professional Fees	Expenses
89	650000	Recruiting	Recruitment	Expenses
90	660000	Software Expense	Software	Expenses
91	670000	Utilities - Office	Offices Utilities	Expenses
92	710001	Cash receipts from customers	Cash receipts from	Operations
93	710002	Inventory purchases	Cash paid for	Operations
94	710003	General operating and administrative expenses	Cash paid for	Operations
95	710004	Wage expenses	Cash paid for	Operations
96	710005	Interest	Cash paid for	Operations
97	710006	Income taxes	Cash paid for	Operations
98	720001	Sale of property and equipment	Cash receipts from	Investing Activities
99	720002	Collection of principal on loans	Cash receipts from	Investing Activities
100	720003	Sale of investment securities	Cash receipts from	Investing Activities