33 - Power Query for Powerful Financial Reporting: From Accounting entries to Consolidated Reporting

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

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

  • @LazyJoel
    @LazyJoel ปีที่แล้ว +2

    I truly appreciate how efficiently you explain even the most complex issues with down to earth examples! Very well done!

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

      Thank you for your message Average Joe !

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

    Great session with so many hidden gems - this is on my watch again list.

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

      Thank you for you kind words, Grainne D. If you have any question, you can contact me via Linked in :)

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

      Just wondering, in your DAX formula "Date.From", couldn't I just change the number to text directly by using the transform text tools vs inserting a second formula "Number.ToText", or does that not work?

  • @abderrahmaneazibi8056
    @abderrahmaneazibi8056 4 หลายเดือนก่อน

    Very clear, useful, and to the point. Thank you so much.

    • @vincentlacomme
      @vincentlacomme 2 หลายเดือนก่อน

      Thank you for your kind words !

  • @georgefandamu5115
    @georgefandamu5115 5 หลายเดือนก่อน +1

    Hi have been watching your videos about reconciliation using power query, you have really helped me. Now how can you match the positive(debt) and negative(credit) amounts not references. Let's say if the ledger references(using voucher number to payments) are different from bank references in excel power query suppliers reconciliation

    • @vincentlacomme
      @vincentlacomme 5 หลายเดือนก่อน

      Thank you for your interest ! I am not sure how it could be fully automated unless there would be at least one column with a common property (Voucher number). The property could be an equal match or partial match.

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

    Awesome

  • @elizabethheng8136
    @elizabethheng8136 3 หลายเดือนก่อน

    very clear and useful. However I stuck with the last step when present the financial statement in the pivot table. In the P/L Statement will shows the Sales as negative whereas the cost is positive which usually when presenting the FS, we will omit the negative sign. Another issue is , if the income is showing a debit balance instead of credit balance. what formula should i use in the custom column.

    • @vincentlacomme
      @vincentlacomme 2 หลายเดือนก่อน

      Thanks ! I would suggest 1- reversing the sign so that sales are positive 2- adding a balance column (equal to debit minus credit) and only working on that column

  • @MuhammadHaris-uj1kf
    @MuhammadHaris-uj1kf 2 ปีที่แล้ว +1

    Excellent tutorial

    • @vincentlacomme
      @vincentlacomme 2 ปีที่แล้ว

      Thank you for the comment Muhammad, please contact me via Linkedin or Twitter so I can send the file.

  • @muraleedharankrishnan7994
    @muraleedharankrishnan7994 2 ปีที่แล้ว

    Very Interesting session. Contain lot of techniques how PQ can be useful in financial reporting.

    • @vincentlacomme
      @vincentlacomme 2 ปีที่แล้ว

      Thank you for you kind words Muraleedharan. If you have any question, you can contact me via Linked in :)

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

    Thank you for sharing this.

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

      Thank you for you comment :)

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

    Really like .❤

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

    Hello, How can we get the data, spreadsheet and the powerpoint ? Is their any link to download the data ?

    • @vincentlacomme
      @vincentlacomme 2 ปีที่แล้ว

      Thank you for you comment Riham. Please can contact me via Linked in or Twitter for the demo files.

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

    BTW weldone on the French beating Denmark yesterday FIFA Worldcup!

  • @westleyempeigne6541
    @westleyempeigne6541 2 ปีที่แล้ว

    Really like how the TB was created in Power Query

    • @vincentlacomme
      @vincentlacomme 2 ปีที่แล้ว

      Thank you for you kind words Westley. If you have any question, you can contact me via Linked in :)

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

    Awesome tricks and great content Vincent 👏. Just wondering if you have a chance to share exercise files ?

    • @vincentlacomme
      @vincentlacomme 2 ปีที่แล้ว

      Thank you for the comment @Tolga. Please contact me via Linkedin or Twitter so I can send the file.

  • @jasonturingan3279
    @jasonturingan3279 2 ปีที่แล้ว +2

    Can you share the file please

    • @vincentlacomme
      @vincentlacomme 2 ปีที่แล้ว

      Thank you for you comment Jason. Please can you contact me via Linked in or Twitter for the files.

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

    Could you please share the files to practice?

    • @vincentlacomme
      @vincentlacomme 2 ปีที่แล้ว

      Thank you for you comment Aby. Please can contact me via Linked in or Twitter for the files.

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

    Great vid can you please share the file 🙏

    • @vincentlacomme
      @vincentlacomme 2 ปีที่แล้ว

      Thank you for you comment Will. Please you can contact me via Linked in or Twitter for the files.