The Accounting team at a Fashion Retailer currently reconciles their point of sale system to their bank system and performs a point of sales to SAP reconciliation only if they notice a difference in totals. The reconciliation process takes an employee one hour on average and entails retrieving the monthly sales report from SAP and manually matching thousands of transactions with the corresponding billing information. To give the team an opportunity to correct errors before performing the bank reconciliation, Accelirate developed an automated solution to identify discrepant transactions from the POS report to transactions in the SAP report.

Solution

  1. Bot Downloads Reports – The Bot logs into the POS system, enters a date range, and downloads the transaction report from that date range. The Bot then logs into SAP and downloads the transaction report from the same date range.
  2. Bot Formats Data – The Bot creates a spreadsheet for each report and formats the transaction data, creating columns for Store, Transaction Number, Amount, and Tender Type.
  3. Bot Tests for Differences – The Bot performs a query to find discrepancies between the POS report and SAP report. There are three exceptions the Bot looks for:
    • Transactions that are logged in one report but not the other
    • Transaction amounts that do not match
    • Stores that do not match
  4. Bot Generates Report – The Bot consolidates the query results into a report, then emails the report to the SME to make the necessary reconciliations.

Results

Accelirate’s end-to-end automated solution runs on a weekly basis to preemptively catch errors before the Accounting department performs the bank reconciliation. The Bot takes 20-30 minutes to process one week’s worth of data, and approximately one hour to process the entire month’s transaction data. Along with the speed and accuracy yielded by this automation, streamlining the downstream process created more available time in the workday for the SME to focus on other high-priority tasks.

15+ Monthly Man Hours Saved
94% Error Reduction

Retail

POS to SAP Sales Amount Verification

The Accounting team at a Fashion Retailer currently reconciles their point of sale system to their bank system and performs a point of sales to SAP reconciliation only if they notice a difference in totals. The reconciliation process takes an employee one hour on average and entails retrieving the monthly.

Learn More

Employee Order Processing

An International Fashion Company holds two yearly shows. After each fashion show, the items debuted are available for sale to the company’s employees. Fulfilling the employee orders involves handoff between 6 different groups: the Fashion Unit, the Finance Department, the individual employees, the Fashion Warehouse, Fashion Account Services, and the.

Learn More

CashApp Purchase Transaction Processing

The Accounting Department of an International Retail and Manufacturing Company’s sub-brand is responsible for recording and applying cash transactions for each month. The SAP payment processing engine requires all cash transactions for each day of the month to be applied by the first business day of the following month –.

Learn More

Automated Purchase Order Creation for International Retailer

The Finance Planning Department for an International Retail and Manufacturing Company and its subsidiary brand companies receives Electronic Data Interchanges (EDIs) from customers via email that contain purchase order requests. Originally, the employees would print out the EDIs for auditing purposes and were responsible for checking the requisitions, ensuring that.

Learn More

Optical Character Recognition: Invoice Processing

The Accounts Payable Department of a major manufacturing company is responsible for locating and uploading all incoming invoice information into the company’s SAP system. This process is currently extremely manual and consumes up to 75% of the AP team’s day during peak times. The Invoice Processing function is essential to.

Learn More

Inventory and Non-Inventory Invoice Processing

A Major International Manufacturing and Retail Company uses both SAP for data entry and DocuWare to keep track of their inventory and non-inventory invoices. Currently the Accounts Payable department is responsible for sorting through over 500 invoice lines for 100+ invoices daily. This task is very monotonous and can take.

Learn More