Custom Format for Twinfield

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.

  1. Click on your profile image in the lower left hand corner and select Settings

  2. From the menu option, select Accounting

  3. Choose Custom Format as your accounting system

  4. 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.

  1. Set up categories

  2. Set up Tags (Cost centres)

  3. Make sure you have set up the settings like below

  4. Create the columns for your export file. Click "New" below the Columns.

  5. 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.


Read more about custom format in this article

Other important settings

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article

Need more help? Contact us.

Chat with us if you have an Essential or Advanced plan, otherwise send us an email!