How to calculate cash and cash equivalents

To calculate cash and cash equivalents, add reconciled cash balances and qualifying liquid investments under your company's accounting policy. First resolve bank-to-ledger differences, then classify the holdings, then tie the included total to the balance sheet. Restricted balances need their own identification so the cash total does not imply unrestricted spending capacity.

Start with one date and one reporting boundary

Use the same closing date for bank statements, the trial balance, investment statements, and the petty-cash count. This example is a US distributor's September 30, 2026 close, with every amount in USD and no foreign-currency balances.

Export account identifier, legal entity, statement date, carrying amount, ledger account, acquisition date, maturity date, restriction status, and a source reference. Add the approved cash-equivalent classification and the reason. A balance without enough evidence stays on the exceptions list until finance resolves it.

Work at the same entity scope as the reported balance sheet. A bank statement covering a subsidiary outside that scope does not belong in the total. Likewise, use balances rather than adding account balances to the individual transactions that produced them.

Decide what qualifies before adding it

Cash and cash equivalents = Reconciled cash + Qualifying cash-equivalent carrying amounts

The FASB cash-equivalent definition, in paragraphs 8-10 and the accompanying maturity footnote, requires ready conversion to known cash amounts and insignificant risk of value changes from interest rates. Generally, investments with original maturities of three months or less qualify; original maturity means the maturity when acquired by the reporting entity.

The test is more specific than being easy to sell. Review the instrument's terms and the company's policy, rather than classifying every short-term investment as cash. In this example, finance has approved a money market fund and a Treasury bill acquired with a three-month maturity as equivalents. A certificate acquired with a six-month maturity remains a short-term investment even though less time remains at the reporting date.

Keep restricted cash visible separately. Here, a collateral deposit is reported on a separate balance-sheet line and excluded from the cash and cash equivalents subtotal.

Step 1: reconcile the operating bank account

The statement and ledger initially disagree. The supporting records show the following adjustments, with no unresolved items.

The adjusted bank side equals the adjusted book side at $650,000. Post the supported wire and fee entries before taking the ledger total into the reporting schedule. The deposit in transit and outstanding checks are already recorded in the books; recording them again would duplicate those transactions.

With bank balance in B2, deposit in B3, and outstanding checks entered positively in B4, use:

=B2+B3-B4

With unadjusted ledger cash in C2, the incoming wire in C3, and fees entered positively in C4:

=C2+C3-C4

The difference between those two results must be zero. Keep each reconciling item tied to a bank reference and a ledger entry or subsequent clearing record.

Step 2: build the classified cash schedule

The operating bank row below uses the reconciled amount. All other holdings have been agreed to their statements or count records and ledger carrying amounts. The inclusion flag is a reviewed accounting input: 1 includes the balance in cash and cash equivalents; 0 excludes it.

Enter the following in D2 and fill through D7:

=B2*C2

The cash and cash equivalents subtotal in D8 is:

=SUM(D2:D7)

These are Excel formulas; Microsoft documents SUM as adding the numeric values in a range. Confirm amounts are numeric before totaling them. Covirage is not affiliated with Microsoft.

Step 3: prove both reporting totals

The balance sheet must show $1,035,000 in its cash and cash equivalents line. The remaining holdings reconcile as $90,000 of restricted cash plus $300,000 of short-term investments. Together, 1,035,000 + 90,000 + 300,000 = $1,425,000, matching the complete schedule.

The cash flow statement has a different boundary. FASB's restricted-cash update requires the beginning-to-ending reconciliation to include cash, cash equivalents, and amounts generally described as restricted cash or restricted cash equivalents. For this example, the ending cash-flow total is 1,035,000 + 90,000 = $1,125,000. The certificate remains excluded from that total.

The bank reconciliation, classified schedule, balance-sheet tie, and restricted-cash bridge answer separate questions. Complete all of them before using the closing balance as the starting point for a cash flow forecast.

Where it goes wrong

• Remaining maturity replaces acquisition maturity. Retain purchase-date evidence for each instrument and apply the policy consistently.
• A restriction disappears in the total. A collateral account can be real cash while remaining unavailable for ordinary operating payments.
• Transfers are counted twice. A bank sweep and the receiving fund statement can describe the same money. Reconcile account ownership and closing positions.
• Statement balances bypass reconciliation. Unrecorded fees and receipts leave the ledger wrong even when the statement itself is accurate.
• Different dates are combined. A current bank statement and an older investment statement cannot prove a single closing balance.

Reconcile your own cash file in Covirage

Bring your classified cash schedule, bank-reconciliation summary, and ledger totals to Covirage. Covirage maps the columns; its tools compute and check the totals and differences, while the external AI model explains the result with every figure traced to its rows. Create a free Covirage account in about a minute, then set up your business and bring a sample of your own data.

See FP&A reporting for the reporting context around the completed reconciliation.