Deposits in transit calculator

List the deposits recorded in your cash records and compare them with the bank statement. Mark the deposits included in the statement as cleared. The tool totals the unchecked items and adds that amount to the statement balance. Use it as a supporting schedule for the full bank reconciliation, and retain the deposit records that explain each item. The IRS example below illustrates deposits not yet credited by the bank.

Worked example: IRS deposits not credited

The IRS illustration adds these deposits to the bank statement balance before subtracting outstanding checks.

How it works

Method source: IRS Publication 583. Amounts are calculated in whole cents. The tool reports the arithmetic of your inputs and does not update your records.

Compare recorded deposits with the statement

Start with the deposits in your checkbook or cash records for the period being reviewed. IRS Publication 583 instructs users to compare the deposits listed on the bank statement with deposits shown in the checkbook and note differences in the dollar amounts. Give each register row a generic reference that can be matched to its supporting deposit record, then enter the amount without commas.

Use the cleared checkbox for deposits that appear on the statement being reconciled. Unchecked rows are added to the in transit total. If you entered a duplicate or an unrelated item, remove that row. The calculator totals what you enter; it cannot tell whether a deposit record exists or whether the bank has processed a payment. Perform that comparison before treating a row as a reconciling item.

Keep the period and evidence together

Use the same statement cutoff for every row. A deposit credited after that cutoff should not be marked cleared for the earlier statement solely because it now appears in online banking. Check the statement being reconciled and keep the deposit record alongside the schedule. That makes it possible to review the timing difference when you work on the next period.

The result adds the unchecked total to the bank statement balance. This follows the IRS illustration, where deposits in the checkbook but absent from the statement are added to the bank side. The calculation is a deposit adjustment only. Outstanding checks and supported bank corrections can also affect the adjusted bank balance, and book entries still need their own review.

Avoid entering the same receipt twice

Use the register to explain differences between existing records. Before adding a row, confirm that the deposit has been recorded in the books and is missing from the statement under review. If it is absent from the books as well, investigate the underlying receipt and recording process. The register does not create a new receipt entry or decide which accounting period applies.

When moving the in transit total into the full worksheet, enter the supporting rows on the bank side. If the ledger balance already includes those deposits, do not add them again to the book balance. Use a signed book correction only when the records support an actual recording correction, as in the separate correction shown in the IRS worked example.

Carry the schedule into your review

Download the CSV to keep the row references, amounts and cleared status. Print the register with the bank statement if you prefer a paper record. The page remembers entries in this browser, so check the retained rows before starting another period. Clear entries when you have saved the completed schedule and want to begin a fresh comparison.

Questions about this tool

Official sources

• IRS Publication 583: checking account reconciliation and recordkeeping illustration

Data as of 2026-10-05. Published illustrations are static teaching cases, not live account data.