There are two ways to import your payroll in Libeo: through a BACS file or a .csv template.
Go to the Dashboard or the “Pay” tab:
Click on “Import payroll” on the upper right-hand side
Click on “Upload your .csv or BACS file”
Choose the file from your drive (do not drag and drop your file ⚠️)
BACS
You can download a BACS payment file from any payroll software, here is an example with Xero Payrolls.
How to import payroll from Xero to Libeo:
First, set up your employees information and bank details in Xero.
You can then download the BACS file from Xero by navigating through the Payroll tab:
Click on “Pay employees” and select your Pay Run
Click on “Options”
Select “Download Bank Payment File” then “BACS”
CSV
In order to run payroll with a .csv file, first, download the template available on Libeo. Then, fill it out with all the mandatory information in the right format, as shown below.
⚠️ Some spreadsheet apps remove “0” at the beginning of your Sort codes and Account numbers. If that happens, change the format of the cells to “text” instead of “number”.
⚠️ Make sure the date format is correct: yyyy/mm/dd or dd/mm/yyyy
Once this is done, you can save it as a .csv file.
Once imported, one invoice per line will be created. Also, each payee will have a contact card created in their name.
Tips
The payrolls will be imported under the “Invoice” tab and a tag is automatically created to be able to filter the invoices using the due date.
Finally, you can pay a payroll directly like any other invoice through the different suggested payment methods.
How does reconciliation work here (with a payroll coming from Xero):
Note that if you use Xero, we do not send any information concerning payrolls back to Xero at this moment.
In order to reconcile these payments, you can create a Manuel Journal entry (MJ) from you Libeo Wallet to your Wages account.
For more information about reconciliation, check this article: https://help.libeo.io/en/articles/5881048-xero-reconciliation