Deposits Outstanding but no Entries in Reconciliation

We often find some issues while doing the Bank Reconciliations, of which one issue is that, we find Deposits Outstanding in the Summary tab of the Bank Reconciliation Screen but no entries in the Reconciliation tab for the same.

We often find some issues while doing the Bank Reconciliations, of which one issue is that, we find Deposits Outstanding in the Summary tab of the Bank Reconciliation Screen but no entries in the Reconciliation tab for the same.

This issue may arise due to the Receipt Entry having the Deposit Date different from its Receipt Date.

For Example:

We have created the following Receipt Entry from the AR Module:

Here we have created the following Receipt Entry for which we have selected the Vendor as 1200 and the Bank as TEST4.

Then we have selected different Deposit Date and Posting Dates i.e The Deposit Date is selected as 1^st December 2022 and the Posting Date is selected as 24^th November 2022.

So now when we try to do the Bank Reconciliation for the month of November. .ie 30^th November 2022:

Here we can see there is a Balance in the Deposit Outstanding. But when we click on the Reconciliation tab, there are no entries regarding Deposits.

But when we try to do the Bank Reconciliation till 1^st December 2022:

Here we can see the Deposit entry which we created. After entering the Statement balance and reconciling the entry, the Out of Balance becomes 0.

The reason behind this issue is that the Bank Module takes the Deposit Date for the Reconciliation, although the calculation of Deposits is based on the Receipt date. So whenever we create a Receipt Entry with a different Deposit Date and Posting Date, the Reconciliation tab will show the entry only if the Deposit Date is in the Criteria.

Sage Software Solutions is a leading IT company with an array of advanced ERP Software solutions. Our proprietary products — Sage X3 and Sage 300 will help you cut your operational expenses, improve business productivity, increase operational efficiency, forge robust customer relationships, and strengthen association with vendors, suppliers, and distributors. So, if you are looking to reinforce your business fundamentals and emerge as an industry leader, then please schedule a call with one of our sales representatives.