Back to TidyStock Guides

How to allocate service expenses

Service expenses are third-party landing costs which are allocated to purchase orders and distributed across the items within those purchase orders. These costs are added to the items' unit cost. They also affect the value of stock on hand in Xero.

Want to view this guide all at once?

Download PDF

Step 1

Under the Inventory tab, there are three new sections:

Service Expenses is where you set up new types of service expenses to select from later (e.g. import duties and clearance charges).

New Service Order is where you add a service expense that has been invoiced to you and needs to be allocated to purchase order/s.

Service Orders is where you actually allocate the expenses to the purchase orders and the items within them.

Step 2

Let's begin by going to Service Expenses.

In here, click on the Service Groups tab to set up groups of service expenses.

Select New Service Group.

Step 3

Name your service group and give it a code.

Step 4

Now go to the Service Expenses tab to create a service expense.

Click on New Service Expenses.

Step 5

Name your service expense and select which service group it falls under. Let's create the expense Storage under the group Freight.

Then enter the currency and cost. This might be a fixed cost or a daily or hourly rate.

Step 6

Before we move on to creating service orders, make sure that you have set up the service provider as a supplier in your account.

E.g. For freight related expenses, set up your freight company as a supplier.

Step 7

When a service provider (e.g. the freight company) invoices you, go to New Service Order to add the service expense.

Step 8

Select the service supplier from the dropdown list. Let's choose our freight company.

Step 9

Under item, add the service expense/s that this supplier has invoiced to you.

Under quantity, type in "1" if it is a fixed expense. For a variable expense, type the number of days or hours the expense has been charged for.

Step 10

When you're done, hit save as receipted and the transaction will be sent through to your Xero freight expense account. You can no longer edit this service order once it is sent to Xero. If you still have edits to make, select save to draft instead.

Step 11

Now go to Service Orders to view your service order and allocate service expenses to purchase orders.

They are grouped by service supplier. When you click on a supplier, all service orders for them appear on the right.

Step 12

Click on the blue icon at the end of the row to allocate expenses for that service order.

Step 13

Each service expense in the service order appears as an item in here.

First choose whether to "expense" this item. Expensing is often used for purchase orders of items that are consumed internally rather than those sold as stock.

E.g. If freight insurance only relates to a purchase order of internal office stationery, you would select "expense." This expense will not be allocated to individual items below.

Step 14

Next, add the purchase order/s that these service expenses need to be allocated to.

Click New Purchase Order, then search for the order you want to add. A full list of purchase orders will pop up for you to choose from.

Step 15

As you add purchase orders, the service expenses will be allocated to them based on their total value.

To manually allocate service expenses with custom amounts, deselect the checkbox next to Proportionate by Value.

Step 16

Once saved, you'll see that the list icons have turned green. This means that you can now allocate service expenses to specific items within each purchase order.

Click on one of these green icons.

Step 17

Here you can see each line item in the purchase order. By default, the service expenses have been allocated in proportion to each item's total value.

To manually allocate service expenses to each item with custom amounts, click Manual.

Step 18

Once you save, the status of this purchase order will turn green, meaning that it is complete.

Step 19

After you've finished allocating expenses for all purchase orders, the Save & Complete button will appear. Click this to finish the service expense allocation process.

Step 20

In your service orders list, this order's status is now Allocated, meaning that all items within all purchase orders in this service order have been allocated.

This updates each item's unit cost which can be seen their material item history. This is also reflected in their stock on hand value in Xero.

Related Guides

Want to learn more? Check out these related guides.

All TidyStock Written Guides

Setup

Set up your account in the global settings of Tidy
Set up your tax rates

If your business trades internationally, it's helpful to set different tax rates to fulfil regional requirements. In this module, learn how to add sales tax rates, to your TidyStock account. Please note that the multiple tax rates option is only available under certain plans.

Set up your users

Users are the people in your organisation who will be using TidyStock. In this module, learn how to set up their logins and permissions. Also learn how to act on behalf of other users.

User types and permissions

When setting up your users, you must select which roles and permissions they have. In this module, learn about different users roles and what areas they can view or edit in TidyStock.

Set up your material items

In TidyStock, stock items are referred to as Material Items. Sometimes, they're simply called "materials" or "items". In this module, learn how to set up and add material items to your TidyStock account. You'll use them to make sales, purchases, create assemblies, and more.

Set up your suppliers

In this module, learn how to add suppliers to your TidyStock account. These are the people or organisation's that you purchase stock from.

Set up your locations

In this module, learn how to add new material locations. Locations are where your material items or stock is stored. These might be distribution centres, warehouses, retail stores, or something else.

Set up your company settings

Company settings are general settings that will affect what you see in your TidyStock account. In this module, learn how to set up your organisation settings, understand the sales and purchases settings, and learn about automatic numbering.

Set up your currencies

When initially signing up for TidyStock, you selected a base currency. This is the currency that you transact and do business in. If you trade internationally, it is useful to set up additional currencies. Please note that multiple currencies are only available under certain plans.

Set up your customers

In this module, learn how to add customers to your TidyStock account. These are the individuals or companies who purchase stock from you.

Set up your countries

When creating a customer or supplier, you can add countries to their information profile. In this module, learn how to set up your countries available for selection.

Set up your accounting

Tidy's integration with Xero accounting means that when you make sales, purchases, and adjustments to your stock in Tidy, your Xero financial records are automatically updated. In this module, learn how to set up the connection to Xero from your Tidy account.

Set up your custom templates

Learn how to create custom templates for sales quotes, packing slips, project proposals, project quotes, and purchase orders. Use our template codes to add fields to your document template.

Migrating stock from Xero to Tidy

When you migrate stock from Xero to Tidy, you no longer need to maintain stock levels in Xero. Tidy tracks and manages inventory and uses Xero for financial accounting but does not integrate its inventory with Xero's inventory.

How to update payment card information

Learn how to update your payment card information with us.

Bulk Imports

Learn how to import data in bulk to your Tidy account
How to do a bulk import of suppliers

Previously, we learnt how to add suppliers to your account manually. However, this can be very time consuming if you have a lot of data to enter. In this module, learn how to import suppliers to your TidyStock account in bulk.

How to do a bulk import of customers

Previously, we learnt how to add customers to your TidyStock account, manually. However, this can be very time consuming if you have a lot of data to enter. In this module, learn how to import customers to your TidyStock account in bulk.

How to do a bulk import of pricing

Previously, we learnt how to add pricing to your account manually. However, this can be very time consuming if you have a lot of data to enter. In this module, learn how to import material prices to your TidyStock account in bulk.

How to do a bulk import of materials

Previously, we learnt how to add material items to your account manually. However, this can be very time consuming if you have a lot of stock and data to enter. In this module, learn how to import materials to your Tidy account in bulk.

Inventory

Learn how to store, manage, and do more with stock and material items in Tidy
How to use the stock level warnings screen

The Stock Level Warnings Screen displays current stock levels, sales and purchases on order, and calculates recommended reorder levels for you. Purchase orders can be quickly created from here, which simplifies reordering and prevents stock shortages.

How to use material categories

Material categories are used to group and help identify material items. In this module, learn how to set them up and use them to track materials. Also learn how material categories are linked to the chart of accounts in your Xero accounting system.

How to use batches

Batches are groups of items created from the same production run. The batch function in Tidy enables you to assign batch numbers against material items, assign batch numbers when receiving items, and sell items with a batch number.

How to use catalogue pricing

When you create a purchase order for a managed item, the price you pay to suppliers may differ from the current unit cost. This allows you to use the current supplier price at the time of purchase. You can also use catalogue pricing to edit the currency when you buy items in foreign currencies.

How to transfer materials between locations

If you store stock in more than one location, you may need to move material items between them for sales. In this module, learn how to transfer materials between locations.

How to use the bulk stock adjustment tool

Learn how to use the stock adjustment tool. This can be used to complete stock adjustments in bulk if you have done a stock take and need to update a list of stock levels for material items.

How to use barcodes

Barcodes are used in TidyStock to quickly search for and identify material items. In this module, learn how to add items by scanning the barcode, search for items using their barcode, and add items to sales using barcodes.

How to disable, archive, or delete items

In this module, learn how to disable, archive, and delete material items. If you are no longer selling or keeping stock of certain items, you can choose to archive or disable them. If there is no sales or purchase history against a specific item, you can also delete it.

How to run a stock on hand report

Stock on hand reports show you the stock levels of your material items. They show a breakdown and total cost value of current stock on hand.

How to create an assembly

An assembly is a top-level finished product compromised of individual material item components. They can also be referred to as a "bill of materials". In this module, learn how to set up an assembly, how to use them, and what wastage in an assembly is.

How to complete a stock adjustment

In this module, learn how to complete a stock adjustment. Stock adjustments are done to manually modify the stock level or value of managed items.

How to allocate service expenses

Service expenses are third-party landing costs which are allocated to purchase orders and distributed across the items within those purchase orders. These costs are added to the items' unit cost. They also affect the value of stock on hand in Xero.

How to complete a material conversion

In this module, learn how to complete a material conversion. Material conversions are used when you sell or consume items in a different form or unit, to which you purchased it in.

Difference between managed and unmanaged items

When setting up material items, you can choose to make them "managed" or "unmanaged". This module explains the difference between the two, the benefits of each, and when they are most appropriate to use.

Sales & Pricing

Learn how to create and credit sales, and use different types of custom pricing in Tidy
How to add quantity breaks

In this module, learn how to add quantity breaks to materials. This is a type of custom pricing where discounts are given to customers based on the quantity of an item purchased. This is particularly useful when customers make bulk purchases.

How to invoice without dispatching stock

In this module, learn how to send an invoice without dispatching stock. You will be able to send an invoice and take payment from the customer first, then order the goods in and dispatch the stock to the customer later.

How to credit a sale

In this module, learn how to credit a sale when customers return items they have purchased from you, or ask for a refund

How to create a backorder

Backorders are created when you want to enter a sale, but not invoice the customer at this stage. You can also create backorders to just get the sale into the system for further details to be added later.

How to create a sales order

Sale orders are created when you want to sell stock to a customer. In this module, learn how to create a new sales order and what different sales order statuses mean.

How to add price levels

In this module, learn how to set up pricing levels. These are used when you want to sell items at different prices to the unit charge you set up in the material items' details

How to add customer override pricing

In this module, learn how to add customer override pricing. This is used to set custom prices for specific customers.

Creating backorders with insufficient stock

Learn how to create a backorder when you have insufficient available items in stock. You'll be able to sell available stock in the order while putting the rest on backorder.

Purchasing

Learn all about sending and receiving purchase orders in Tidy
How to receive a purchase order

Previously, we created and sent a purchase order to a supplier. In this module, learn how to receive the items on the purchase order when stock has arrived. Once the items have been received, a bill payable is created in your connected Xero account.

How to credit or refund a purchase order

You can credit/refund Purchase Orders that have been receipted. This takes the goods out of stock and returns them to the supplier. A Supplier Credit Note is also created in Xero to that Supplier.

How to create a purchase order

Purchase orders are created when you want to purchase stock from a supplier. In this module, learn how to create a new purchase order and what different purchase order statuses mean.

Create and receive purchase orders from an assembly

If you want to purchase components to create an assembly, the "Purchase Order from Assembly" feature in Tidy makes it easy to ensure you order all of the material items required. In this module, learn how to create and receive purchase orders from an assembly.