---
title: "PerfectView open invoices per customer, by age · Hypamoon"
description: "The amount each customer still owes and the age of the oldest unpaid invoice, on the PerfectView relation card, from the invoices in PerfectView."
url: https://hypamoon.com/connect-to/perfectview/open-amounts
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [PerfectView](https://hypamoon.com/connect-to/perfectview)
3.  Open invoices per customer

For teams that run on PerfectView

# PerfectView open invoices per customer, by age

With the Exact Online connection, PerfectView shows open amounts and their age on the relation card. With other bookkeeping connections, or none, the invoices are in PerfectView but the total per customer is not on the card.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=perfectview/open-amounts)

## How it goes today

1.  Open the list of sales invoices in PerfectView.
2.  Filter on the customer and on invoices that are sent but not paid.
3.  Add up the amounts and check the oldest due date.
4.  Or look the customer up in the bookkeeping software.

## How it can go

**What a customer still owes, on the card your team already opens.**

Each night the tool adds up the invoices per customer in PerfectView that are sent or reminded but not paid, and writes the total and the days past the oldest due date into two fields on the relation card that you add once. On Monday you get a list of customers with an invoice more than 30 days overdue. It counts on the paid status in PerfectView, set by your bookkeeping connection or by hand.

## Say this in ChatGPT, Claude or Copilot

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

Your request

> With Hypamoon, each night, add up per customer the PerfectView sales invoices that are sent or reminded but not paid, and write the open total and the days past the oldest due date into two fields on the relation card. On Monday, send me a list of customers with an invoice more than 30 days overdue, with the amounts and the account manager.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~perfectview/open-amounts&say=the%20open%20invoice%20total%20and%20the%20days%20overdue%20per%20customer%20on%20the%20PerfectView%20relation%20card%2C%20updated%20each%20night%2C%20with%20a%20Monday%20list.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=perfectview/open-amounts)

You switch on the API yourself in PerfectView under Settings, Integrations, in the API tile, where the API details then appear. The API is part of the single PerfectView edition. It stays yours.

## More for teams on PerfectView

-   [**I want our own copy of our customer data outside PerfectView, more often than once a week.**](https://hypamoon.com/connect-to/perfectview/data-copy)
-   [**I can see that someone changed a relation card, but not what changed.**](https://hypamoon.com/connect-to/perfectview/change-history)
-   [**I want to follow up on quotes that have been out for a week without a signature.**](https://hypamoon.com/connect-to/perfectview/quote-follow-up)
-   [**I want the state of our sales in my inbox every week, without building it in Excel.**](https://hypamoon.com/connect-to/perfectview/weekly-sales-report)
-   [**Everything for PerfectView**](https://hypamoon.com/connect-to/perfectview)
