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

Presenter: Vincent Lacomme
In today’s world, creating a reporting is sometime stressful and time-consuming with multiple manual actions.
Whether you are an accountant, an auditor, a financial department or a business controller, you may be juggling between Excel sheets and other files.
This session will explain how you can profit from Power Query (in Excel and Power BI) through a use case showing how you can automate the restructuring of your accounting source (from an exported general ledger) and the mapping of your reporting through a unified process.
During this hour, learn how to use the most common Power Query functions to produce more efficient and reliable reporting.

[@abderrahmaneazibi8056]

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

[@AverageJoe-Ohio]

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

[@vincentlacomme]

Thank you for your message Average Joe !

[@GrainneDuggan_Excel]

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

[@vincentlacomme]

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

[@AverageJoe-Ohio]

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?

[@aaroacademy]

Thank you for sharing this.

[@vincentlacomme]

Thank you for you comment :)

[@nanthaSN]

Really like .❤

[@muraleedharankrishnan7994]

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

[@vincentlacomme]

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

[@MuhammadHaris-uj1kf]

Excellent tutorial

[@vincentlacomme]

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

[@georgefandamu5115]

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]

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.

[@AverageJoe-Ohio]

BTW weldone on the French beating Denmark yesterday FIFA Worldcup!

[@westleyempeigne6541]

Really like how the TB was created in Power Query

[@vincentlacomme]

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

[@terbasol]

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

[@vincentlacomme]

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

[@rihamissa239]

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

[@vincentlacomme]

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

[@abymathew2069]

Could you please share the files to practice?

[@vincentlacomme]

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

[@jasonturingan3279]

Can you share the file please

[@vincentlacomme]

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

[@willm7994]

Great vid can you please share the file 🙏

[@vincentlacomme]

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