46 Prepare a tabular analysis of the above transactions and compute the balance of each account after each transaction. Determine thebalances of the following account titles to be used in preparing the tabular analysis:CashFurnitureAccounts ReceivableAccounts PayableRepair MaterialsLoan PayablePrepaid RentNuttie, CapitalSewing MachinesNOTE: Do not use Peso sign or "P". If the answer has decimal amount, round off your answer to two decimal places. Do not forget touse comma as separator, if necessary. For example, if your answer is P90,000, you should type 90,000 or P 15,000.75 as 115,000.75 Hazel Nuttie opened a dress repair shop. She completed the following transactions for the month of February:Transferred P80,000 from personal bank account to the business account named HN Dress Repair Shop.Hired two workers with monthly salary of P10,000 each.3Purchased repair materials for shop use, P5,000, on credit.4Purchased two sewing machines in cash, P7,500 each.5Paid rent in advance for six months, P12,000.6Applied for loan from Masho Bank, P200,000.7Performed dress repair services to Aluya de Pinya on account, P5,000.8Bought furniture from Ralph Quatro Cantos on account, P10,000.The loan from Masho Bank was granted and directly credited to the business account.10Rendered services to Katrina Magah Mata received in cash, P6,000.12Repair materials used amounted to P2,000 (refer to #3 transaction).13Paid utilities expenses: water, P500; electricity, 4,000; and telephone, P1,000.15Repaired dresses of Mr. Dextrose Ganzon, P10,000 received in cash.15Paid fırst half of salary of workers.17Bought additional repair materials in cash, P5,000.Received payment from Aluya de Pinya in full.1820Paid half of the account due to Ralph Quatro Cantos.23Received payment from various cash customers, P15,000.25Made partial payment to Masho Bank, P50,000.28Paid the salaries for the second half.Performed services to various customers amounted to 8,000, of which P3,500 was received in cash.29Rental for the first month was expensed out.

Trial balance is a tabular format in which all general ledger account balances are being shown as a…

Prepare a tabular analysis of the above transactions and compute the balance of each account after each transaction. Determine the balances of the following account titles to be used in preparing the tabular analysis: Cash Furniture Accounts Receivable Accounts Payable Repair Materials Loan Payable Prepaid Rent Nuttie, Capital Sewing Machines NOTE: Do not use Peso sign or "P". If the answer has decimal amount, round off your answer to two decimal places. Do not forget to use comma as separator, if necessary. For example, if your answer is P90,000, you should type 90,000 or P 15,000.75 as 115,000.75

Prepare a tabular analysis of the above transactions and compute the balance of each account after each transaction. Determine the balances of the following account titles to be used in preparing the tabular analysis: Cash Furniture Accounts Receivable Accounts Payable Repair Materials Loan Payable Prepaid Rent Nuttie, Capital Sewing Machines NOTE: Do not use Peso sign or "P". If the answer has decimal amount, round off your answer to two decimal places. Do not forget to use comma as separator, if necessary. For example, if your answer is P90,000, you should type 90,000 or P 15,000.75 as 115,000.75

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 6R: On June 1 of the current year, Wilson Wood opened Woodys Web Services. This sole proprietorship had...

See similar textbooks

Similar questions

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.
In March, T. Carter established Carter Delivery Service. The account headings are presented below. Transactions completed during the month of March follow. a. Carter deposited 25,000 in a bank account in the name of the business. b. Bought a used truck from Degroot Motors for 15,140, paying 5,140 in cash and placing the remainder on account. c. Bought equipment on account from Flemming Company, 3,450. d. Paid the rent for the month, 1,000, Ck. No. 3001. e. Sold services for cash for the first half of the month, 6,927. f. Bought supplies for cash, 301, Ck. No. 3002. g. Bought insurance for the truck for the year, 1,200, Ck. No. 3003. h. Received and paid the bill for utilities, 349, Ck. No. 3004. i. Received a bill for gas and oil for the truck, 218. j. Sold services on account, 3,603. k. Sold services for cash for the remainder of the month, 4,612. l. Paid wages to the employees, 3,958, Ck. Nos. 30053007. m. Carter withdrew cash for personal use, 1,250, Ck. No. 3008. 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 March, T. Carter established Carter Delivery Service. The account headings are presented below. Transactions completed during the month of March follow. a. Carter deposited 25,000 in a bank account in the name of the business. b. Bought a used truck from Degroot Motors for 15,140, paying 5,140 in cash and placing the remainder on account. c. Bought equipment on account from Flemming Company, 3,450. d. Paid the rent for the month, 1,000, Ck. No. 3001 (Rent Expense). e. Sold services for cash for the first half of the month, 6,927 (Service Income). f. Bought supplies for cash, 301, Ck. No. 3002. g. Bought insurance for the truck for the year, 1,200, Ck. No. 3003. h. Received and paid the bill for utilities, 349, Ck. No. 3004 (Utilities Expense). i. Received a bill for gas and oil for the truck, 218 (Gas and Oil Expense). j. Sold services on account, 3,603 (Service Income). k. Sold services for cash for the remainder of the month, 4,612 (Service Income). l. Paid wages to the employees, 3,958, Ck. Nos. 30053007 (Wages Expense). m. Carter withdrew cash for personal use, 1,250, Ck. No. 3008. 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.
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 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.
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 (Service Income). 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 (Service Income). i. Received and paid the bill for utilities, 280, Ck. No. 103 (Utilities Expense). j. Received a bill for gas and oil for the truck, 130 (Gas and Oil Expense). k. Paid wages to the employees, 2,680, Ck. Nos. 104106 (Wages Expense). l. Sold services for cash for the remainder of the month, 3,500 (Service Income). m. Rodriguez withdrew cash for personal use, 4,000, Ck. No. 107. 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.
B. Kelso established Computer Wizards during November of this year. The accountant prepared the following chart of accounts: The following transactions occurred during the month: a. Kelso deposited 45,000 in a bank account in the name of the business. b. Paid the rent for the current month, 1,800, Ck. No. 2001. c. Bought office desks and filing cabinets for cash, 790, Ck. No. 2002. d. Bought a computer and printer from Cyber Center for use in the business, 2,700, paying 1,700 in cash and placing the balance on account, Ck. No. 2003. e. Bought a neon sign on account from Signage Co., 1,350. f. Kelso invested her personal computer software with a fair market value of 600 in the business. g. Received a bill from Country News for newspaper advertising, 365. h. Sold services for cash, 1,245. i. Received and paid the electric bill, 345, Ck. No. 2004. j. Paid on account to Country News, a creditor, 285, Ck. No. 2005. k. Sold services for cash, 1,450. l. Paid wages to an employee, 925, Ck. No. 2006. m. Received and paid the bill for the city business license, 75, Ck. No. 2007. n. Kelso withdrew cash for personal use, 850, Ck. No. 2008. o. Kelso withdrew cash for personal use, 850, Ck. No. 2008. 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 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 November 30, 20--.
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 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.
A business has the following transactions: A. The business is started by receiving cash from an investor in exchange for common stock $10,000. B. Rent of $1,250 is paid for the first month. C. Office supplies are purchased for $375. D. Services worth $3,450 are performed. Cash is received for half. E. Customers pay $1,250 for services to be performed next month. F. $6,000 is paid for a one year insurance policy. G. We receive 25% of the money owed by customers in D. H. A customer has placed an order for $475 of services to be done this coming week. How much total revenue does the company have?
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?