Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please no handwritten answers please make fill out the spreadsheet The following events occurred in March: - March 1: Owner borrowed $125,000 to fund/start the
please no handwritten answers
please make fill
The following events occurred in March: - March 1: Owner borrowed $125,000 to fund/start the business. The loan term is 5 years. - March 1: Owner paid $250 to the county for a business license. - March 2: Owner signed lease on office space; paying first (March 20XX) and last month's rent of $950 per month. - March 5: Owner contributed office furniture valued at $2,750 and cash in the amount of $15,000 to the business. - March 6: Owner performed service for client in the amount of $650. Customer paid in cash. - March 8: Owner purchased advertising services on account in the amount of $500. - March 10: Owner provided services to client on account, in the amount of $1,725. - March 15: Owner paid business insurance in the amount of $750. - March 20: The owner received first utility bill in the amount of $135, due in April. - March 20: Office copier required maintenance; owner paid $95.00 for copier servicing. - March 22: Owner withdrew $500 cash for personal use. - March 25: Owner paid \$215 for office supplies. - March 25: Owner provided service to client in the amount of $350. Client paid at time of service. - March 30: Owner paid balance due for advertising expense purchase on March 8. - March 30: Received payment from customer for March 10 invoice in the amount of $1,725. - March 31: Last day of pay period; owner owes part-time worker $275 for the March 16 through March 31 pay period. This will be paid on April 5. - March 31: Provided service for client on account in the amount of $3,500. - March 31: Record depreciation of the office furniture at $45.83. Fouthel timiry Epn Overview In previous modules you examined the initial stages of the accounting cycie and practiced journalking financial transactions, ln Milestone One. you will complete the first part of your course areject to demenstrate your ablity to accurately recard financial data, which will contirae to be. wed to complete other aarts of the project Scenario You were recently tired as an entry level bookkeeper foe a service business that recentyr opened This is the first inooth in operation for the business and your first task is to recort business transactions for their first month using the source documents and transactian data the owner will grovide to you, Because this is a small business that does not use computerizcd accounting, wou wil apply the accounting cycle in Ercel to record transactions and senerate hnancial reportane results tar the oweter. Prompt Record Financial Data: Use accepted accounthos princioks to accurately capture business fransoctions for the month int the Comoamc Accountine Workboak Temoble using the data provided in the Accourtiok Data Acsecdix document. Specifically, you munt addeess the fotiowine fubric criteria - Accuracyi Prepare extries that are accueate in that they fuley refiect the aporoprate intormation. - Completeness Piepare entries that are comolete for each month, kicudini transterring ported entries to T accoungs encirint that the total debts and credts match Guidelines for Submission Ledger Accaints tab, and the Trial falukce tab. This shocid be completed ard sutymitted unine the Microsott fucel workbook ternolate. Please note that the first tab of the workbook giovides you with the chart of accounts. These are the accounts you will use in recorfine transactions for the Trial Balance ealances frena the tarcounts =ill autolili your tral balince. If fotal debits do not eqaal tolal credits in the trial balance: you know you have an eror. These are the balances that will be used to prepare the financial statecnents. Be sure to inglement feedbuck provided by your instructor for this Milestone One submission out the spreadsheet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started