Skip to content

Assets

Assets records each cylinder you choose to track by its serial number. Bottle keeps where it is, whether it is full or empty, and the details you record for it, such as batch number and expiry date.

Your stock counts stay as they are. A product set to Track each cylinder is counted full and empty like any other, and each stock movement also names the cylinders that moved, so the counts and the cylinders agree.

  • Choose the products to track: set a cylinder product to Track each cylinder. Every other product is counted as before.
  • Choose the cylinder details: decide what you record for each cylinder, such as serial number, batch number, fill date and expiry date, or start from a medical oxygen or industrial gas set.
  • Add the cylinders you have: add them one at a time, or import them from a spreadsheet with your customers.
  • See every cylinder: the Asset register shows where each one is, full or empty, its details and when it last moved.
  • Follow one cylinder: its page shows its details, earlier values and every movement.
  • Count a yard by serial number: find what’s missing, what’s recorded somewhere else and what isn’t in the register.
  • Name the cylinders as stock moves: when you receive stock, move it between yards, and when drivers deliver and collect.
  • Run reports: where cylinders are, who holds them and which dates are coming up, each as a CSV.

Related guides: Batch intake and recall, Needs checking, Work reports and Equipment servicing.

Assets must be switched on for your business by Bottle. Ask Bottle to switch it on. Until then, nothing in this guide shows.

Assets is on the Round and Depot plans. On the Yard plan it shows greyed with the plan it starts on. It isn’t on the Shop plan.

Once Bottle has switched it on, open Settings, then Assets under Feature settings. Use Assets is on to start with. The Asset register shows in the menu under Stock & fleet once at least one product is set to Track each cylinder.

Reading serials with the phone camera on Batch intake is a separate switch, Read cylinders with the camera, which Bottle switches on once your cylinders have been tested. While it is off, Batch intake in the office says “Read cylinders with the camera is off. Ask Bottle to switch it on.”

What Roles
Settings, cylinder details, quarantine Owner, Admin
Asset register, cylinder pages, Count a yard, import and reports Owner, Admin
Naming cylinders in Record stock and Move stock between yards Owner, Admin
Naming cylinders at the door Driver, on iPhone and Android, and on the web
Batch intake on the phone Owner, Admin. A driver with Allow stock takes can add serials. See Batch intake

The Technical role doesn’t see Assets.

  1. Open Products and open the cylinder.
  2. In the Stock card, under How is this cylinder recorded?, choose Track each cylinder. As a count keeps fulls and empties as a number, as before.
  3. Type the Shelf life in months. Bottle uses it to suggest the expiry date when stock comes in.
  4. Save the product.

Only cylinders can be tracked. You can set a product back to As a count at any time. Cylinders already in the register keep their records.

To switch Assets off, set every tracked product back to As a count first. Settings → Assets names the products still tracked, and Save stays unavailable until none are.

Open Settings → Assets. Cylinder details lists what drivers and yard staff record for each tracked cylinder.

Before you have any, Start from a set offers three choices:

  • Medical oxygen: Serial number, Batch number, Fill date and Expiry date. It also sets the work report job types Install, Refill, Return and Service, and the checks Condition, Gauge and Leaks.
  • Industrial gas: Serial number, Next test due, Tare weight (kg), Batch number and Fill date. It also sets the job types Delivery, Exchange, Collection and Service, and the checks Cylinder condition, Valve and outlet, Leaks and In test date.
  • Start empty: press Add cylinder detail and add each one yourself.

A set adds its cylinder details and sets the work report job types, checks and statements. A detail you already have by the same name is left as it is. If you’ve changed your work report job types, checks or statements, Bottle asks Replace your job types, checks and statements? Choose Replace all three, or Keep mine, add cylinder details only. Reports already sent keep what they had.

Every detail can be changed or removed afterwards. Press Add cylinder detail, or a detail’s change button, and fill in:

  • Name and Type: Text or number, or Date.

  • Changes at refill?: Yes, new each refill for a batch number or fill date. No, stays the same for a serial number.

  • Unique to each cylinder?: Yes for the serial number. Bottle then refuses the same value on two cylinders.

  • Marked on the cylinder as: Label, Barcode or QR code, Stamped into the metal, Not marked or Other.

  • Required: Every time, When the cylinder is full or Optional. Bottle asks for a required detail when a cylinder is added, imported or has its details changed.

  • Note for drivers: a short line shown under the detail when someone records it, such as “On the shoulder, starts with C.”

  • Required format: optional. It refuses values with typing mistakes. \d means any digit, so C\d{6} means C then 6 digits. Use Test a value to try a real one.

  • Warn before date (dates only): how far ahead the date shows in Expiry dates. Leave it blank for no warning.

  • After the date (dates only): what happens when a driver hands over a full cylinder whose date has passed. It works the same on iPhone, Android and the web. A date set to warn or block also shows in Expiry dates once it has passed.

    • Warn driver and office: the driver sees, for example, “C431108 is past its Expiry date, 05/11/2026. The office will check it.” They can still hand it over. The cylinder then waits in Needs checking.
    • Driver can’t hand it over: the driver sees “C431108 is past its Expiry date, 05/11/2026. You can’t hand it over. Take another cylinder.” The app won’t record it, and the rest of the stop carries on. If a phone that hasn’t had today’s list sends it anyway, Bottle leaves it off the stop and the gap waits in Needs checking with the reason.
    • Do nothing: the date is only recorded.

    The summary beside the form says what happens, such as “After the date: the driver can’t hand it over”.

Summary beside the form says in plain words what the detail does.

To stop recording a detail, choose Stop recording. Values already recorded are kept.

Cylinders are matched to customers by account number when you import them. Account numbers are set under Settings → Invoices → Account numbers, where Work reports under Print the account number on puts them on work reports. See Account numbers.

Open Asset register under Stock & fleet. It has five tabs: Cylinders, Needs checking, Batch intake, Batch recall and Reports.

Cylinders lists every tracked cylinder with its product, Location, Full or empty, its details and when it last moved. A cylinder in quarantine shows In quarantine.

  • The cards at the top count cylinders With customers, In yards, On vehicles, At suppliers and To check. Press a card to show only those. Press it again to show them all. With customers leaves out cylinders marked lost.
  • Search serial or batch number finds a cylinder by serial, or every cylinder that carries a batch, including a batch from an earlier fill.
  • Filter by Location and Status. Clear filters shows everything again.

The buttons at the top are Asset settings, which opens Settings → Assets, Import from a spreadsheet, Count a yard and Add existing cylinder.

Use this for a cylinder that is already in your stock count. Adding it to the register doesn’t change the count.

  1. Press Add existing cylinder.
  2. Choose the Product. Only products set to Track each cylinder are listed.
  3. Choose the Current location: a yard, vehicle, customer or supplier, or Location not known. Choose which one beside it.
  4. Choose Full or empty and the Status.
  5. Fill in the details. On the cylinder holds details that stay with the cylinder, serial number first. Fill sticker holds details that change at each fill, and shows only when the cylinder is full. A detail not needed for the choice you made is marked (optional).
  6. Press Add a note if you want one, then save.

If the serial number is already on another cylinder, Bottle says so and doesn’t save.

Open a cylinder from the register to see:

  • Current location and when it last moved.
  • Details: what it carries now. Change details keeps the old value under Previous values, with the dates it applied.
  • Movements: every place it has been, with the details it carried on each move, who moved it and when. A move that was undone shows as “Back at Woking yard: move undone”. Corrected mistakes stay listed, marked as corrected.
  • Change status: mark it Lost, Faulty, Retired or To check, with a note, or back to In use.

Import customers and cylinders from a spreadsheet

Section titled “Import customers and cylinders from a spreadsheet”

Owners and admins can import customers and cylinders from an Excel (.xlsx) or CSV file. Open Asset register → Import from a spreadsheet, or Settings → Import from a spreadsheet under Business administration. Bottle checks every row before anything is saved, and you can undo any import.

Import customers first, so cylinders can be linked to them.

  1. What to import: choose Customers or Cylinders. Each card says how many are already in Bottle. For cylinders, choose the Product, one product at a time. What your file needs lists the Required and Optional columns, and Download a blank template gives you a file to fill in.
  2. Upload file: drop your file in or choose it. Bottle says whether it can open the file, which row the column names are on (a title row above them is skipped), how many rows and columns it found, and how it reads any dates saved as Excel numbers. A workbook with several sheets asks which one.
  3. Match columns: Bottle guesses what each column is from its name. Change any under Import as, choose Don’t import, or add a column as a New cylinder detail. Bottle remembers the matching for next time.
  4. Check rows: nothing is saved yet. Counts show what is New, To fix, Will be updated, and the Stock count change, which is always 0. Each row to fix names your spreadsheet’s own row number and the problem, such as Unknown location: "Faulty Cylinder". Choose a location in the row, or Leave out. Rows you’ve dealt with lists your choices so you can change them.
  5. Import: press the import button, such as Import 8 cylinders. Bottle says how many were added and updated, how many are with customers, in yards, and lost or faulty. Rows left out can be downloaded as a CSV to fix and import again.

How cylinders are placed:

  • A location such as “ETH001 - Ethos Dental Care” finds the customer by account number, then by name.
  • A location starting “LOST” marks the cylinder lost with that customer. “Faulty Cylinder” marks it faulty.
  • Yards, vehicles and suppliers are found by name.
  • Anything else is asked once per location: a yard, vehicle or supplier, Add as a new customer, Location not known, or leave those rows out.
  • “N/A” counts as blank. A cylinder with this fill’s details is full. One without them is empty.

An import adds no stock. The cylinders are already in your count.

Uploading the same file again changes only what changed. Customers are matched by account number, or by name and postcode if you don’t use account numbers. Cylinders are matched by serial number.

Imports so far lists each import with who did it and when. Press Undo on one. Bottle removes what it added and puts back what it changed. A customer used since, on an order or invoice, is archived instead. A cylinder moved since is kept.

Press Count a yard on the Asset register to count one product at one yard by serial number. Nothing changes until you save.

  1. Choose the Yard and Product, then press Start counting.
  2. Scan or type every serial number you find. Press Enter after each, or paste a list.
  3. Press Check the count. Bottle lists:
    • Missing: recorded at the yard but not counted. Tick the ones to mark lost. They come off the yard’s stock.
    • Recorded elsewhere: counted here but recorded somewhere else. Tick the ones to move to this yard.
    • Not in the register: tick the ones to add, and say whether each is full or empty. Each one you add goes into the register and into the yard’s stock, so the two agree.
    • A serial of another product: go back and remove it.
  4. Under the stock figures, Recorded stock, with the ticked changes includes the cylinders you are adding. If it still doesn’t match what you counted, tick Set Woking yard’s stock to the count (with your yard’s name) to make the yard’s full and empty counts match. Mark every missing cylinder lost first. Cylinders you add are counted once, whether or not you tick it.
  5. Add a note if you want, then press Save the count. Only the changes you ticked are saved. The count is kept in the yard’s count history even if nothing changed.

Every stock movement of a tracked product can name the cylinders that moved. Cylinders not named still move in the counts, and Bottle records them as not named. Drivers’ gaps go to Needs checking.

Undoing a delivery puts its cylinders back where they were. A cylinder moved again since stays where it is. When two customers are merged, the cylinders the merged account held move to the one you keep.

A round’s load is recorded by quantity. Cylinders are named at the door, not when the vehicle is loaded. When the round is unloaded, the tracked cylinders still on the vehicle go back into the yard.

Open Asset register → Reports. Each report has Download CSV, with the same choices you made on screen.

  • Where cylinders are: cards for In yards (with how many are in quarantine), On vehicles, With customers, With suppliers and All cylinders, then a line for each product. Lost and retired cylinders are left out. Choose a past day under As at to see where they were at the end of that day. Quarantine isn’t known for a past day. Show now goes back to today.
  • Who holds cylinders: each customer, yard, vehicle or supplier, chosen under Show, most first, with full, empty and which products. Up to 500 are shown. The CSV has them all.
  • Expiry dates: cylinders whose dates have passed or are coming up, passed first, such as “Passed 5 days ago”, “Today” or “In 12 days”. How far ahead it looks is each date detail’s Warn before date. A date detail with After the date set to warn or block, but no warning, looks 30 days ahead. A date that only records something, such as Fill date, is left out.

Each cylinder links to its page, and each customer to theirs.

To trace a batch, use Batch recall.

  • Search: type a serial number to find the cylinder, or a batch number to find the batch. See Finding things.
  • Orders: an order shows Tracked cylinders that went out and came back on it. See Orders.
  • Customers: a customer’s Cylinders section lists the Tracked cylinders they have now. See Customers.

Does adding or importing cylinders change my stock? Add existing cylinder and importing don’t. Those cylinders are already in your count. Adding one in Count a yard does, as the next answer explains.

Does adding a cylinder in Count a yard change the yard’s stock? Yes. It goes into the register and into the yard’s stock as full or empty, as you chose. The stock movement says Stocktake, like the other changes a count makes.

What happens to a serial number Bottle hasn’t seen before? In Record stock and Count a yard, you choose to add it to the register. A driver who types one at the door adds it where they found it, marked To check, and it waits in Needs checking.

What happens to a cylinder’s batch when it’s refilled? The new batch replaces the old one under Details. The old one stays under Previous values, and searching the old batch still finds the cylinder.

Can I stop tracking a product? Yes. Set it back to As a count. The register keeps the cylinders’ history.

Problem What to do
“No product is set to track individual cylinders. Go to Products, open your cylinder product and turn on Track each cylinder.” Open the cylinder in Products and choose Track each cylinder in its Stock card.
Assets won’t switch off, and the page lists products Open each product named and choose As a count, then switch Assets off.
“This file can’t be opened. Save it as .xlsx or .csv and upload it again.” Save the file as .xlsx or .csv from Excel, Google Sheets or Numbers, then upload it again.
“This file has account numbers, but account numbers are turned off. Customers will be matched by name and postcode.” To match by number, press Turn on account numbers.
Import is unavailable: “Fix or leave out every row first.” Choose a location for each row to fix, or press Leave out.
“No cylinders found. Check the serial or batch number.” Check the number. The register searches serial and batch numbers only.
“The count wasn’t saved. Nothing has changed. Try again.” Press Save the count again. Your counted serials are still on the page.
“Some cylinders changed since the count was checked. Check the count again.” Press Check the count again, then save.
“C500999 needs Batch number before it can be added. Add it from the Asset register instead.” Leave it unticked, save the count, then add it with Add existing cylinder.
“Another cylinder already has Serial number C500201.” Check the serial number. Each serial number can be on one cylinder only.
“Someone else just moved that cylinder. Refresh and try again.” Refresh the page, check where the cylinder is now, then try again.
“No cylinder detail is unique to each cylinder. Go to Settings, open Cylinder details and set the serial number to Unique to each cylinder.” Open Settings → Assets, change the serial number and choose Yes under Unique to each cylinder?.