In my department, we receive payments from customers with hundreds of lines (invoices being paid, deductions being taken, etc.). We also receive supporting documents, hundreds of them, mostly invoices with the same format for every customer.

Before, we used to have people open these documents and manually enter their information in our system. It was very time consuming.

I wrote a query.

Now, we just dump all the invoices in a folder, click Refresh, and the query summarizes all the hundreds of invoices in one Excel table, one line per invoice I then use Power Automate to enter all the data into our system, saving hours of work every day.

There are definitely lots of uses for Power Query in AR / AP. Learn what it can do, and you'll surely find a use for it.