Get Spending Report by Account Group by Category (XLSX)

The GET /api/userReport/spendingReportByAccountGroupByCategoryXl endpoint retrieves a spending report for a specified financial account, aggregated by merchant category, and returns the result as a downloadable XLSX file. This is ideal for customers who want to analyze their spending habits using spreadsheet software, enabling features such as graphs, charts, and pivot tables. Date range filters allow focused reporting on specific time periods.

Endpoint

GET /api/userReport/spendingReportByAccountGroupByCategoryXl

Authentication

Bearer token required. Obtain via:

POST https://api.banking.netevia.dev/api/auth/v2

Include in header: Authorization: Bearer {token}
Token lifetime: 10 minutes. Refresh via POST /api/auth/refresh.

When to use

Use this endpoint when a customer wants to download a summary of their spending broken down by merchant category for a specific financial account. This is particularly useful for business customers performing expense analysis or personal customers reviewing their spending habits. The XLSX format makes the data immediately compatible with tools like Microsoft Excel or Google Sheets.

Query Parameters

Response

200 OK

{
  "name": "spending_report_2024.xlsx",
  "content": "UEsDBBQABgAIAAAAIQB...",
  "contentType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
}

Error Codes

Common Mistakes

• Providing from and to dates in a format other than ISO 8601 date-time will result in a 400 error — always use the format YYYY-MM-DDTHH:MM:SSZ.
• The content field in the response is Base64-encoded; you must decode it before saving or opening the file as an XLSX document.
• Omitting finAccountId may return data for a default account or an empty report — always specify the target account ID for accurate results.
• Ensuring the from date is earlier than the to date; reversed date ranges may return an empty or unexpected report.

Related Endpoints

• GET /api/userReport/spendingReportByAccountGroupByCategory — Retrieve the same spending report grouped by merchant category as JSON instead of XLSX.
• GET /api/userReport/spendingReportByAccount — Retrieve a general spending report for a financial account.
• GET /api/finAccount — List financial accounts available to the authenticated customer.

Example

curl -X GET "https://api.banking.netevia.dev/api/userReport/spendingReportByAccountGroupByCategoryXl?finAccountId=XXXXXXXXXX&from=2024-01-01T00%3A00%3A00Z&to=2024-12-31T23%3A59%3A59Z" \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json"