How to set up Custom Format for Twinfield
These instructions are more of an example that might not work for all use cases of Twinfield.
Click on your profile image in the lower left hand corner and select Settings
From the menu option, select Accounting
Choose Custom Format as your accounting system
Create Tax codes and set up the Settings like below:
Note! Twinfield only imports XLS, but the best thing is to export first in CSV from Pleo, and then save the file as XLS.
Set up categories
Set up Tags (Cost centres)
Make sure you have set up the settings like below
Create the columns for your export file. Click "New" below the Columns.
Create each column using the image below as a reference
You can always change the column names and add more columns and datapoints if that works with your set up in Twinfield.
In Custom Format, you can also use Teams and the department code as another data point. You just need to choose Project ID and the data source to be "Team code". The team code is always fixed for each user.
If employees always need to choose the tag, then we recommend using the Tags in Pleo and choosing "tag name - ID" as a data source. Read more about Tags from here!
Formatting values for Twinfield
1. Choose dd/mm/yyyy
2. Make sure the number format is with 1000.00 and not 1000,00 with Amounts
3. Data point ‘Periode’ - Period
For now you can either choose to make this a static field that they update in Pleo once a month, or use a date field and modify this manually in Excel after the export is done.
NOTE! Before importing the file to Twinfield, some manual work is required on the spreadsheet. Remember to export in CSV and convert the file to XLS before exporting.
Credit and Debit lines:
For this it is important to select a multiline export as advised above, and add the debit / credit field to the custom export.
When you export, all lines will be shown as debit, and you need to manually remove every second “debit” and replace this with “credit”.
Copy the amount from the debit line and add it to the credit line, and remove the cost centre from the credit line.
Other important settings