Filter Criteria includes: Report order is by ID.
Employee ID Employee Address line 1 Address line 2 City ST ZIP Masked SS No Fed Filing Status Pay Type
C50 Rick Copley 10345 Atlantic Lane Norcross, GA 30092 XXX-XX-0003 Single Hourly
M60 Mae Mandette 201 Wingate Avenue Norcross, GA 30092 XXX-XX-0001 Single Hourly
Student Name Sales and Service
Employee List
Filter Criteria includes: Report order is by ID. Report is printed in Detail Format.
Customer ID Customer Date Trans No Type Debit Amt Credit Amt Balance
ac001 Abby Caron 1/7/19 101 SJ 459.00 459.00
ac001 Abby Caron 1/10/19 CM101 SJ 91.80 367.20
ac001 Abby Caron 1/10/19 Invoice 101 CRJ 367.20 0.00
bb002 Bobby Berman 1/7/19 102 SJ 486.00 486.00
bb002 Bobby Berman 1/14/19 Invoice 102 CRJ 486.00 0.00
rn003 Roberta Norton 1/7/19 103 SJ 972.00 972.00
rn003 Roberta Norton 1/30/19 Invoice 103 CRJ 972.00 0.00
Report Total 1,917.00 1,917.00 0.00
Student Name Sales and Service
Customer Ledgers
For the Period From Jan 1, 2019 to Jan 31, 2019
5/14/2020 at 10:52 PM Page: 2
Filter Criteria includes: Report order is by ID.
Vendor ID Vendor Date Trans No Type Paid Debit Amt Credit Amt Balance
CPT12 Charles Peterson Tools 1/4/19 480CP PJ * 300.00 300.00
CPT12 Charles Peterson Tools 1/6/19 VCM480CP PJ * 60.00 240.00
CPT12 Charles Peterson Tools 1/11/19 2021 CDJ 4.80 4.80 240.00
CPT12 Charles Peterson Tools 1/11/19 2021 CDJ 240.00 0.00
CPT12 Charles Peterson Tools 1/28/19 732CP PJ 240.00 240.00
SJH14 Sheila Johnson Hardware 1/4/19 SJH52 PJ * 400.00 400.00
SJH14 Sheila Johnson Hardware 1/11/19 2020 CDJ 8.00 8.00 400.00
SJH14 Sheila Johnson Hardware 1/11/19 2020 CDJ 400.00 0.00
Report Total 712.80 952.80 240.00
Student Name Sales and Service
Vendor Ledgers
For the Period From Jan 1, 2019 to Jan 31, 2019
5/14/2020 at 10:52 PM Page: 3
Filter Criteria includes: 1) Stock/Assembly. Report order is by ID. Report is printed with shortened descriptions.
Item ID Item Class Item Description Stocking U/M Cost Method Qty on Hand Item Value Avg Cost % of Inv Value
002tools Stock item tools each Average 160.00 4,800.00 30.00 36.23
003hardware Stock item hardware each Average 169.00 8,450.00 50.00 63.77
13,250.00 100.00
Student Name Sales and Service
Inventory Valuation Report
As of Jan 31, 2019
Filter Criteria includes: Report order is by Check Date. Report is printed in Detail Format.
Date Employee GL Acct ID Reference Debit Amt Credit Amt
1/4/19 Rick Copley 77500 6050 500.00
1/4/19 Rick Copley 23400 6050 48.39
1/4/19 Rick Copley 24000 6050 31.00
1/4/19 Rick Copley 24200 6050 7.25
1/4/19 Rick Copley 23600 6050 20.58
1/4/19 Rick Copley 10300 6050 392.78
1/4/19 Mae Mandette 77500 6051 500.00
1/4/19 Mae Mandette 23400 6051 48.39
1/4/19 Mae Mandette 24000 6051 31.00
1/4/19 Mae Mandette 24200 6051 7.25
1/4/19 Mae Mandette 72545 6051 0.40
1/4/19 Mae Mandette 10300 6051 392.78
1/11/19 Rick Copley 77500 6052 500.00
1/11/19 Rick Copley 23400 6052 48.39
1/11/19 Rick Copley 24000 6052 31.00
Student Name Sales and Service
Payroll Journal
For the Period From Jan 1, 2019 to Jan 31, 2019
Date Employee GL Acct ID Reference Debit Amt Credit Amt
1/11/19 Rick Copley 24400 6052 7.25
1/11/19 Rick Copley 23500 6052 3.00
1/11/19 Rick Copley 23700 6052 17.00
1/11/19 Rick Copley 23755 6052 0.40
1/11/19 Rick Copley 72510 6052 31.00
1/11/19 Rick Copley 72520 6052 7.25
1/11/19 Rick Copley 72530 6052 3.00
1/11/19 Rick Copley 72540 6052 17.00
1/11/19 Rick Copley 72545 6052 0.40
1/11/19 Rick Copley 10300 6052 392.78
1/11/19 Mae Mandette 72510 6053 31.00
1/11/19 Mae Mandette 72520 6053 7.25
1/11/19 Mae Mandette 72530 6053 3.00
1/11/19 Mae Mandette 72540 6053 17.00
1/11/19 Mae Mandette 72545 6053 0.40
1/18/19 Rick Copley 23755 6054 0.40
1/18/19 Rick Copley 72510 6054 31.00
1/18/19 Rick Copley 72520 6054 7.25
1/18/19 Rick Copley 72530 6054 3.00
1/18/19 Rick Copley 72540 6054 17.00
Date Employee GL Acct ID Reference Debit Amt Credit Amt
1/18/19 Mae Mandette 23400 6055 48.39
1/18/19 Mae Mandette 24000 6055 31.00
1/18/19 Mae Mandette 24200 6055 7.25
1/18/19 Mae Mandette 23600 6055 20.58
1/18/19 Mae Mandette 24100 6055 31.00
1/18/19 Mae Mandette 24400 6055 7.25
1/18/19 Mae Mandette 23500 6055 3.00
1/18/19 Mae Mandette 23700 6055 17.00
1/18/19 Mae Mandette 23755 6055 0.40
1/18/19 Mae Mandette 72510 6055 31.00
1/25/19 Rick Copley 24100 6056 31.00
1/25/19 Rick Copley 24400 6056 7.25
1/25/19 Rick Copley 23500 6056 3.00
1/25/19 Rick Copley 23700 6056 17.00
1/25/19 Rick Copley 23755 6056 0.40
1/25/19 Mae Mandette 23600 6057 20.58
1/25/19 Mae Mandette 24100 6057 31.00
1/25/19 Mae Mandette 24400 6057 7.25
1/25/19 Mae Mandette 23500 6057 3.00
1/25/19 Mae Mandette 23700 6057 17.00
Date Employee GL Acct ID Reference Debit Amt Credit Amt
1/25/19 Mae Mandette 72530 6057 3.00
1/25/19 Mae Mandette 72540 6057 17.00
1/25/19 Mae Mandette 72545 6057 0.40
1/25/19 Mae Mandette 10300 6057 392.78
4,469.20 4,469.20
5/14/2020 at 10:52 PM Page: 8
Filter Criteria includes: Report order is by ID. Report is printed in Detail Format.
Account ID Account Description Debit Amt Credit Amt
10200 Boulevard Bank 68,008.63
10300 Payroll Checking Account 2,292.76
10400 Enterprise Savings & Loan 13,300.00
23600 State Payroll Taxes Payable 164.64
23700 SUTA Payable 136.00
23755 SUTA2 Payable 3.20
24000 Soc. Sec. Employee Taxes Payab 248.00
24100 Soc. Sec. Employer Taxes Payab 248.00
59500 Purchase Discounts 12.80
62000 Bank Charges 27.00
70000 Maintenance Expense 125.00
71000 Office Expense 145.72
72510 Soc. Sec. Expense 248.00
Student Name Sales and Service
General Ledger Trial Balance
As of Jan 31, 2019
Account ID Account Description Debit Amt Credit Amt
76000 Telephone Expense 46.65
77500 Wages Expense 4,000.00
Total: 201,889.96 201,889.96
ASSETS
Current Assets
Boulevard Bank 68,008.63$
Payroll Checking Account 2,292.76
Property and Equipment
Furniture and Fixtures 3,500.00
Computers & Equipment 5,500.00
Building 85,000.00
Total Property and Equipment 94,000.00
Student Name Sales and Service
Balance Sheet
January 31, 2019
Federal Payroll Taxes Payable 387.12
FUTA Tax Payable 24.00
State Payroll Taxes Payable 164.64
SUTA Payable 136.00
SUTA2 Payable 3.20
Soc. Sec. Employee Taxes Payab 248.00
Soc. Sec. Employer Taxes Payab 248.00
Medicare Employee Taxes Payabl 58.00
Medicare Employer Taxes Payabl 58.00
Total Current Liabilities 2,112.16
Long-Term Liabilities
Long-Term Notes Payable 10,000.00
Mortgage Payable 60,000.00
Current
Month Year to
Date
Revenues
Sales-Hardware 4,350.00$ 63.83 4,350.00$ 63.83
Sales-Tools 2,465.00 36.17 2,465.00 36.17
Total Revenues 6,815.00 100.00 6,815.00 100.00
Cost of Sales
Cost of Sales-Hardware 1,450.00 21.28 1,450.00 21.28
Cost of Sales-Tools 930.00 13.65 930.00 13.65
Purchase Discounts (12.80) (0.19) (12.80) (0.19)
Total Cost of Sales 2,367.20 34.74 2,367.20 34.74
Wages Expense 4,000.00 58.69 4,000.00 58.69
Total Expenses 4,858.57 71.29 4,858.57 71.29
Student Name Sales and Service
Income Statement
For the One Month Ending January 31, 2019
5/14/2020 at 10:52 PM For Management Purposes Only
Current
Month Year to
Date
Net Income 410.77)($ (6.03) 410.77)($ (6.03)
5/14/2020 at 10:52 PM For Management Purposes Only
Current
Month Year to
Date
Cash Flows from operating activities
Net Income 410.77)($ 410.77)($
Adjustments to reconcile net
income to net cash provided
by operating activities
Merchandise Inventory 1,500.00 1,500.00
Accounts Payable 240.00 240.00
Sales Tax Payable 545.20 545.20
Federal Payroll Taxes Payable 387.12 387.12
Total Adjustments 3,612.16 3,612.16
Net Cash provided by Operations 3,201.39 3,201.39
Cash Flows from investing activities
Used For
Net cash used in investing 0.00 0.00
Student Name Sales and Service
Statement of Cash Flow
For the one Month Ended January 31, 2019
Current
Month Year to
Date
Proceeds From
Used For
Student Name, Drawing (400.00) (400.00)
Net cash used in financing (400.00) (400.00)
Net increase <decrease> in cash 2,801.39$ 2,801.39$
Summary
Cash Balance at End of Period 83,601.39$ 83,601.39$
Cash Balance at Beg of Period (80,800.00) (80,800.00)
Net Increase <Decrease> in Cash 2,801.39$ 2,801.39$
5/14/2020 at 10:52 PM Unaudited – For Internal Use Only.