User Account

All Pages

Sell privacy and cybersecurity

Assignment Help Accounting Basics
Reference no: EM133247041

Ask the Question: Can PivotTables be used to post journal entries and create a trial balance?

Master the Data: AttackID is formed to sell privacy and cybersecurity. AttackID begins business January 1, 2022, and has 52 journal entries in the first month, which we have now input into an Excel spreadsheet.

Software needed

  • Excel
  • Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

Data: Excel File Lab 1-1 Alt Data.xlsx.

Perform the Analysis: Refer to Lab 1-1 Alternative in the text for instructions and Lab 1-1 steps for each of the lab parts.

Share the Story: Once we have completed the trial balance and it, in fact, balances, we are ready to publish the balance sheet and the income statement for all interested stakeholders.

Upload the Word or PDF document containing your Lab screenshots using the button below. (Note: To prevent uploading issues avoid using special characters in your file attachment name.)

Take a screenshot of your final trial balance and label it "Lab 1-1 Alt Submission".

Date JE# Account Name Debit Credit Entered Approved
1/2/22 1 Cash 50,000   VR AC
1/2/22 1 Common Stock   50,000 VR AC
1/2/22 2 Travel Expense 150   VR AC
1/2/22 2 Cash   150 VR AC
1/2/22 3 Building 30,000   VR AC
1/2/22 3 Cash   30,000 VR AC
1/4/22 4 Utilities Expense 1,500   MW AC
1/4/22 4 Cash   1,500 MW AC
1/5/22 5 Equipment 17,200   VR AC
1/5/22 5 Notes Payable   17,200 VR AC
1/6/18 6 Salaries Expense 1,300   VR AC
1/6/18 6 Cash   1,300 VR AC
1/5/22 7 Payroll Tax Expense 1,000   VR AC
1/5/22 7 Cash   1,000 VR AC
1/6/22 8 Accounts Receivable 10,000   VR AC
1/6/22 8 Sales Revenue   10,000 VR AC
1/6/22 9 Cash 11,000   VR AC
1/6/22 9 Notes Payable   11,000 VR AC
1/7/22 10 Repairs Expense 7,000   VR AC
1/7/22 10 Cash   7,000 VR AC
1/7/22 11 Accounts Receivable 20,000   VR DH
1/7/22 11 Sales Revenue   20,000 VR DH
1/10/22 12 Cash 10,000   VR DH
1/10/22 12 Accounts Receivable   10,000 VR DH
1/10/22 13 Repairs Expense 1,300   MW DH
1/10/22 13 Cash   1,300 MW DH
1/10/22 14 Rent Expense 7,000   MW DH
1/10/22 14 Cash   7,000 MW DH
1/10/22 15 Prepaid Insurance 1,000   VR DH
1/10/22 15 Cash   1,000 VR DH
1/10/22 16 Accounts Receivable 15,000   VR DH
1/10/22 16 Sales Revenue   15,000 VR DH
1/10/22 17 Notes Payable 2,000   MW DH
1/10/22 17 Cash   2,000 MW DH
1/11/22 18 Supplies 500   MW DH
1/11/22 18 Computer Supplies 500   MW DH
1/11/22 18 Cash   1,000 MW DH
1/12/22 19 Salaries Expense 5,200   MW DH
1/12/22 19 Cash   5,200 MW DH
1/12/22 20 Payroll Tax Expense 1,000   MW DH
1/12/22 20 Cash   1,000 MW DH
1/13/22 21 Travel Expense 2,025   VR DH
1/13/22 21 Cash   2,025 VR DH
1/13/22 22 Insurance Expense 1,200   VR DH
1/13/22 22 Cash   1,200 VR DH
1/14/22 23 Cash 23,000   VR DH
1/14/22 23 Sales Revenue   23,000 VR DH
1/14/22 24 Training Expense 500   VR DH
1/14/22 24 Cash   500 VR DH
1/14/22 25 Travel Expense 50   VR DH
1/14/22 25 Cash   50 VR DH
1/14/22 26 Misc. Expense 200   VR DH
1/14/22 26 Cash   200 VR DH
1/15/22 27 Travel Expense 2,025   DH DH
1/15/22 27 Cash   2,025 DH DH
1/15/22 28 Postage Expense 250   VR AC
1/15/22 28 Cash   250 VR AC
1/17/22 29 Cash 2,000   VR AC
1/17/22 29 Accounts Receivable   2,000 VR AC
1/19/22 30 Salaries Expense 5,200   MW AC
1/19/22 30 Cash   5,200 MW AC
1/19/22 31 Payroll Tax Expense 1,100   MW AC
1/19/22 31 Cash   1,100 MW AC
1/20/22 32 Accounts Receivable 1,200   MW AC
1/20/22 32 Sales Revenue   1,200 MW AC
1/20/22 33 Cash 2,400   MW AC
1/20/22 33 Sales Revenue   2,400 MW AC
1/20/22 34 Travel Expense 272   MW AC
1/20/22 34 Cash   272 MW AC
1/21/22 35 Training Expense 500   VR VR
1/21/22 35 Cash   500 VR VR
1/21/22 36 Misc. Expense 125   VR AC
1/21/22 36 Cash   125 VR AC
1/21/22 37 Travel Expense 350   VR AC
1/21/22 37 Cash   350 VR AC
1/21/22 38 Travel Expense 2,025   VR AC
1/21/22 38 Cash   2,025 VR AC
1/21/22 39 Travel Expense 250   VR AC
1/21/22 39 Cash   250 VR AC
1/22/22 40 Training Expense 400   MW AC
1/22/22 40 Cash   400 MW AC
1/22/22 41 Cash 2,200   MW AC
1/22/22 41 Sales Revenue   2,200 MW AC
1/22/22 42 Travel Expense 250   MW AC
1/22/22 42 Cash   250 MW AC
1/23/22 43 Cash 12,000   VR AC
1/23/22 43 Accounts Receivable   12,000 VR AC
1/23/22 44 Computer Supplies 200   MW AC
1/23/22 44 Cash   200 MW AC
1/23/22 45 Supplies Expense 255   MW AC
1/23/22 45 Supplies   255 MW AC
1/26/22 46 Salaries Expense 4,200   MW AC
1/26/22 46 Cash   4,200 MW AC
1/26/22 47 Payroll Tax Expense 1,100   MW AC
1/26/22 47 Cash   1,100 MW AC
1/27/22 48 Bad Debt Expense 5,000   VR AC
1/27/22 48 Allowance for Doubtful Accounts 5,000 VR AC
1/27/22 49 Depreciation Expense 1,100   VR AC
1/27/22 49 Accumulated Depreciation 1,100 VR AC
1/27/22 50 Training Expense 300   VR AC
1/27/22 50 Cash   300 VR AC
1/28/22 51 Insurance Expense 150   VR AC
1/28/22 51 Prepaid Insurance   150 VR AC
1/29/22 52 Cash 20,000   MW AC
1/29/22 52 Sales Revenue   20,000 MW AC

Reference no: EM133247041

Questions Cloud

How does firewalls assist in ict system protection : How does firewalls assist in ICT system protection? Calculate a checksum of an application and store this in a table.
How many meals does it have to sell to break even : A fish and chips shop in the city sells a meal for R50 It costs the shop R30 to produce each meal If the fixed costs involved in running the shop
Identify options to improve ict system performance : How to identify options to improve ICT system performance? Wait for the system to fail to identify the cause of failure.
What is non monetary exchange of assets : 1. How do you compute avoidable interest and actual interest? Illustrate with examples.
Sell privacy and cybersecurity : Ask the Question: Can PivotTables be used to post journal entries and create a trial balance?
Explain the value proposition of e-tailer like amazon : Explain the value proposition of e-tailer like Amazon. What can small stores do to compete against global giant like Amazon.
Find offload passengers involuntarily : It is common practice for airlines to overbook so that despite any no-shows or cancellations, each flight will still have as many occupied seats as possible, be
List four types of services that are prohibited by the act : The Sarbanes-Oxley Act of 2002 placed significant restrictions on the types of consulting that may be performed by auditors for public companies.
Discuss the ethicality of refusing to allow employees : During the COVID pandemic, many employees were required to work from home in an effort to reduce the spread of the virus. Subsequently, even when they were able

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Theory of interest - term structure of interest rates

Term Structure of Interest Rates

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd