![debit credit balance debit credit balance](http://4.bp.blogspot.com/-KAF8xQmq9cM/Wq8w5uoAp6I/AAAAAAAAAzU/erY2YZ-LffM-mC_laKLabxOH8g6zFlcdwCK4BGAYYCw/s1600/Prob.%2B2%25E2%2580%25935A.png)
the debit side while the decrease is entered on the right side, i.e. There are some accounts in which an increase is entered on the left side i.e. for credit.įurther, all the accounts indicate entries of increase as well as decrease.
![debit credit balance debit credit balance](https://media.cheggcdn.com/media/070/070f182e-45d3-49be-83cd-6c6795b85d20/phpnbxeJJ.png)
And the left side will be the debit side, whereas the right side will be the credit side. Hence, your left-hand side will be the left side and your right-hand side will be the right side. Well, you should always remember that if there lies an open book in front of you and it is you who look at the book and not the book looks at you. Now, how could you identify the left and right sides of the account? The terms ‘debit’ and ‘credit’ reflects the left-hand side and right-hand side of an account respectively. assets = liability + capital, and the rules for debit and credit to check the accuracy of the recorded transactions. One can use the basic accounting equation i.e. On the contrary, the one who provides or gives a benefit is credited because he is entitled to a return of the obligation. In accounting terminology, the individual who receives the benefit is debited as he is placed under an obligation. In this post, we will discuss the difference between debit and credit in accounting Content: Debit Vs Credit in Accountingĭebit is an entry that is passed when there is an increase in assets or decrease in liabilities and owner's equity.Ĭredit is an entry that is passed when there is a decrease in assets or an increase in liabilities and owner's equity. In short, banks refer to the terms debit and credit in account differently. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.Important: The debit and credit rules for increase and decrease of accounts, in accounting terminology is different from banking terminology. If the answer is helpful, please click " Accept Answer" and upvote it. SELECT NULL ,NULL ,NULL, null,null, 'Total',sum(Debit),sum(Credit),null SELECT Trans_ID,Trans_Type,TransDate,Trans_Remarks, Code,Head,Debit,Credit,sum(Balance) over (order by (select null) ROWS UNBOUNDED PRECEDING) Balance T.Level_Four_ID_D as Code,COA.Level_Four_Name as Head, CAST(0 AS decimal(18,2)) as Debit, Trans_Amount as Credit,CAST(0 AS decimal(18,2))-Trans_Amount Balance
![debit credit balance debit credit balance](https://kashoo.com/wp-content/uploads/2014/09/DC-4-886x1024.png)
#DEBIT CREDIT BALANCE CODE#
T.Level_Four_ID_C as Code ,COAc.Level_Four_Name as Head, T.Trans_Amount as Debit, CAST(0 AS decimal(18,2)) as Credit,T.Trans_Amount- CAST(0 AS decimal(18,2)) Balance SELECT T.Trans_ID,ty.trans_type_name as Trans_Type,Convert(varchar, T.Trans_Date ,101)as TransDate, SELECT NULL Trans_ID,NULL Trans_Type,NULL TransDate,'Opening' Trans_Remarks,NULL Code,NULL Head,null Debit,null Credit,isnull(opening,0) Balance Sql-server-general sql-server-transact-sql T.Level_Four_ID_D as Code,COA.Level_Four_Name as Head, CAST(0 AS decimal(18,2)) as Debit, Trans_Amount as Credit (CONCAT(COA.Level_Four_Name ,'Online Receipt C/O',' ',COA.Level_Four_Name, '',T.Trans_Amount)) as Trans_Remarks, SELECT T.Trans_ID,ty.trans_type_name as Trans_Type, Convert(varchar, T.Trans_Date ,101)as TransDate, Inner join #tbl_trans_type ty on ty.trans_type_ID=T.Trans_Type_ID Inner join #tbl_COA COAc on COAc.Level_Four_ID=T.Level_Four_ID_C Inner join #tbl_COA COA on COA.Level_Four_ID=T.Level_Four_ID_D T.Level_Four_ID_C as Code ,COAc.Level_Four_Name as Head, T.Trans_Amount as Debit, CAST(0 AS decimal(18,2)) as Credit (CONCAT(COA.Level_Four_Name ,' ','Online Receipt C/O',' ',COAc.Level_Four_Name,' ', 'Rs. INSERT INTO #tbl_transection VALUES(4,1215,1222,44444,'',5)Īs( SELECT T.Trans_ID,ty.trans_type_name as Trans_Type,Convert(varchar, T.Trans_Date ,101)as TransDate, Insert into #tbl_trans_type VALUES(4,'Return') Insert into #tbl_trans_type VALUES(4,'Tranfer') Insert into #tbl_trans_type VALUES(3,'Deposite') Insert into #tbl_trans_type VALUES(2,'Cheque') Insert into #tbl_trans_type VALUES(1,'Online') INSERT INTO #tbl_COA VALUES(1222,'Cheque In Hand',45000) I want Balance column in Last ,if opening Balance is define in #tbl_COA table then get opening from there else 0,īalance =(Opening+Debit-Credit),then carry Forward.īelow is Data Create table #tbl_COA (Level_Four_ID int,Level_Four_Name varchar(50),Opening decimal(10,2))Ĭreate table #tbl_trans_type (Trans_Type_ID int,trans_type_name varchar(50))Ĭreate table #tbl_transection (Trans_ID int,Level_Four_ID_C int,Level_Four_ID_D int,Trans_Amount Decimal(10,2),Trans_date date,Trans_Type_ID int)