Ashbourne Industries, Inc.

2020 Monthly TrIal Balance

Summary
Code Description Total
10000 Assets 1,263,879,322
20000 Liabilities & Equity 1,263,879,320
30000 Revenue 988,385,863
40000 to 80000 Expenses 837,023,600

Account Name
Step 1
11210 Master Cash A
Hide columns Jan - Nov - remember we only need to use data
from December 11600 Investments
12100 Trade Account
Step 2 12610 Misc A/R
Populate the summary table in columns B-D - use a ‘SUM’ 12614 A/R-Refundabl
formula for the accounts with the relevant codes 14100 Raw Materials
14123 Raw Materials
Step 3
Now let’s calculate the pre-tax income - as this is what we’ll use to 14200 Work In Progr
figure out our $ Materiality threshold. 14212 WIP - LIFO Re
Calculate NET INCOME (Revenue less Expenses) = -12 816 420 14310 Finished Good
Calculate TAXES (add up line items 81000 and 82000)= 53 985 14311 Finished Good
885 14315 Finished Good
Pre-tax income = NET INCOME + TAXES = 41 169 465
14410 Supply Invent
Step 4 15020 Investment In GRG
Find 1% of the pre-tax income - this is our $ materiality = 411 694 15100 Prepaid Asset
15120 PPD Ins - Pro
Step 5 15123 PPD Ins - Gen
Figure out if each account is higher or lower than the $ materiality. 15140 Prepaid Rent
All accounts higher than this figure are considered material. You
15145 Prepaid Railc
can use an ‘IF’ formula to help you. : DONE
15170 Deferred Tax
15180 Deferred Fina
15230 Deposits - Mi
15300 Deferred Stri
16010 Depletable La
16015 Reclamation
16020 Land
16030 Land Improvem
16035 Mineral Right
16040 Buildings
16050 Machinery & E
16060 Trucks & Auto
16070 Furniture & F
16090 Leasehold Imp
16100 Construction
19200 Notes Receiva
19293 Notes Receiva
19300 Other Assets
19310 Deferred Stri
19510 Deferred Fina
19520 Patents
19540 Goodwill
19550 ASB technoogy investment
19560 Intangible - C
19580 Intangible - E
22100 Accrued Trade
22601 Sales Tax Pay
22710 Accrued Feder
22720 Accr. State I
29145 Treasury Stoc
29205 Retained Earn
29215 Dividends/Dis
30515 Commission Ex
30531 Transportatio
31011 Sales-C
36002 Allowances an
41100 COGS - Standa
41101 COGS - Standa
41105 COGS-Std. Dir
41150 COGS - Standa
41170 COGS - Supers
41180 COGS - Bio Se
41190 COGS - Frt Co
41310 COGS - Price
41320 COGS - Inv. L
50115 Raw Material
50130 Raw Material-
50200 Material Cost
50310 Resins
50320 Additives
51100 Production La
51150 Production La
51155 Production La
51156 Production La
51158 Safety Bonus
51200 Maintenence L
51250 Maintenance L
51256 Maintenance L
51511 Fringe - Work
51512 Fringe - Heal
51513 Fringe - Pens
51514 Fringe - FICA
51516 Fringe - 401K
51600 Contract Serv
51604 Contract Serv
51608 Contract Serv
51611 Contract Serv
53100 Electric Powe
53200 Dryer Fuel
54200 Bags
54300 Pallets
55100 Other Product
55110 Other Prod Su
55140 Other Prod Su
55200 Gas Oil & Gre
55300 Explosives
56000 Maintenence
57100 Amortization
57200 Royalties
57750 Miscellaneous
57800 Contract D
57850 Demurrage
57855 Demurrage - I
57856 Demurrage - T
57860 Penalties - T
58100 Personnel - O
58155 Personnel - O
58512 Fringe - Heal
58514 Fringe - FICA
59050 Plant Custodi
59110 Real Estate T
59200 Other Utiliti
59300 Rail Car Rent
59340 Railcar Other
59400 Rentals/Lease
59510 Depletion
59530 Depr. - Land
59535 Amort - Miner
59540 Depr. - Build
59550 Depr. - Machi
59590 Depr. - Lease
59700 Insurance
61100 Salaries - S
61155 Salaries - S
61511 Fringe - Work
61512 Fringe - Heal
61513 Fringe - Pens
61514 Fringe - FICA
61516 Fringe - 401K
62000 Professional
62010 Prof. Service
62020 Prof. Service
62030 Prof. Service
62100 Office Servic
62120 Office Servic
62270 Pers. Serv. -
62300 Advertising/P
62320 Trade Show Ex
62400 Communication
62500 Office Suppli
62510 Office Suppli
62710 T & E - Trave
62715 T & E - Lodgi
62720 T & E - Milea
62730 T & E - Auto
62740 T & E - Meals
62800 Rentals/Lease
63620 Amortization
63650 Amortization
63700 Insurance
63840 Misc. Expense
63850 Misc. Expense
66000 Managment Fee
73116 Minority Inte
73220 Misc. Other E
73221 Bad Debt Expense
73223 Non Recur
79011 Interest - Te
79015 Interest - Li
79022 Interest - Sw
81000 Federal Income Tax
82000 State Income Tax

0 0
DEC
11,258,045
10,283,165
138,207,286
1,893,119
7,162,743
7,882,178
7,275,630
24,576,311
786,985
3,309,431
174,017,144
1,436,237
1,443,372
3,208,597
546,774
632,202
481,708
998,277
1,083,412
11,747,872
5,261,694
768,178
4,688,476
157,193,459
2,680,250
12,298,726
23,577,937
74,809,940
89,738,431
430,981,609
1,133,273
1,424,317
9,484,608
112,818,718
4,520,273
1,086,325
 2,706,136
15,287,530
31,443,324
807,995
89,095,424
56,320,416
50,700,000
617,000
8,647,577
462,690
5,095,457
4,799,317
1,227,001,102
123,032,200
299,939,615
2,117,489
1,543,232
271,301,526
1,343,540
463,689,498
8,561,862
40,724,539
2,453,796
5,829,116
888,987
19,776,595
10,095,206
14,942,682
406,270,759
417,110
743,817
85,059,670
17,715,640
15,594,578
7,041,955
1,081,176
2,370,730
823,238
2,618,515
1,325,518
496,192
1,725,796
5,208,390
1,349,204
2,506,796
423,865
10,357,476
775,271
27,238,761
475,787
9,274,009
12,946,658
2,187,607
715,171
3,130,914
1,609,270
449,306
4,543,469
3,958,002
22,348,859
3,178,707
1,817,626
1,708,412
1,114,346
11,213,905
1,040,916
648,923
1,632,624
6,791,376
937,057
1,110,263
629,792
423,021
3,291,961
439,454
26,134,708
695,022
4,805,158
1,659,220
1,454,526
1,403,641
1,821,350
24,192,983
1,337,886
921,078
24,519,045
5,066,163
1,133,982
2,859,297
451,762
1,966,358
504,358
5,103,904
5,181,832
7,475,730
583,057
 489,722
577,271
478,494
983,573
1,038,450
1,262,200
792,702
497,877
2,586,648
1,359,970
708,398
727,821
1,384,783
1,120,725
6,600,840
1,690,000
1,637,973
2,430,473
1,802,412
2,820,977
695,999
895,272
2,219,030
21,334,427
50,303,675
1,135,850
5,208,746
50,629,854
3,329,031