Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

i need help creating an accounting worksheet using the information and template provided. Date X X X X * December 2, 2018 100 Comprehensive Project

i need help creating an accounting worksheet using the information and template provided.
image text in transcribed
image text in transcribed
image text in transcribed
Date X X X X * December 2, 2018 100 Comprehensive Project Part B Business Transactions Transaction Amount Nick Roberts invested capital in his new December 1, 2018 Deposit Ticket 1 business venture by depositing money into $10.000,00 an interest bearing business checking account. December 1, 2018 Deposit Ticket1 Nick borrowed from the local bank it is a s. Il bank. It is a $20.000.00 year note, 10% interest Check Number Nick paid cash for a trailer listed on Cran's list to haul his lawn equipment Nick signed a contract with a cellular company and purchased a smart phone on account to track appointments and make $200.00 business phone calls (anything less than $300 is considered an expense). Nick purchased a lawn tractor at Season $4.000.00 Secember 3, 2018 account. Nick paid cash for a hand lawn mower at Check Number Menards (anything tangible over $300 is $750.00 capitalized as a fixed asset). Nick paid for a one-year insurance policy 1.200.00 Check Number that was effective December 1. Nick signed a contract with a local graphic center to detail the name of the business on song X December 2, 2018 X X X X December 3, 2018 101 C December 4, 2018 102 x December 5, 2018 Check Number X December 5, 2018 103 X his truck for advertising and received an Invoice to be paid. Nick paid cash for supplies (gas cans, rakes. & garbage cans) which he will be using in November for the business (hint - he is $90.00 using them right away so they are an expense) Nick filled all of the gas cans and purchased oil for the lawn equipment (GOS & Clare Canon recorded as an asset and adjusted at the end of the month for usage). Nick advertised his business in the local newspaper The newspaper invoices their $100.00 customers monthly Nick performed lawn service for the local Community College campus and its $1,000.00 dormitories. The college was invoiced December 8, 2018 Check Number December 9, 2018 Invoice 001 December 10, 2018 December 1. 2018 December 14, 2018 December 415, 2018 December 17, 2018 December 19, 2018 December 19, 2018 December 22, 2018 December 24, 2018 December 28, 2018 December 28, 2018 Deposit Ticket 2 Nick performed lawn service for The CPA Firm and received cash $200.00 The Insurance Agency gave Nick an advance Deposit Ticket 2 payment to maintain their lawn Nick $900.00 quoted them $300 per service visit. Deposit Ticket 2 Nick received partial payment for woice anno 001 Invoice 002 Nick performed lawn service for MNO $400.00 Marvufacturing. The company was irwoiced. Check Number Nick filled all of the gas cans and purchased sam 105 oil for the lawn equipment Check NumberNick paid the local graphic center for the $700.00 106 work they did on his truck $400.00 Deposit Ticket 3 Nick received payment for invoice 002 Nick performed lawn service for The Local $950.00 Invoice 003 Community College campus and its dormitories. The college was invoiced Check Number Nick filled all of the gas cans and purchased $27500 107 oil for the lawn equipment Nick submitted an expense report for Check Number 108 truck business mileage incurred on his personal $210.00 $800.00 Invoice 004 $175.00 December 29, 2018 December 29, 2018 December Nick performed lawn service for a new client, FSC Corporation and sent them an invoice Nick paid the cell phone for the month of December Nick withdrew cash for personal use. $1,000.00 Check Number 109 Check Number 110 30, 2018 Excel Fietot View insert FormatTools Date Window Help Fri Nov 24 Acctg1 Practice Set Template, SP19 Addy Burnett Home Insert Draw Page Layout Formulas Data Review View BI O A Merge & Carte $ % 9323 ou Table Sivas H ormat X Fier Roberts Lawn service Worksheet For the Month anded December 31, 2018 III IIIIIIIII MacBook Pro My

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions