https://1drv.ms/x/s!Al3_nQv4rY2CgRmojFAVgmtuzM5X Here's the excel link, thank you so much for helping me
E G H J K L M N P Q R Analyze, Journalize, Post with a few Adjustments 1. Make sure you are able to edit the Excel file. You may see a banner across the top of the file that must be clicked to "Enable Editing of the File." 2. Save your Excel file so that or can determine that it is your file. Here's a format for the file name: YourLastNameLast4-Lab3.xIsx Excel files use the file extension .xIsx Jane Smith, with student number 982011234 would name her file Smith1234-Lab2.xisx When you finish the lab, save it and then submit the file through Canvas--Find the TURN-IN link. INSTRUCTIONS First--take a look at the sheets in this file. Look below and you will find the HINTS-HELP sheet, the ACCTS sheet, the DATA-ENTRY sheet, and the REPORTS sheet. ACCTS In the ACCTS sheet, you will find all accounts. You don't need to copy them or remember them--because they will display automatically in the DATA-ENTRY sheet. DATA-ENTRY This is your journal. Remember that for each entry, the debits must equal the credits. You will have a balance indicator that will tell you if you are out of balance. REPORTS These are your financial statements--IS, OE and BS. They will be automatically generated. 1. GO TO the DATA-ENTRY SHEET It appears like this, in green. I entered the date, January 1, 2015. We need to debit cash on line 2. Note the dropdown in column C. Here is the transaction description: The dropdown will display your accounts B G 1 DATE ACCOUNTS DEBIT CREDIT TRANSACTIONS--RECORD IN JOURNAL 2 1/1/2015 1. On Jan. 1, the company issued 10,000 shares of $1.00 par common TW stock at a price of $12.00 per share, for cash. Debit Cash for 120,000; credit Common Stock for 10,000, and credit Paid in Capital in Excess for 110,000. 2. If you click on the down-arrow, you will see all accounts. DATE ACCOUNTS DEBIT CREDIT TRANSACTIONS--RECORD IN JOURNAL 2 1/1/2015 1. On Jan. 1, the company issued 10,000 shares of $1.00 par common ACCOUNT w 101 CASH stock at a price of $12.00 per share, for cash. 104 ACCOUNTS RECEIVABLE Debit Cash for 120,000; credit Common Stock for 10,000, and 10 EQUIPMENT credit Paid in Capital in Excess for 110,000 111 ACCUM. DEPRECIATION-EQUIPMENT 201 ACCOUNTS PAYABLE 202 NOTES PAYABLE 301 COMMON STOCK 3. Choose CASH from the dropdown and it will appear in the journal. The debit amount should be 10,000. Similarly, go down one line and enter the credit to COMMON STOCK, and the credit to PAID IN CAPITAL IN EXCESS OF PAR. DATE ACCOUNTS DEBIT CREDIT TRANSACTIONS--RECORD IN JOURNAL 1/1/2015 101 CASH 120,000 1. On Jan. 1, the company issued 10,000 shares of $1.00 par common 301 COMMON STOCK 10,000 stock at a price of $12.00 per share, for cash. 302 PAID IN CAPITAL IN EXCESS OF PAR-COMMON 10,000 Debit Cash for 120,000; credit Common Stock for 10,000, and credit Paid in Capital in Excess for 110,000 Note: The accounts you see in the dropdown came from the ACCTS sheet. If you scroll down the page to the bottom of the journal, you will see an indicator showing you if you are in balance... Checking JOURNAL balance: Total Debits = $
