top of page

OUR PORTFOLIO

We bring a strong track record across diverse automation projects. 
Reach out to discuss how we can customize a solution for your unique scenario.

Macro BSPL Movement Analysis

Client Source Data: SAP ERP

From 4 Hours Manual Process To 5 Minutes Automated Process

Explain increment / deduction of Balance Sheet and P&L Account from downloaded data. Make grouping of activity from highlighted line items and explain the major movement.

Macro BSPL Analysis Illustration.gif

🔁 On mobile device, landscape your screen to see full image

This image is for illustrative purpose only

Macro Management Report Analysis

Client Source Data: SAP ERP

From 4 Hours Manual Process To 5 Minutes Automated Process

Summarize downloaded data into analysis. Create Management Report supporting wordings from set of data.

Macro Management Report Analysis Illustration.gif

🔁 On mobile device, landscape your screen to see full image

This image is for illustrative purpose only

Macro Budget vs Actual

Client Source Data: SAP ERP

From 4 Hours Manual Process To 3 Minutes Automated Process

Calculate Planned Amount to Actual Amount from a set of data, with certain criteria in the column. After data processing, make Comparison Report of Plan vs Actual.

Macro Budget vs Actual Illustration.gif

🔁 On mobile device, landscape your screen to see full image

This image is for illustrative purpose only

Macro Vendor Blending Calculation

Client Source Data: Excel Files (Database Manually Maintained)

From 3 Days Manual Process To 1 Hour Automated Process

Calculate most efficient alternative for vendors based on client’s order, product specification, product volume, and shipping maximum capacity.

Macro Vendor Blending Calculation Illustration.gif

🔁 On mobile device, landscape your screen to see full image

This image is for illustrative purpose only

Macro Ekualisasi PPN

Client Source Data: Accurate ERP

From 3 Hours Manual Process To 5 Minutes Automated Process

Compare data downloaded from Accurate and reconcile to DJPOnline / Coretax transaction data (including return). Spot the difference for easier review.

Macro Ekualisasi Pajak Illustration.gif

🔁 On mobile device, landscape your screen to see full image

This image is for illustrative purpose only

Macro Extract Data to Summary File

Client Source Data: Excel Files (Manual Input By Employee)

From 5 Days Manual Process To 15 Minutes Automated Process

Extract data from Excel files inside multiple layers of folders (hundreds of excel files) and summarize certain important data into an excel file.

Macro Extract Data To Summary File Illustration.gif

🔁 On mobile device, landscape your screen to see full image

This image is for illustrative purpose only

Macro AR Sampling

Client Source Data: SAP ERP

From 5 Hours Manual Process To 5 Minutes Automated Process

Create Account Receivable sampling list from SAP downloaded data, and transform it into certain ready-to-upload template to Mekari Qontak. Ensure non-duplicate sample within certain period.

Macro AR Sampling Illustration.gif

🔁 On mobile device, landscape your screen to see full image

This image is for illustrative purpose only

Macro AR Reconciliation

Client Source Data: SAP ERP

From 1 Day Manual Process To 30 Minutes Automated Process

Reconcile transactions based on text on certain field from SAP Downloaded Data to Bank Statement. Give mark on the matched transactions.

Macro AR Reconcilliation Illustration.gif

🔁 On mobile device, landscape your screen to see full image

This image is for illustrative purpose only

We possess a broad and proven track record across diverse projects.
Feel free to contact us to explore more tailored scenarios.

MASTEREXCEL.ID

Automate Business Process Since 2018

Jakarta, Indonesia (ID) - (+62) 895 3172 4214

bottom of page