SAP – Auditing

Introduction

Correspondence audit is considered to be the least serious form of an audit with a limited scope. These types of audits are generally only used for relatively simple matters and involve small amounts of money. The next step after a correspondence audit is an office audit, where the IRS requires the taxpayer to come to an IRS location to discuss the issue in question.

In a correspondence audit, as long as the taxpayer can produce sufficient evidence to resolve the issue, the procedure is closed. The penalties for an audit that turns up errors or fraud could include payment of additional taxes, liens on property, fines, garnishment, criminal investigations and court hearings, so it’s important to have legal representation in the event of an audit. Most attorneys will advise taxpayers to keep answers as simple as possible and never offer additional information, as that could allow the agent to expand the scope of the audit.

Objective of the automation

The objective of Correspondence audit is to generate the final Audit sheet for the input provided by business. 

Solution Overview 

• Process Overview:

Bot Reads the Input excel file and group the rows based on company code and Application Form type process batch by batch.

• OneTimeBankDraft
  Bot Filter the Input records which are of the type OneTimeBankDraft.

• Opens the CheckBook in SAP and retrieve the value of last Row with the Columns name Payment.
• Check weather payment in excel and payment in SAP are same or not.
• Retrieve Mailing Address and check whether it is same as in Excel Sheet or not.
• For any exceptions update the Note with appropriate Note Content.

• Deferred Pay AGNMNT

      Bot Filter the Input records which are of the type Deferred Pay AGNMNT.

• Retrieve Mailing Address and check whether it is same as in Excel Sheet or not.
•  Retrieve Service Address and check whether it is same as in Excel Sheet or not.
• Open Deferred payment plan extract the date and amount from the Sap and Audit the same with the value of Excel.
• For any exceptions update the Note with appropriate Note Content.

• EnergySavingsTips

     Bot Filter the Input records which are of the type EnergySavingsTips.

• Check for the Row in superscreen which contains both ‘StandardMail and Energy Savings tips’
• For any exceptions update the Note with appropriate Note Content.

• SwitchHoldRelease

             Bot Filter the Input records which are of the type SwitchHoldRelease.

• Remove all the filters in Full view of SAP SuperScreen.
•  Search for the row with DPP Switch Hold removal.
• For any exceptions update the Note with appropriate Note Content.

• Change of address

      Bot Filter the Input records which are of the type Change of address.

• Retrieve Mailing Address and check whether it is same as in Excel Sheet or not.
•  Retrieve Service Address and check whether it is same as in Excel Sheet or not.
• Retrieve the address for the Business partner from FPP3 and check whether it is same as in Excel Sheet or not.
•  For any exceptions update the Note with appropriate Note Content.

 

What are the benefits?

1. Elimination of Repetitive Manual Tasks -The people currently involved in doing the Report Generation task can be free from it and could rather do something more significant.
2. Improved Efficiency – Efficiency is something every business goes for.  The Automation ensures a smooth purchase order execution process that results in better efficiency.
3. Reduced Errors – Automation Systems are better than humans at doing repetitive tasks that require accuracy.  
4. Faster Delivery – A BOT would finish any task in general far quicker than any human, hence ensuring faster delivery. Same goes for the tasks in Correspondence audit.
5. Reduced Costs – The BOT once deployed will do the UDP template generation efficiently, effectively and quickly and it will never ask for any payment in return for it.

 

 

Implementation life cycle

The entire process was built in one phase. The phase consisted of:

Phase1:

1. Requirement Gathering and Analysis.
2. Process Design Document
3. Setting up the process skeleton.
4. Development
5. Unit Testing
6. Integration 
7. Integration Testing
8. Deployment onto the client machine via RDP

 

Application Used

1. Outlook.
2. SAP
3. Excel.