Settling with the agent's final account

Applies from version 2258.

On an ordinary agency request every service is an item with its own price and cost account. That works when the services are known in advance. After a port call they often are not: the agent sends one final account afterwards, listing port dues, pilotage, launch, transport and a dozen other positions.

For that case an agency request can be settled with the agent's final account. The request then carries a single item called Agency Fees, and the agent's own spreadsheet is imported into the invoice later. ZeeBORN splits the amount across the cost accounts when the invoice is approved.

Creating the request

Purchasing → New → New Agency Request → choose the vessel. ZeeBORN then asks:

Will this agency request be settled with the agent's final account?

Answer What happens
Yes The request gets the one item Agency Fees with price 0. No further items can be added — the amounts come from the final account later.
No The ordinary agency request, with items you enter yourself.

The question appears only when the setting above is on, and only in the office — agency requests cannot be created on board.

From here the document runs through the usual steps: approve the requisition, request for quotation if you want one, purchase order, send it. A purchase order holding Agency Fees can be approved with price 0 and does not ask for an estimated price. That is intended: at this point nobody knows the amount yet.

Importing the final account

Register the invoice for the purchase order as usual, then:

Invoice → Import AR Summary Sheet → load or drop the file → Import Summary Sheet

The button appears only on a purchase order holding Agency Fees, and only while the invoice has no account lines yet. After a successful import it is gone — which is also how you can tell that an import has already run.

What the file has to look like

Row 1 holds exactly these headings, then one row per cost position:

Currency Amount Account Department Description
EUR 1200 55050 GENERAL EXPENSES Transport and customs
350 55060   Communication  
EUR 800 55900 REGULATORY / CLASS / VETTING Certificates
Total 2350      
Column What it means
Account The account number. Only accounts assigned to this vessel under that cost department are accepted — the same ones you could pick by hand in the invoice.
Department Name or short code of the cost department. Empty means the cost department of the purchase order.
Currency Empty means the currency of the invoice. One final account may hold only one currency.
Amount Required.
Description Free text, carried into the booking.

A row with Total in the first column ends the list. Empty rows are skipped.

When something in the file is wrong

ZeeBORN lists every faulty row with its row number and imports nothing at all — not the good rows either:

The summary sheet was not imported. Row 3: account 99999 is not available for this vessel …

Correct the file and import it again. Cancelling the dialog leaves the invoice untouched. This is deliberate: a half-imported final account would be harder to find and repair than one that was rejected outright.

What you see after approval

When the invoice is approved, the single Agency Fees item in the purchase order is replaced by one item per account, named agency costs: …. The budget is booked per account and cost department, exactly as if the positions had been entered by hand.

That is the point of the whole route: the agent sends one document, and the costs still land on the right accounts.

Printing

Agency requests are printed with their own forms where such forms are installed, and with the ordinary purchasing forms where they are not. Nothing has to be selected for this, and a missing agency form is no longer reported as an error.