XML export

Hieronder vind je een generieke XML export met alle beschikbare variabelen in SpendControl. We bieden een extra module waarmee je een aangepaste XML-export kunt maken op basis van deze variabelen. Houd er rekening mee dat sommige variabelen al dan niet beschikbaar zijn voor je op basis van je account configuratie. Een tabel met meer gedetailleerde informatie over elke variabele kun je vinden hier.

Wil je deze functie gebruiken of heb je aanvullende vragen? Neem gerust contact op met onze sales afdeling voor meer informatie.

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

Bijgewerkt op: 20/02/2024