I will reconcile your inventory stock data in excel or google sheets

Nigeria

I speak English

Data Analyst, Excel, Power BI, Google Sheets

Hi, I’m Isaac, a Data and Business Operations Analyst specializing in Excel, Google Sheets, Power Query, Power BI, Apps Script and AppSheet. My services include: • Inventory reconciliation and stock ...
About this Gig

Is your inventory data difficult to reconcile?


Do your opening stock, receipts, sales, transfers and closing balances not match?

I will clean, reconcile and structure your inventory data so you can clearly understand your stock position and identify discrepancies.


I can work with:

Opening and closing stock

Purchases and receipts

Sales and dispatch

Stock transfers

Stock adjustments

Physical stock counts

SKU/product-level reconciliation

Variance analysis

Multiple Excel or Google Sheets files


WHAT YOU WILL RECEIVE

Clean and organized data

Reconciled inventory records

Variance identification

Clear reconciliation report

Excel or Google Sheets solution

Formulas and calculations where appropriate

Professional summary of findings

I can also build a reusable reconciliation template to make future stock reconciliations faster.


Please contact me before ordering if your data involves multiple files, complex inventory movements or a customized reconciliation process.


BUYER REQUIREMENTS

  1. Upload the Excel, CSV or Google Sheets data you want reconciled.
  2. Tell me the period or dates I should analyze.
  3. Tell me the products, SKUs or locations that should be included.
  4. Tell me your expectations

Technology:

Excel

Analysis Type:

Quantitative Analysis

•

Qualitative Analysis

Expertise:

Web analytics

•

Algorithms

•

Prediction

•

Forecasting

Programming language:

SQL