Question
2/6/24 Add a new invoice 4 Add a new invoice #1006 for $820 Customer: Surf Rider Foundation, terms: Net 30, service: Repairs, quantity: 2, and
2/6/24 Add a new invoice 4 Add a new invoice #1006 for $820 Customer: Surf Rider Foundation, terms: Net 30, service: Repairs, quantity: 2, and product: Rook 15, quantity: 1. 2/7/24 Add a cash receipt 4 Add a new cash receipt Customer: Blondies Boards, payment method: Check, reference no.: 1003, deposit to: Undeposited Funds, amount received: $8,000, applied to invoice #1003. 2/8/24 Make a bank deposit 4 Add a bank deposit to the checking account in the amount of $15,810, which represents payments from Blondies Boards for $5,000 and $8,000 and Awesome Surf for $2,810. 2/9/24 Add a new vendor 5 Add a new vendor BoardsWest, 36 Anacapa St., Santa Barbara, CA 93101, terms: Net 30. 2/9/24 Add a new product 5 Add a new product with quantity tracked Wiley One, initial quantity on hand: 0, as of date: 2/9/24, price: $4,000, cost: $2,400, income account: Sales, expense account: Cost of Goods Sold. Vendor: BoardsWest. 2/9/24 Add a new account 3 Add a new account Account type: Other Current Assets, detail type: Other Current Assets, name: Employee Loans. 2/9/24 Add a new purchase order 5 Add a new purchase order #1003 for $9,600 to purchase 4 Wiley One boards from vendor BoardsWest. 2/10/24 Use credit card 5 Add a credit card charge Vendor: Village Travel, using credit card: VISA, category Travel, amount: $775. 2/11/24 Record a check 5 Add check no. 1013 Vendor: Office Depot, amount: $575, category: Supplies Asset. 2/11/24 Add a new purchase order 5 Add a new purchase order #1004 for $12,400 Vendor: Channel Islands, ordered 10 Fred Rubbles, 6 Rook 15, and 8 The Water Hog boards. 2/12/24 Add a new bill 5 Add a new bill based on a purchase order #1002 for $4,700 Vendor: Stewart Surfboards, terms: Net 30. All items ordered were received. 2/13/24 Add a new bill 5 Add a new bill without a purchase order San Diego Gas & Electric, terms: Net 15, category: Utilities, amount: $150. 2/14/24 Add a new bill 5 Add a new bill without a purchase order Prime Properties, terms: Net 15, category: Rent or Lease, amount: $2,500. 2/14/24 Pay a bill with a check 5 Pay bill $7,500 due to Prime Properties using check no. 1012. 2/15/24 Add new fixed asset accounts 6 Create four new fixed asset accounts Account type: Fixed Assets, detail type: Buildings and Accumulated Depreciation (where appropriate), account names: Original Cost (a sub account of Building) and Accumulated Depreciation (a sub account of Building), and Land with Account type: Fixed Asset, detail type: Land. 2/15/24 Purchase land and building 6 Add the purchase of land and a warehouse building from Prime Properties, check no. 1014, amount: $2,000, as a down payment on land $5,000 and a building $15,000. The balance was paid by signing a long-term note for $18,000 (create a new account called Notes Payable Chase, Account type: Long-Term Liabilities, detail type: Notes Payable). 2/19/24 Sell common stock 6 Add the sale of common stock to shareholders as a deposit of a $15,000 check. 2/19/24 Pay dividends 6 Add the payment of dividends to shareholders on 2/19/24, check no. 1015, in the amount of $500. 2/20/24 Make a loan payment 6 Add the payment of $339.68 to Chase Bank (a new vendor) as an installment on the land and building purchase made on 2/15/24, which included interest expense of $75 and principal amount of $264.68 using check no. 1016. 2/20/24 Make a loan payment 6 Record the payment of $1,132.27 to Bank of CA on 2/20/24 (as an installment on a loan received last month), which included interest expense of $250 and principal amount of $882.27 using check no. 1017. 2/20/24 Pay first payroll 7 Add payroll (as you did in the chapter) based on the information shown in Figure 1. (This payroll covers work through 2/15/24 but wasnt paid until 2/20/24.) 2/27/24 Add a new bill 6 Add a new bill based on purchase order #1003 on 2/9/24 Vendor: BoardsWest, terms: Net 30. All items ordered were received. 2/27/24 Add a new invoice 4 Add invoice #1007 for $12,000 to Blazing Boards, terms: Net 30, for 3 Wiley One boards. 2/28/24 Pay second payroll 7 Add payroll (as you did in the chapter) based on the information shown in Figure 2 as follows. 2/28/24 Add a new bill 5 Add a new bill based on purchase order #1004 for $12,400 Vendor: Channel Islands, terms: Net 15. All items ordered were received. (Hint: First clear all lines in the Item details section of the bill that are left over from a previous bill from Channel Islands.) 2/28/24 Add a new invoice 4 Add an invoice #1008 for $12,990 to Blondies Boards, terms: Net 30, for 8 Fred Rubble, 3 Rook 15, and 4 The Water Hog boards. 2/28/24 Add a sales receipt 4 Add a sales receipt #1009 for Sarah Hay at Hey Hays Surf for $12,210 to record their check no. 988, which was deposited to the checking account, for 1 California Nose Rider, 3 Fred Rubble, 1 Wiley One, 1 Water Hog, and 2 Rook 15 boards. 2/28/24 Reconcile bank account 4 Reconcile your companys checking account. No service charges or interest were incurred or earned. The ending bank statement balance on 2/28/24 was $39,896.91. All checks cleared the bank except checks no. 1021 to 1023. All deposits cleared the bank except a check from Sarah Hay for $12,210. 2/28/24 Adjust supplies 9 $250 of supplies were used in February. Use journal entry 10. 2/28/24 Adjust prepaid rent 9 $800 of prepaid expenses expired (representing prepaid rent) in the month of February. Use journal entry 11. 2/28/24 Accrue expenses 9 A bill for $450 was received and recorded in the next month for travel consumed in the current month. Use journal entry 12. In January, you accrued $150 in maintenance costs, which remains unpaid. No adjustment is necessary, but payment needs to be made next month. 2/28/24 Defer revenue 9 Consulting services recorded on invoice #1004 for $2,500 to Surf Rider Foundation were unearned as of 1/31/24 but were performed in February 2024. Thus, the revenue was earned. This requires the reversal of journal entry 7 recorded on 1/31/24. (Hint: Look at journal entry 7, and use journal entry 13 to reverse it on 2/28/24.) 2/28/24 Accrue revenue 9 Consulting services of $8,500 (340 hours) were performed as of 1/31/24 for Blazing Boards but not invoiced to the customer or recorded into the accounting records. Revenue was accrued using journal entry 8. Add invoice #1010 to bill Blazing Boards for this service. This also requires reversal of journal entry 8 recorded on 1/31/24. (Hint: Look at journal entry 8, and use journal entry 14 to reverse it on 2/28/24.) 2/28/24 Accrue depreciation 9 Depreciation Expense of $675 ($100, $75, and $500 for Building, Equipment, and Furniture & Fixtures, respectively) needs to be recorded for the month. Use journal entry 15 to record this depreciation. 2/28/24 Accrue revenue 9 Consulting services of $10,200 were performed on 2/28/24 for a new customer, Kyle Hain, but not invoiced or recorded into the accounting records. Use journal entry 16 to accrue this revenue. Requirements: Create, save, and print a Profit and Loss report for February 2024. Create, save, and print a Sales Transaction report for February 2024. Create, save, and print a Balance Sheet report for February 28, 2024, with a % of column. Create, save, and print a Checking report for February 2024. Create, save, and print a Statement of Cash Flows report for February 2024. Create, save, and print an A/R Aging Summary report for February 2024. Create, save, and print an A/P Aging Summary report for February 2024. Create, save, and print an Inventory Valuation Summary report for February 2024. Create, save, and print a Transactions List by Date report for February 2024. Create, save, and print a Budget vs. Actuals report for February 2024.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started