Bank Reconciliation with IfNa and Match Excel functions.

Поделиться
HTML-код
  • Опубликовано: 27 окт 2024

Комментарии • 31

  • @kaluiroegbu1154
    @kaluiroegbu1154 3 месяца назад +1

    Thanks for this work

  • @brightonmungoni7782
    @brightonmungoni7782 3 месяца назад +1

    Thanks very much

  • @taiwobabatunde5573
    @taiwobabatunde5573 2 года назад +3

    Hello sir. Thanks for your insightful teachings. The worksheet however is not available on one drive. Kindly assist with practice worksheet especially when bank statements references are not same as cash book. Thank you.

  • @folamioyewumi4358
    @folamioyewumi4358 2 года назад +1

    Thank you

  • @ahmedayinde4285
    @ahmedayinde4285 Год назад +1

    Thanks so much for this.... Please can I have the data used so one can use to practice, also what do you mean by fix it .. I do not understand it even in the PAYE computation, what function key did you pressed ?

    • @DatatechAnalytics
      @DatatechAnalytics  Год назад +1

      To fixed a cell means you want to permanent that cell in a formula across cells. We use button F4 to fix it. Once you do that, you will see double dollars sign .

    • @ahmedayinde4285
      @ahmedayinde4285 Год назад

      Please sir can you share the data used?

  • @MonsuruBakare
    @MonsuruBakare Год назад

    Thanks for sharing this Sir. Kindly share the Excel file sir. Thank you!

  • @rachaelbriggs4231
    @rachaelbriggs4231 Год назад +1

    Sir please can you share this file so I can also practise with it
    Thank you so much

  • @willm7994
    @willm7994 2 года назад +1

    great vid can you please link the file so that I can follow along with you . kind regards

  • @bilkisraji2561
    @bilkisraji2561 2 года назад +1

    Thank you for the session, kindly share the file

  • @moronkeowosho8851
    @moronkeowosho8851 2 года назад

    Thank you sir for the session... Very insightful.. Kindly share the excel file. Thank you

  • @justineasika5243
    @justineasika5243 3 года назад +1

    Lovely session! Kindly share the Excel file sir. Thank you!

  • @ahsanshaikh3108
    @ahsanshaikh3108 2 года назад +1

    wonderful sir great explanation.if there are no references either on bank statement or cash book then what should we do? can we start this scenario by doing debit and credit amounts match differently.?

    • @DatatechAnalytics
      @DatatechAnalytics  2 года назад +1

      In a real life, there should be reference. But if you have it, use match debt and credit as you said.

  • @abdulrazaqabdulsalam956
    @abdulrazaqabdulsalam956 3 года назад +1

    Kindly share the excel file for us to practice, thanks in advance

  • @isaackwegyir8936
    @isaackwegyir8936 2 года назад

    How do you do the reconciliation if there is no reference number?

  • @Heartie_adiepena
    @Heartie_adiepena 2 года назад

    Thank you sir. Can you kindly share this excel? Please is it possible to make a reconciliation of intercompany account? Thanks

  • @casaagyekum6342
    @casaagyekum6342 Год назад

    Please I don’t understand how you got the 1 when you started from the beginning

    • @casaagyekum6342
      @casaagyekum6342 Год назад

      Please what the function you used

    • @DatatechAnalytics
      @DatatechAnalytics  Год назад

      It shows the row number you will find the reference when you match it

  • @tijanijamiu-olalekan2545
    @tijanijamiu-olalekan2545 2 года назад

    Kindly drop the excel here sir

  • @masidatu
    @masidatu 3 года назад

    Kindly share sir
    Thank you