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