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

  Compute rodeswell earnings per share

Compute Rodeswell's earnings per share for 2011. Start with income from continuing operations. All income and loss amounts are net of income tax

  Any tax issues related to relocating some

Dave needs advice as to how this new family layer will affect the tax situation of the family-owned and -operated businesses. He also wants to know if there are any tax issues related to relocating some of his business efforts to another country, ..

  How much is the supplies expense

At December 31, supplies on hand are $1200. How much is the supplies expense for the year under accrual accounting

  Filling the form of turbotax as per the requirement

See the atteched file of Turbotax accounting. Filling the form of turbotax as per the requirement. The response must be typed, single spaced, must be in times.

  Discuss the previous periods and check for majors ups

compare the balance sheet statement with the previous periods and check for majors ups and downs in the elements

  How many units does bison need to have

Bison occasionally gets special orders for odd-numbered batches - How many units does Bison need to have

  What is the sourcing of the royalty income

IrishCo uses the patent in a manufacturing facility located in Ireland. What is the sourcing of the royalty income received by USCo

  Prepare a statement of cash flows

Equipment (cost $21,770 and accumulated depreciation $9,770) was sold for $11,770. Prepare a statement of cash flows for 2017

  What principles of corporate governance appear to have

In July 20X5, Bell, Inc. agreed to pay P100 million to settle SEC charges, What principles of corporate governance appear to have

  Calculate diluted earnings per share for mayfair enterprise

Calculate the diluted earnings per share for Mayfair Enterprise?Calculate the basic earnings per share for Mayfair Enterprises for 2016. HINT: For basic EPS

  Compute the break-even point in units

The Hartnett Corporation manufactures baseball bats with Pudge Rodriguez's autograph stamped on them. Compute the break-even point in units

  What price should adcited quote to the customer for the job

What price should ADCITED quote to their customer for the job? ADCITED is a business that specialises in making signs for their customers.

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