Custom QBO Expense Payment Report

I need a custom QuickBooks Online report that shows vendor payments for the entire fiscal year, organised month-by-month and grouped under each Chart of Accounts number so only expense activity is captured—no revenue lines at all.

The workflow I have in mind is:
• Build the custom report inside QBO, filtering strictly by expense-type accounts and drilling down by vendor.
• Arrange the data so every account number appears as its own row (or section) with the twelve months displayed across the columns, plus a year-to-date total.
• Export the finished result to a clean, well-labelled Excel workbook; this Excel file is the final deliverable I will use for analysis and sharing.

Key requirements for acceptance:
• One tab containing the raw export exactly as it appears in QBO.
• A second tab with the same data pivoted or formatted for easy reading, subtotalling by account number and grand-totalling at the bottom.
• Filters applied only by Chart of Accounts account number (no vendor-type or name filters beyond what falls under each account).
• All figures tie back to QBO when spot-checked.

If you are familiar with QBO’s custom reporting tools and comfortable shaping the export in Excel, this should be a straightforward task.