Your Company Name
13957 South Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
--------------------------------------------------------------------------------------------------------------------------
| Sales | Sales | Average Daily Sales |Projected| Estimated Gross Profit
Department | M.T.D. % Sales | Y.T.D. % Sales | Goal Last MTD YTD | Sales | Last MTD Projected GP%
--------------------------------------------------------------------------------------------------------------------------
Full Service | 860.82 12.3% | 21856.05 16.1% | 393 0 287 420 | 8034 | 0 127 1182 14.72%
Self Service | 3389.67 48.3% | 86457.75 63.8% | 1814 0 1130 1663 | 31637 | 0 483 4504 14.24%
| | | | |
Tot. Gasoline| 4250.49 60.6% | 108313.80 80.0% | 2207 0 1417 2083 | 39671 | 0 609 5686 14.33%
Oil & A.T.F. | 385.00 5.5% | 1874.67 1.4% | 173 0 128 36 | 3593 | 0 199 1858 51.70%
Labor | 776.60 11.1% | 11326.37 8.4% | 411 0 259 218 | 7248 | 0 756 7060 97.40%
Parts | 378.97 5.4% | 8267.80 6.1% | 232 0 126 159 | 3537 | 0 147 1371 38.75%
Accessories | 50.75 0.7% | 275.42 0.2% | 27 0 17 5 | 474 | 0 22 207 43.67%
Misc shop sup| 0.00 0.0% | 585.00 0.4% | 0 0 0 11 | 0 | 0 0 0 25.50%
Sublet labor | 25.00 0.4% | 1750.04 1.3% | 14 0 8 34 | 233 | 0 8 70 30.00%
Tires | 163.73 2.3% | 552.83 0.4% | 89 0 55 11 | 1528 | 0 16 153 10.00%
Batteries | 173.75 2.5% | 491.75 0.4% | 18 0 58 9 | 1622 | 0 30 276 17.00%
Road Service | 56.50 0.8% | 633.75 0.5% | 30 0 19 12 | 527 | 0 11 105 20.00%
X-Sales tax | 48.00 0.7% | 599.73 0.4% | 0 0 16 12 | 448 | 0 0 0 0.00%
Vending | 78.50 1.1% | 137.05 0.1% | 39 0 26 3 | 733 | 0 10 95 13.00%
Food & Snacks| 59.85 0.9% | 59.85 0.0% | 32 0 20 1 | 559 | 0 16 154 27.50%
Cigarettes | 569.05 8.1% | 569.05 0.4% | 321 0 190 11 | 5311 | 0 25 230 4.33%
| | | | |
Total SOTG | 2765.70 39.4% | 27123.31 20.0% | 1387 0 922 522 | 25813 | 0 1240 11579 44.86%
Total Sales | 7016.19 100.0% | 135437.11 100.0% | 3594 0 2339 2605 | 65484 | 0 1850 17265 26.37%
Estimated operating expense | 711 2132 19900 30.39%-SL
Estimated net profit | -711 -282 -2635 -4.02%-SL
-----------------------------------------------------------------------------------------------------------------------------------
Average Daily Sales
| Gasoline Order | Full Service | Self Service | Total |
Product |On-Hand Order Out in| Last M.T.D. Y.T.D. Margin| Last M.T.D. Y.T.D. Margin| Last M.T.D. Y.T.D.|Projected
-----------------------------------------------------------------------------------------------------------------------------------
Super U/L | 1198 1016 9 days| 0.0 25.0 25.0 .1599 | 0.0 104.0 108.0 .1127 | 0.0 129.0 133.0| 3612.0
Regular | 4368 2855 10 days| 0.0 60.0 61.2 .1744 | 0.0 380.7 372.7 .1933 | 0.0 440.7 433.8| 12338.7
Unleaded | 4202 2490 10 days| 0.0 100.3 101.3 .1533 | 0.0 294.7 300.7 .1061 | 0.0 395.0 402.0| 11060.0
Diesel | 1488 1439 8 days| 0.0 37.7 45.3 .1461 | 0.0 133.0 130.4 .0990 | 0.0 170.7 175.8| 4778.7
| | | | |
Total | 11256 7800 8 days| 0.0 223.0 232.8 .1894 | 0.0 912.4 911.8 .1763 | 0.0 1135.4 1144.6|
Projected | | 6243.8 | 25546.2 | 31790.0
-----------------------------------------------------------------------------------------------------------------------------------
Pool margin : MTD $.1789 Pool margin (less credit card discount) : $.1757 S.O.T.G./1000 units : $811.96
-----------------------------------------------------------------------------------------------------------------------------------
Days in operation 3 M.T.D. 52 Y.T.D.
------------------------------------------------------
Checking and Receivables
------------------------------------------------------
Commercial Acc't - 123-4567-8 252.38
Misc. Account - 876-5432-1 1,833.40
----------------
Total Checking Account Balance $ 2,085.78
Current Accounts Receivable Balance $ 1,245.72
----------------
Total Cash and Receivables $ 3,331.50
------------------------------------- ================
Page ( 1 ) - Business Analysis Report
Back
Daily report
Your Company Name
13957 South Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
----------------------------------------------------------
Sales Summary Shift 1 Shift 2 Total
----------------------------------------------------------
Full Service 265.84 254.94 520.78
Self Service 1162.56 1082.00 2244.56
Total Gasoline 1428.40 1336.94 2765.34
Oil & A.T.F. 31.35 108.15 139.50
Labor 118.00 187.95 305.95
Parts 48.05 104.49 152.54
Accessories 4.95 14.00 18.95
Misc shop sup 0.00 0.00 0.00
Sublet labor 0.00 0.00 0.00
Tires 0.00 75.85 75.85
Batteries 47.50 126.25 173.75
Road Service 0.00 42.50 42.50
X-Sales tax 5.37 12.35 17.72
Vending 0.00 0.00 0.00
U-Haul rental 0.00 0.00 0.00
Food & Snacks 0.00 0.00 0.00
Cigarettes 174.80 108.30 283.10
Total sales 1858.42 2116.78 3975.20
Received on account 0.00 0.00
Cash on hand (open) 54.14 75.25
Credit cards (open) 2191.81 2851.27
TOTAL TO ACCOUNT FOR -> 4104.37 5043.30
Charge sales 25.00 167.25
Cash on hand (close) 75.25 75.12
Credit cards (close) 2851.27 3406.86
Paid out 1153.38 1395.14
TOTAL ACCOUNTED FOR -> 4104.90 5044.37
OVER / SHORT 0.53 1.07 1.60
Deposits Reference Credit cards By:
----------------------------------------------------------------------------------------------------------------------
Shift 1 425.99 123-4567-8 Bank Deposit (auto.) 536.75 Net Amount John Smith
500.00 876-5432-1 Bank Deposit (auto.) 126.50 Discounted
76.55 876-5432-1 Bank Deposit (auto.)
Shift 2 644.00 876-5432-1 Bank Deposit (auto.) 385.12 Net Amount Bill Jones
322.81 123-4567-8 Bank Deposit (auto.) 175.75 Discounted
325.55 123-4567-8 Bank Deposit (auto.)
Page ( 1 ) - 09/25/95 Daily report
Your Company Name
13957 South Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
---------------------------------------------------------------------------------------
- Paid out -
Invoice Date / Shift Emp Act# Category Paid to/Purpose Amount
---------------------------------------------------------------------------------------
12 09/25/95 / 1 1 1010 Computer Accnt. Bank Deposit (auto.) 425.99
13 09/25/95 / 1 1 1020 Manual Accnt. Bank Deposit (auto.) 500.00
14 09/25/95 / 1 1 1020 Manual Accnt. Bank Deposit (auto.) 76.55
15 09/25/95 / 1 1 5580 C.Card Discount Credit Card Discount 3.79
28 09/25/95 / 2 5 1020 Manual Accnt. Bank Deposit (auto.) 644.00
29 09/25/95 / 2 5 1010 Computer Accnt. Bank Deposit (auto.) 322.81
30 09/25/95 / 2 5 1010 Computer Accnt. Bank Deposit (auto.) 325.55
31 09/25/95 / 2 5 5580 C.Card Discount Credit Card Discount 5.27
4568 09/25/95 / 1 1 4008 Sublet labor Joe's Machine Shop 84.15
12708 09/25/95 / 1 1 4009 Tires Goodyear Tire store 60.45
25426 09/25/95 / 2 1 4005 Parts Oldsmobile Dealer 45.75
60466 09/25/95 / 2 1 5350 Uniforms Pro Uniform Company 44.91
458755 09/25/95 / 1 1 5600 Discounts other Bill's TV-Gas Discnt 2.45
480926 09/25/95 / 2 1 5140 Cleaning supply Seven-Eleven store 6.85
-------------------------------------------------------------------------------------------------------------------------
Invoice Date / Shift Emp Act#
Gasoline Oil & A. Labor Parts Accessor Misc sho Sublet l Tires Batterie Road Ser X-Sales Total
-------------------------------------------------------------------------------------------------------------------------
480941 09/25/95 / 2 7 1001 / Acme Products
9.00 28.00 68.75 17.50 0.30 123.55
-------------------------------------------------------------------------------------------------------------------------
693319 09/25/95 / 2 1 1005 / General Distributors
9.00 5.95 14.95
-------------------------------------------------------------------------------------------------------------------------
753476 09/25/95 / 2 1 2100 / Parkside Equipment, Inc.
6.00 14.00 8.75 28.75
-------------------------------------------------------------------------------------------------------------------------
753546 09/25/95 / 1 5 1012 / Local Hardware Store
21.40 3.60 25.00
-------------------------------------------------------------------------------------------------------------------------
146942 09/25/95 / 2 5 3 / Credit Card
15.00 17.60 1.06 33.66
-------------------------------------------------------------------------------------------------------------------------
146965 09/25/95 / 2 5 3 / Credit Card
32.00 44.62 1.40 78.02
-------------------------------------------------------------------------------------------------------------------------
693304 09/25/95 / 2 9 1 / Paid by Cash
8.00 57.50 25.00 3.45 93.95
-------------------------------------------------------------------------------------------------------------------------
693305 09/25/95 / 1 7 1 / Paid by Cash
5.00 84.00 48.05 2.88 139.93
-------------------------------------------------------------------------------------------------------------------------
693308 09/25/95 / 1 5 1 / Paid by Cash
14.00 47.50 2.49 63.99
-------------------------------------------------------------------------------------------------------------------------
693313 09/25/95 / 1 9 1 / Paid by Cash
4.95 4.95
-------------------------------------------------------------------------------------------------------------------------
Page ( 2 ) - 09/25/95 Daily report
Your Company Name
13957 South Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
-------------------------------------------------------------------------------------------------------------------------
Invoice Date / Shift Emp Act#
Gasoline Oil & A. Labor Parts Accessor Misc sho Sublet l Tires Batterie Road Ser X-Sales Total
-------------------------------------------------------------------------------------------------------------------------
693314 09/25/95 / 2 5 1 / Paid by Cash
40.00 9.30 0.90 50.20
-------------------------------------------------------------------------------------------------------------------------
693317 09/25/95 / 2 9 1 / Paid by Cash
45.00 32.97 75.85 5.24 159.06
-------------------------------------------------------------------------------------------------------------------------
753535 09/25/95 / 1 5 3 / Credit Card
20.00 20.00
-------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------
- Miscellaneous income -
Invoice Date / Shift Emp Acnt# Sales department Transaction Description Amount
------------------------------------------------------------------------------------------------------------
65 09/25/95 / 1 1 14 Food & Snacks Total sales for 09/25/95 Shift 2 59.85
98 09/25/95 / 2 1 12 Vending Pepsi machine sales 78.50
Page ( 3 ) - 09/25/95 Daily report
Your Company Name
13957 South Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
---------------------------------------------------------------------------------------------
Key item inventory report
No. Product Department Price Open Received Close Sales Units Dollars
---------------------------------------------------------------------------------------------
1 MOBIL I Oil & A.T.F. 4.25 4 120 119 5 21.25
2 10/40 oil Oil & A.T.F. 1.80 16 480 481 15 27.00
3 10/30 oil Oil & A.T.F. 1.70 8 72 73 7 11.90
4 H/D 30w Oil & A.T.F. 1.60 4 0 4 0 0.00
5 H-D 20w Oil & A.T.F. 1.60 0 0 0 0 0.00
6 Dextron qt Oil & A.T.F. 1.70 21 24 46 -1 -1.70
7 Type F qt. Oil & A.T.F. 1.70 32 24 49 7 11.90
8 Dextron pt Oil & A.T.F. 0.95 12 0 12 0 0.00
9 Type F pt. Oil & A.T.F. 0.95 1 0 1 0 0.00
10 A/F gal. Oil & A.T.F. 6.50 8 256 255 9 58.50
11 Wash Solv. Oil & A.T.F. 1.25 4 72 69 7 8.75
12
13 Heet Oil & A.T.F. 0.95 27 0 25 2 1.90
14
15 Brake Fld. Accessories 2.50 0 0 0 0 0.00
16
17
18
19
20 Cigarettes Cigarettes 0.95 2587 0 2289 298 283.10
21
22
23 Wiper Blds Accessories 5.25 36 0 35 1 5.25
24 Wiper arms Accessories 5.95 30 0 30 0 0.00
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
Page ( 4 ) - 09/25/95 Daily report
Your Company Name
13957 South Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
---------------------------------------------------------------------------------------------------------
Pump description Price/Cost Opening Closing Units / Amount
---------------------------------------------------------------------------------------------------------
Pump 1 Diesel Full Service Half price 1.248 Units 49714.0 49800.0 86.0
1.03800 Dollars 3183.43 3237.09 107.32
---------------------------------------------------------------------------------------------------------
Pump 2 Unleaded Full Service Half price 1.298 Units 38031.0 38181.0 150.0
1.08000 Dollars 8379.57 8476.52 193.90
---------------------------------------------------------------------------------------------------------
Pump 3 Super U/L Full Service Half price 1.358 Units 26033.0 26075.0 42.0
1.13000 Dollars 6907.35 6935.52 56.34
---------------------------------------------------------------------------------------------------------
Pump 4 Regular Full Service Half price 1.278 Units 67134.0 67263.0 129.0
1.04000 Dollars 9341.12 9422.73 163.22
---------------------------------------------------------------------------------------------------------
Pump 5 Unleaded Self Service Full price 1.248 Units 117.0 779.0 662.0
1.08000 Dollars 5561.00 6386.61 825.61
---------------------------------------------------------------------------------------------------------
Pump 6 Super U/L Self Service Full price 1.308 Units 1116.0 1314.0 198.0
1.13000 Dollars 6671.00 6929.94 258.94
---------------------------------------------------------------------------------------------------------
Pump 7 Regular Self Service Full price 1.228 Units 116.0 852.0 736.0
1.04000 Dollars 7782.00 8685.63 903.63
---------------------------------------------------------------------------------------------------------
Pump 8 Diesel Self Service Full price 1.198 Units 8888.0 9102.0 214.0
1.03800 Dollars 8895.00 9151.38 256.38
---------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------
Gasoline inventory Variance Current
Product Open Recv. Close Stick M.T.D. Today Full Serv Self Serv
-------------------------------------------------------------------------------
Super U/L 925 0 685 682 3- 3- 42.0 198.0
Regular 1,490 0 625 616 9- 9- 129.0 736.0
Unleaded 3,437 0 2,625 2,603 22- 22- 150.0 662.0
Diesel 1,000 0 700 699 1- 1- 86.0 214.0
Totals 6,852 0 4,635 4,600 35- 35- 407.0 1810.0
Gasoline value at cost 4,985.65 4,948.10 Totals : 2,217.0
Page ( 5 ) - 09/25/95 Daily report
Back
Cash receipts report
Your Company Name
13957 South Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
---------------------------------------------------------------------------------------------------------------------------------
Charge Cash Cr.cards Cash paid Bank Total Rec'd on Cash Cr.Cards Non-sales Over /
Date Sales close close out deposits sales account open open income short
(Dr) (Dr) (Dr) (Dr) (Dr) (Cr) (Cr) (Cr) (Cr) (Cr) (Dr/Cr)
---------------------------------------------------------------------------------------------------------------------------------
09/01/95 192.25 75.12 3406.86 253.62 2294.90 -3975.20 0.00 -54.14 -2191.81 0.00 1.60
09/02/95 261.41 75.00 4224.68 113.73 2099.49 -3040.99 -250.45 -75.12 -3406.86 0.00 0.89
09/03/95 0.00 75.00 4224.66 0.00 0.00 0.00 0.00 -75.00 -4224.66 0.00 0.00
------------------------------------------------------------------------------------------------------------------------
TOTALS 453.66 75.00 4224.66 367.35 4394.39 -7016.19 -250.45 -54.14 -2191.81 0.00 2.49
========================================================================================================================
Checking and Receivables
------------------------------------------------------
Commercial Acc't - 123-4567-8 252.38
Misc. Account - 876-5432-1 1,833.40
----------------
Total Checking Account Balance $ 2,085.78
Current Accounts Receivable Balance $ 1,245.72
----------------
Total Cash and Receivables $ 3,331.50
------------------------------------- ================
Page ( 1 ) - Cash receipts report
Back
Disbursement summary report Accounts 1000 through 9999
Your Company Name
13957 S. Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
-----------------------------------------------------------------------------------
Account Month to date activity
Number / Description Cash Check Payables Total % Sales
-----------------------------------------------------------------------------------
1010 Commercial Acct 200.00 0.00 0.00 200.00 51.1 %
1020 Misc. Account 0.00 0.00 0.00 0.00 0.0 %
1030 Oil Co. C.Cards 0.00 0.00 0.00 0.00 0.0 %
Sub-Totals 200.00 0.00 0.00 200.00 51.1 %
2000 Joe's Parts 0.00 0.00 0.00 0.00 0.0 %
2001 A/P Control 0.00 0.00 0.00 0.00 0.0 %
Sub-Totals 0.00 0.00 0.00 0.00 0.0 %
2100 Fed'L W/H 0.00 0.00 0.00 0.00 0.0 %
2110 S.S. W/H 0.00 0.00 0.00 0.00 0.0 %
2120 Medicare W/H 0.00 0.00 0.00 0.00 0.0 %
2130 State W/H 0.00 0.00 0.00 0.00 0.0 %
Sub-Totals 0.00 0.00 0.00 0.00 0.0 %
4001 Full Service 0.00 0.00 0.00 0.00 0.0 %
4002 Self Service 0.00 0.00 0.00 0.00 0.0 %
4003 Oil & A.T.F. 0.00 0.00 0.00 0.00 0.0 %
4004 Labor 0.00 0.00 0.00 0.00 0.0 %
4005 Parts 0.00 0.00 0.00 0.00 0.0 %
4006 Accessories 0.00 0.00 0.00 0.00 0.0 %
4007 Misc shop sup 0.00 0.00 0.00 0.00 0.0 %
4008 Sublet labor 0.00 0.00 0.00 0.00 0.0 %
4009 Tires 0.00 0.00 0.00 0.00 0.0 %
4010 Batteries 0.00 0.00 0.00 0.00 0.0 %
4011 Road Service 0.00 0.00 0.00 0.00 0.0 %
4012 X-Sales tax 0.00 0.00 0.00 0.00 0.0 %
4013 Vending 0.00 0.00 0.00 0.00 0.0 %
4014 U-Haul rental 0.00 0.00 0.00 0.00 0.0 %
4015 Food & Snacks 0.00 0.00 0.00 0.00 0.0 %
4016 Cigarettes 0.00 0.00 0.00 0.00 0.0 %
Sub-Totals 0.00 0.00 0.00 0.00 0.0 %
5000 Unemployment Tx 0.00 0.00 0.00 0.00 0.0 %
5020 FICA Match 0.00 0.00 0.00 0.00 0.0 %
5030 Medicare Match 0.00 0.00 0.00 0.00 0.0 %
5040 Licenses / Tax. 0.00 0.00 0.00 0.00 0.0 %
5050 Equipment rent 0.00 0.00 0.00 0.00 0.0 %
5060 Repair & Maint. 0.00 0.00 0.00 0.00 0.0 %
5070 Insurance 0.00 0.00 0.00 0.00 0.0 %
5080 Accounting fees 0.00 0.00 0.00 0.00 0.0 %
5090 Legal fees 0.00 0.00 0.00 0.00 0.0 %
Sub-Totals 0.00 0.00 0.00 0.00 0.0 %
5100 Interest charge 0.00 0.00 0.00 0.00 0.0 %
5110 Bank Serv. Chg. 0.00 0.00 0.00 0.00 0.0 %
5120 Bad debts 0.00 0.00 0.00 0.00 0.0 %
5140 Cleaning Supply 0.00 0.00 0.00 0.00 0.0 %
Sub-Totals 0.00 0.00 0.00 0.00 0.0 %
5350 Uniforms 0.00 0.00 0.00 0.00 0.0 %
Page ( 1 ) - Disbursement summary report Accounts 1000 through 9999
Your Company Name
13957 S. Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
-----------------------------------------------------------------------------------
Account Month to date activity
Number / Description Cash Check Payables Total % Sales
-----------------------------------------------------------------------------------
5555 Utilities 0.00 0.00 0.00 0.00 0.0 %
5580 CrCard Discount 0.00 0.00 0.00 0.00 0.0 %
5590 Discounts Other 0.00 0.00 0.00 0.00 0.0 %
Sub-Totals 0.00 0.00 0.00 0.00 0.0 %
5600 Gross Wages 0.00 0.00 0.00 0.00 0.0 %
5610 Overtime Wages 0.00 0.00 0.00 0.00 0.0 %
5620 Commission Paid 0.00 0.00 0.00 0.00 0.0 %
Sub-Totals 0.00 0.00 0.00 0.00 0.0 %
9999 Cash Shortages 0.00 0.00 0.00 0.00 0.0 %
Totals 200.00 0.00 0.00 200.00 51.1 %
Page ( 2 ) - Disbursement summary report Accounts 1000 through 9999
Your Company Name
13957 S. Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
--------------------------------------------------------------------------------------------------------
Account Year to date activity
Number / Description Cash Check Payables Balance forward Total % Sales
--------------------------------------------------------------------------------------------------------
1010 Commercial Acct 200.00 0.00 0.00 1100.00 1300.00 332.0 %
1020 Misc. Account 0.00 0.00 0.00 2000.00 2000.00 510.7 %
1030 Oil Co. C.Cards 0.00 0.00 0.00 7472.10- 7472.10- %1908.0-%
Sub-Totals 200.00 0.00 0.00 4372.10- 4172.10- %1065.4-%
2000 Joe's Parts 0.00 0.00 0.00 372.42- 372.42- 95.1-%
2001 A/P Control 0.00 0.00 0.00 1.00- 1.00- 0.3-%
Sub-Totals 0.00 0.00 0.00 373.42- 373.42- 95.4-%
2100 Fed'L W/H 0.00 0.00 0.00 1104.38- 1104.38- 282.0-%
2110 S.S. W/H 0.00 0.00 0.00 759.63- 759.63- 194.0-%
2120 Medicare W/H 0.00 0.00 0.00 177.66- 177.66- 45.4-%
2130 State W/H 0.00 0.00 0.00 320.11- 320.11- 81.7-%
Sub-Totals 0.00 0.00 0.00 2361.78- 2361.78- 603.1-%
4001 Full Service 0.00 0.00 0.00 -------- 0.00 0.0 %
4002 Self Service 0.00 0.00 0.00 -------- 0.00 0.0 %
4003 Oil & A.T.F. 0.00 0.00 0.00 -------- 0.00 0.0 %
4004 Labor 0.00 0.00 0.00 -------- 0.00 0.0 %
4005 Parts 0.00 0.00 0.00 -------- 0.00 0.0 %
4006 Accessories 0.00 0.00 0.00 -------- 0.00 0.0 %
4007 Misc shop sup 0.00 0.00 0.00 -------- 0.00 0.0 %
4008 Sublet labor 0.00 0.00 0.00 -------- 0.00 0.0 %
4009 Tires 0.00 0.00 0.00 -------- 0.00 0.0 %
4010 Batteries 0.00 0.00 0.00 -------- 0.00 0.0 %
4011 Road Service 0.00 0.00 0.00 -------- 0.00 0.0 %
4012 X-Sales tax 0.00 0.00 0.00 -------- 0.00 0.0 %
4013 Vending 0.00 0.00 0.00 -------- 0.00 0.0 %
4014 U-Haul rental 0.00 0.00 0.00 -------- 0.00 0.0 %
4015 Food & Snacks 0.00 0.00 0.00 -------- 0.00 0.0 %
4016 Cigarettes 0.00 0.00 0.00 -------- 0.00 0.0 %
Sub-Totals 0.00 0.00 0.00 0.00 0.00 0.0 %
5000 Unemployment Tx 0.00 0.00 0.00 -------- 0.00 0.0 %
5020 FICA Match 0.00 0.00 0.00 -------- 0.00 0.0 %
5030 Medicare Match 0.00 0.00 0.00 -------- 0.00 0.0 %
5040 Licenses / Tax. 0.00 0.00 0.00 -------- 0.00 0.0 %
5050 Equipment rent 0.00 0.00 0.00 -------- 0.00 0.0 %
5060 Repair & Maint. 0.00 0.00 0.00 -------- 0.00 0.0 %
5070 Insurance 0.00 0.00 0.00 -------- 0.00 0.0 %
5080 Accounting fees 0.00 0.00 0.00 -------- 0.00 0.0 %
5090 Legal fees 0.00 0.00 0.00 -------- 0.00 0.0 %
Sub-Totals 0.00 0.00 0.00 0.00 0.00 0.0 %
5100 Interest charge 0.00 0.00 0.00 -------- 0.00 0.0 %
5110 Bank Serv. Chg. 0.00 0.00 0.00 -------- 0.00 0.0 %
5120 Bad debts 0.00 0.00 0.00 -------- 0.00 0.0 %
5140 Cleaning Supply 0.00 0.00 0.00 -------- 0.00 0.0 %
Sub-Totals 0.00 0.00 0.00 0.00 0.00 0.0 %
5350 Uniforms 0.00 0.00 0.00 -------- 0.00 0.0 %
Page ( 3 ) - Disbursement summary report Accounts 1000 through 9999
Your Company Name
13957 S. Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
--------------------------------------------------------------------------------------------------------
Account Year to date activity
Number / Description Cash Check Payables Balance forward Total % Sales
--------------------------------------------------------------------------------------------------------
5555 Utilities 0.00 0.00 0.00 -------- 0.00 0.0 %
5580 CrCard Discount 0.00 0.00 0.00 -------- 0.00 0.0 %
5590 Discounts Other 0.00 0.00 0.00 -------- 0.00 0.0 %
Sub-Totals 0.00 0.00 0.00 0.00 0.00 0.0 %
5600 Gross Wages 0.00 0.00 0.00 -------- 0.00 0.0 %
5610 Overtime Wages 0.00 0.00 0.00 -------- 0.00 0.0 %
5620 Commission Paid 0.00 0.00 0.00 -------- 0.00 0.0 %
Sub-Totals 0.00 0.00 0.00 0.00 0.00 0.0 %
9999 Cash Shortages 0.00 0.00 0.00 -------- 0.00 0.0 %
Totals 200.00 0.00 0.00 7107.30- 6907.30- %1763.8-%
Page ( 4 ) - Disbursement summary report Accounts 1000 through 9999
Back
Accounts Receivable Aging report
Your Company Name
13957 South Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
-----------------------------------------------------------------------------------------------------------------------------------
Account No. / Name Phone number / Ext. Last Mo. 1 Mo.Old 2 Mo.Old 3 Mo.Old 4 Mo.Old 5+Mo.Old Balance Late
-----------------------------------------------------------------------------------------------------------------------------------
133 Mr. John Adams (312) 851-4440 X 451
1001 Acme Products ( ) 123-4567 123.55 379.55 626.65 0.6
1005 General Distributors ( ) 123-4567 14.95
1006 Bill's Television Repair ( ) 123-4567 122.25
1012 Local Hardware Store ( ) 123-4567 45.00 375.66 465.66 0.8
2050 Corner Pizza ( ) 123-4567 90.10 36.85 216.50 0.9
2100 Parkside Equipment, Inc. ( ) 123-4567 42.61 100.97
9998 Work In Progress ( ) -
9999 Miscellaneous And Temp. ( ) -
.........................................................................................................................
: Gasoline: Oil : Labor : Parts : Accessor: Misc sho: Sublet l: Tires : Batterie: Road Ser: X-Sales : Total:
.........................................................................................................................
MTD : 72.60: 22.85: 131.85: 32.68: 8.75: : : 87.88: 68.75: 17.50: 10.80: 453.66: MTD
MTD%: 16.0%: 5.0%: 29.1%: 7.2%: 1.9%: : : 19.4%: 15.2%: 3.9%: 2.4%: 100.0%: MTD%
.........................................................................................................................
YTD : 72.60: 22.85: 131.85: 32.68: 8.75: : : 87.88: 68.75: 17.50: 10.80: 453.66: YTD
YTD%: 16.0%: 5.0%: 29.1%: 7.2%: 1.9%: : : 19.4%: 15.2%: 3.9%: 2.4%: 100.0%: YTD%
.........................................................................................................................
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Last month 1 Mo. Old 2 Mo. Old 3 Mo. Old 4 Mo. Old 5+Mo. Old
551.71 755.21 0.00 0.00 0.00 36.85
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Prior balance: 1,343.77+
Total payments: 250.45-
Total sales: 453.66+
Total receivables: 1,546.98+ as of 03/03/83
+++++++++++++++++++++++++++++++++++++++++++++++++
Page ( 1 ) - Accounts Receivable Aging report
Back
Employee Commission Report
Your Company Name
13957 South Kostner Avenue Date : Monday, September 25, 1995
Crestwood, IL 60445
---------------------------------------------------------------------------------------------------------------------------------
Gasoline Oil & A. Labor Parts Accessor Misc sho Sublet l Tires Batterie Road Ser X-Sales Total
---------------------------------------------------------------------------------------------------------------------------------
Employee # 1 - John Smith
Current 44.00 43.80 111.80 48.10 17.40 0.00 0.00 87.88 0.00 14.00 13.62 380.60
M.T.D. 6.00 21.00 75.80 6.80 17.40 0.00 0.00 87.88 0.00 14.00 10.18 239.06
C.Y.T.D. 769.70 133.70 388.51 369.85 25.15 0.00 664.45 257.40 0.00 129.00 41.85 2779.61
F.Y.T.D. 769.70 133.70 388.51 369.85 25.15 0.00 664.45 257.40 0.00 129.00 41.85 2779.61
.................................................................................................................................
Total commission due # 1 - John Smith
Comm due 0.88 6.39 37.26 4.81 1.74 0.00 0.00 2.93 0.00 1.40 0.00 55.41
=================================================================================================================================
Employee # 5 - Bill Jones
Current 93.10 126.10 822.77 915.76 0.00 50.00 14.00 0.00 47.50 27.50 64.77 2161.50
M.T.D. 53.60 28.25 212.95 216.39 0.00 0.00 0.00 0.00 47.50 0.00 18.59 577.28
C.Y.T.D. 272.44 403.16 4742.15 4474.32 16.40 50.00 377.00 0.00 172.00 189.50 295.14 10992.11
F.Y.T.D. 272.44 403.16 4742.15 4474.32 16.40 50.00 377.00 0.00 172.00 189.50 295.14 10992.11
.................................................................................................................................
Total commission due # 5 - Bill Jones
Comm due 1.86 18.41 274.23 91.58 0.00 2.50 1.40 0.00 1.58 2.75 0.00 394.31
=================================================================================================================================
Employee # 7 - Tom Adams
Current 87.75 184.20 1082.20 653.89 20.20 0.00 32.50 55.13 68.75 54.00 46.39 2285.01
M.T.D. 31.45 31.00 399.90 115.13 11.25 0.00 25.00 0.00 68.75 17.50 9.12 709.10
C.Y.T.D. 276.05 580.69 5202.64 2698.73 211.57 535.00 688.65 55.13 214.50 237.25 197.35 10897.56
F.Y.T.D. 276.05 580.69 5202.64 2698.73 211.57 535.00 688.65 55.13 214.50 237.25 197.35 10897.56
.................................................................................................................................
Total commission due # 7 - Tom Adams
Comm due 1.76 26.89 360.70 65.39 2.02 0.00 3.25 1.84 2.29 5.40 0.00 469.53
=================================================================================================================================
Employee # 9 - Ray Davis
Current 42.40 68.00 247.75 105.51 4.94 0.00 0.00 89.84 57.50 36.00 19.39 671.33
M.T.D. 0.00 9.00 87.95 40.65 4.94 0.00 0.00 75.85 57.50 25.00 10.11 311.00
C.Y.T.D. 428.90 329.18 993.15 724.94 5.15 0.00 19.95 240.33 105.25 78.00 73.62 2998.47
F.Y.T.D. 428.90 329.18 993.15 724.94 5.15 0.00 19.95 240.33 105.25 78.00 73.62 2998.47
.................................................................................................................................
Total commission due # 9 - Ray Davis
Comm due 0.85 9.93 82.58 10.55 0.49 0.00 0.00 2.99 1.91 3.60 0.00 112.90
=================================================================================================================================
Grand Total
Current 267.25 422.10 2264.52 1723.26 42.54 50.00 46.50 232.85 173.75 131.50 144.17 5498.44
Comm due 5.35 61.63 754.76 172.33 4.25 2.50 4.65 7.75 5.79 13.15 0.00 1032.16
Page ( 1 ) - Employee Commission Report
Back
Payroll
:Your Company Name CHECK 1246
Bill Jones SS# 222-22-2222
This pay check: Hours Amount Year to date: Hours Amount
09/22/95 5600 Reg. Hrs.= 38.750 339.06 398.750 2409.06
09/22/95 5610 O.T. Hrs.= 0.000 0.00 34.750 144.48
09/22/95 5620 Commission 394.31 788.62
09/22/95 2100 Fed'l Withholding -48.27 -208.19
09/22/95 2110 Soc. Security -45.47 -207.22
09/22/95 2120 Medicare -10.63 -48.45
09/22/95 2130 State Withholding -18.54 -70.41
09/22/95 5350 Uniforms -7.15 -71.50
09/22/95 5600 Group insurance -10.00 -10.00
09/22/95 5800 Beeper -2.00 -2.00
CHECK DATE CONTROL NUMBER
09/22/95 1246 TOTALS 591.31
YOUR COMPANY NAME
13957 S. Kostner Avenue 1st State Bank
Crestwood, IL 60445 Crestwood, IL 60445
Five Hundred Ninety-One and 31/100 Dollars
Bill Jones
09/22/95 1246 *******$591.31
PAY Bill Jones
TO THE 1019 Elm Street
ORDER OF Your Town, USA
Payroll check SS# 222-22-2222
Back
Invoice
Your Company Name
13957 S Kostner Avenue
Crestwood, IL 60445
(708) 371-6555
ACCOUNT DATE
1015 02/28/98
Bill's Engineering
11233 Any Street 02/28/98
Your Town, Us 11111
Last Mo. 1 Month 2 Month 3 Month 4 Month 5+Month
141.10
AMOUNT ENCLOSED $_____________________
PLEASE RETURN ABOVE PORTION WITH YOUR REMITTANCE REMITTANCE
DATE INVOICE NO. CHARGES CREDITS BALANCE
01/27/98 19388 2352.30+ Applied
Your PO# 232989
02/02/98 19461 1639.42+ Applied
Your PO# 233100
02/05/95 19472 344.41+
Your PO# 233173
02/07/98 19488 142.64+
Your PO# 233221
02/09/98 18498 1253.91+
Your PO# 233298
02/20/98 12545 Payment 3,991.72- Applied
Total - Remit this amount to pay in full -> 3,011.76+
Prompt payment 3,011.76+
ensures good credit! PLEASE PAY THIS AMOUNT
Back