Filter Criteria includes: Report order is by ID. Report is printed with Accounts having Zero Amounts and in Detail Format.
Account ID Account Description Active? Account Type
10200 State Bank Yes Cash
10400 Western Savings & Loan Yes Cash
11000 Accounts Receivable Yes Accounts Receivable
11100 Accounts Receivable Service Yes Accounts Receivable
11400 Other Receivables Yes Accounts Receivable
12000 Inventory-Mountain Bikes Yes Inventory
12020 Inventory-Road Bikes Yes Inventory
12030 Inventory-Children’s Bikes Yes Inventory
12050 Cleaning Supplies Inventory Yes Inventory
12100 Office Supplies Inventory Yes Inventory
14000 Prepaid Insurance Yes Other Current Assets
14100 Employee Advances Yes Other Current Assets
14700 Other Current Assets Yes Other Current Assets
15000 Furniture and Fixtures Yes Fixed Assets
15100 Equipment Yes Fixed Assets
15200 Automobiles Yes Fixed Assets
20000 Accounts Payable Yes Accounts Payable
23100 Sales Tax Payable Yes Other Current Liabilities
23200 Wages Payable Yes Other Current Liabilities
23300 Medicare Employee Taxes Payabl Yes Other Current Liabilities
23350 Medicare Employer Taxes Payabl Yes Other Current Liabilities
23400 Federal Payroll Taxes Payable Yes Other Current Liabilities
23500 FUTA Tax Payable Yes Other Current Liabilities
23600 State Payroll Taxes Payable Yes Other Current Liabilities
23700 SUTA Payable Yes Other Current Liabilities
23800 Local Payroll Taxes Payable Yes Other Current Liabilities
Valley Bikes
Chart of Accounts
As of Jan 31, 2019
Account ID Account Description Active? Account Type
24800 Short-Term Notes Payable Yes Other Current Liabilities
24900 Suspense-Clearing Account Yes Other Current Liabilities
27000 Long-Term Notes Payable Yes Long Term Liabilities
27400 Other Long-Term Liabilities Yes Long Term Liabilities
39003 Common Stock Yes Equity-doesn’t close
39004 Paid-in Capital Yes Equity-doesn’t close
39005 Retained Earnings Yes Equity-Retained Earnings
39007 Dividends Paid Yes Equity-gets closed
40000 Sales-Mountain Bikes Yes Income
40020 Sales-Road Bikes Yes Income
40030 Sales-Children’s Bikes Yes Income
40200 Sales-Services Yes Income
40400 Sales-Clearance Yes Income
40600 Interest Income Yes Income
50500 Cost of Sales-Service Yes Cost of Sales
57000 Cost of Sales-Salaries and Wag Yes Cost of Sales
57500 Cost of Sales-Freight Yes Cost of Sales
58000 Cost of Sales-Other Yes Cost of Sales
58500 Inventory Adjustments Yes Cost of Sales
59000 Purchase Returns and Allowance Yes Cost of Sales
59500 Purchase Discounts Yes Cost of Sales
60000 Default Purchase Expense Yes Expenses
60100 Advertising Expense Yes Expenses
61000 Auto Expenses Yes Expenses
61500 Bad Debt Expense Yes Expenses
62000 Bank Charges Yes Expenses
62500 Cash Over and Short Yes Expenses
64000 Depreciation Expense Yes Expenses
64500 Dues and Subscriptions Exp Yes Expenses
Account ID Account Description Active? Account Type
69500 Loss on NSF Checks Yes Expenses
70000 Maintenance Expense Yes Expenses
70500 Meals and Entertainment Exp Yes Expenses
71000 Office Expense Yes Expenses
72000 Payroll Tax Expense Yes Expenses
72500 FUTA Expense Yes Expenses
73000 SUTA Expense Yes Expenses
73200 Soc. Sec. Expense Yes Expenses
73300 Medicare Expense Yes Expenses
73350 Local Payroll Taxes Expense Yes Expenses
73500 Postage Expense Yes Expenses
74000 Rent-Mall Space Yes Expenses
74500 Repairs Expense Yes Expenses
75500 Supplies Expense Yes Expenses
76000 Telephone Expense Yes Expenses
76500 Travel Expense Yes Expenses
77000 Salaries Expense Yes Expenses
77500 Wages Expense Yes Expenses
78000 Utilities Expense Yes Expenses
89500 Purchase Disc-Expense Items Yes Expenses
90000 Gain/Loss on Sale of Assets Yes Expenses
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
DB001 Donna Bryant 1/13/19 101 SJ 300.00 300.00
RL002 Rich Lucero No Activity 0.00
SW003 Sheila Welch 1/26/19 102 SJ 90.00 90.00
Report Total 390.00 390.00
Valley Bikes
Customer Ledgers
For the Period From Jan 1, 2019 to Jan 31, 2019
Valley Bikes
Vendor Ledgers
For the Period From Jan 1, 2019 to Jan 31, 2019
Filter Criteria includes: Report order is by ID. Report is printed in Detail Format.
Account ID Account Description Debit Amt Credit Amt
10200 State Bank 93,610.53
10400 Western Savings & Loan 15,000.00
11000 Accounts Receivable 390.00
12000 Inventory-Mountain Bikes 4,650.00
12020 Inventory-Road Bikes 7,275.00
12030 Inventory-Children’s Bikes 3,510.00
14000 Prepaid Insurance 2,400.00
15000 Furniture and Fixtures 6,000.00
20000 Accounts Payable 1,050.00
23300 Medicare Employee Taxes Payabl 58.00
23350 Medicare Employer Taxes Payabl 58.00
23400 Federal Payroll Taxes Payable 148.48
23500 FUTA Tax Payable 24.00
23600 State Payroll Taxes Payable 192.00
23700 SUTA Payable 136.00
23800 Local Payroll Taxes Payable 28.96
24000 Soc. Sec. Employee Taxes Payab 248.00
24100 Soc. Sec. Employer Taxes Payab 248.00
24800 Short-Term Notes Payable 3,755.00
27000 Long-Term Notes Payable 5,324.20
39003 Common Stock 120,600.00
40000 Sales-Mountain Bikes 6,600.00
40020 Sales-Road Bikes 4,500.00
40030 Sales-Children’s Bikes 2,880.00
50000 Cost of Sales-Mountain Bikes 3,300.00
50020 Cost of Sales-Road Bikes 2,250.00
50030 Cost of Sales-Children’s Bikes 1,440.00
59500 Purchase Discounts 61.50
62000 Bank Charges 15.00
72500 FUTA Expense 24.00
73000 SUTA Expense 136.00
73200 Soc. Sec. Expense 248.00
Valley Bikes
General Ledger Trial Balance
As of Jan 31, 2019
5/14/2020 at 10:56 PM Page: 6
Account ID Account Description Debit Amt Credit Amt
Total: 145,912.14 145,912.14
5/14/2020 at 10:56 PM Page: 7
Filter Criteria includes: Report is printed in Detail Format.
Beginning GL Balance 88,400.00
Add: Cash Receipts 13,590.00
Less: Cash Disbursements (8,364.47)
Add (Less) Other (15.00)
Ending GL Balance 93,610.53
Ending Bank Balance 94,675.56
Add back deposits in transit
Total deposits in transit
(Less) outstanding checks
Valley Bikes
Account Reconciliation
As of Jan 31, 2019
10200 – State Bank
Bank Statement Date: January 31, 2019
ASSETS
Current Assets
State Bank 93,610.53$
Western Savings & Loan 15,000.00
Accounts Receivable 390.00
Inventory-Mountain Bikes 4,650.00
Inventory-Road Bikes 7,275.00
Inventory-Children’s Bikes 3,510.00
Prepaid Insurance 2,400.00
Total Current Assets 126,835.53
Property and Equipment
Furniture and Fixtures 6,000.00
Total Property and Equipment 6,000.00
Other Assets
Total Other Assets 0.00
Valley Bikes
Balance Sheet
January 31, 2019
Federal Payroll Taxes Payable 148.48
FUTA Tax Payable 24.00
State Payroll Taxes Payable 192.00
SUTA Payable 136.00
Local Payroll Taxes Payable 28.96
Soc. Sec. Employee Taxes Payab 248.00
Soc. Sec. Employer Taxes Payab 248.00
Short-Term Notes Payable 3,755.00
Total Current Liabilities 5,946.44
Long-Term Liabilities
Long-Term Notes Payable 5,324.20
Total Long-Term Liabilities 5,324.20
Total Liabilities 11,270.64
Capital
Common Stock 120,600.00
Net Income 964.89
Total Capital 121,564.89
Current Month Year to Date
Revenues
Sales-Mountain Bikes 6,600.00$ 47.21 6,600.00$ 47.21
Sales-Road Bikes 4,500.00 32.19 4,500.00 32.19
Sales-Children’s Bikes 2,880.00 20.60 2,880.00 20.60
Total Revenues 13,980.00 100.00 13,980.00 100.00
Cost of Sales
Cost of Sales-Mountain Bikes 3,300.00 23.61 3,300.00 23.61
Cost of Sales-Road Bikes 2,250.00 16.09 2,250.00 16.09
Cost of Sales-Children’s Bikes 1,440.00 10.30 1,440.00 10.30
Purchase Discounts (61.50) (0.44) (61.50) (0.44)
Total Expenses 6,086.61 43.54 6,086.61 43.54
Net Income 964.89$ 6.90 964.89$ 6.90
Valley Bikes
Income Statement
For the One Month Ending January 31, 2019
5/14/2020 at 10:56 PM For Management Purposes Only
Current Month Year to Date
5/14/2020 at 10:56 PM For Management Purposes Only
Current Month Year to Date
Cash Flows from operating activities
Net Income 964.89$ 964.89$
Adjustments to reconcile net
income to net cash provided
by operating activities
Accounts Receivable (390.00) (390.00)
Inventory-Mountain Bikes 1,350.00 1,350.00
Inventory-Road Bikes 975.00 975.00
Inventory-Children’s Bikes 540.00 540.00
Accounts Payable 1,050.00 1,050.00
Medicare Employee Taxes Payabl 58.00 58.00
Medicare Employer Taxes Payabl 58.00 58.00
Federal Payroll Taxes Payable 148.48 148.48
FUTA Tax Payable 24.00 24.00
State Payroll Taxes Payable 192.00 192.00
SUTA Payable 136.00 136.00
Local Payroll Taxes Payable 28.96 28.96
Soc. Sec. Employee Taxes Payab 248.00 248.00
Soc. Sec. Employer Taxes Payab 248.00 248.00
Short-Term Notes Payable (245.00) (245.00)
Total Adjustments 4,421.44 4,421.44
Valley Bikes
Statement of Cash Flow
For the one Month Ended January 31, 2019
Current Month Year to Date
Cash Flows from financing activities
Proceeds From
Used For
Long-Term Notes Payable (175.80) (175.80)
Net cash used in financing (175.80) (175.80)
Net increase <decrease> in cash 5,210.53$ 5,210.53$
Summary
Cash Balance at End of Period 108,610.53$ 108,610.53$
Cash Balance at Beg of Period (103,400.00) (103,400.00)
Net Increase <Decrease> in Cash 5,210.53$ 5,210.53$