Most test and demo auditfiles that are available on the internet are incomplete and invalid. In this post I present a maximal SAF-T auditfile which is valid and contains all possible data elements. I also explain how to create this file and it’s minimal variants.
[Read more…] about SAF-T auditfiles for test and developmentXML stuff
Een postcodetabel op basis van BAG Extract 2.0
In de Basisregistratie Adressen en Gebouwen (BAG) beheert het Kadaster alle adressen die in Nederland voorkomen. In de BAG wordt bij een adres ook de postcode van PostNL vastgelegd, en dus moet het mogelijk zijn om o.b.v. de BAG een postcodetabel van Nederland samen te stellen.
[Read more…] about Een postcodetabel op basis van BAG Extract 2.0Improvements on SAF-T, OESO’s Standard Audit File for Tax
SAF-T (Standard Audit File for Tax) is an international standard for electronic exchange of accounting data. In this post I propose some improvements for SAF-T version 2.00.
[Read more…] about Improvements on SAF-T, OESO’s Standard Audit File for TaxExcel and XML: four observations and two bugs
I have been working with Xml files in Excel for some time now, and thought it is time to share some observations. [Read more…] about Excel and XML: four observations and two bugs
Create Xml from Schema
In this post I describe a tool to create an Xml file from a schema (Xsd) using VBA and the DOM and SOM objects of the Microsoft XML library MSXML version 6. [Read more…] about Create Xml from Schema
Get XPaths from workbook – update
In Get XPath objects from Excel workbook I described a method to retrieve all mapped XPaths from a workbook. In this post I describe another method, using the Worksheet.XmlMapQuery function. It’s simpler, and faster.
[Read more…] about Get XPaths from workbook – updateSepa Direct Debits: from Excel to Pain
Europe is preparing for SEPA, the Single Euro Payments Area. One of the SEPA goals is to replace all national direct debit standards by one XML based SEPA standard by 1 February 2014. This article shows how to create such an Xml file from Excel, without scripting. [Read more…] about Sepa Direct Debits: from Excel to Pain
Get XPath objects from Excel workbook
When working with XML enabled workbooks the relevant objects and properties are easy to retrieve. Unfortunately a workbook has no built-in collection of XPath objects. How can we get a list of all XPath objects in a workbook? [Read more…] about Get XPath objects from Excel workbook