1. Journalize the account receivable and account payable transactions (transactions are described on the next page)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Journalize the account receivable and account payable transactions (transactions are described on the next page) in a general journal, post them to the general ledger (just the accounts receivable and accounts payable accounts), and record the transactions in the appropriate subsidiary accounts. You do not need to enter descriptions in the journal - just the date, account names, and the amounts (Debit/Credit). When recording an account receivable transaction, please note the customer's name and the invoice number. For example, if $1,000 was sold to a company named XYZ company on invoice #1001, you would record the entry in this format: Accounts Accounts Receivable (XYZ Company, Invoice # 1001) Sales Debit 1,000 Credit 1,000 Do the same for any entry that effects the accounts payable (i.e., vendor name and invoice #). Bring each balance up to date after each transaction by entering the correct Excel formula. For example, if you enter a debit into the General Ledger account for Accounts Receivable, enter a formula in the balance column to increase the account balance; bringing the account up-to-date. Do the same with the GL account for Accounts Payable, and the subsidiary accounts (Accounts Receivable and Accounts Payable.) Think of it this way - you will be maintaining real-time data in both the general ledger and the subsidiary ledger. 2. After completing the last transaction, go to the Reconciliation sheet and enter the final general ledger balance for both the accounts receivable and accounts payable and then compare those balances to the sum of the final balances from the subsidiary ledgers. PLEASE NOTE: This assignment focuses on accounts receivable and payables. To save time and effort, you won't be posting to any other general ledger accounts. The general intent (learning objective) of the assignment is to review the workings of subsidiary ledgers. TRANSACTIONS Below are transactions of a company named Naples Industries (the subject company of this assignment). Here are some important facts: • As you begin this assignment, there are account balances in the Naples Industries' general ledger and the subsidiary ledgers. The balances are carried forward from the previous business day. • The subsidiary ledgers are in balance with their associated general ledger balances when business starts up on Jan 2. Please process the following transactions by first recording them in the general journal (journalizing), posting to the general ledger, and recording them in the subsidiary ledgers. Please use the following accounts when journalizing the transactions: Cash, Accounts Receivable, Supplies, Accounts Payable, Sales, and Sales Allowances. Assume that the company uses a periodic inventory system and therefore, do not record the effect on cost of goods sold or inventory when a sale is made. Transactions: Date Description Jan Sold $5,000 (invoice # 150) of product to Smith Company on account. 2 Jan 2 Jan 3 Jan 3 Jan 4 Paid $1,000 on the account balance owed to a supplier named: Solar Circus. The original Solar Circus invoice # was 117. Purchased on account, supplies of $500 (invoice # 40) from a vendor named: A&P. Returned $1,500 of supplies to a vendor named PB&J. The supplies were originally purchased on account (invoice #301) and has not yet been paid for by Naples Industries. PB&J issues a credit memo to Naples Industries to recognize that a return has been made in lieu of payment. Received a check from a customer named: Jackson Company for $11,000 as a partial payment of its outstanding account balance. This is related to invoice 115. 4 Jan Received a return from a customer name: Scissor Corp. for $5,000 of product. Naples Industries needs to credit the customer's account as this was part of a sale (invoice # 101) made on credit. Debit the Inventory account. 5 Purchased on account, $750 of supplies from K-3 Inc. (K-3's invoice number is # 444) Jan 5 Jan 6 its outstanding account balance. This is related to invoice 115. Jan 7 Sold $500 of product to Notepad Ltd on account (Invoice #151). Reminder: ignore the effect on cost of goods sold and inventory as a result of this sale. ABC Company contacted Naples to complain about a potential defect in a product they purchased last month. Naples agreed to credit ABC Accounts Receivable for $700 (against the amount they owe) and record a Sales Allowance (debit). This is related to invoice #99. After you have journalized, posted to the general ledger accounts, and recorded entries in the subsidiary ledgers. Please perform a reconciliation (last sheet in the Excel workbook) of both the accounts receivable and accounts Payable on the sheet named: Reconciliations. Save your file and then upload it via the Assignment in myCourses. a. Post a general journal b. Post an accounts receivable subsidiary ledger c. Post accounts payable subsidiary ledger d. Post general ledger accounts e. Post reconciliation of accounts receivable and accounts payable 1. Journalize the account receivable and account payable transactions (transactions are described on the next page) in a general journal, post them to the general ledger (just the accounts receivable and accounts payable accounts), and record the transactions in the appropriate subsidiary accounts. You do not need to enter descriptions in the journal - just the date, account names, and the amounts (Debit/Credit). When recording an account receivable transaction, please note the customer's name and the invoice number. For example, if $1,000 was sold to a company named XYZ company on invoice #1001, you would record the entry in this format: Accounts Accounts Receivable (XYZ Company, Invoice # 1001) Sales Debit 1,000 Credit 1,000 Do the same for any entry that effects the accounts payable (i.e., vendor name and invoice #). Bring each balance up to date after each transaction by entering the correct Excel formula. For example, if you enter a debit into the General Ledger account for Accounts Receivable, enter a formula in the balance column to increase the account balance; bringing the account up-to-date. Do the same with the GL account for Accounts Payable, and the subsidiary accounts (Accounts Receivable and Accounts Payable.) Think of it this way - you will be maintaining real-time data in both the general ledger and the subsidiary ledger. 2. After completing the last transaction, go to the Reconciliation sheet and enter the final general ledger balance for both the accounts receivable and accounts payable and then compare those balances to the sum of the final balances from the subsidiary ledgers. PLEASE NOTE: This assignment focuses on accounts receivable and payables. To save time and effort, you won't be posting to any other general ledger accounts. The general intent (learning objective) of the assignment is to review the workings of subsidiary ledgers. TRANSACTIONS Below are transactions of a company named Naples Industries (the subject company of this assignment). Here are some important facts: • As you begin this assignment, there are account balances in the Naples Industries' general ledger and the subsidiary ledgers. The balances are carried forward from the previous business day. • The subsidiary ledgers are in balance with their associated general ledger balances when business starts up on Jan 2. Please process the following transactions by first recording them in the general journal (journalizing), posting to the general ledger, and recording them in the subsidiary ledgers. Please use the following accounts when journalizing the transactions: Cash, Accounts Receivable, Supplies, Accounts Payable, Sales, and Sales Allowances. Assume that the company uses a periodic inventory system and therefore, do not record the effect on cost of goods sold or inventory when a sale is made. Transactions: Date Description Jan Sold $5,000 (invoice # 150) of product to Smith Company on account. 2 Jan 2 Jan 3 Jan 3 Jan 4 Paid $1,000 on the account balance owed to a supplier named: Solar Circus. The original Solar Circus invoice # was 117. Purchased on account, supplies of $500 (invoice # 40) from a vendor named: A&P. Returned $1,500 of supplies to a vendor named PB&J. The supplies were originally purchased on account (invoice #301) and has not yet been paid for by Naples Industries. PB&J issues a credit memo to Naples Industries to recognize that a return has been made in lieu of payment. Received a check from a customer named: Jackson Company for $11,000 as a partial payment of its outstanding account balance. This is related to invoice 115. 4 Jan Received a return from a customer name: Scissor Corp. for $5,000 of product. Naples Industries needs to credit the customer's account as this was part of a sale (invoice # 101) made on credit. Debit the Inventory account. 5 Purchased on account, $750 of supplies from K-3 Inc. (K-3's invoice number is # 444) Jan 5 Jan 6 its outstanding account balance. This is related to invoice 115. Jan 7 Sold $500 of product to Notepad Ltd on account (Invoice #151). Reminder: ignore the effect on cost of goods sold and inventory as a result of this sale. ABC Company contacted Naples to complain about a potential defect in a product they purchased last month. Naples agreed to credit ABC Accounts Receivable for $700 (against the amount they owe) and record a Sales Allowance (debit). This is related to invoice #99. After you have journalized, posted to the general ledger accounts, and recorded entries in the subsidiary ledgers. Please perform a reconciliation (last sheet in the Excel workbook) of both the accounts receivable and accounts Payable on the sheet named: Reconciliations. Save your file and then upload it via the Assignment in myCourses. a. Post a general journal b. Post an accounts receivable subsidiary ledger c. Post accounts payable subsidiary ledger d. Post general ledger accounts e. Post reconciliation of accounts receivable and accounts payable
Expert Answer:
Answer rating: 100% (QA)
a Post a general journal Accounts Date Jan02 Accounts Receivable Smith Company Invoice 1001 Sales Ja... View the full answer
Related Book For
College Accounting A Contemporary Approach
ISBN: 978-0077639730
3rd edition
Authors: David Haddock, John Price, Michael Farina
Posted Date:
Students also viewed these accounting questions
-
In an applied research context you do not need to explain the relationships between the variables in your conceptual model. Discuss this statement.
-
In an applied research context you do not need to explain the relationships between the variables in your conceptual model. Discuss this statement. (2-3 paragraphs).
-
You do not need a lot of money to invest in a mutual fund. However, if you decide to put some money into an investment, you are usually advised to leave it in for (at least) several years. Why?...
-
WESTON ENTERPRISES 2019 and 2020 Partial Balance Sheets Assets 2019 2020 Current assets $1,193 $1272 Net fixed assets 5,722 6,023 WESTON ENTERPRISES 2020 Income Statement Sales Costs Depreciation...
-
Determine the operating cash flow (OCF) for Kleczka, Inc., based on the following data. (All values are in thousands of dollars.) During the year the firm had sales of $2,500, cost of goods sold...
-
Perform the indicated operations in Problem, if possible. [6-2-[ 4 4 1 2 -5 1-2 4 ] 0 4 5
-
Materiality. The concept of materiality is important in an audit of financial statements and expression of opinion. Required A. How are materiality (and immateriality) related to the proper...
-
Refer to the previous question. A manufacturing engineer for MPI collected the following data on the failure rates of components X, Y, and Z in a random sample of 1,000 circuit boards: For example,...
-
Net Present Value Method for a Service Company Coast - to - Coast Inc. is considering the purchase of an additional delivery vehicle for $ 3 8 , 0 0 0 on January 1 , 2 0 Y 1 . The truck is expected...
-
Julie Lane, Sara Miles, and Amber Noll have capital balances of $50,000, $40,000, and $30,000, respectively. The profit and loss ratio is 4:4:2. Assume Noll withdraws from the partnership on December...
-
Crane Inc. has decided to raise additional capital by issuing$185,000 face value of bonds with a coupon rate of 10%. Indiscussions with investment bankers, it was determined that to helpthe sale of 2...
-
how to do an introduction and conclusion of 200 words min. on Equal opportunity, Our National Myth by Joseph E Stinglitz?
-
The National Consumer Commission (NCC) is currently investigating 'Lolli World & Co', the supplier of lollipops. The investigation commenced subsequent to the NCC receiving numerous complaints from...
-
George owns 100% of equity of a company. . If George works 6 hours per day, the company's EBIT will be 335,000 dollars per year, in perpetuity. If, instead, he works 12 hours per day, the firm's EBIT...
-
Hendrick Hospital keeps paper records for ten years. They have gotten behind on the destruction of medical records. Their HIM director has sent down a memo that it was time to start purging some...
-
Willie Wilson plans to borrow $ 3 5 , 5 9 1 at the beginning of each of his 5 years of college. He will repay the loan in 1 0 equal annual installments at the end of each year starting one year after...
-
The product exchange function for gasoline x and heating oil y in hundreds of gallons per day is shown below 170 000 120x y 170 2x Sketch the portion of the function in Quadrant I of the graph and...
-
As indicated by mutual fund flows, investors tend to beat the market seek safety invest in last year's winner invest in last years loser
-
Juan Padronas works for H&C Commercial Builders, Inc. His pay rate is $13.00 per hour and he receives overtime pay at one and one-half times his regular hourly rate for any hours worked beyond 40 in...
-
The following transactions took place at Fine Fashions Outlet during July 2016. Fine Fashions Outlet uses a perpetual inventory system. Record the transactions in a general journal. Use 8 as the page...
-
Bruno Company (buyer) and Smith, Inc. (seller), engaged in the following transactions during January 2016: Bruno Company DATETRANSACTIONS 2016 Jan. 8Issued Check 2101 for $2,940 on account to Smith,...
-
Bank Reconciliation OBJECTIVE 3 Hula Corp. utilizes J.P. Chase in its banking transactions. For the month of August, 2018, J.P. Chase presented Hula with its bank statement as follows: Upon receiving...
-
Petty Cash Fund} Minsky Ltd. maintains a balance of \(\$ 2,500\) in its petty cash fund. On December 31, Minsky's petty cash account has a balance of \(\$ 216\). Minsky replenishes the petty cash...
-
Journal Entry from bank reconciliation OBJECTIVE 3 Eagel, a furniture company, made an error in recording a cheque received from a customer. Last month, Eagel's customer bought a table for \(\$...
Study smarter with the SolutionInn App