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
   
   

IMPORTANT

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.

Done!

Read more about custom format in this article

Other important settings

• How to set up your categories

• How to set up your tax codes

• How to set up your tags (cost centers and projects)

• How to export expenses from Pleo

• How to use Reimbursements with your accounting