You can track income from multiple sources - like consumables and stock - by customising how line items appear on your invoices. This helps you organise and analyse different types of income to suit your business needs.
Bookem allows you to create custom line item columns that group charges into categories such as services, consumables or stock. You can also control which of these categories are visible to clients.
To create a column that categorises your income sources:
Click on the Line items tab
Click Edit columns at the top of the screen
Click Add column
Choose Dropdown as the field type
Name the column Type (or use another label like Category if you prefer)
Set the list source to Options list
Note: Only add this column if it doesn’t already exist. If you already have a Type column, skip to the next step.
Add category options like:
- Consumables (e.g. taping, dry needles, massage oil)
- Procedure (for services)
- Stock (e.g. foam rollers, braces, resistance bands)
Click Show more to toggle visibility and requirement settings for each column
- You can choose whether clients see these columns on their invoices
- You can also make a column required when creating invoices
This is what your categorised line items might look like:
Once your line items are categorised, you can export them into a spreadsheet for analysis:
Go to Accounts > Invoices
Click Export line items
Enter the date range and status filters you'd like to export and click Download
Your spreadsheet will include a column with the Type field. From here you can:
Filter by type to review stock or consumables usage
Create a pivot table to calculate totals for each category