Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

cu unu une trom the Excel Name Box. Make your entries in the appropriate cells. No entry is required in the ITEM column. Remember, this

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
cu unu une trom the Excel Name Box. Make your entries in the appropriate cells. No entry is required in the ITEM column. Remember, this spreadsheet will not be part of your CengageNow grade. GENERAL LEDGER Account Cash Account No. 11 DATE POST REE DEBIT CREDIT BALANCE DEBIT CREDIT OS Account No. 12 Account Accounts Receivable DATE POST. REF. DEBIT CREDIT BALANCE DEBIT CREDIT Ledger ERP Work Sheet Type here to search Account Accounts Receivable Account No. 12 DATE ITEM POST REFDEBIT CREDIT BALANCE DEBIT CREDIT WN Account: Supplies Account No. 14 DATE DEBIT CREDIT BALANCE DEBIT CREDIT Account: Prepaid Rent Account No. 15 BALANCE DEBIT CREDIT DATE POST. REF. DEBIT CREDIT Account: Prepaid Insurance Account No. 16 BALANCE DEBIT CREDIT DATE ITEM POST RES DEBIT CREDIT Ledger EOP Work Sheet O Type here to search BCDEFGH Account: Prepaid Insurance AS, A ALIA TAIWAN TANIMIMANA AMATAI Account N DATE A U TEM POST. REF DEBIT CREDIT BALANCE DEBUT CR Account: Office Equipment Account No: BALANCE DATE I TEM POST. REF. DEBIT DEBIT CREDIT DEBIT CRE Account: Accumulated Depreciation Account No. DATE ITEM POSTRE DEBIT CREDIT BALANCE DEBIT CRED Account Accounts Payable Account No. BALANCE ITEM POST. REF DEBIT CREDIT CRED Account: Salaries Payable Account No. 2 ITEM POST. REF. DEBIT CREDIT BALANCE DEBIT CREDIT Ledger EOP Work Sheet O Type here to search te h Bc. F GHI Account No. 22 Account Salaries Payable DATE POST. REF. DEBIT CREDIT BALANCE DEBIT CREDIT Account. Unearned Fees Account No. 23 DATE POST. REF DEBIT CREDIT BALANCE DEBIT CREDIT Account: Kelly Pitney, Capital Account No. 31 DATE CREDIT BALANCE DEBIT CREDIT Account: Kelly Pitney, Drawing Account No. 32 BALANCE CREDIT DATE POST. REF. DEBIT CREDIT DEBIT Account No. 41 Account Fees Earned Ledger EOP Work Sheet O Type here to search Account Fees Earned Account No. 41 DATE ITEM POST. REF. DEBIT CREDIT BALANCE DEBIT CREDIT Account: Salary Expense Account No. 51 DATE CREDIT BALANCE DEBIT CREDIT Account Rent Expense Account No. 52 BALANCE DEBIT CREDIT DATE POST. REF. DEBIT CREDIT Account No. 53 Account: Supplies Expense Ledger EOP Work Sheet O Type here to search hp D E F G H Account Supplies Expense Account No. 53 ITEM POST. REF. DEBIT CREDIT LALANCE DEBIT CREDIT Account: Depreciation Expense Account No. 54 DATE POST. REF DEBIT CREDIT BALANCE DEBIT CREDIT Account Insurance Expense Account No. 55 DATE FORE DEBIT CREDIT BALANCE DEBIT CREDIT Account: Miscellaneous Expense Account No. 59 DATE ITEM POST. REF. DEBIT CREDIT RALANCE DEBIT CREDIT Ledger EOP Work Sheet O Type here to search hp Denption IPS Ret Cash 4,500 Unearned Fees 4,500 May 5: Received cash from dients on account, $2,450. Description Post Ref. Debit Credit Cash 2,450 Accounts Receivable 2,450 May 9: Paid cash for a newspaper advertisement, $225. Description el. Miscellaneous Expense Credit Debit 225 Cash May 13: Paid Office Station Co. for part of the debt incurred on April 5, $640. Description Post. Ref. Debit Credit Accounts Payable 640 De Description Posten Accounts Payable Cash 640 May 15: Provided services on account for the period May 1-15, $9,180. Description Accounts Receivable 9,180 Credit Fees Earned 9,180 May 16: Paid part-time receptionist for two weeks' salary including the amount owed on April 30, $75 Description Debit Credit Salary Expense 630 Salaries Payable 120 750 Cash May 17: Received cash from cash clients for fees earned during the period May 1-16, $8,360. Description Post. Ref. Debit Credit Cash 8,360 eBook Calculator Destation POR Cash 8,360 Fees Earned 8.360 May 20: Purchased supplies on account, $735. Description Credit Supplies 735 Accounts Payable 735 riod May 16-20, $4,820. Credit May 21: Provided services on account for c Description Accounts Receivable Fees Earned 4.920 4,820 May 25: Received cash from cash clients for fees eamed for the period May 17-23, $7.900. Description Post. Ref. Debit Credit Cash 7,900 7,900 Fees Earned Despionnent create Cash 7,900 Fees Earned 7,900 May 27: Received cash from clients on account, $9,520. Description Credit Cash 9,520 Accounts Receivable 9,520 May 28: Paid part-time receptionist fortreeks' salary, $750. Description Debit Credit Salary Expense 750 750 Cash May 30: Paid telephone bill for May, $260. Description Post. Ref. Credit Debit 260 CamSun xen 260 ATE D Miscellaneous Expense 260 Cash 260 May 31: Paid electricity bill for May, $810. Post. Ref. Debit Credit Description Miscellaneous Expense 810 Gast 810 May 31: Received cash from cash dients for fees earned for the period May 26-31, $3,300. Description Post Credit 3,300 Debi 3.300 Fees Earned May 31: Provided services on account for the remainder of May, $2,650. Description Post. Ref. Debit Accounts Receivable 2,650 Credit 2,650 Fees Ered cu unu une trom the Excel Name Box. Make your entries in the appropriate cells. No entry is required in the ITEM column. Remember, this spreadsheet will not be part of your CengageNow grade. GENERAL LEDGER Account Cash Account No. 11 DATE POST REE DEBIT CREDIT BALANCE DEBIT CREDIT OS Account No. 12 Account Accounts Receivable DATE POST. REF. DEBIT CREDIT BALANCE DEBIT CREDIT Ledger ERP Work Sheet Type here to search Account Accounts Receivable Account No. 12 DATE ITEM POST REFDEBIT CREDIT BALANCE DEBIT CREDIT WN Account: Supplies Account No. 14 DATE DEBIT CREDIT BALANCE DEBIT CREDIT Account: Prepaid Rent Account No. 15 BALANCE DEBIT CREDIT DATE POST. REF. DEBIT CREDIT Account: Prepaid Insurance Account No. 16 BALANCE DEBIT CREDIT DATE ITEM POST RES DEBIT CREDIT Ledger EOP Work Sheet O Type here to search BCDEFGH Account: Prepaid Insurance AS, A ALIA TAIWAN TANIMIMANA AMATAI Account N DATE A U TEM POST. REF DEBIT CREDIT BALANCE DEBUT CR Account: Office Equipment Account No: BALANCE DATE I TEM POST. REF. DEBIT DEBIT CREDIT DEBIT CRE Account: Accumulated Depreciation Account No. DATE ITEM POSTRE DEBIT CREDIT BALANCE DEBIT CRED Account Accounts Payable Account No. BALANCE ITEM POST. REF DEBIT CREDIT CRED Account: Salaries Payable Account No. 2 ITEM POST. REF. DEBIT CREDIT BALANCE DEBIT CREDIT Ledger EOP Work Sheet O Type here to search te h Bc. F GHI Account No. 22 Account Salaries Payable DATE POST. REF. DEBIT CREDIT BALANCE DEBIT CREDIT Account. Unearned Fees Account No. 23 DATE POST. REF DEBIT CREDIT BALANCE DEBIT CREDIT Account: Kelly Pitney, Capital Account No. 31 DATE CREDIT BALANCE DEBIT CREDIT Account: Kelly Pitney, Drawing Account No. 32 BALANCE CREDIT DATE POST. REF. DEBIT CREDIT DEBIT Account No. 41 Account Fees Earned Ledger EOP Work Sheet O Type here to search Account Fees Earned Account No. 41 DATE ITEM POST. REF. DEBIT CREDIT BALANCE DEBIT CREDIT Account: Salary Expense Account No. 51 DATE CREDIT BALANCE DEBIT CREDIT Account Rent Expense Account No. 52 BALANCE DEBIT CREDIT DATE POST. REF. DEBIT CREDIT Account No. 53 Account: Supplies Expense Ledger EOP Work Sheet O Type here to search hp D E F G H Account Supplies Expense Account No. 53 ITEM POST. REF. DEBIT CREDIT LALANCE DEBIT CREDIT Account: Depreciation Expense Account No. 54 DATE POST. REF DEBIT CREDIT BALANCE DEBIT CREDIT Account Insurance Expense Account No. 55 DATE FORE DEBIT CREDIT BALANCE DEBIT CREDIT Account: Miscellaneous Expense Account No. 59 DATE ITEM POST. REF. DEBIT CREDIT RALANCE DEBIT CREDIT Ledger EOP Work Sheet O Type here to search hp Denption IPS Ret Cash 4,500 Unearned Fees 4,500 May 5: Received cash from dients on account, $2,450. Description Post Ref. Debit Credit Cash 2,450 Accounts Receivable 2,450 May 9: Paid cash for a newspaper advertisement, $225. Description el. Miscellaneous Expense Credit Debit 225 Cash May 13: Paid Office Station Co. for part of the debt incurred on April 5, $640. Description Post. Ref. Debit Credit Accounts Payable 640 De Description Posten Accounts Payable Cash 640 May 15: Provided services on account for the period May 1-15, $9,180. Description Accounts Receivable 9,180 Credit Fees Earned 9,180 May 16: Paid part-time receptionist for two weeks' salary including the amount owed on April 30, $75 Description Debit Credit Salary Expense 630 Salaries Payable 120 750 Cash May 17: Received cash from cash clients for fees earned during the period May 1-16, $8,360. Description Post. Ref. Debit Credit Cash 8,360 eBook Calculator Destation POR Cash 8,360 Fees Earned 8.360 May 20: Purchased supplies on account, $735. Description Credit Supplies 735 Accounts Payable 735 riod May 16-20, $4,820. Credit May 21: Provided services on account for c Description Accounts Receivable Fees Earned 4.920 4,820 May 25: Received cash from cash clients for fees eamed for the period May 17-23, $7.900. Description Post. Ref. Debit Credit Cash 7,900 7,900 Fees Earned Despionnent create Cash 7,900 Fees Earned 7,900 May 27: Received cash from clients on account, $9,520. Description Credit Cash 9,520 Accounts Receivable 9,520 May 28: Paid part-time receptionist fortreeks' salary, $750. Description Debit Credit Salary Expense 750 750 Cash May 30: Paid telephone bill for May, $260. Description Post. Ref. Credit Debit 260 CamSun xen 260 ATE D Miscellaneous Expense 260 Cash 260 May 31: Paid electricity bill for May, $810. Post. Ref. Debit Credit Description Miscellaneous Expense 810 Gast 810 May 31: Received cash from cash dients for fees earned for the period May 26-31, $3,300. Description Post Credit 3,300 Debi 3.300 Fees Earned May 31: Provided services on account for the remainder of May, $2,650. Description Post. Ref. Debit Accounts Receivable 2,650 Credit 2,650 Fees Ered

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

Recommended Textbook for

Managerial Accounting

Authors: John J. Wild, Ken W. Shaw

2010 Edition

9789813155497, 73379581, 9813155493, 978-0073379586

Students also viewed these Accounting questions

Question

Define Administration and Management

Answered: 1 week ago

Question

Define organisational structure

Answered: 1 week ago