XML Export
Below, you will find a generic XML export with all available nodes in SpendControl. We provide an additional module with which you can create a custom XML export format based on these nodes. Please note that some nodes may or may not be be available to you based on your account configuration. A table with more in-depth information about each node can be found here.
Would you like to use this feature or do you have any additional questions? Feel free to contact our sales department for more information.
Would you like to use this feature or do you have any additional questions? Feel free to contact our sales department for more information.
<bookings>
<custom_folder>
<custom_value/>
</custom_folder>
<ID>65b28282f7005c64e308b14a</ID>
<Division_name>Klippa App B.V.</Division_name>
<Division_code>1248</Division_code>
<Division_VAT_number>NL860025664B01</Division_VAT_number>
<Division_CoC_number>74785834</Division_CoC_number>
<Journal_name>Purchase book</Journal_name>
<Journal_code>60</Journal_code>
<Accounting_relation_code>12</Accounting_relation_code>
<Accounting_relation_name>Nederlandse Spoorwegen</Accounting_relation_name>
<Accounting_relation_email>info@ns.nl</Accounting_relation_email>
<Accounting_relation_phone>088 123 45 67</Accounting_relation_phone>
<Accounting_relation_COC_number>9305 6589</Accounting_relation_COC_number>
<Accounting_relation_VAT_number>NL000099998B57</Accounting_relation_VAT_number>
<Accounting_relation_Payment_condition>IN</Accounting_relation_Payment_condition>
<Accounting_relation_Bank_account>NL20INGB0001234567</Accounting_relation_Bank_account>
<Booking_date>14-10-2024</Booking_date>
<Purchase_date>14-10-2024</Purchase_date>
<Currency>EUR</Currency>
<Payment_reference>41 000 19 736 24</Payment_reference>
<Purchase_order>1234567890</Purchase_order>
<Invoice_number>41 000 19 736 24</Invoice_number>
<Receipt_type>receipt</Receipt_type>
<Finance_type>purchase</Finance_type>
<Book_as_invoice>Yes</Book_as_invoice>
<Booked_by_email>administratie+user_api+demo@klippa.com</Booked_by_email>
<Document_URL>https://app.klippa.com/dm/receipt/65b28214f7005c64e308b02f</Document_URL>
<Bank_account_number_submitter>NL20INGB0001234567</Bank_account_number_submitter>
<Total_amount_booking_lines>391.01</Total_amount_booking_lines>
<Total_booking_amount_incl._VAT>391.01</Total_booking_amount_incl._VAT>
<Total_booking_amount_excl._VAT>351.40</Total_booking_amount_excl._VAT>
<Total_booking_VAT_amount>39.61</Total_booking_VAT_amount>
<codes>
<code>
<vat_amount>7.99</vat_amount>
<index>1</index>
<key>4</key>
<amount>46.04</amount>
<amount_ex>38.05</amount_ex>
</code>
<code>
<amount>344.97</amount>
<amount_ex>313.35</amount_ex>
<vat_amount>31.62</vat_amount>
<index>2</index>
<key>3</key>
</code>
</codes>
<combined_Attachment_file_type>application/pdf</combined_Attachment_file_type>
<combined_Attachment_file_name>combined-attachment-export-booking-65b28282f7005c64e308b14a.pdf</combined_Attachment_file_name>
<combined_Attachment>base64 string</combined_Attachment>
<booking_lines>
<General_ledger_name>Operating expenses</General_ledger_name>
<General_ledger_code>Oper</General_ledger_code>
<VAT_name>VAT high rate, inclusive</VAT_name>
<VAT_code>4</VAT_code>
<VAT_include>Yes</VAT_include>
<VAT_reverse_charge>No</VAT_reverse_charge>
<VAT_percentage>21.00</VAT_percentage>
<Booking_line_description>Factuurbeschrijving</Booking_line_description>
<Booking_line_amount>46.04</Booking_line_amount>
<Booking_line_amount_ex._VAT>38.05</Booking_line_amount_ex._VAT>
<Booking_line_VAT_amount>7.99</Booking_line_VAT_amount>
<Booking_line_index>1</Booking_line_index>
<General_ledger_name>Operating expenses</General_ledger_name>
<General_ledger_code>Oper</General_ledger_code>
<VAT_name>VAT low rate, inclusive</VAT_name>
<VAT_code>3</VAT_code>
<VAT_include>Yes</VAT_include>
<VAT_reverse_charge>No</VAT_reverse_charge>
<VAT_percentage>9.00</VAT_percentage>
<Booking_line_description>Factuurbeschrijving</Booking_line_description>
<Booking_line_amount>344.97</Booking_line_amount>
<Booking_line_amount_ex._VAT>313.35</Booking_line_amount_ex._VAT>
<Booking_line_VAT_amount>31.62</Booking_line_VAT_amount>
<Booking_line_index>2</Booking_line_index>
</booking_lines>
<receipts>
<Klippa_ID>65b28214f7005c64e308b02f</Klippa_ID>
<ID_User>65b19754f7005c42873b01a7</ID_User>
<Name_User>Joop Muntjesman</Name_User>
<Email_User>administratie+user_api+demo@klippa.com</Email_User>
<User>187778</User>
<Description>Factuurbeschrijving</Description>
<Merchant>NS Reizigers</Merchant>
<Purchase_Date>14-10-2024</Purchase_Date>
<Due_Date>28-10-2024</Due_Date>
<Create_Date>25-01-2024</Create_Date>
<Update_Date>25-01-2024</Update_Date>
<Origin>Groningen</Origin>
<Locations>Zwolle</Locations>
<Destination>Amsterdam</Destination>
<Amount_of_trips>1</Amount_of_trips>
<Distance_per_trip>214.46</Distance_per_trip>
<Distance_all_trips>214.46</Distance_all_trips>
<Currency>EUR</Currency>
<Amount>428.97</Amount>
<Purchase_Amount>428.97</Purchase_Amount>
<Tip_amount>8.25</Tip_amount>
<Compensation_per_KM>0.23</Compensation_per_KM>
<Compensation_source>Default travel expense compensation</Compensation_source>
<Compensation_amount>23.00</Compensation_amount>
<Untaxed_amount>0.00</Untaxed_amount>
<Untaxed_compensation_per_KM>0.00</Untaxed_compensation_per_KM>
<Taxed_amount>49.33</Taxed_amount>
<Taxed_compensation_per_KM>0.23</Taxed_compensation_per_KM>
<VAT>39.61</VAT>
<Amount_Excl._VAT>389.36</Amount_Excl._VAT>
<VAT_deductible>No</VAT_deductible>
<Account_number>1234</Account_number>
<Invoice_number>41 000 19 736 24</Invoice_number>
<Is_exchanged>No</Is_exchanged>
<Original_amount>49.33</Original_amount>
<Original_currency>EUR</Original_currency>
<Exchange_rate>1</Exchange_rate>
<Submit_Date>25-01-2024</Submit_Date>
<Category>Reis- en verblijfkosten (03)</Category>
<Category_name>Reis- en verblijfkosten</Category_name>
<Category_code>03</Category_code>
<Category_description>Zakelijke reis- en verblijfkosten.</Category_description>
<Administration>Demobedrijf - Klippa SpendControl API (000)</Administration>
<Administration_name>Demobedrijf - Klippa SpendControl API</Administration_name>
<Administration_code>000</Administration_code>
<Administration_description>Default administration</Administration_description>
<Cost_center>901 - Sales - Klippa App B.V. (901)</Cost_center>
<Cost_center_name>901 - Sales - Klippa App B.V.</Cost_center_name>
<Cost_center_code>901</Cost_center_code>
<Cost_center_description>Sales</Cost_center_description>
<Cost_unit>555 - Amsterdam - Klippa App B.V. (555)</Cost_unit>
<Cost_unit_name>555 - Amsterdam - Klippa App B.V.</Cost_unit_name>
<Cost_unit_Cost_unit_>555</Cost_unit_Cost_unit_>
<Cost_unit_description>Amsterdam</Cost_unit_description>
<Project>F003 - Conference - Klippa App B.V. (F003)</Project>
<Project_name>F003 - Conference - Klippa App B.V.</Project_name>
<Project_code>F003</Project_code>
<Project_description>Conference</Project_description>
<Bank_account_number_User>NL20INGB0001234567</Bank_account_number_User>
<Default_Cost_center_User>901 - Sales - Klippa App B.V.</Default_Cost_center_User>
<Default_Cost_center_code_User>901</Default_Cost_center_code_User>
<General_Ledger_Account>65b19754f7005c42873b0165, 65b19754f7005c42873b0165</General_Ledger_Account>
<combined_attachment_file_type>application/pdf</combined_attachment_file_type>
<combined_attachment_file_name>combinedAttachementExport_receipt_65b28214f7005c64e308b02f.pdf</combined_attachment_file_name>
<combined_attachment>base64 string</combined_attachment>
<Klippa_short_ID>ZbKCFPcAXGTjCLAv</Klippa_short_ID>
<vat_items>
<VAT_item_amount>7.99</VAT_item_amount>
<VAT_item_original_amount>7.99</VAT_item_original_amount>
<VAT_item_percentage>21.00</VAT_item_percentage>
<VAT_item_amount>31.62</VAT_item_amount>
<VAT_item_original_amount>31.62</VAT_item_original_amount>
<VAT_item_percentage>9.00</VAT_item_percentage>
</vat_items>
</receipts>
<other>
<current_time/>
</other>
</bookings>Updated on: 01/02/2024
Thank you!