5 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.

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

Gather the Necessary Documents

To start the reconciliation process, it’s essential to collect the following documents:

  • Your latest bank statement: This is the most recent record of all your transactions with the bank, showing deposits, withdrawals, and other activities.
  • Your cash records or register: Keep track of your cash transactions separately. This could include any physical cash you handle or transactions that involve the bank.
  • Any deposit slips or receipts for deposits in transit: If you’ve made deposits that haven’t yet been reflected in your bank statement, gather the corresponding deposit slips or receipts. These documents help ensure all your deposits are accurately recorded.

Prepare your book debits

To stay organized with your financial records, it’s a good idea to get your book debits ready for the upcoming reconciliation. Essentially, book debits are entries in your cash book that document all the funds you’ve sent to your company’s bank for deposits. Having these records in order makes the reconciliation process smoother and ensures accurate tracking of your financial transactions.

cash book debits

Prepare your bank credits

Next, make sure to organize your bank credits. These are the deposits logged by your bank, crucial for reconciling your accounts. Properly arranging them facilitates the process, making it simpler to identify deposits in transit.

bank statement credits

Reconcile your deposits

To reconcile your deposits and identify deposits in transit, there are several approaches you can take. One effective method is using SUMIF in either Excel or Google Sheets. I recommend utilizing batch numbers above to streamline the search process.

Take a closer look at how I manually compare records using batch numbers. This may seem challenging with a large number of transactions, but it’s crucial for a quicker reconciliation of deposits in transit. Batch numbers provide a systematic way to match and identify transactions, making the process more efficient and accurate.

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.

Download Link

Related Post

Free Accounting Training

How I prepare & generate financial Statements in under an hour.

Email Address *

Scroll to Top