Before exporting your line items, we need to make sure your line items are correctly
If you don't see all line items categorised the way you need, you can edit them to suit your business needs. Bookem offers customisable invoice options, one of which includes adding specific columns tailored to your business needs. These columns categorise and help track your income from different sources such as consumables and stock.
In the example below, we show you how to add and track consumables and stock.
We'll use a physiotherapist as an example. For this type of business, consumables would include things like taping, dry needles and massage oil. Stock could include resistance bands, foam rollers or braces. Services would be categorised as procedures.
Follow these steps:
1. Go to Settings > Payments & Invoicing
2. Navigate to the Line items tab
3. Now, click 'Edit columns' in the top bar
4. Click 'Add column' to add a new line item column
5. Select 'Dropdown'
6. Next, add 'Type' as the label. You can call it anything you like, for e.g. Category, but for the purposes of this article we'll stick with Type. Select 'Options list' as your List source.
Note: only do this if you don't already have this column. Skip to step 7 to add additional categories.
7. Now, you need to categorise your items. See the image below for an example. We added consumables, procedure and stock as type categories.
8. When you click 'Show more' you can toggle on/off which columns you want your clients to see on their invoices as well as which are “required”.
Here is an example of what your line items might look like after categorising them according to Type:
9. That's it! Now you can export your categorised line items according to types: procedures, consumables and stock.
Follow these steps:
1. Go to Accounts > Invoices
2. Click 'Export line items' in the bar at the top
3. A banner will pop up asking for the dates you'd like to download invoices for. Specify the start and end dates, then click 'download'
This is an example of what your spreadsheet might look like:
From here you can easily filter by Type to see what stock was used over the specified period.
By creating a pivot table on this data using Excel or Sheets, all used stock can be calculated, click here to learn more on how to work with pivot tables on Excel.