Suppose your job is controlling and auditing accounts to find out the discrepancies between account receivables (sales) and saving accounts in banking systems. Now, consider a manufacturing company which has the network of chain stores (retail chains) and saving accounts in different banks so that all payments made by customers (Sales) in each store can be distributes and deposited among different saving accounts (below figure) something like a network. There are two types of payment: 1. ATM system 2. POS machines. Assume you are willing to compare the payments of customers (account receivables) with different saving accounts in banks for preparing a trial balance to ensure accuracy and reach the balance to zero for a period of three months. What are your challenges? For example:
1. It is possible, there will be simultaneously the transactions which show exactly the same numbers among different stores and banks.
2. The POS systems usually accumulate the payments made by customers. It means that you will not be able to control the accounts item to item and one by one.
3. Sometimes a customer send to you a payment several times. You are expected to recognize these frauds and to claim on the customer.
And maybe other challenges.
I have designed a model which is able to resolve all above challenges. I name this model something like the Artificial Intelligence by using Microsoft Excel.
If you are interested in having this model, please do not hesitate to send your request to my email: soleimani_gh@hotmail.com
Phone number: +98 9109250225
