1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Identify Back Date Entry / Deals - Volume Report

Discussion in 'Ask an Excel Question' started by ashish mehra, Jan 9, 2019.

  1. ashish mehra

    ashish mehra Active Member


    We are facing 3 issues as of now:

    1) Back Date Entry posted in system
    2) Change in Loan Amount
    3) Change in Loan Start Date column

    Point# 1) There is a bug in our system that is allowing back date entry posting manually in system by Operation team. Till the system is developed we have to find manual way.

    Point# 2) Initially Disbursed amount is 50k but after 2-3 months this could be 20k in addition to initial amount. We refer these as Partial Disbursed booked deals.

    Point# 3) We have found that in some scenarios Loan Start Date is changed due to Partial Disbursed deals.

    We have to make a model to overcome the above conditions in Volume Report.

  2. Deepak

    Deepak Excel Ninja

    Can we have a sample file.
  3. ashish mehra

    ashish mehra Active Member

    Hi Deepak,

    I have shared sample data for Volume till July & August with Output format of Volume Report.

    The logic is once the Volume Report is made, this will be freeze. There will not be any change.


    Attached Files:

Share This Page