Skip to content
Hypamoon

For teams that run on smallinvoice

smallinvoice open invoices on a date, per client

For the annual accounts your fiduciary asks which invoices were still open at year end. smallinvoice exports what is open today, so the list for a past date is made in Excel by removing each invoice paid before that day.

How it goes today

  1. Export the invoices of the year from smallinvoice, paid or not, with the paid date column.
  2. Open the export in Excel and sort it by paid date.
  3. Delete the invoices that were paid within that year.
  4. Repeat with a longer period when older invoices could still be open.

How it can go

What your customers still owed on 31 December, without sorting an export.

You pick a date, for example 31 December. The invoices dated on or before it are read from smallinvoice together with their payments, and for each one the amount still open on that day is worked out, also when part was paid before and the rest after. You get a spreadsheet per customer with invoice number, date, due date and open amount, with totals per currency, ready for your fiduciary. Cancelled invoices are left out and nothing in smallinvoice changes.

Say this in ChatGPT, Claude or Copilot

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

Your request

With Hypamoon, when I ask, and on 1 January each year, read our smallinvoice invoices dated on or before the date I give, with their payments, and work out how much of each was still open on that date. Leave out cancelled ones. Email me a spreadsheet per customer with invoice number, date, due date and open amount, and totals per currency, for our fiduciary.

You create a client ID and secret yourself in smallinvoice under Home, Users, API V2, with the scopes the tool needs. The API comes with the Starter plan and higher. It stays yours.