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
- Export the invoices of the year from smallinvoice, paid or not, with the paid date column.
- Open the export in Excel and sort it by paid date.
- Delete the invoices that were paid within that year.
- 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.
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.
More for teams on smallinvoice
- I want the hours from my time app to become smallinvoice invoices per customer each month.
- I want overdue smallinvoice invoices to get a friendly reminder without me checking each one.
- I want customers to get the updated smallinvoice invoice when a part payment comes in.
- I want a list of the smallinvoice products that fall below my minimum stock.
- I want orders from my webshop to become smallinvoice invoices without typing them in again.
- Everything for smallinvoice