Skip to content
Hypamoon

For teams that run on CashCtrl

CashCtrl monthly budget against actuals

CashCtrl keeps a budget per account as a target for the whole fiscal year and compares it with the balance. Comparing the current month with a twelfth of that budget, or putting next year's targets beside this year, means exporting and joining the figures in a spreadsheet.

How it goes today

  1. Export the targets report and the income statement for the period.
  2. Divide each yearly budget by twelve in a spreadsheet.
  3. Join last year and this year in Excel by account.
  4. Add a column for the trend to the end of the year.

How it can go

Each month, each account next to its budget for that month and the year so far.

On the first working day of each month you get an overview by email: per account the figure for last month and for the year so far, next to the budget for the month and the year so far, with the difference and a straight-line trend to year end. The budget comes from the yearly targets you set in CashCtrl, split evenly over the months, or from a budget per month you upload once. Accounts that differ most from the budget come first. Nothing in CashCtrl changes.

Say this in ChatGPT, Claude or Copilot

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

Your request

With Hypamoon, on the first working day of each month, email me an overview from CashCtrl: per account the figure for last month and the year so far, next to the budget for the month and the year so far, the difference and a straight-line trend to year end. Use our yearly targets in CashCtrl split over twelve months, or the monthly budget I upload. Put the accounts with the largest difference first.

You add an API user with a role yourself in CashCtrl under Settings, Users and roles, and copy its key. It belongs to one organization and stays yours.