FCPA data visualization - part 2/4

Publicado em: 18 Agosto 2024
no canal de: 300Framework

Let's continue with FCPA data visualization.

It could be a foreign exchange adjustment, so let’s see. We want to see what kind of journal entry it is. We can go up here and we can see whether or not we’ve been able to categorise that thing as something such as an accrual or a foreign exchange adjustment, or it’s more likely to be a foreign exchange adjustment, or something like that.

So, in this filter, the journal entry description filter is really interesting because what we see in this filter is an automated classification of all of your journal entries. We typically want to say, what is this journal entry like? What is it doing? Is it a customer invoice? Here you can see they’re greyed out because this isn’t to do with customer invoice. You’ve got customer invoice reverse, or you’ve got customer payment, customer payment reverse, or you’ve got customer adjustment.

That just means like debit customer, credit customer, or the other way around. And you’ve got all these different journal entry descriptions in here. And these are all automatically generated, right? So inside the Qlik App, it’s like we have a whole lot of rules, and it’s based on lots of different tables inside the chart of accounts.

So you’ve got like T030, loads of different, you know, T012K, all these different things. Lots and lots of different tables that are configuration tables in SAP. And they’re really helpful because they tell you that this account is a type of account that’s used for disbursements, this account is a type of account that’s used for provisions, and this account is a type of account that’s used for accruals. It gives you all of that information.

Based on all of that information, and based on a few other things that you can get from the general ledger itself, when you have like some flags to say this is a payment, or this isn’t a payment, or this is, you know, an automated posting, or this is just a clearing document, we don’t care about it, and all that stuff, we are able to actually say, based on some rules, that these things are specific things that we know what they are, right? We know that it is a supply invoice or supply invoice reversal. Here you can see you’ve got sample document, that just means that it’s not a real posting, as I didn’t filter on the entry status up here. But normally what we do is start off by filtering on entry status is normal.

That will help you to just ignore anything that is not even posted in general ledger. Because quite a lot of times we get a bit confused with SAP, because if you just get the data out of SAP, you’ve actually got a whole load of junk in there. And you’ve got all the draft posting, and you’ve got recurring entry and all this stuff.

So when we look at what we just filtered on, we see that at the top, we don’t have a very good description of what it is. The reason we don’t have a very good description for what it is, is because it is something that didn’t fall into any of our buckets. And that means it’s something a bit unusual.

That’s really interesting, because we don’t actually know how to classify it, right? So if you took this QLIK App, and you get to know all the rules, you understand them and stuff like that, you might start thinking, oh, but actually, this particular one is normal for us, it’s this type of thing. And then you could change it, you could add that rule. And then you would no longer get it coming up like this, you get it with your particular rule for your group.

But for the moment, this is something unusual. And I think it is quite unusual, because it’s just a debit cost and credit bank. And the other thing about it is, obviously, this is all dummy data from a sandbox. This is not real data. But if you see that there is actually only one user doing it, then it would also be maybe a bit suspicious, depending on the size of the entity...

...click here for more information: https://aufinia.com/knowledge-center/...

________________________________________________________________________________________________

Want to learn more from Claire?

1. Subscribe to the channel:
/ @300framework

2. Over 150 Free webclasses on data audit - join our LinkedIn group: / 13966266

3. Free+shipping: over 500-page book on how to audit SAP data:
https://shop.aufinia.com/sp/data-anal...

4. One-month free trial SAP extractor tool:
https://shop.aufinia.com/sp/asap-tool/

5. Free-trial Process Mining:
https://aufinia.com/contact-us/

6. Free-trial SAP data audit e-learning:
https://aufinia.com/contact-us/

#FCPA #DataVisualization #GeneralLedger #InternalAudit

Nesta página do site você pode assistir ao vídeo on-line FCPA data visualization - part 2/4 duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário 300Framework 18 Agosto 2024, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 31 vezes e gostou 0 espectadores. Boa visualização!

4,428

165