0

# Need to deduct one column from another to show the balance available but this balance has to be shown in the deducted column to show that the two columns are equal?

Updated: 9/24/2023

Wiki User

10y ago

Sounds like you are trying to balance off a T-account.

The easiest way to do this is:

1. Sum the debit and credit columns separately;
2. Take the smaller sum from the larger sum to find the balance;
3. Put this balance in the column with the smaller sum with description "Balance c/d";
4. The two columns now total the larger sum (found in step 1), so write this as the total for each of the columns;
5. Under the total in the column which originally had the larger sum write the balance (found in step 2) with description "Balance b/d".
If there is a zero balance found in step 2, there is no balance carried down, the t-account already balances and no figures other than the total need be written.

However, if you want to have an opening balance written, then put the "balance c/d" in the opposite column to the type of balance the account normally has (eg an asset account normally has a debit balance, so the balance c/d (of 0) would go in the credit column) above the totals and the "balance b/d" goes in the normal column (eg for an asset account this would be in the debit column) under the totals.

Wiki User

10y ago

Earn +20 pts
Q: Need to deduct one column from another to show the balance available but this balance has to be shown in the deducted column to show that the two columns are equal?
Submit
Still have questions?
Related questions

### What is the difference of trial balance of balances and trial balance of totals?

trial balance of balances is the trial balance with two columns while trial balance of totals is the one with four columns

18,357.82

### What does it mean to balance the columns on page in word 2007?

To Make all the columns the same length.

### How can balance columns of unequal length on a page?

You can balance columns of unequal length on a page by inserting a continuous section break at the end of the last column on the page. You can also try a column break to move text from one column into another. This may take a little experimentation to get it right.

### How can you balance columns of unequal lengths in Word?

You can balance columns of unequal length on a page by inserting a continuous section break at the end of the last column on the page. You can also try a column break to move text from one column into another. This may take a little experimentation to get it right.

### Shall we extend the number of columns in a Microsoft Excel work sheet?

Can not be done. Your version of Excel has a fixed maximum number of columns available. However, if you just want to include more available columns in an existing worksheet, just insert columns, as needed.

service revenue

balance

### How are rows and columns identified?

Columns are up to down, while rows are from left to right. This is true on spreadsheets, paper balance sheets, etc. On spreadsheets, columns are identified with letters and rows are numbered.

column break

### How do you balance the columns in a newsletter so that each column contains the same amount of text?

manually set the column widths in the columns dialog box

### What is double column cash book?

Double column cash book is tha in which there are columns for cash balance as well as for bank balance.