Alberto’s Computer Shop (Sample Balance Sheet) On October 01, 2000, Mr Alberto opened a computer rental shop. The following transactions occurred during the month: 1. Oct. 01, 2000: Mr Alberto invested P500,000 cash in the computer rental shop.

Alberto’s Computer Shop (Sample Balance Sheet) On October 01, 2000, Mr Alberto opened a computer rental shop. The following transactions occurred during the month: 1. Oct. 01, 2000: Mr Alberto invested P500,000 cash in the computer rental shop.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter1: Business Transactions (ptrans)

Section: Chapter Questions

Problem 4R: On June 1 of the current year, Wilson Wood opened Woodys Web Services. This sole proprietorship had...

See similar textbooks

Similar questions

In July of this year, M. Wallace established a business called Wallace Realty. The account headings are presented below. Transactions completed during the month follow. a. Wallace deposited 24,000 in a bank account in the name of the business. b. Paid the office rent for the current month, 650, Ck. No. 1000. c. Bought office supplies for cash, 375, Ck. No. 1001. d. Bought office equipment on account from Dellos Computers, 6,300. e. Received a bill from the City Crier for advertising, 455. f. Sold services for cash, 3,944. g. Paid on account to Dellos Computers, 1,500, Ck. No. 1002. h. Received and paid the bill for utilities, 340, Ck. No. 1003. i. Paid on account to the City Crier, 455, Ck. No. 1004. j. Paid truck expenses, 435, Ck. No. 1005. k. Wallace withdrew cash for personal use, 1,500, Ck. No. 1006. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
P. Schwartz, Attorney at Law, opened his office on October 1. The account headings are presented below. Transactions completed during the month follow. a. Schwartz deposited 25,000 in a bank account in the name of the business. b. Bought office equipment on account from QuipCo, 9,670. c. Schwartz invested his personal law library, which cost 2,800. d. Paid the office rent for the month, 1,700, Ck. No. 2000. e. Bought office supplies for cash, 418, Ck. No. 2001. f. Bought insurance for two years, 944, Ck. No. 2002. g. Sold legal services for cash, 8,518. h. Paid the salary of the part-time receptionist, 1,820, Ck. No. 2003. i. Received and paid the telephone bill, 388, Ck. No. 2004. j. Received and paid the bill for utilities, 368, Ck. No. 2005. k. Sold legal services for cash, 9,260. l. Paid on account to QuipCo, 2,670, Ck. No. 2006. m. Schwartz withdrew cash for personal use, 2,500, Ck. No. 2007. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
On March 1 of this year, B. Gervais established Gervais Catering Service. The account headings are presented below. Transactions completed during the month follow. a. Gervais deposited 25,000 in a bank account in the name of the business. b. Bought a truck from Kelly Motors for 26,329, paying 8,000 in cash and placing the balance on account, Ck. No. 500. c. Bought catering equipment on account from Luigis Equipment, 3,795. d. Paid the rent for the month, 1,255, Ck. No. 501. e. Bought insurance for the truck for one year, 400, Ck. No. 502. f. Sold catering services for cash for the first half of the month, 3,012. g. Bought supplies for cash, 185, Ck. No. 503. h. Sold catering services on account, 4,307. i. Received and paid the heating bill, 248, Ck. No. 504. j. Received a bill from GC Gas and Lube for gas and oil for the truck, 128. k. Sold catering services for cash for the remainder of the month, 2,649. l. Gervais withdrew cash for personal use, 1,550, Ck. No. 505. m. Paid the salary of the assistant, 1,150, Ck. No. 506. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
In April, J. Rodriguez established an apartment rental service. The account headings are presented below. Transactions completed during the month of April follow. a. Rodriguez deposited 70,000 in a bank account in the name of the business. b. Paid the rent for the month, 2,000, Ck. No. 101 (Rent Expense). c. Bought supplies on account, 150. d. Bought a truck for 23,500, paying 2,500 in cash and placing the remainder on account. e. Bought insurance for the truck for the year, 2,400, Ck. No. 102. f. Sold services on account, 4,700. g. Bought office equipment on account from Stern Office Supply, 1,250. h. Sold services for cash for the first half of the month, 8,250. i. Received and paid the bill for utilities, 280, Ck. No. 103. j. Received a bill for gas and oil for the truck, 130. k. Paid wages to the employees, 2,680, Ck. Nos. 104106. l. Sold services for cash for the remainder of the month, 3,500. m. Rodriguez withdrew cash for personal use, 4,000, Ck. No. 107. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
On July 1 of this year, R. Green established the Green Rehab Clinic. The organizations account headings are presented below. Transactions completed during the month of July follow. a. Green deposited 30,000 in a bank account in the name of the business. b. Paid the office rent for the month, 1,800, Ck. No. 2001. c. Bought supplies for cash, 362, Ck. No. 2002. d. Bought professional equipment on account from Rehab Equipment Company, 18,000. e. Bought office equipment from Hi-Tech Computers, 2,890, paying 890 in cash and placing the balance on account, Ck. No. 2003. f. Sold professional services for cash, 4,600. g. Paid on account to Rehab Equipment Company, 700, Ck. No. 2004. h. Received and paid the bill for utilities, 367, Ck. No. 2005. i. Paid the salary of the assistant, 1,150, Ck. No. 2006. j. Sold professional services for cash, 3,868. k. Green withdrew cash for personal use, 1,800, Ck. No. 2007. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
J. Carrie established Carries Photo Tours during June of this year. The accountant prepared the following chart of accounts: The following transactions occurred during the month of June: a. Carrie deposited 30,000 cash in a bank account in the name of the business. b. Bought office equipment for cash, 1,850, Ck. No. 1001 c. Bought computer software from Moreys Computer Center, 640, paying 350 in cash and placing the balance on account, Ck. No. 1002. d. Paid current months rent, 950, Ck. No. 1003. e. Sold services for cash, 1,575. f. Bought a neon sign from The Sign Company, 1,335, paying 435 in cash and placing the balance on account, Ck. No. 1004. g. Received bill from The Gossiper for advertising, 445. h. Bought supplies on account from City Supply, 460. i. Received and paid the electric bill, 380, Ck. No. 1005. j. Paid on account to The Gossiper, 245, Ck. No. 1006. k. Sold services for cash, 3,474. l. Paid wages to an employee, 930, Ck. No. 1007. m. Carrie invested his personal computer with a fair market value of 1,000 in the business. n. Carrie withdrew cash for personal use, 800, Ck. No. 1008. o. Received and paid the bill for city business license, 75, Ck. No. 1009. Required 1. Record the owners name in the Capital and Drawing T accounts. 2. Correctly place the plus and minus signs for each T account and label the debit and credit sides of the accounts. 3. Record the transactions in the T accounts. Write the letter of each entry to identify the transaction. 4. Foot the T accounts and show the balances. 5. Prepare a trial balance, with a three-line heading, dated June 30, 20--.
On July 1 of this year, R. Green established the Green Rehab Clinic. The organizations account headings are presented below. Transactions completed during the month of July follow. a. Green deposited 30,000 in a bank account in the name of the business. b. Paid the office rent for the month, 1,800, Ck. No. 2001 (Rent Expense). c. Bought supplies for cash, 362, Ck. No. 2002. d. Bought professional equipment on account from Rehab Equipment Company, 18,000. e. Bought office equipment from Hi-Tech Computers, 2,890, paying 890 in cash and placing the balance on account, Ck. No. 2003. f. Sold professional services for cash, 4,600 (Professional Fees). g. Paid on account to Rehab Equipment Company, 700, Ck. No. 2004. h. Received and paid the bill for utilities, 367, Ck. No. 2005 (Utilities Expense). i. Paid the salary of the assistant, 1,150, Ck. No. 2006 (Salary Expense). j. Sold professional services for cash, 3,868 (Professional Fees). k. Green withdrew cash for personal use, 1,800, Ck. No. 2007. Required 1. In the equation, write the owners name above the terms Capital and Drawing. 2. Record the transactions and the balance after each transaction. Identify the account affected when the transaction involves revenues or expenses. 3. Write the account totals from the left side of the equals sign and add them. Write the account totals from the right side of the equals sign and add them. If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
On October 1, 2019, Jay Pryor established an interior decorating business, Pioneer Designs. During the month, Jay completed the following transactions related to the business: Oct. 1. Jay transferred cash from a personal bank account to an account to be used for the business, 18,000. 4.Paid rent for period of October 4 to end of month, 3,000. 10.Purchased a used truck for 23,750, paying 3,750 cash and giving a note payable for the remainder. 13.Purchased equipment on account, 10,500. 14.Purchased supplies for cash, 2,100. 15.Paid annual premiums on property and casualty insurance, 3,600. 15.Received cash for job completed, 8,950. Enter the following transactions on Page 2 of the two-column journal: 21.Paid creditor a portion of the amount owed for equipment purchased on October 13, 2,000. 24.Recorded jobs completed on account and sent invoices to customers, 14,150. 26.Received an invoice for truck expenses, to be paid in November, 700. 27.Paid utilities expense, 2,240. 27.Paid miscellaneous expenses, 1,100. Oct. 29. Received cash from customers on account, 7,600. 30.Paid wages of employees, 4,800. 31.Withdrew cash for personal use, 3,500. Instructions 1. Journalize each transaction in a two-column journal beginning on Page 1, referring to the following chart of accounts in selecting the accounts to be debited and credited. (Do not insert the account numbers in the journal at this time.) Journal entry explanations may be omitted. 2. Post the journal to a ledger of four-column accounts, inserting appropriate posting references as each item is posted. Extend the balances to the appropriate balance columns after each transaction is posted. 3. Prepare an unadjusted trial balance for Pioneer Designs as of October 31, 2019. 4. Determine the excess of revenues over expenses for October. 5. Can you think of any reason why the amount determined in (4) might not be the net income for October?
On July 1, K. Resser opened Ressers Business Services. Ressers accountant listed the following chart of accounts: The following transactions were completed during July: a. Resser deposited 25,000 in a bank account in the name of the business. b. Bought tables and chairs for cash, 725, Ck. No. 1200. c. Paid the rent for the current month, 1,750, Ck. No. 1201. d. Bought computers and copy machines from Ferber Equipment, 15,700, paying 4,000 in cash and placing the balance on account, Ck. No. 1202. e. Bought supplies on account from Wigginss Distributors, 535. f. Sold services for cash, 1,742. g. Bought insurance for one year, 1,375, Ck. No. 1203. h. Paid on account to Ferber Equipment, 700, Ck. No. 1204. i. Received and paid the electric bill, 438, Ck. No. 1205. j. Paid on account to Wigginss Distributors, 315, Ck. No. 1206. k. Sold services to customers for cash for the second half of the month, 820. l. Received and paid the bill for the business license, 75, Ck. No. 1207. m. Paid wages to an employee, 1,200, Ck. No. 1208. n. Resser withdrew cash for personal use, 700, Ck. No. 1209. Required 1. Record the owners name in the Capital and Drawing T accounts. 2. Correctly place the plus and minus signs for each T account and label the debit and credit sides of the accounts. 3. Record the transactions in the T accounts. Write the letter of each entry to identify the transaction. 4. Foot the T accounts and show the balances. 5. Prepare a trial balance as of July 31, 20--. 6. Prepare an income statement for July 31, 20--. 7. Prepare a statement of owners equity for July 31, 20--. 8. Prepare a balance sheet as of July 31, 20--. LO 1, 2, 3, 4, 5, 6
On June 1 of this year, J. Larkin, Optometrist, established the Larkin Eye Clinic. The clinics account names are presented below. Transactions completed during the month follow. a. Larkin deposited 25,000 in a bank account in the name of the business. b. Paid the office rent for the month, 950, Ck. No. 1001. c. Bought supplies for cash, 357, Ck. No. 1002. d. Bought office equipment on account from NYC Office Equipment Store, 8,956. e. Bought a computer from Wardens Office Outfitters, 1,636, paying 750 in cash and placing the balance on account, Ck. No. 1003. f. f. Sold professional services for cash, 3,482. g. Paid on account to Wardens Office Outfitters, 886, Ck. No. 1004. h. Received and paid the bill for utilities, 382, Ck. No. 1005. i. Paid the salary of the assistant, 1,050, Ck. No. 1006. j. Sold professional services for cash, 3,295. k. Larkin withdrew cash for personal use, 1,250, Ck. No. 1007. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
On October 01, 2000, Mr Alberto opened a computer rental shop. The following transactions occurred during the month: 4. Oct. 12, 2000: Mr Alberto borrowed from P300,000 from a bank, which he promised to pay by December 2000.
: Ahmad started his own Computer service on January 1, 2020. The following transactions occurred during the month of January. January 01 Ahmad invested $ 200000 cash in the business 03 Paid $ 10000 for office rent for the month 05 Service provided on account $ 15000 12 Purchased supplies for $ 3000 on account 15 Received a cash payment of $ 5000 for services provided on January 05 17 Purchased gasoline for $ 2000 on account 23 Received Bank Loan of $ 40000 on the note payable Instructions Show the effects of these transactions on the accounting equation Prepare a balance sheet at January 31, 2020 Date Assets Liabilities Owner’s Equity Cash Accounts Receivable Supplies Note Payable Account…