How to Tie Out Bank Statements Month to Month

To tie out bank statements month to month, check two things on every statement in the run. First, beginning balance plus deposits minus withdrawals equals the stated ending balance. Second, that ending balance equals the next statement's beginning balance. When both hold for twelve months in a row, the run of statements is continuous and complete.

The statement balance roll-forward, line by line

A statement balance roll-forward is the arithmetic that links one bank statement to the next. Each month starts from the prior month's ending balance, adds the deposits and credits, subtracts the withdrawals and debits, and arrives at a new ending balance. That ending balance then becomes the following month's starting point.

Written out, the roll-forward for one month is:

1. Beginning balance, as printed on this statement.
2. Plus deposits and other credits: deposits, incoming transfers, interest credited and any reversals in the account's favour.
3. Minus withdrawals and other debits: checks paid, card purchases, outgoing transfers, fees.
4. Equals computed ending balance.
5. Compare with the ending balance printed on the statement.
6. Carry the printed ending balance to the next statement and compare it with that statement's beginning balance.

Steps 1 to 5 test one statement on its own. Step 6 tests the link between two statements. A run is proven only when both kinds of test pass for every month.

The figures come from the statement itself, never from the client's books. A roll-forward built from the ledger tests the ledger. A roll-forward built from the statements tests whether the firm has every statement and whether each one is internally consistent, which is the question before any reconciliation starts.

Most statements print a summary box with these totals, often labelled previous balance, deposits and credits, withdrawals and debits, and new balance. Use those totals rather than adding every line by hand. Adding the lines is a separate check, useful when the summary looks wrong.

For consumer accounts that can send or receive electronic transfers, the opening and closing balances are required content. The CFPB's text of Regulation E, section 1005.9 lists the account balance at the beginning and close of the statement period among what a periodic statement sets forth.

Running an ending balance check on every bank statement

A bank statement ending balance check confirms that the statement's own arithmetic adds up: the beginning balance, plus all credits, minus all debits, equals the printed ending balance. It catches a statement with missing pages, a partial printout, or totals copied wrongly into the worksheet. Run it on each statement before comparing neighbours.

In a spreadsheet the check is two formulas. If the beginning balance is in column B, deposits in C and withdrawals in D, the computed ending in E can be =ROUND(B2+C2-D2,2). Microsoft's support page for the Excel ROUND function describes it as rounding a number to a specified number of digits, which keeps tiny floating-point remainders from showing up as false differences.

With the printed ending balance in F, a status column can say whether they agree: =IF(ROUND(E2-F2,2)=0,"OK","CHECK"). The Excel IF function returns one value when the test is true and another when it is false.

A failed ending check usually has a plain cause:

• A category left out. The statement shows interest or fees in their own lines, outside the deposit and withdrawal totals. Add them to the right column.
• Missing pages. The PDF stops before the last transactions, so the totals typed in are short.
• A typing slip. Two digits swapped when copying a total into the worksheet.

Fix the input, not the formula. If the ending check still fails after every figure has been compared with the statement, the document itself is suspect, and the client should be asked for a fresh copy from the bank.

When many statements need their figures entered, the bank statements to Excel category covers ways to get them into a spreadsheet without retyping.

Why does a beginning balance not match the prior statement?

A beginning balance does not match the prior statement when the two documents are not true neighbours in the same account's run. The most common reason is a missing statement between them. Others are a statement from a different account, a reissued statement, or a printout made partway through a cycle and sent as the statement.

Work through the causes in this order:

1. A missing statement. Compare the period dates. If the earlier statement ends on May 31 and the later one starts on July 1, June is missing. Spotting this from the dates alone is covered in reading statement period dates to find missing bank statements.
2. A different account. Check the last four digits on both statements. Clients with checking and savings at one bank sometimes send the wrong one for a month.
3. A partial-cycle printout. A document printed from online banking before the cycle ended can pass its own ending check and still stop short. The period dates usually give it away: the "June statement" ends on June 26, not June 30.
4. A reissued or corrected statement. If the bank corrected an error and reissued a statement, the firm may hold the old version for one month and the new one for the next.
5. A typing error in the worksheet. Compare both figures with the PDFs before concluding anything else.

The difference between the two balances does not tell you the size of the missing activity. It is the net of everything in the gap. A $125.00 break could be one fee, or $30,000 in and $29,875 out.

Do not adjust the worksheet to make the balances meet. A break is information. Note it, find the cause and get the right document.

Roll-forward edge cases: pending items, fees and mid-month cycles

Some legitimate items make a bank statement roll-forward look wrong when nothing is missing. Pending transactions, fees posted at the cycle boundary, interest credits and mid-month cycles are the usual ones. Each has a simple explanation once you know to look for it, and none of them should be forced through the worksheet.

Pending items. Online banking often shows pending card transactions that have not posted. A statement shows only posted activity for its period. A client who compares the statement with the balance on their banking home screen will see a difference that is not an error. In the roll-forward, use only the statement.

Fees and interest at the boundary. A monthly service fee or interest credit posted on the last day of the cycle belongs to that statement. When it is printed in a separate section, include it in the right column or the ending check will be short by exactly that amount.

Mid-month cycles. A cycle that runs from the 15th to the 14th still rolls forward cleanly; it just will not line up with the client's monthly books. Label each row with the cycle dates, not the month name, so no one reads "March" as March 1 to 31.

Account changes. A renumbered account starts a new run whose beginning balance should equal the old account's final ending balance. Treat the link between them as one roll-forward step, with a note.

Combined statements. A statement that shows checking and savings together has two sets of balances. Run a separate roll-forward for each account, using its own lines.

Tie-out worksheet columns for a year of statements

A tie-out worksheet for a year of statements has one row per statement and columns for the period, the beginning balance, total deposits, total withdrawals, the computed ending balance, the stated ending balance and two status columns. One status checks the statement's own math. The other checks the link to the previous row.

Example twelve-month tie-out worksheet

This example is for a fictional client, Lindqvist Landscaping, and its Pinecrest Savings Bank checking account ending XXXX-5582, for 2026. All amounts are invented. "Ending check" compares computed and stated ending balances. "Roll-forward" compares each beginning balance with the previous row's stated ending balance.

Every row passes its own ending check, yet July begins $125.00 below June's stated ending. The period column explains it: the June document ends on June 26. It was a printout made before the cycle closed, not the June statement. The final days of June, holding $125.00 of net debits, are not in the file, so the firm asks the client for the actual June statement.

With the July beginning balance in B8 and the June stated ending in F7, the roll-forward cell can be =IF(ROUND(B8-F7,2)=0,"OK","BREAK"). Keep the period column in the sheet even when every cycle is a calendar month, because it is often the fastest way to explain a break.

Does a clean tie-out mean the bank account is reconciled?

A clean tie-out does not mean the bank account is reconciled. The tie-out proves the firm holds a continuous, internally consistent run of statements for the account. A bank reconciliation compares those statements with the client's own books, and explains every difference. The tie-out is the step before, and the reconciliation still has to be done.

What the tie-out leaves open is everything on the books side. A check the client wrote in December that the bank has not paid yet appears in the ledger and not on the statement. A deposit recorded on December 31 may reach the bank in January. A fee on the statement may never have been entered in the ledger. None of these affects the tie-out, and all of them affect the reconciliation.

The reconciliation works by pairing each ledger entry with a statement line, which is explained in matching ledger entries to bank statement lines. The guide on what a bank reconciliation is walks through a full month. The two most common timing differences have their own explainer: outstanding checks and deposits in transit.

The order still matters. A reconciliation built on a run with a missing month will either fail to balance or, worse, be forced to balance. Tying out first means the reconciliation starts from statements the firm knows are complete.

This first step is the part Schema CPA handles: as statements arrive it ties each one to the next and calls out any break or gap in the run, so the reconciliation starts from a complete set. The document categories on the homepage list the bank, savings and loan statements it reads.