How to Complete the Worksheet with Accounting Principles

How to Complete the Worksheet with Accounting Principles

النص الكامل للفيديو

in this video we will see how to complete worksheet worksheet is multiple column form used in The Adjustment process and in preparing financial statements it is working tool and not permanent accounting record companies usually computerize worksheets by using an electronic spreadsheet programs such as Excel worksheet is neither journal nor part of the general ledger the use of worksheet is optional worksheet makes it possible to provide the financial statements to the management and the other interested parties at an earlier date let's look at an illustration to understand how we can complete worksheet partial worksheet of Ambit toe company is provided to us it has the adjusted trial balance from which we are required to fill in the income statement and the balance sheet to complete the worksheet an income state shows the financial performance of business for specific time period it presents the revenues and expenses and the resulting net income or net loss for specific period of time first we record revenues Ambit toe has service revenue of $166,000 service Revenue has normal credit balance so we record $116,000 in the credit column of the income statement next we list expenses expenses have normal debit balance and all the expenses are recorded in the debit column of the income statement expenses of Ambit toe include salaries and wages expense of $10,200 rent expense of $900 depreciation expense of $698 and interest expense of $63 total expenses and total revenues incurred During the period are $1,861 and $116,000 resp effectively thus the net income of $4,139 is the excess of Revenue over expenses thus total debit equals total credits next we complete the balance sheet Columns of the worksheet in balance sheet we list assets liabilities and stock ERS Equity first we list assets assets have normal debit balance and therefore will be recorded in the debit column of the balance sheet under assets we have cash of $11,500 accounts receivable of $8,250 prepaid rent of $2,700 and Equipment of $24,105 638 note that accumulated depreciation is contra asset account and has normal credit balance it reduces is the value of assets next we list liabilities and owner's equity which have normal credit balance hence they will be recorded in the credit column of the balance sheet under liabilities we have notes payable of $ 7,620 and accounts payable of $558 Interest payable of $63 liability will be recorded in the credit column of the balance sheet under owner Equity we have owner's capital of $27,900 and owner's drawings of $3,500 note that owner's drawings is contra Equity account and has normal debit balance it reduces the balance of owner's equity the total of the debit column in the balance sheet is $49,990 the total of the credit column excluding net income is $45,881 to this we add the net income of $4,139 which increases owner's equity by adding the net income we notice that total debits equal total credits it indicates that assets equal the sum of liabilities and owners equity
Create Worksheets in Seconds with AI Perfect for Teachers Tutors 0:19

Create Worksheets in Seconds with AI Perfect for Teachers Tutors

Alamin

30.4K مشاهدة · 11 months ago

How to Create a Worksheet in Canva Tutorial for Teachers 21:31

How to Create a Worksheet in Canva Tutorial for Teachers

Pocketful of Primary

77.1K مشاهدة · 2 years ago

How to Prepare a Worksheet 6:31

How to Prepare a Worksheet

Steven Force

12.4K مشاهدة · 5 years ago

How to create a spreadsheet in excel in 5 minutes excel for beginners 11:54

How to create a spreadsheet in excel in 5 minutes excel for beginners

Learning MsOffice

1.9M مشاهدة · 2 years ago

Worksheet in Nepali 2080 Model Question Solution 5 Marks NEB Account Exam 16:02

Worksheet in Nepali 2080 Model Question Solution 5 Marks NEB Account Exam

Gurubaa

968.5K مشاهدة · 3 years ago

Create a Worksheet with Me in Google Docs 18:45

Create a Worksheet with Me in Google Docs

Busy Miss Beebe

2.8K مشاهدة · 9 months ago

Split Excel Worksheet into Separate Worksheets Based on Column Value WITHOUT VBA MACRO 2:59

Split Excel Worksheet into Separate Worksheets Based on Column Value WITHOUT VBA MACRO

Chester Tugwell

70.2K مشاهدة · 2 years ago

Pre Nursery Worksheets Try this with your kids 0:24

Pre Nursery Worksheets Try this with your kids

InkCrafted

1.1M مشاهدة · 1 year ago

Google Sheets Tutorial for Beginners 49:11

Google Sheets Tutorial for Beginners

Kevin Stratvert

1.5M مشاهدة · 3 years ago

Create a worksheet for your students 0:15

Create a worksheet for your students

Brianne Ferreiro

8K مشاهدة · 3 years ago

Generate almost any type of worksheet 0:19

Generate almost any type of worksheet

SetupsAI

209.7K مشاهدة · 11 months ago

Alphabets worksheets for kindergarten 0:06

Alphabets worksheets for kindergarten

Learn with Saha

30K مشاهدة · 4 years ago

Free digital tool to make your own worksheets 0:15

Free digital tool to make your own worksheets

Make learning Fun

39.6K مشاهدة · 3 years ago

Fun Easy LKG Maths Worksheets for Kids Preschool Learning Activity 0:18

Fun Easy LKG Maths Worksheets for Kids Preschool Learning Activity

rainbowDoodle

1M مشاهدة · 11 months ago

How to Create a Worksheet In Canva Beginner Friendly Tutorial For Teachers 8:10

How to Create a Worksheet In Canva Beginner Friendly Tutorial For Teachers

Teacher Tech with Allyeah

3.8K مشاهدة · 1 year ago

worksheet for curved ll Tracing the curved line 0:16

worksheet for curved ll Tracing the curved line

kids color academy

34.3K مشاهدة · 4 years ago

Class 1 maths worksheet maths worksheet for class 1 0:12

Class 1 maths worksheet maths worksheet for class 1

moms magic

1.5M مشاهدة · 1 year ago