From Ledger Postings to an Ending Balance
A ledger account collects the amounts posted to one account. Its debit and credit columns show activity during a period, while its ending balance is the net amount remaining after that activity is considered. The two are not the same: a cash account can have thousands of dollars of debits and credits during a month but a much smaller balance at month-end.
To calculate that balance, include the opening balance on its existing side, total each column, and compare the two totals. This method applies whether the account is an asset, liability, equity, revenue, or expense account, and whether there is activity on one side or both. It assumes the opening balance and the period’s postings are already correctly recorded in this ledger account.
A Reliable Calculation Method
The opening balance is part of the ledger: place it on the side where the account already has a balance. Then include all postings made to the account during the period. Adding the debit amounts together and the credit amounts together gives the two totals to compare. Do not add a debit posting to the credit total merely because the account normally carries a credit balance; its posted side determines which column it belongs in.
Write the opening balance on its stated debit or credit side. List each posted debit and credit in the corresponding column.
Add all amounts in the debit column and, separately, all amounts in the credit column. Include the opening balance in its column.
Subtract the smaller column total from the larger. The larger column determines whether the ending balance is debit or credit.
A compact way to justify the method is to assign a positive sign to a debit balance and a negative sign to a credit balance. Each debit posting increases the signed balance, and each credit posting decreases it. Therefore, if \(D\) is the total of debit postings during the period and \(C\) is the total of credit postings, then
Here, \(B_{\text{open}}\) is positive for an opening debit balance and negative for an opening credit balance. If \(B_{\text{end}}>0\), its amount is a debit balance; if \(B_{\text{end}}<0\), its absolute value is a credit balance. If it equals zero, there is no ending balance. This follows because debits and credits move the net balance in opposite directions. The signed formula and the column-total procedure give the same result; the column method makes the ending side especially easy to identify.
An account’s normal balance helps interpret the result, but it does not replace the calculation. Assets and expenses normally have debit balances; liabilities, equity, and revenue normally have credit balances. A result on the opposite side may be unusual, but the side is still determined by the ledger totals. A debit or credit balance also does not, by itself, prove that the account is correct; this calculation only nets the amounts recorded in that account.
Worked Example: Finding the Ending Cash Balance
A small repair shop’s cash ledger opens the month with a debit balance of $4,800. During the month, posted debits are $1,250 and $600; posted credits are $900 and $1,400. Calculate the ending balance. State the method and identify the common mistake to avoid.
Method. Use the two-column total method. Cash is an asset and normally has a debit balance, so the opening amount is placed in the debit column. The postings stay on their recorded sides.
Debit total. Include the opening balance: $4,800 + $1,250 + $600 = $6,650.
Credit total. Add the credits: $900 + $1,400 = $2,300.
Compare. The debit total is larger, so $6,650 − $2,300 = $4,350 remains as a debit balance. The shop’s ending cash ledger balance is $4,350 debit.
Check. The net increase from the opening balance is $1,250 + $600 − $900 − $1,400 = −$450. Thus, $4,800 − $450 = $4,350, matching the column calculation. The common mistake is to report the $6,650 debit total as the balance; that total includes activity which must be offset by the $2,300 of credits.
Accounts With Activity on Both Sides
A ledger account may have postings on both sides even when it keeps its normal balance overall. The ending balance depends on the net difference, not on which side had more individual entries or on the largest single posting. It is also possible for the activity to exceed the opening balance and leave the account with a balance on the opposite side. In that case, report the side indicated by the totals rather than forcing the result to match the account’s normal balance.
Worked Example: Calculating an Accounts Payable Balance
A supplier account in a retailer’s accounts payable ledger opens with a credit balance of $7,200. During the month, the retailer posts debits of $2,750 and $1,100, and credits of $1,900 and $600. Find the ending balance. Explain why the opening amount belongs in the credit column.
Method. Use column totals, placing the opening balance on its stated side. Accounts payable is a liability and normally carries a credit balance, but the stated opening side—not just the account type—determines where this specific opening amount goes.
Debit total. $2,750 + $1,100 = $3,850.
Credit total. Include the opening credit balance: $7,200 + $1,900 + $600 = $9,700.
Compare. Credits exceed debits by $9,700 − $3,850 = $5,850. The ending balance is $5,850 credit.
Check. The net change from activity is $3,850 − ($1,900 + $600) = $1,350 toward the debit side. Applying that change to the opening credit balance leaves $7,200 − $1,350 = $5,850 credit. The common mistake is to omit the opening credit balance when totaling the credit column, which would incorrectly give a much smaller difference.
Worked Example: When the Ending Balance Changes Sides
A customer’s receivable ledger account opens with a debit balance of $1,250. During the month, the account receives debits of $400 and credits of $900 and $1,100. Calculate the ending balance and interpret its side. Assume these amounts are the complete postings for the account during the period.
Method. Total each side, including the opening balance. A receivable normally has a debit balance, but the calculation must allow for credits to exceed debits.
Debit total. $1,250 + $400 = $1,650.
Credit total. $900 + $1,100 = $2,000.
Compare. Credits exceed debits by $2,000 − $1,650 = $350, so the ending balance is $350 credit.
Check and interpretation. The activity alone is $400 − $2,000 = −$1,600. Adding that to the opening debit balance gives $1,250 − $1,600 = −$350, which represents a $350 credit balance. In this hypothetical customer account, that could reflect a payment exceeding the recorded receivable. The common mistake is to call the result a debit merely because receivables normally have debit balances; the larger ledger total determines the ending side.
Common Mistakes and Checks
The calculation is short, but several errors can produce a plausible-looking wrong answer. Keep the distinction between activity and balance clear: column totals show amounts accumulated on each side, while the ending balance is only the difference between them.
- Leaving out the opening balance. It is already part of the account and must be included in the correct column.
- Assigning an amount by account type instead of by posting. A credit posted to a cash account is still a credit; do not move it into the debit column because cash normally has a debit balance.
- Reporting both column totals as the ending balance. The ending balance is their difference, not the sum of activity on both sides.
- Assuming the normal side must be the ending side. If the opposite column is larger, the calculated balance is on that opposite side. Consider whether the result is reasonable, but do not change the arithmetic to force the normal side.
- Subtracting in the wrong order and losing the side. Subtract the smaller total from the larger, then label the result with the larger total’s side.
A final check can use the signed-balance formula: start with a positive opening debit balance or a negative opening credit balance, add the period’s debits, and subtract its credits. The sign should agree with the side identified from the column totals. If it does not, recheck the opening side and the column additions.
Check Your Understanding
For each account, include the opening balance in its stated column, total both sides, and identify the ending balance and its side.
- A cash account opens with a debit balance of $2,400. Posted debits are $650; posted credits are $475 and $900. What is the ending balance? (Answer: $1,675 debit)
- An accounts payable account opens with a credit balance of $5,600. Posted credits are $1,250; posted debits are $2,100 and $800. What is the ending balance? (Answer: $3,950 credit)
- A prepaid insurance account opens with a debit balance of $1,800. Posted debits are $900; posted credits are $1,100 and $350. What is the ending balance? (Answer: $1,250 debit)
- A customer receivable account opens with a debit balance of $780. It receives a debit posting of $220 and a credit posting of $1,400. What is the ending balance, and is it on the normal side for a receivable? (Answer: $400 credit; no, it is on the opposite side)
- An accumulated depreciation account opens with a credit balance of $3,200. It receives a debit posting of $450 and credit postings of $800 and $150. What is the ending balance? (Answer: $3,700 credit)