Video instructions and help with filling out and completing Are 8850 Form Debit

Instructions and Help about Are 8850 Form Debit

Welcome to the virtual office tanning today we will learn how to create a business account laser in Microsoft Excel today we will see two different business account ledger first laser is here and here is a direct reference description debit and credit and balance column given and opening balance is in debit side and income is in the aside and expenses in credit side all the expenses we will put into credit side all the income we put into debit side and how can we perform this calculation let's see just delete all the calculation first this is the opening Elysee type is equal to and select this cell and press enter and after that you have to perform calculation in this cell just type is equal to and select opening balance plus debit amount minus credit amount this is a debit amount and this is a credit amount and press enter now if you drag it to the bottom now all the calculation will be done this is a debit and 1000 debit 60,000 and 5000 is - and now 55,000 20,000 debit 75,000 now you can perform this calculation like this this is a business account ledger and you can create in your excel sheet and this is a total double amount and this is a total credit amount and if debit - credit dog balance will be display here now just I just perform this calculation just let auto sum and select the select debit cells and press ENTER and select click autosum and select the grid cells and press enter and type is equal to t cell minus t cell you can create a business account ledgers like this as well this is a two column business letters debit credit and this is a one column debit and credit business account ledger you can create like this how can perform this calculation Deb all the debit amount in positive amount and this is a credit amount and it will you you can type this minus or bracket sign this is a minus amount if you type minus 5,000 press ENTER it will display like this and this is expense and this is a income income is positive and expenses negative now how can we perform this calculation just type is equal to and let these cells type is equal to and type sum and press tab key and select the cell and shift : if you press shift + : mine it will display like this m12 and m12 D cell display like this first am 12 you have to free just press f4 to freeze this cell and press ENTER now drag it to the bottom now you can see the balance is 40,000 this is a fifty thousand and ten thousand plus it's a sixty thousand and five thousand - it's 55 thousand now you can perform this calculation like this just understand it will sum these amount and T cell if I drag it it will be changed and it will be 6m 13 and if you sum M 12 and M 13 and 12 NM 13 it will come then it will like this it will display like people 60,000 and if you perform some these three cells it will be - and now the balance is fifty-five thousand now you can create business account ledger like this this is these are two methods you can create a business account ledger hope this tip will be very helpful for you thanks for watching

Get Form