9 Steps to Reconcile Deposits in Transit(with advance formula)

Today, you’ll learn how to reconcile deposits in transit.

When reconciling your deposits in transit, it is crucial to ensure that the cash balance reported in your records matches the bank’s records.

What is a deposit in transit?

A deposit in transit refers to the deposit made by your business that have not yet been credited by the bank.

This usually occurs when you make a deposit near the end of a bank statement period and it does not appear on that period’s bank statement.

Here’s a step-by-step guide on how to reconcile deposits in transit:

1. Gather the necessary documents

To begin the reconciliation process, you should gather the following documents:

 – Your most recent bank statement

 – Your cash records or register

 – Any deposit slips or receipts related to your deposits in transit

2. Review the bank statement

Carefully examine the bank statement, focusing particularly on the ending balance and any transactions listed.

Take note of any deposits that are not included in the bank statement, as these may be deposits in transit.

3. Review your cash records

Compare your cash records or register with the bank statement, paying close attention to any missing or unrecorded deposits.

Identify any deposits made near the end of the statement period that are not yet reflected in your bank statement.

These deposits are most likely your deposits in transit.

4. Verify the deposit slips

Match the deposit slips or receipts you gathered with your missing deposits in step 3.

Ensure that the deposit amounts and dates align.

If any discrepancies arise, thoroughly investigate and account for them.

It is also important to check for any errors in recording these deposits in your cash records.

Use the SUMIF function of Excel. Use batch numbers for simple reconciliation. Download the demo file below.

5. Update your records

Record the missing deposits in transit in your cash register or records.

Ensure that the amounts and dates match the deposit slips or receipts.

It is crucial to maintain accurate records throughout this process to avoid confusion and potential discrepancies later on.

6. Reconcile your balance

Add the deposits in transit back into your bank statement balance.

This will provide a more accurate reflection of the cash balance that should be reported in your records.

Make sure to double-check your calculations to avoid any errors.

7. Document the reconciliation

It is crucial to document the steps you’ve taken during the reconciliation process in case of future reference or auditing purposes.

Keep a record of your bank statement, cash records, deposit slips, and any calculations made.

This documentation will help you track the progress of your reconciliation and serve as evidence of your diligent efforts.

8. Stay organized

To avoid future discrepancies and make the reconciliation process smoother, it is important to stay organized with your financial records.

Keep track of your deposit slips, receipts, and bank statements in an orderly manner.

This practice will help you promptly identify any deposits in transit and streamline the reconciliation process.

9. Regularly reconcile

Lastly, make it a routine to reconcile your deposits in transit regularly, preferably monthly.

By doing so, you can promptly identify and rectify any issues or discrepancies.

Regular reconciliations also enable you to maintain accurate cash records and ensure the integrity of your financial statements.

Jason John Wethe
Follow Me
Latest posts by Jason John Wethe (see all)
Scroll to Top