---
title: "Abacus monthly report next to last year · Hypamoon"
description: "Exporting Abacus figures to Excel to compare months? Income and expenses per account, next to the same month last year and your budget, by email."
url: https://hypamoon.com/connect-to/abacus/monthly-report
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Abacus](https://hypamoon.com/connect-to/abacus)
3.  Monthly report

For teams that run on Abacus

# Abacus monthly report next to last year

Abacus holds the figures, but a monthly comparison for the owner or the board often still goes through Excel: export the accounts, build a pivot table, check the totals. A fiduciary told Abacus he worked this way for the year-end and found it time-consuming.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=abacus/monthly-report)

## How it goes today

1.  Run the account balances for the month in Abacus financial accounting.
2.  Export them to Excel and paste them next to last year's numbers.
3.  Rebuild the pivot table when accounts were added or renamed.
4.  Check the totals and send the file to the owner or the board.

## How it can go

**The month's figures arrive by email, next to last year and the budget.**

Early each month the balance of every income and expense account is read from Abacus for the month just closed and for the same month a year earlier, plus the budget where you keep one in Abacus. You get one email with revenue, costs and result and the accounts that moved most, with the same table as a spreadsheet for your fiduciary. You choose the day and who receives it.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. Abacus first switches on access for your company when you ask them, which can take a few business days. After that you get the key, or create it yourself, and paste it in the portal, never in the chat.

Your request

> With Hypamoon, on the day I choose each month, take the balances of our income and expense accounts in Abacus for last month, the same month a year earlier and the budget. Email me and the people I name one overview with revenue, costs and result and the accounts that changed most, and attach the table as a spreadsheet for our fiduciary.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~abacus/monthly-report&say=a%20monthly%20email%20with%20our%20Abacus%20income%20and%20expense%20accounts%20next%20to%20the%20same%20month%20last%20year%20and%20the%20budget%2C%20with%20a%20spreadsheet%20attached.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=abacus/monthly-report)

Your Abacus administrator creates an API connection with a service user in program Q910 and copies its Client ID and Client Secret, with the address of your Abacus server, which has to be reachable over HTTPS. Abacus Research AG then enables your client for the API and approves the service user within 21 days. It stays yours.

## More for teams on Abacus

-   [**I want our project leads to know which of their customers pay late, without someone pulling the list from Abacus.**](https://hypamoon.com/connect-to/abacus/overdue-invoices)
-   [**I want everyone to see who is away next week without asking HR.**](https://hypamoon.com/connect-to/abacus/absence-calendar)
-   [**I want the hours we record outside Abacus on our projects without typing them in again.**](https://hypamoon.com/connect-to/abacus/project-hours)
-   [**Everything for Abacus**](https://hypamoon.com/connect-to/abacus)
