---
title: "Holded aged receivables: by customer and age · Hypamoon"
description: "Need an ageing of what customers owe at month end or for the bank? Get it from Holded each Monday, per customer in 30, 60 and 90 day columns."
url: https://hypamoon.com/connect-to/holded/aged-receivables
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Holded](https://hypamoon.com/connect-to/holded)
3.  Aged receivables

For teams that run on Holded

# Holded aged receivables: by customer and age

At month end, at year end and when the bank asks, you need to know who owes what and how long it has been overdue. Holded lists the open invoices; the ageing per customer in columns is built by hand in Excel.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=holded/aged-receivables)

## How it goes today

1.  Filter the open sales invoices in Holded.
2.  Export the list to Excel.
3.  Sort each invoice into a column by days overdue.
4.  Total it per customer and repeat it next month.

## How it can go

**See what each customer owes, sorted by how late it is.**

Each Monday a list per customer of what is open in Holded: not yet due, 1 to 30 days late, 31 to 60, 61 to 90 and over 90, with the total. Part payments are taken into account. Customers above the credit limit you set are at the top.

## Say this in ChatGPT, Claude or Copilot

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

Your request

> With Hypamoon, each Monday make an aged list of what our customers owe in Holded: per customer the open amount not yet due, 1 to 30 days late, 31 to 60, 61 to 90 and over 90, with the total. Take part payments into account. Put customers above the credit limit I give you at the top, and email me the list as a spreadsheet too.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~holded/aged-receivables&say=a%20weekly%20aged%20list%20of%20what%20each%20customer%20owes%20in%20Holded%2C%20in%2030%2C%2060%20and%2090%20day%20columns%2C%20with%20our%20own%20credit%20limits.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=holded/aged-receivables)

You create the Holded key yourself under Settings, API, and choose what it may read and change. It stays yours.

## More for teams on Holded

-   [**I want to send the SEPA form to my contacts so they fill it in themselves.**](https://hypamoon.com/connect-to/holded/sepa-mandates)
-   [**I want to add my own income and expense lines to the forecast without linking them to an account.**](https://hypamoon.com/connect-to/holded/cash-forecast)
-   [**I want to calculate sales commission per agent; with tags it is a real mess.**](https://hypamoon.com/connect-to/holded/sales-commissions)
-   [**Repeating recurring tasks in every project is tedious and a waste of time.**](https://hypamoon.com/connect-to/holded/recurring-tasks)
-   [**Employees have to be able to report their expenses easily, without seeing everyone else's.**](https://hypamoon.com/connect-to/holded/employee-receipts)
-   [**Different documents with the same name show up as duplicates.**](https://hypamoon.com/connect-to/holded/duplicate-bills)
-   [**I have to create the document myself every time a customer asks for it.**](https://hypamoon.com/connect-to/holded/payment-receipts)
-   [**We repeat the same entries every month and have to do it by hand.**](https://hypamoon.com/connect-to/holded/recurring-journal-entries)
-   [**The worker forgets to clock in, especially when leaving.**](https://hypamoon.com/connect-to/holded/clock-in-reminders)
-   [**A report of average customer collection time and average supplier payment time.**](https://hypamoon.com/connect-to/holded/payment-times)
-   [**We need a record of the hours per project, because the client asks for it.**](https://hypamoon.com/connect-to/holded/project-hours)
-   [**When adding an intra-community contact, check the VAT number against VIES.**](https://hypamoon.com/connect-to/holded/vat-number-check)
-   [**You have to go in every day to send dozens of invoices by hand.**](https://hypamoon.com/connect-to/holded/send-invoices)
-   [**It should not be necessary at this point to build a pivot table from sales.**](https://hypamoon.com/connect-to/holded/sales-by-product)
-   [**With many customers you have to go one by one changing the amount.**](https://hypamoon.com/connect-to/holded/recurring-invoice-prices)
-   [**Everything for Holded**](https://hypamoon.com/connect-to/holded)
