10 Column Worksheet

Description

10 Column Worksheet document sample

Document Sample
scope of work template
							                    A                    B               C           D   E            F        G                H          I           J             K           L             M
 1   Name:
 2                                                                                        Mini-Practice Set 2
 3                                                                                            Worksheet
 4
 5                                                                                         Bargain Buys
 6                                                                                          Work Sheet
 7                                                                               For Month Ended October 31, 2007
 8                                          Trial Balance                      Adjustments                   Adj. T/Balance           Income Statement             Balance Sheet
 9     Account Title                     Dr.              Cr.            Dr.                Cr.           Dr.              Cr.        Dr.           Cr.          Dr.           Cr.
10   Cash                               49,025.58                                                        49,025.58             0.00                             49,025.58          0.00
11   Accts Receivable                   12,554.75                                                        12,554.75             0.00                             12,554.75          0.00
12   Allowance for Doubtful Accounts                        420.00                                             0.00          420.00                                  0.00        420.00
13   Merchandise Inventory              88,996.00                                                        88,996.00             0.00                             88,996.00          0.00
14   Supplies                            5,250.00                                                         5,250.00             0.00                              5,250.00          0.00
15   Prepaid Insurance                   8,400.00                                                         8,400.00             0.00                              8,400.00          0.00
16   Prepaid Advertising                 2,800.00                                                         2,800.00             0.00                              2,800.00          0.00
17   Equipment                          83,000.00                                                        83,000.00             0.00                             83,000.00          0.00
18   Accum depn - Equip.                                  7,050.00                                             0.00        7,050.00                                  0.00      7,050.00
19   Accounts Payable                                     5,090.00                                             0.00        5,090.00                                  0.00      5,090.00
20   Social Security Tax Payable                          1,404.00                                             0.00        1,404.00                                  0.00      1,404.00
21   Medicare Tax Payable                                   324.00                                             0.00          324.00                                  0.00        324.00
22   Employee Income Tax Payable                          1,020.00                                             0.00        1,020.00                                  0.00      1,020.00
23   FUTA                                                   630.00                                             0.00          630.00                                  0.00        630.00
24   SUTA                                                 1,852.00                                             0.00        1,852.00                                  0.00      1,852.00
25   Salaries Payable                                         0.00                                             0.00            0.00                                  0.00          0.00
26   Sales Tax Payable                                    3,277.75                                             0.00        3,277.75                                  0.00      3,277.75
27   J. Jackson, Capital                               203,252.00                                              0.00      203,252.00                                  0.00    203,252.00
28   J. Jackson, Drawing                 6,000.00                                                         6,000.00             0.00                              6,000.00          0.00
29   Income Summary                           0.00            0.00                                             0.00            0.00        0.00         0.00
30   Sales                                              66,155.00                                              0.00       66,155.00        0.00    66,155.00
31   Sales Returns & Allowances            600.00                                                            600.00            0.00      600.00         0.00
32   Purchases                          15,090.00                                                        15,090.00             0.00   15,090.00         0.00
33   Freight In                            300.00                                                            300.00            0.00      300.00         0.00
34   Purchases Returns & Allowances                         430.00                                             0.00          430.00        0.00       430.00
35   Purchases Discounts                                    462.58                                             0.00          462.58        0.00       462.58
36   Advertising Expense                 2,000.00                                                         2,000.00             0.00    2,000.00         0.00
37   Depreciation Expense - Equip.            0.00                                                             0.00            0.00        0.00         0.00
38   Insurance Expense                        0.00                                                             0.00            0.00        0.00         0.00
39   Uncollectible Accounts Expense           0.00                                                             0.00            0.00        0.00         0.00
40   Janitorial Services Expense           200.00                                                            200.00            0.00      200.00         0.00
41   Payroll Taxes Expense               1,566.00                                                         1,566.00             0.00    1,566.00         0.00
42   Rent Expense                        3,500.00                                                         3,500.00             0.00    3,500.00         0.00
43   Salaries Expense                   10,800.00                                                        10,800.00             0.00   10,800.00         0.00
44   Supplies Expense                         0.00                                                             0.00            0.00        0.00         0.00
45   Telephone Expense                     480.00                                                            480.00            0.00      480.00         0.00
46   Utilities Expense                     805.00                                                            805.00            0.00      805.00         0.00
47                                     291,367.33      291,367.33
48
49
50
51     Totals                                                                  0.00                0.00    291,367.33   291,367.33    35,341.00    67,047.58   256,026.33    224,319.75
52     Net Income                                                                                                                     31,706.58         0.00         0.00     31,706.58
53   Final Totals                                                                                                                     67,047.58    67,047.58   256,026.33    256,026.33
54

						
Related docs