Pricing and billing

Extensions needed: tank pricing

In Zebrabase, it is possible to calculate billing for facility users based on their tank usage. A price is associated with individual tank positions and in the billing calculations, it is multiplied by the number of days the position was occupied, within the defined billing period. You can calculate billing for workgroups, and individual users, based on the defined funding, and more.

Step 1: Define prices

To set up, first define the tank prices you will use in Admin / Codebooks / Position Price. For each price, it is mandatory to fill in its name (for example "Academic", "Juvenile fish", ...) and price per day. Optionally, you can add a description.

Step 2: Assign prices to positions

Once your prices are defined, you can assign them to individual positions in your facility. Go to Facility view and in the upper right corner, select Price to get into the pricing mode. Then you can select one or more positions you want to assign the price to, and select the price you want to use in the panel on the right. Confirm the action by clicking Assign price.

You can view the prices by switching the color coding of your tanks. Click on Status and select Price from the drop-down menu. When you place a substock into a priced position, it will be added to the billing statistics.

Step 3: Billing statistics

At the end of each day, billing statistics for that day are calculated. You can view them in Stats / Billing stats (this page is only visible to admins). In the table on the bottom of the page, each row represents one day and displays three values:

  • fish count - total number of fish in positions with a defined price
  • used tanks - total number of used tanks, i.e. substocks assigned to positions with defined price
  • used tanks price - total price for used tanks - your defined prices will be used in the calculation

In the top row, there are the sums calculated for the whole billing period (i.e. all rows of the table summed up).

Clicking on the filter icon in the top right corner opens filtering options, where you can define the billing period and which tanks should be included in the calculation (for example, only tanks belonging to a certain workgroup or with a certain type of funding can be counted).

You can download the billing table by clicking the download icon in the top right corner.

Please notice!
  • If a substock is owned by 2 workgroups and billing stats are computed for workgroups separately, the substock will be counted twice (once for each of the workgroups)
  • Filters are applied on current data only - i.e. filtering by room counts only fish placed in the selected room
  • Wider tank counts as one
  • Split or shared tank counts as one