Discrepancy Analysis for The Partial Payments (Debit/Credit)

Sometimes finding the discrepancies between the accounts is easy, but that can be very complicated as a real case in which to extract the area of discrepancies would be impossible. For instance, suppose your customer settles the sales invoice in partial payments during a period of time. On the other hand, it is possible. The partial payments made by your customer are not exactly equal to the total sum mentioned in the credit section of your bank account. In fact, here we have two big problems with auditing the accounts: 1. In the credit section of a bank account, we have the total sum which has been divided into many partial payments on the debit section of a bank account. 2. The above total sum is not exactly equal to the partial payments. This new analytic model can help us to fix these two problems. Since this model is under test, interested people who have real cases do not hesitate to send their data to my email: [email protected] Do not worry about the security of your data, because you can multiply or divide all the data of columns debit and credit by a positive real number such as 0.058, 3.7, 6, and so on, and then send it to me.

• #فناوری_و_رایانه
• #data_analysis
• #microsoft_excel
• #debit
• #credit
• #accounting