Filter Criteria includes: Report is printed in Detail Format.
Beginning GL Balance 21,815.30
Add: Cash Receipts 4,305.00
Less: Cash Disbursements (874.47)
Add (Less) Other (12.00)
Ending GL Balance 25,233.83
Ending Bank Balance 25,353.55
Add back deposits in transit
Nov 16, 2019 1014 (29.95)
Nov 28, 2019 1015 (47.80)
Total outstanding checks (119.72)
Add (Less) Other
Total other
Unreconciled difference 0.00
Crafts by Student Name
Account Reconciliation
As of Nov 30, 2019
1020 – County Bank
Bank Statement Date: November 30, 2019
Filter Criteria includes: Report order is by Date.
Date Trans No Type Trans Desc Deposit Amt Withdrawal Amt Balance
Beginning Balance 21,815.30
11/2/19 ATM Withdrawal ATM 100.00 21,715.30
11/3/19 1009 Withdrawal Albert Maintenance and Repairs 75.00 21,640.30
11/3/19 11/3/19 Deposit Deposit 2,200.00 23,840.30
11/8/19 11/8/19 Deposit Deposit 2,105.00 25,945.30
11/9/19 1010 Withdrawal Utilities Company 55.75 25,889.55
11/10/19 1011 Withdrawal Lake Advertising 175.00 25,714.55
11/13/19 1012 Withdrawal U.S. Post Office 49.00 25,665.55
11/15/19 1013 Withdrawal SIM Telephone 41.97 25,623.58
11/16/19 1014 Withdrawal DSL Service 29.95 25,593.63
11/20/19 ATM Withdrawal ATM 100.00 25,493.63
11/28/19 1015 Withdrawal Basic Office Supplies 47.80 25,445.83
11/29/19 ATM Withdrawal ATM 200.00 25,245.83
11/30/19 11/30/19 Other Service Charge 12.00 25,233.83
Total 4,305.00 886.47
Crafts by Student Name
Account Register
For the Period From Nov 1, 2019 to Nov 30, 2019
1020 – County Bank
Filter Criteria includes: Report order is by Date. Report is printed with Accounts having Zero Amounts and with shortened descriptions and in Detail Format.
Date Account ID Reference Trans Description Debit Amt Credit Amt
11/30/19 1020 11/30/19 Service Charge 12.00
11/30/19 6850 11/30/19 Service Charge 12.00
Total 12.00 12.00
Crafts by Student Name
General Journal
For the Period From Nov 1, 2019 to Nov 30, 2019
Filter Criteria includes: Report order is by Check Date. Report is printed in Detail Format.
Date Account ID Transaction Ref Line Description Debit Amnt Credit Amnt
11/3/19 4050 Crafts Income
Crafts income 2,200.00
11/3/19 1020 Crafts Income
Deposit 2,200.00
11/8/19 4000 Teaching Income
Teaching income 2,105.00
11/8/19 1020 Teaching Income
Deposit 2,105.00
4,305.00 4,305.00
Crafts by Student Name
Cash Receipts Journal
For the Period From Nov 1, 2019 to Nov 30, 2019
5/14/2020 at 10:52 PM Page: 4
Filter Criteria includes: Report order is by Date. Report is printed in Detail Format.
Date Check # Account ID Line Description Debit Amount Credit Amount
11/2/19 ATM 3930
Student Name, Draw 100.00
11/2/19 ATM 1020
ATM 100.00
11/3/19 1009 6350
Maintenance & Repairs
Expense
75.00
11/3/19 1009 1020
Albert Maintenance and
Repairs
75.00
11/9/19 1010 6400
Utilities Expense 55.75
11/9/19 1010 1020
Utilities Company 55.75
11/10/19 1011 6600
Advertising Expense 175.00
11/10/19 1011 1020
Lake Advertising 175.00
11/13/19 1012 7400
Postage Expense 49.00
11/13/19 1012 1020
U.S. Post Office 49.00
11/15/19 1013 6500
Telephone Expense 41.97
11/15/19 1013 1020
SIM Telephone 41.97
11/16/19 1014 6560
Internet Service Provider 29.95
11/16/19 1014 1020
DSL Service 29.95
11/20/19 ATM 3930
Student Name, Draw 100.00
11/20/19 ATM 1020
ATM 100.00
11/28/19 1015 1450
Supplies 47.80
11/28/19 1015 1020
Basic Office Supplies 47.80
11/29/19 ATM 3930
Student Name, Draw 200.00
11/29/19 ATM 1020
ATM 200.00
Total 874.47 874.47
Crafts by Student Name
Cash Disbursements Journal
For the Period From Nov 1, 2019 to Nov 30, 2019
5/14/2020 at 10:52 PM Page: 5
Filter Criteria includes: Report order is by ID. Report is printed in Detail Format.
Account ID Account Description Debit Amt Credit Amt
1020 County Bank 25,233.83
1300 Prepaid Insurance 1,000.00
1400 Prepaid Rent 700.00
1450 Supplies 1,035.60
1500 Computer Equipment 6,500.00
1510 Furniture 3,500.00
1520 Automobile 19,000.00
3920 Student Name, Capital 50,000.00
3930 Student Name, Draw 800.00
4000 Teaching Income 4,210.00
4050 Crafts Income 4,500.00
6350 Maintenance & Repairs Expense 75.00
6400 Utilities Expense 101.55
6500 Telephone Expense 97.12
6560 Internet Service Provider 59.90
6600 Advertising Expense 290.00
6800 Conference Expense 195.00
6850 Bank Service Charge 24.00
7400 Postage Expense 98.00
Total: 58,710.00 58,710.00
Crafts by Student Name
General Ledger Trial Balance
As of Nov 30, 2019
ASSETS
Current Assets
County Bank 25,233.83$
Prepaid Insurance 1,000.00
Prepaid Rent 700.00
Supplies 1,035.60
Total Current Assets 27,969.43
Property and Equipment
Computer Equipment 6,500.00
Furniture 3,500.00
Automobile 19,000.00
Total Property and Equipment 29,000.00
Current Liabilities
Total Current Liabilities 0.00
Crafts by Student Name
Balance Sheet
November 30, 2019
Total Long-Term Liabilities 0.00
Total Liabilities 0.00
Capital
Student Name, Capital 50,000.00$
Student Name, Draw (800.00)
Net Income 7,769.43
Total Capital 56,969.43
Total Liabilities & Capital 56,969.43$
Current
Month
Year to
Date
Revenues
Teaching Income 2,105.00$ 48.90 4,210.00$ 48.34
Crafts Income 2,200.00 51.10 4,500.00 51.66
Total Revenues 4,305.00 100.00 8,710.00 100.00
Cost of Sales
Total Cost of Sales 0.00 0.00 0.00 0.00
Gross Profit 4,305.00 100.00 8,710.00 100.00
Expenses
Maintenance & Repairs Expense 75.00 1.74 75.00 0.86
Utilities Expense 55.75 1.30 101.55 1.17
Telephone Expense 41.97 0.97 97.12 1.12
Internet Service Provider 29.95 0.70 59.90 0.69
Advertising Expense 175.00 4.07 290.00 3.33
Conference Expense 0.00 0.00 195.00 2.24
Bank Service Charge 12.00 0.28 24.00 0.28
Crafts by Student Name
Income Statement
For the Eleven Months Ending November 30, 2019
Filter Criteria includes: Report is printed in Detail Format.
Beginning GL Balance 25,233.83
Add: Cash Receipts 4,955.00
Less: Cash Disbursements (932.55)
Add (Less) Other (12.00)
Ending GL Balance 29,244.28
Ending Bank Balance 29,506.08
Add back deposits in transit
Ending GL Balance 29,244.28
Crafts by Student Name
Account Reconciliation
As of Dec 31, 2019
1020 – County Bank
Bank Statement Date: December 31, 2019
5/14/2020 at 10:52 PM Page: 10
Filter Criteria includes: Report order is by Date.
Date Trans No Type Trans Desc Deposit Amt Withdrawal Amt Balance
Beginning Balance 25,233.83
12/2/19 ATM Withdrawal ATM 100.00 25,133.83
12/3/19 1016 Withdrawal Lake Advertising 100.00 25,033.83
12/3/19 12/3/19 Deposit Deposit 2,850.00 27,883.83
12/7/19 12/7/19 Deposit Deposit 2,105.00 29,988.83
12/8/19 1017 Withdrawal Albert Maintenance and Repairs 75.00 29,913.83
12/9/19 1018 Withdrawal Utilities Company 95.75 29,818.08
12/13/19 1019 Withdrawal U.S. Post Office 49.00 29,769.08
12/15/19 1020 Withdrawal SIM Telephone 45.05 29,724.03
12/16/19 1021 Withdrawal DSL Service 29.95 29,694.08
12/20/19 ATM Withdrawal ATM 100.00 29,594.08
12/28/19 1022 Withdrawal Basic Office Supplies 137.80 29,456.28
12/30/19 ATM Withdrawal ATM 200.00 29,256.28
12/31/19 12/31/19 Other Service Charge 12.00 29,244.28
Total 4,955.00 944.55
Crafts by Student Name
Account Register
For the Period From Dec 1, 2019 to Dec 31, 2019
1020 – County Bank
Filter Criteria includes: Report order is by Date. Report is printed with Accounts having Zero Amounts and with shortened descriptions and in Detail Format.
Date Account ID Reference Trans Description Debit Amt Credit Amt
12/31/19 1020 12/31/19 Service Charge 12.00
12/31/19 6850 12/31/19 Service Charge 12.00
Total 12.00 12.00
Crafts by Student Name
General Journal
For the Period From Dec 1, 2019 to Dec 31, 2019
5/14/2020 at 10:52 PM Page: 12