Seamlessly export your expense reports to Twinfield
The direct connection between SRXP and Twinfield allows you to easily export your company's expenses from SRXP to your accounting system in a single click.
1. Connecting to Twinfield
To connect SRXP to your Twinfield environment, go to:
- Admin
- Connections
- Twinfield.
- Click Connect.
If you are not logged in yet to your Twinfield / Wolters Kluwer environment, enter your login credentials. After you logged in, you will be redirected to the following page:
Click Yes, allow to establish the connection between SRXP and Twinfield. Once connected, you will be redirected back to SRXP and your connection status bar will appear in green, as shown below:
2. Flexible mapping
Our connection offers you a very flexible mapping of the different fields in SRXP and Twinfield. To map your fields, go to:
- Connections.
- Exports.
- Open your Twinfield export format.
- Scroll down to the Report and Expense blocks.
It is important for you to know that Report values are booked on the Entry level, while Expense values are booked on Entry line level.
2.1 - Where to find the information in Twinfield?
SRXP | Twinfield |
Category | Accounting > Dimensions > Winst & verlies (PNL) Profit and Loss |
Establishment | Accounting > Dimensions > Kostenplaatsen (KPL) Cost Center |
Creditor ID | Accounting > dimensions > Crediteuren (CRD) Account Payable |
Payment methods | Accounting > Pay & Collect > Types |
VAT codes | General > Company > VAT |
Division | General > Company Settings > Code. |
Journal Code | General > Company > Transaction Types |
Projects | Projects > Manage projects > Time & expenses – Project Dimension Manager |
Audit Code |
General> transaction types > Inkoopfactuur Make the free fields allowed + Document imaging : Name Audit Trail https://audit.srxp.com/$FreeText2$ = available in free field 2 |
Account Payable | General > Company > Settings > System accounts -> Crediteuren / Accounts payable (Open the lock) (on the report section, needed for dimension 1) |
Currency | General > Company > Currencies (!) if you want to export the expense currency, make sure that all currencies are existing in Twinfield. |
2.2 - Available fields and their meaning
2.2.1 - Purchase
Report values
Name XML code
Division / company code <office>
Journal code <code>
Currency <currency>
Booking date (per export file) <date>
Booking due date (per export file) <duedate>
Invoice number <invoicenumber>
Credit side description <description>
Credit side dim1 (creditor role) <dim1>
Credit side dim2 (cost centre) <dim2>
Credit side dim2 - no_reimbursement or to_pay <dim2>
Credit side total <value>
Credit side free text field 1 on 'total' line <freetext1>
Credit side free text field 2 on 'total' line <freetext2>
Credit side free text field 3 on 'total' line <freetext3>
Expense values
Debit side dim1 (ledger) <dim1>
Debit side dim2 (cost centre) <dim2>
Debit side dim3 (project / assets) <dim3>
Debit description per subamount <description>
Debit line value<value>Debit VAT code per subamount <vatcode>
Debit VAT value per subamount <vatvalue>
Debit side free text field 1 on 'detail' line <freetext1>
Debit side free text field 2 on 'detail' line <freetext2>
Debit side free text field 3 on 'detail' line <freetext3>
------------------------------------------------------
2.2.2 - Memorial
Report values
Name XML code
Division / company code <Office>
Journal code <Code>
Export Currency <Currency>
Booking date <Date>
Due date <Duedate>
Invoice number <Invoice number>
Debit side dim1 (Balance) <dim1>
Debit side dim2 (Creditor) <dim2>
Debit side dim3 (Project / Assets) <dim3>
Debit description per subamount <description>
Debit line value <value>
Debit side free text field 1 on 'detail' line <freetext1>
Debit side free text field 2 on 'detail' line <freetext2>
Debit side free text field 3 on 'detail' line <freetext3>
Credit side dim1 (Balance) <dim1>
Credit side dim2 (Creditor) <dim2>
Credit side dim3 (Project / Assets) <dim3>
Credit description per subamount <description>
Credit line value <value>
Credit side free text field 1 on 'detail' line <freetext1>
Credit side free text field 2 on 'detail' line <freetext2>
Credit side free text field 3 on 'detail' line <freetext3>
Expense values
Name XML code
Debit side dim1 (ledger) <dim1>
Debit side dim2 (cost centre) <dim2>
Debit side dim3 (project / assets) <dim3>
Debit description per subamount <description>
Debit line value <value>
Debit VAT code per subamount <vatcode>
Debit VAT value per subamount <vatvalue>
Debit side free text field 1 on 'detail' line <freetext1>
Debit side free text field 2 on 'detail' line <freetext2>
Debit side free text field 3 on 'detail' line <freetext3>
Credit side dim1 (ledger) <dim1>
Credit side dim2 (cost centre) <dim2>
Credit side dim3 (project / assets) <dim3>
Credit description per subamount <description>
Credit line value <value>
Credit VAT code per subamount <vatcode>
Credit VAT value per subamount <vatvalue>
Credit side free text field 1 on 'detail' line <freetext1>
Credit side free text field 2 on 'detail' line <freetext2>
Credit side free text field 3 on 'detail' line <freetext3>
2.2.3 - Cash
Report values
Name XML code
Company code <office>
Transaction type code <code>
Currency <currency>
Dimension - Cash code <dim1>
Amount <value>
Date <currencydate>
Description <description>
Invoice Number <invoicenumber>
Free Text 1 <freetext1>
Free Text 2 <freetext2>
Free Text 3 <freetext3>
Expense values
Name XML code
GL Account <dim1>
Cust./supp. /Ccr. <dim2>
Project/asset <dim3>
Amount <value>
Date <currencydate>
Description <description>
Invoice Number <invoicenumber>
VAT Code <vatcode>
VAT Amount <vatvalue>
Free Text 1 <freetext1>
Free Text 2 <freetext2>
Free Text 3 <freetext3>