Manual

August, 2026

Internal invoice - V2

This is the description for internal invoice version 2, and runs from August 2026.

Internal invoice - V2
internal invoice serials

Each email has a unique internal invoice number (red squares) that is reflected in the email title and attachment names. The order marking is also found in the email title, in the message body and PDF document, and on each line in the details.

Changes from the previous version

Version 2 corrects how the cost of tools still checked out at the end of the period is calculated. Instead of trusting whichever «current holder» happens to be live at the moment the invoice is generated, the invoice now resolves who was actually holding the tool at the end of the period. It also checks all of the company's warehouses - not just the tool's single home warehouse - when deciding whether a tool is still checked out. If a tool's rental price can't be resolved, the line is now flagged instead of silently being billed as free.

The email, PDF and spreadsheet formats themselves are unchanged from version 1 - column order and headings stay the same, so anything built to read version 1 will keep working with version 2.

ERRATA/Corrections to this document itself describing version 2:

  • None for now.

Sending

Internal invoices are sent for all companies at 08:00 every Monday «Oslo time». If something goes wrong and we need to fix the report function, the next report will include events from the time the previous report was sent. This means that you will usually get weekly reports with what has happened from Monday to Monday 08:00. That's about it. Depending on server load, reporting may go off a little before or after 08:00:00.

The first time you activate the report module, you will automatically receive a report from the last 2 weeks. You can contact us if you would like a report from a different time.

Opening

CSV files are just plain text, and you can open them with a spreadsheet, for example. See main page for more information on how to open in Excel.

Time limit

We cannot deliver logs from before January 1, 1970 00:00:00 UTC nor from the future (should work fine for all our customers). The year 2038 problem has been taken into account. We will have a problem at the turn of the year 9999/10000 CE but will update the app well in advance.

Data sources

Most fields in the log are stored “as they were at the time.” For example, the log shows tool names as they were at the time the event occurred. Therefore, the same tool may be called different things down the log.

Some fields are retrieved at the time of export, and therefore the value may have been different at the time of the event:

  • Employee numbers
  • Rental price

These are typically fields that are not updated very often, but if you have changed them during the week, the value will be displayed at the time of export (which is almost certainly Monday 08:00).

Some fields are calculated at the time of export, such as date fields, «days/hours/minutes/seconds out», and cost.

Required settings

For the export to work you must:

recievers of emails
  • Check «Report» under Company Settings
  • fill in «Email to receive internal invoice» under Company Settings
  • - You can enter multiple email addresses separated by commas if you want to send to more than one person.

Format

The robot sends an email to the address(es) specified in the «Email to receive internal invoice» field under Company Settings.

The email has the same list in the message body, in the attached CSV file and attached PDF. There will always be a CSV file and PDF file attached, even if there have been no events since the last time.

  • Character set UTF-8
  • The field separator is comma ,
  • Line separator is LF ( , 0x0a)
  • The decimal separator is a period .
  • The time zone is Europe/Oslo and takes summer/winter time into account.
  • Date format is «YYYY-MM-DD HH:MM:SS» for example «2026-07-13 08:15:01» for July 13, 2026 at 08:15:01 Oslo time
  • Fields containing double quotes or commas are enclosed in double quotes, with internal quotes doubled, following standard CSV escaping

Time outside/inside

The time is counted from when a tool is taken out of any of the company's warehouses, and ends when it is put back into any of the company's warehouses - not just the tool's single home warehouse. If a tool is still checked out at the end of the period, the invoice resolves who was holding it at that point in time, rather than whoever the live «current holder» happens to be when the invoice is generated. If the tool was taken out several weeks ago, the «time out» will typically be 7 days on each weekly report, until the tool is registered back into a warehouse.

Back to all manuals

Last updated: August 01, 2026

© 2026 Toolbee. All rights reserved.