Logo

How to split invoices

postImg
Why split invoices?

There are a number of reasons you might want to split your supplier invoices / bills, here are a few:

  • Multi site/brand organisation has an invoice for the whole group which should be split between all sites (such as insurance)
  • Commercial property management company splits expenses between tenants
  • Allocate items on the invoice to different GL/nominal codes depending on what it is
  • Add cost centres to different parts of the invoice
Ways an invoice can be split

There are a few ways you might want to split an invoice.

By items shown on the invoice

If a supplier sends an invoice which has separate charges for your different sites, and they are all shown as different lines on the one invoice, then the invoice can be split into the individual lines and each line be allocated to the site it is for. The supplier just needs to show the site name or address on each line of the invoice so you know where it should be allocated.

The same can be done if you want to split an invoice into the products shown on the invoice. If, for example, you want to apply different GL/nominal codes to different products, you can use the product code or description to detect what each line is then apply a set of actions to each line.

Evenly between pre-defined settings

You have expenses which are invoiced centrally, but you want to share that cost between sites or cost centres. You can read the invoice totals, then split the invoice into as many segments as you need, and apply different nominal codes, cost centres, tracking etc to each segment.

An example of this would be a charge for software which is used by all your sites but it is just one invoice with one charge. You can use this method to split that invoice into multiple parts and apply each part to a site.

Split an invoice by pre-defined ratios

Like the previous example, but instead of splitting the invoice evenly, it is split according to pre-dfined ratios. This is particually useful if you're a commercial propery management company and need to split invoices based on the floor area of each tenant.

How can I split supplier invoices?

Of course, you can do it manually. But here at Peripat, we have fully automated it as part of our accounts payable system. Just specifiy what you want split, how you want it split, and the system will take care of the rest.

Do you want to learn more about how Peripat can automate accounts payable? Contact us or schedule a meeting