👉HOW TO ANALYZE ACCOUNTS RECEIVABLE (DEBTORS) IN EXCEL

แชร์
ฝัง
  • เผยแพร่เมื่อ 7 พ.ย. 2024

ความคิดเห็น • 19

  • @AccountingOnExcel
    @AccountingOnExcel  ปีที่แล้ว +3

    To better understand all the formulas and features explained in this training, download the practice file to work along.

    • @habibmomodu1074
      @habibmomodu1074 9 หลายเดือนก่อน

      Thank you ma, you're genius, you're blessed

    • @kelvinkhoo98
      @kelvinkhoo98 7 หลายเดือนก่อน

      server not found

  • @insomniac3429
    @insomniac3429 9 หลายเดือนก่อน +1

    Ma'am Great work u have done. I am also in need of that kind of programming. What if I want Customer balance "From" "TO" Range series. I mean from particular date to particular date.

    • @AccountingOnExcel
      @AccountingOnExcel  9 หลายเดือนก่อน +1

      Thank you for the feedback.
      That can also be programmed.

  • @habibmomodu1074
    @habibmomodu1074 10 หลายเดือนก่อน +1

    Ma, did you make any video for practical demonstration on hw to apply these formulas?

    • @AccountingOnExcel
      @AccountingOnExcel  9 หลายเดือนก่อน +2

      The step-by-step process is explained in the tutorial.
      You can watch, follow to replicate

  • @toyosiabayomi326
    @toyosiabayomi326 ปีที่แล้ว +1

    Thank you Aunty Amaka❤

  • @abosedeayobami2320
    @abosedeayobami2320 ปีที่แล้ว +1

    Thank you for sharing. i got value. However if i want to insert customer name instead of the code. How can i go about it. Thanks

    • @AccountingOnExcel
      @AccountingOnExcel  ปีที่แล้ว +1

      Glad you got value.
      Regarding your question, Instead of using the code input the customer name.

  • @habibmomodu1074
    @habibmomodu1074 10 หลายเดือนก่อน +1

    Pls what are the account prepared for flight bookings and how they prepared.

    • @AccountingOnExcel
      @AccountingOnExcel  10 หลายเดือนก่อน +1

      Understanding the operations in such business will guide me on the accounting structure to put in place.

    • @habibmomodu1074
      @habibmomodu1074 10 หลายเดือนก่อน +1

      What i actually do is,I booked the passenger online prepared the ticket and then add little commission to the actual amount for the flight . that why I am asking what are the relevant books of account for this service

    • @AccountingOnExcel
      @AccountingOnExcel  10 หลายเดือนก่อน

      @@habibmomodu1074 You will need a book that captures the sales and Commission element.
      Understanding your business operations will give more insight in the accounting system that can be designed for your business for easy recording, reporting and decision making

  • @ThomasAndumuken
    @ThomasAndumuken 6 หลายเดือนก่อน

    Madam, can also show in your next video on how to 1. Show opening balances in accounts and 2. How to a rollover of accounts for a current period to the next period.
    Many thanks.

  • @ThomasAndumuken
    @ThomasAndumuken 6 หลายเดือนก่อน

    Hello Madam,
    I think full payment received for an invoice terminates the number of days owing. Can you please show in your next video how this can be done.
    Appreciated your videos so far with many thanks.

  • @farooqtahir538
    @farooqtahir538 ปีที่แล้ว +1

    What is the value of that even a small software like quickbooks can do more than that with a single click.

    • @AccountingOnExcel
      @AccountingOnExcel  ปีที่แล้ว

      You are right.
      Is same with this template. With a click you get what you want.
      Thank you for engaging 🤗