What Is a Ledger Balance? Meaning, Formula, and Examples

A ledger balance is the balance in a bank account after the bank records posted deposits, withdrawals, fees, and other transactions. It represents the bank’s recorded position at a particular cutoff. It does not necessarily show how much you can spend: pending payments and deposit holds can make your available balance different.

For a finance team, this distinction matters twice: when planning payments and when reconciling the bank statement to the company’s cash records.

Key Takeaways

• Ledger balance reflects posted bank transactions. Available balance reflects funds the bank currently permits you to use.
• Calculate it as opening balance plus posted credits minus posted debits, using the bank statement’s terminology.
• Reconcile records for the same account, currency, and cutoff date.
• Excel and AI can help prepare transaction files and explain differences. Accounting adjustments still require review.

What Is a Ledger Balance?

Banks may label this figure “ledger,” “posted,” or “current” balance, although terminology varies. SoFi Tech Solutions’ balance documentation describes ledger balance as the total of officially posted account transactions, excluding pending transactions.

The cutoff matters. Some banks calculate the displayed ledger balance during nightly processing. Other systems expose posted balances through different reporting schedules. Check the balance’s timestamp and your bank’s explanation rather than assuming every balance updates identically.

Bank Ledger Balance vs. Your Company’s Book Balance

Your company also maintains a cash account in its general ledger. That book balance reflects transactions recorded in your accounting system.

The two records can differ legitimately. You may have recorded a supplier check before the bank processes it. The bank may have charged a service fee that your bookkeeper has not entered.

In this article, “ledger balance” means the bank’s posted balance. “Book balance” means the company’s internal cash balance. Keeping those labels separate makes reconciliation easier to follow.

Ledger Balance vs. Available Balance

The central difference is the question each number answers.

The Office of the Comptroller of the Currency explains that available balance generally accounts for holds on deposited funds and authorized, pending card transactions.

Even available balance can omit obligations the bank has not received. A check you mailed or a future payroll payment may still need to be reserved in your own cash plan. Neither displayed balance provides a complete list of upcoming commitments.

How to Calculate Ledger Balance

The Ledger Balance Formula

For a deposit account, using bank-statement terminology:

Closing ledger balance = Opening ledger balance + Posted credits − Posted debits

Credits here mean money added to the bank account. Debits mean money removed. In the company’s own accounting records, a debit increases a cash asset account, so do not apply the bank’s sign convention blindly to a general ledger export.

Use an opening balance immediately before the reporting period, then include only postings within that period.

A Worked Ledger Balance Example

Suppose a business starts June 30 with $10,000 in its bank account. These transactions post that day:

The closing calculation is:

$10,000 + $2,000 − $1,500 − $25 = $10,475

This illustrative example assumes no other posted activity.

On July 1, the business makes an $800 debit card purchase. The bank authorizes it, but the transaction has not posted. Assuming no other holds or adjustments:

• Ledger balance remains $10,475.
• Available balance falls to $9,675.

When the $800 debit posts and the corresponding authorization hold releases, the ledger balance becomes $9,675. Available balance remains $9,675 if nothing else changes. The authorization and final posting should not reduce available funds twice. Hancock Whitney’s explanation illustrates this sequence.

How Ledger Balance Fits Into Bank Reconciliation

Reconciliation compares the bank’s records with your books and explains their differences. Xero’s reconciliation guide distinguishes timing items, such as outstanding checks, from transactions that require book adjustments.

Start With the Same Cutoff Date

For June’s reconciliation, use the June 30 statement closing balance. Do not compare June’s cash book with a live banking screen that already reflects July activity.

Return to the example. The bank’s June 30 balance is $10,475, but the company’s cash book shows $9,800. Investigation identifies:

• A $500 deposit in transit, recorded in the books but not posted by the bank.
• A $1,200 outstanding check, recorded in the books but not processed by the bank.
• The $25 bank fee, posted by the bank but missing from the books.

Separate Timing Differences From Book Adjustments

The deposit and check explain timing differences. They are already in the books, so recording them again would duplicate activity. The fee requires an approved accounting entry.

The July 1 card authorization belongs outside this June 30 reconciliation. It matters for current payment capacity, but it does not change June’s statement balance.

For the broader process, see HiData’s bank reconciliation guide. Keep the completed reconciliation and supporting records with your month-end close checklist.

How to Review Ledger Balance in Excel

Prepare the Transaction Table

Keep an untouched source export. Build a separate working table for one bank account and one currency, with these fields:

• Transaction ID and source row
• Transaction date and posting date
• Description or reference
• Credit and debit amounts
• Posting status

Use actual Excel dates and numeric amounts. For the formula below, both Credit and Debit contain positive amounts; the formula subtracts Debit. If your bank provides one signed Amount column, use that convention consistently instead.

Distinguish transaction date from posting date. A June 30 purchase posted July 2 belongs to July’s posted bank activity, even if your accounting treatment requires a June entry.

Standardize inconsistent formats before calculating. HiData’s data cleaning guide explains how to preserve sources and review uncertain records without silently replacing missing data.

Calculate and Check the Closing Balance

Name the Excel table Txns. Set:

• B1: opening ledger balance immediately before the start date
• B2: period start date
• B3: cutoff date

Use:

=$B$1
+SUMIFS(Txns[Credit],Txns[Status],"Posted",
 Txns[Posting Date],">="&$B$2,
 Txns[Posting Date],"<"&($B$3+1))
-SUMIFS(Txns[Debit],Txns[Status],"Posted",
 Txns[Posting Date],">="&$B$2,
 Txns[Posting Date],"<"&($B$3+1))

The upper date limit includes timestamps throughout the cutoff day. For the example, B1 is 10000 and both dates are June 30. The result is 10475.

This formula assumes the table contains only the selected account and currency. Add account and currency criteria if it contains several. Filtering the visible rows alone does not restrict SUMIFS.

Then calculate:

Balance difference = Calculated closing balance − Statement closing balance

A zero difference confirms that the opening balance and included postings reproduce the statement total. It does not prove every transaction is legitimate or that the company’s books are reconciled.

Build an Exception Review List

Investigate differences before changing records. Common causes include repeated imports, missing rows, reversed signs, incorrect cutoffs, and pending transactions included as posted.

Compare bank and book exports using references, amounts, and reasonable date windows. Matching on amount alone can confuse separate payments of equal value. Grouped deposits and split payments may also need one-to-many matching.

Keep possible matches separate from confirmed matches, with source references and reviewer decisions. Never insert an unexplained adjustment simply to make the difference zero.

An AI-Assisted Workflow With HiData

Prepare and Analyze Transaction Exports

When several exports use different headers or formats, preparation can take longer than the calculation. HiData AI Sheets supports spreadsheet cleaning, classification, data transformation, analysis, and visualization through natural-language instructions.

A useful starting request is:

Standardize the dates and amount fields in this bank export. Keep posted and pending activity separate. Flag possible duplicate transaction IDs without deleting rows, and summarize posted credits and debits through June 30.

Review the proposed changes against the original file. Then use the prepared data to calculate balances and organize items requiring investigation. Any AI-suggested match or explanation should retain enough source detail for a reviewer to verify it.

The useful output is a reviewable transaction table and exception summary. Finance staff still approve accounting entries and decide whether a difference represents timing, an error, or an unfamiliar payment.

Local and Private Data Processing

Bank exports contain sensitive account and transaction information. Local AI processing can help teams work within an approved environment when their deployment supports it.

HiData offers private and on-premises deployment options. For a local reconciliation workflow, confirm where files, model processing, and results reside in the configured setup. A web account does not by itself establish that every processing step stays on the device.

Frequently Asked Questions About Ledger Balance

Can I Withdraw My Ledger Balance?

Not necessarily. The bank may restrict part of it through deposit holds or pending authorizations. Check available funds, account restrictions, and withdrawal limits, and account for payments the bank has not yet received.

Why Is My Available Balance Lower Than My Ledger Balance?

Common reasons include authorized card purchases awaiting posting and holds on recent deposits. Review the bank’s transaction and hold details rather than assuming the difference is an error.

Can Available Balance Be Higher Than Ledger Balance?

Yes. A bank may make incoming funds available before the transaction appears in the displayed ledger balance. The result depends on the bank’s posting and availability rules, so check the transaction details.

When Does Ledger Balance Update?

It depends on the bank and the balance field. Nightly processing is common, but reporting schedules vary. Check the posting date and displayed timestamp instead of assuming a universal clearing period.

What Does a Negative Ledger Balance Mean?

For a deposit account, it generally means posted debits exceed the opening balance plus posted credits. Review the transactions and contact the bank about unexpected activity or applicable overdraft terms.

For reliable cash decisions, keep the bank’s posted balance, available funds, and your own payment commitments visible separately. Use reconciliation to explain differences, and preserve the evidence behind every adjustment.