Accounting Data Entry Assignment Excel

Assume that on December 1, 2017, Lee Dunbar organizes a company that will be known as Web Solutions. Web Solutions will initially perform 2 activities: Consulting Services and Programming. The following transactions take place during the month of December: Dec. 1 To start the business, Lee deposits $25,000 in the Web Solution’s bank account. Dec. 1 Web Solutions purchased land for $20,000, paying cash. Dec. 1 Purchased supplies on account for $1,350. Dec. 2 Received $7,500 for Consulting Services to be provided to customers in December. Dec. 2 Paid a premium of $2,400 on a comprehensive insurance policy covering liability, theft, and fire. The policy covers a two year period. Dec. 2 Paid rent for the month of December, $800. Dec. 3 Received an offer from a local retailer to rent the land purchased on Dec. 1st. The retailer plans to use the land as a parking lot for it employees and customers. Web Solutions agreed to rent the land to the retailer for three months with the rent payable in advance. Web Solutions received $360 for three months’ rent beginning December 1st. Dec. 4 Purchased computer equipment on account from Executive Supply Co. for $1,800. Dec. 6 Paid $180 for a newspaper advertisement. Dec. 11 Paid creditors $400 for the Dec. 1st supplies purchase. Dec. 15 Paid a receptionist and part-time assistant $950 for two weeks’ wages for December work so. Dec. 16 Received $3,100 from Programming fees earned for a completed Web site. Dec. 16 Earned fees on account from Consulting Services paid Dec. 2 and provided during the first half of December. Dec. 20 Paid $1,800 to Executive Supply Co. on the debt owed from the December 4th transaction. Dec. 21 Received $650 from customers for Consulting Services performed on Dec. 20th. Dec. 23 Purchased $1,450 of supplies by paying $550 in cash and charging the remainder on account. Dec. 27 Paid the receptionist and the part-time assistant $1,200 for two weeks’ wages. Dec. 31 Paid telephone for the month of December, $310. Dec. 31 Paid $225 electricity bill for December. Dec. 31 Received $2,870 cash from consulting services for the second half of December. Dec. 31 Recognized Programming fees earned by not paid of $1,120 from the second half of December. Dec. 31 Lee accepted a cheque of $2,000, as an employee salary. Instructions: 1) Prepare the Chart of Accounts. 2) Prepare journal entries in the General Journal for Web Solutions for December. Do not make any adjustments for the month of December. 3) Post the journal entry amounts to T-accounts. 4) Create an Unadjusted Trial Balance for Web Solutions for December 31, 2017. Use an Excel Spreadsheet file with five worksheets: First worksheet: Documentation Second worksheet: Chart of Accounts. Third worksheet: General Journal. Fourth worksheet: T-Accounts. Fifth worksheet: Unadjusted Trial Balance. Please ensure that any calculations are performed with formulas and that all worksheets are linked and automated as much as possible.