On this sheet, fill in the 4th column with the appropriate Journal, Subjournal, Ledger, or Subledger where information should be recorded. Use the appropriate journal/subjournal to record journal entries. Transfer this information to the appropriate subledger/ledger. Update the General Ledger at the end of each day as indicated in the ‘Date’ column of this sheet. Do not enter values in the blue columns The values in those cells are calculated automatically.
Accounting Treatments for This Assignment:
Gross method for Sales and Purchases
Direct Write off method for uncollectable accounts
Perpetual Inventory System
Sheet 2 Sheet 1 Fin. Adj. Bal. G.L. AP PPE Inv AR General Cash Macros Purch. Sales Desc. Info Customer List Account Key Inventory Information Supplier ID Customer No. Customer Name Credit Limit Acct. No. Acct. Name Item ID Item Name Item Price Item Cost Supplier Name A00001 Kahn, Oliver Sales INV 001 Lawnmower C01 Garden Supply A00002 Lawal, Rashid Sales Discounts INV 002 Hedge Clippers C02 Plant Life A00003 Anderson, Susan Gains INV 003 Weed Eater C03 John Deere A00004 COGS INV 004 Shovel C04 Tools, Inc. A00005 Hurt, Marcus Interest Expense INV 005 20lb Mulch C05 Fastenal A00006 Wallace, Peter INV 006 20lb Fertilizer A00007 Uhlmann, Alex Losses INV 007 Pesticide A00008 Knote, Andrew Cash INV 008 Plant Seeds A00009 Mosiman, Andrew Accounts Receivable INV 009 Wheelbarrow A00010 Morris, Lauren INV 010 50ft Water Hose A00011 Kahn Jr., Oliver Inventory INV 011 100ft Water Hose PP&E Accounts Payable Notes Payable Interest Payable Retained Earnings Trans. No. Date Transaction Description Cust. No. Cust. Name Inv. No. Inv. Name Inv. Cost Quantity Credit Sale? Supplier No. Purchase Amount Credit? Debit Credit Customer Balance Balance Notes Trans. No Number In Number Out Supplier Balance AP Balance General Ledger End of Day Check Figures: Individual Ledgers to GL Acct. Bal Ledger Bal. Account No. Account Name Individual Ledgers Balance? Company Balance Sheet Income Statement ASSETS REVENUES EXPENSES Total Assets LIABILITIES AND OWNERS’ EQUITY Liabilities Total Liabilities Owners’ Equity Total Liabilities and Owners’ Equity Dr. Cr. Where to put information? Inv. Price You must enable Macros to do this homework. “Macros not enabled” warning screen To Enable Macros in Excel 2007 or 2010, Click the ‘Options’ Button above the formula bar. Under ‘Macro’, Select ‘Enable this Content’ and click ‘OK’ Amt Credit Amt Cash If using an…
Attachments:
Ledger HW S20….xls