Hello and welcome to this AEOI Hub demonstration video. In this video I'm going to be showing
you how you can use the AEOI Hub template to understand a submission file that's been prepared
for a UK Financial Institution. This is a typical example of an XML file that's been prepared for a
UK Financial Institution for submission for AEOI reporting purposes. Now this might not
look that easy to understand but we can import this data into an AEOI Hub reporting template,
which is completely free to download from aeoihub.com, which will make this easier to read
and understand. This is the AEOI Hub reporting template, which is opened in Microsoft Excel,
and if you want to import the XML file that you might have been sent by a third party
you simply click on the first import icon, select XML and continue.
Select the XML file that you've been sent that you want to have a look at, so click on the spyglass,
select the xml file,
import. The first thing that the template does, it checks that it is a valid XML file
and it checks the type of that and now it's found it's a UK AEOI, it's got one Financial Institution
with this ID and if I'm happy I can click on continue.
That's imported the data from the XML file into this template
For the Reporting Financial Institutions, it's produced one here, it's imported details.
Because the actual submission file itself doesn't contain the FI name
we've included here the FI Register ID in place of the name and there are also four
questions that are answered within the submission in relation to these various elections.
If I take a look at the accounts data that's been imported,
this is a list of all of the accounts that are imported within that submission file
and you can see on here this has put them into the template
in a much easier to read format. So I can see the balance and the income, the type of account
(whether it's an individual or an organisation of some type), that individual's name, the address,
birth information like the date of birth and the tax jurisdictions where they're
resident for tax purposes, in some cases that might be more than one.
What you can also do with the template, if you don't like scrolling left and right too much,
is on the toolbar here if you click on the pencil icon it will open up the account details for the
particular row that you've selected and there you can click through the tab seeing the account
information, the financial information in terms of the balance and income that's been reported,
details about the account holder, the address, birth information and the tax information.
In this example they're US resident and you've got their tax information number reported there.
We hope that you found that brief overview useful.
You can download a free copy of the AEOI Hub template from aeoihub.com and you can see for
yourself how easy it is to import an XML file and view the details of those reportable accounts.