its a cybertext project in excel sheet . please help me

Byte of Accounting, Inc. Pranjali patel 8362 Transaction Description of transaction 4 01 June 1- Byte of Accounting, Inc. acquired $95,200 in cash from Lauryn and issued 3,400 shares of its common stock. 02 June 1: Byte of Accounting, Inc. issued 2,560 shares of its common stock to Pranjali patel after $30,240 in cash and computer equipment with a fair market value of $41.440 were received. 03. Courtney $51,800 in cash, computer equipment with a fair market value of $11,760 and office equipment with a fair value of $728. June 2. A down payment of $30,000 in cash was made on additional computer equipment that was purchased for $150,000 A five-year note was executed by Byte for the balance Introduction FAQ. Welcome Chart of Accounts Transactions Generaljoumal W ... X AutoSave On O Gie P PP091. Saved V Search File Home insert Page Layout formulas Data Review View Help 18 08 June 14. A one-year insurance policy covering its computer equipment was purchased by Byte for $5,304 in cash. The effective date of the policy was June 16 . 09. June 16: A check in the amount of $8,250 was received for consulting revenue June 16. Byte purchased a building and the Land it is on for $107,000, to house its repair facilities and to store computer equipment. The lot on which the bualding is located is valued at $17,000. 10. The balance of the cost is to be allocated to the building Byte made a cash down payment of $10,700 and executed a mortgage for the balance. The mortgage is payable in cight equal anmal Introduction FAQ Welcome Chart of Accounts Transactions General Journal u ... Reaoy \& Accestibingy investigate \begin{tabular}{|l|l|l|} \hline 24 & & A \\ \hline 25 & 11. & June17:Cashof$4,800waspaidforrentforJuneandJuly.PutthetotalamountintothePrepaidRentaccount. \\ \hline \end{tabular} 12. June 17. Received a bill of $325 from the local newspaper for advertising 13. June 21: Accounts payable in the amount of $560 were paid. 14. June 21. A fax machine for the office was purchased for $825 cash 15. June 21: Billed various miscellaneous local customers $4,400 for consulting services performed 16. June 22: Paid salaries of $985 to equipment operators for the week ending June 18 computer equipment Introduction FAQ Welcome Chart of Accounts Transactions Genernt Joumal B. C 18. June 22: Paid the advertising bill that was received on June 17. 41 19. June 23: Purchased office supplies for $480 on credit Record the purchase as an increase to the assets. 20. June 23: Cash in the amount of $3,525 was received on billings. 21. June 28: Billed $5,910 to miscellaneous customers for services performed to June 25. 22. June 29: Paid the bill received on June 22, from Computer Parts and Repairs Co. 23. June 29: Cash in the amount of $5,600 was received for billings. 24. June 29: Paid salaries of $985 to equipment operators for the week ending June 25 . 25. June 30: Received a bill for the amount of $990 from O \& G Oil and Gas Co. Introduction FAQ Welcome Chart of Accounts Transactions General Journal u ... A June 30: Paid a cash dividend of $0.21 per share to the three shareholders of Byte. 26. [MMPORTANT NOTE: The number of shares of capital stock outstanding can be determined from the first three transactions.] Adjusting Eutries - Round to two decimal places. 58 The rent payment made on June 17 was for June and July, Expense the amount associated with 60 28. A physical inventory showed that only $191.00 worth of office supplies remained on hand as of 62 The anmual interest rate on the montgage payable was 900 percent. Interest expense for one-balf 29. month should be computed because the building and land were purchased and the liability incurred 64 on June 16 Information relating to the prepaid insurance may be obtained from the transaction recorded on June 14. Expense the amount associated with one half month's insurance. Introduction FAQ Welcome Chart of Accounts Iransactions General Journal 33. A review of the payroll records show that unpaid salanies in the amount of $591.00 are owed by Byte for three days, June 2830. The note payable relating to the June 2 , and 10 transactions is a five-year note, with interest at the rate of 12 percent annually. Interest expense should be computed based on a 360 day year. [IMPORTANT NOTE: The original note on the computer equipment purchased on June 2 was $120,000. On June 10, eight days later, $23,000 was repaid. Interest expense must be calculated on the $120,000 for eight days. In addition, interest expense on the $97,000 balance of the loan ($120.000 less $23,000=$97,000) must be calculated for the 20 days remaining in the month of June.] \begin{tabular}{l|l|l} 88 & 37. & Close the expense accounts. \end{tabular} \begin{tabular}{|l|l|l|} 89 & & \\ 90 & 38 & Close the income summary account. \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline 91 & & \\ \hline 92 & 39 & Close the dividends account \\ \hline 93 & & \\ \hline \end{tabular} 94 95 96 97 98 99 100 101 A Byte of Accounting, Inc. General Journal A Byte of Accounting, Inc. Worksheet For Period Ending June 3, 2023 ... Chart of Accounts Transactions General Journal Worksheet Income Statement B A Byte of Accounting, Inc. Statement of Changes in Retained Earnings For Month Ending June 3, 2023 Balance, Beginning of Penod Net income Dividends Balance. End of Period AB23CAByteofAccounting,BalanceSheetAsofJune3,2023 Assets Current Assets Cash Accounts Receivable Prepaid Insurance Prepuid Rent Office Supplies Total Long-Term Assets Ofice Equip. Accum Depr Office Equip Computer Equip. Accum Depr -Computer Equip. Balance sheet How to Create a Pivot Table Data for General Ledger tedger Byte of Accounting, Inc. Pranjali patel 8362 Transaction Description of transaction 4 01 June 1- Byte of Accounting, Inc. acquired $95,200 in cash from Lauryn and issued 3,400 shares of its common stock. 02 June 1: Byte of Accounting, Inc. issued 2,560 shares of its common stock to Pranjali patel after $30,240 in cash and computer equipment with a fair market value of $41.440 were received. 03. Courtney $51,800 in cash, computer equipment with a fair market value of $11,760 and office equipment with a fair value of $728. June 2. A down payment of $30,000 in cash was made on additional computer equipment that was purchased for $150,000 A five-year note was executed by Byte for the balance Introduction FAQ. Welcome Chart of Accounts Transactions Generaljoumal W ... X AutoSave On O Gie P PP091. Saved V Search File Home insert Page Layout formulas Data Review View Help 18 08 June 14. A one-year insurance policy covering its computer equipment was purchased by Byte for $5,304 in cash. The effective date of the policy was June 16 . 09. June 16: A check in the amount of $8,250 was received for consulting revenue June 16. Byte purchased a building and the Land it is on for $107,000, to house its repair facilities and to store computer equipment. The lot on which the bualding is located is valued at $17,000. 10. The balance of the cost is to be allocated to the building Byte made a cash down payment of $10,700 and executed a mortgage for the balance. The mortgage is payable in cight equal anmal Introduction FAQ Welcome Chart of Accounts Transactions General Journal u ... Reaoy \& Accestibingy investigate \begin{tabular}{|l|l|l|} \hline 24 & & A \\ \hline 25 & 11. & June17:Cashof$4,800waspaidforrentforJuneandJuly.PutthetotalamountintothePrepaidRentaccount. \\ \hline \end{tabular} 12. June 17. Received a bill of $325 from the local newspaper for advertising 13. June 21: Accounts payable in the amount of $560 were paid. 14. June 21. A fax machine for the office was purchased for $825 cash 15. June 21: Billed various miscellaneous local customers $4,400 for consulting services performed 16. June 22: Paid salaries of $985 to equipment operators for the week ending June 18 computer equipment Introduction FAQ Welcome Chart of Accounts Transactions Genernt Joumal B. C 18. June 22: Paid the advertising bill that was received on June 17. 41 19. June 23: Purchased office supplies for $480 on credit Record the purchase as an increase to the assets. 20. June 23: Cash in the amount of $3,525 was received on billings. 21. June 28: Billed $5,910 to miscellaneous customers for services performed to June 25. 22. June 29: Paid the bill received on June 22, from Computer Parts and Repairs Co. 23. June 29: Cash in the amount of $5,600 was received for billings. 24. June 29: Paid salaries of $985 to equipment operators for the week ending June 25 . 25. June 30: Received a bill for the amount of $990 from O \& G Oil and Gas Co. Introduction FAQ Welcome Chart of Accounts Transactions General Journal u ... A June 30: Paid a cash dividend of $0.21 per share to the three shareholders of Byte. 26. [MMPORTANT NOTE: The number of shares of capital stock outstanding can be determined from the first three transactions.] Adjusting Eutries - Round to two decimal places. 58 The rent payment made on June 17 was for June and July, Expense the amount associated with 60 28. A physical inventory showed that only $191.00 worth of office supplies remained on hand as of 62 The anmual interest rate on the montgage payable was 900 percent. Interest expense for one-balf 29. month should be computed because the building and land were purchased and the liability incurred 64 on June 16 Information relating to the prepaid insurance may be obtained from the transaction recorded on June 14. Expense the amount associated with one half month's insurance. Introduction FAQ Welcome Chart of Accounts Iransactions General Journal 33. A review of the payroll records show that unpaid salanies in the amount of $591.00 are owed by Byte for three days, June 2830. The note payable relating to the June 2 , and 10 transactions is a five-year note, with interest at the rate of 12 percent annually. Interest expense should be computed based on a 360 day year. [IMPORTANT NOTE: The original note on the computer equipment purchased on June 2 was $120,000. On June 10, eight days later, $23,000 was repaid. Interest expense must be calculated on the $120,000 for eight days. In addition, interest expense on the $97,000 balance of the loan ($120.000 less $23,000=$97,000) must be calculated for the 20 days remaining in the month of June.] \begin{tabular}{l|l|l} 88 & 37. & Close the expense accounts. \end{tabular} \begin{tabular}{|l|l|l|} 89 & & \\ 90 & 38 & Close the income summary account. \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline 91 & & \\ \hline 92 & 39 & Close the dividends account \\ \hline 93 & & \\ \hline \end{tabular} 94 95 96 97 98 99 100 101 A Byte of Accounting, Inc. General Journal A Byte of Accounting, Inc. Worksheet For Period Ending June 3, 2023 ... Chart of Accounts Transactions General Journal Worksheet Income Statement B A Byte of Accounting, Inc. Statement of Changes in Retained Earnings For Month Ending June 3, 2023 Balance, Beginning of Penod Net income Dividends Balance. End of Period AB23CAByteofAccounting,BalanceSheetAsofJune3,2023 Assets Current Assets Cash Accounts Receivable Prepaid Insurance Prepuid Rent Office Supplies Total Long-Term Assets Ofice Equip. Accum Depr Office Equip Computer Equip. Accum Depr -Computer Equip. Balance sheet How to Create a Pivot Table Data for General Ledger tedger