Report on list of all users and what they have access to for a SharePoint site

KEGAN1975 - This has always been a gap with SharePoint.  We use a third party tool (Sharegate) to fill this gap. When I export the Sharegate permissions matrix report to excel, I end up with a sheet with the following column headings:

Row #
Type
Name
URL
Item Path
Inheritance
Details
User/Group
Principal Type
Account Name
Given Through
Full Control
Design
Contribute
Edit
Read
View Only
Approve
Manage Hierarchy
Restricted Read
Restricted Interfaces for Translation
Public-Add

This report can consist of thousands of rows depending on how many securable objects are in your site collection and how many objects have custom permissions (vs. inherited).  Generally a business user will not want to try to read this report, I will provide it for the record, but they usually follow up with a more specific question such as "Do these people have access to this stuff?" and I help them figure that out.  

You also apply a filter to display the report based on particular users or SharePoint groups. 

If you look around you will find some examples of Powershell for getting some of this information, but you will have your hands full creating a complete report.

We have found Sharegate to be indispensible for this and many other tasks. I am sure there are other tools that perform equally as well or maybe better, but Sharegate was easier for us to purchase because of the cost and how they price their tool.