---
title: "Moss spend report by team and category each month · Hypamoon"
description: "Exporting Moss data to a spreadsheet to see spend per team? Get a monthly report per team, cost center and category, next to the months before."
url: https://hypamoon.com/connect-to/moss/spend-by-team
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Moss](https://hypamoon.com/connect-to/moss)
3.  Spend report

For teams that run on Moss

# Moss spend report by team and category each month

Moss shows budgets and lists of transactions, and for reports of your own it points to the CSV export or its API. Reviewers ask for analytics by team or category with a trend, so many finance teams export each month and build the overview in a spreadsheet.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=moss/spend-by-team)

## How it goes today

1.  Export the card transactions, invoices and reimbursements of the month as CSV.
2.  Add the team and category to each line with lookups.
3.  Build a pivot per team and compare it with the months before.
4.  Send each team lead their part.

## How it can go

**A monthly spend report per team, cost center and category, with the trend.**

On the first working day of the month each team lead gets their team's spend of last month per category, cost center and supplier, next to the eleven months before, with the biggest changes on top. Finance gets the whole company on one page. Card payments, invoices and reimbursements count, in your home currency. The team is the one the person belongs to in Moss today.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Moss key in the portal, never in the chat.

Your request

> With Hypamoon, on the first working day of each month, take last month's card payments, invoices and reimbursements from Moss in our home currency. Make a report per team, per category, cost center and supplier, next to the eleven months before, with the biggest changes on top. Email each team lead their team's part and send me the whole company on one page.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~moss/spend-by-team&say=a%20monthly%20spend%20report%20from%20Moss%20per%20team%2C%20category%20and%20cost%20center%2C%20next%20to%20the%20months%20before%2C%20emailed%20to%20each%20team%20lead.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=moss/spend-by-team)

As a Moss admin you create the API key yourself under Settings, Company Settings, API Keys, and confirm it in the Moss mobile app. Read access is enough for these tools. It stays yours.

## More for teams on Moss

-   [**I send people reminders myself for card payments that still need a receipt.**](https://hypamoon.com/connect-to/moss/receipt-reminders)
-   [**To see group spend I export each Moss entity and add them up in a spreadsheet.**](https://hypamoon.com/connect-to/moss/group-spend)
-   [**I don't know which subscriptions still run on the card of someone who is leaving.**](https://hypamoon.com/connect-to/moss/recurring-payments)
-   [**I only top up the Moss wallet when the balance is already low.**](https://hypamoon.com/connect-to/moss/wallet-top-up)
-   [**For the auditor I download receipts from Moss one transaction at a time.**](https://hypamoon.com/connect-to/moss/receipt-archive)
-   [**Each month I collect the Moss costs per client to put them on their invoice.**](https://hypamoon.com/connect-to/moss/client-rebilling)
-   [**Everything for Moss**](https://hypamoon.com/connect-to/moss)
