Ilya Shkura

Work with me

Sales reports, report checks and reconciliation.

I work where numbers have to hold up. Every figure is recounted from your raw export by separate code, and the rules are agreed in writing before counting.

Hire me on Fiverr Hire me on Upwork

Services

01

Reconciliation

Your sales against your payouts, or any two files that should agree: orders vs payment processor, invoices vs a supplier statement.

  • Every record that does not match, with both values
  • A table from one total to the other, every line recounted
  • What needs a decision, listed instead of guessed

02

Report checks

A report you already have, checked against the raw export it was built from.

  • Every agreed figure beside its recount
  • Matches, does not match (both values), or can't be checked, and why
  • The definitions each figure rests on

03

Sales reports

Your orders export turned into a report for the period: net sales, orders, average order value, refunds, discounts, top products, repeat customers.

  • Drafted with Anthropic's Claude, every figure recounted by separate code
  • The questions only you can answer, asked instead of guessed
  • Next month, the same code runs the new export

Cases

Self-initiated case studies on synthetic data in real export formats, so the right answers are known.

Reconciliation€285,611between March sales and card payouts, explained line by line

Shopify sales vs Shopify Payments payouts

EUR 529,976 of March sales against EUR 244,365 net card payments for March. The gap explained to the cent; 1,439 of 1,444 card orders match their charge, eight records need a person.

Read the case → Report check8 of 35recounted figures were wrong, all from one line of code

AI sales report: 35 figures recounted, 8 wrong

All 113 figures reviewed, 35 recounted from the export: 27 matched to the cent, 8 differed, all from one line of code. Net sales came out EUR 505.35 too high.

Read the case → Sales report36/36figures of the report matched an independent recount

A quarter of a Shopify shop, analysed and checked

Net sales EUR 1,474,891.63 from 8,664 orders. 36 of 36 figures matched an independent recount, and five questions only the owner can answer.

Read the case → Sales report · finance37.2%of gross value in suspended or delisted securities

Fifteen funds on one date, every figure recounted

EUR 13.55 billion in 2,133 positions, and the figure the total does not show: 37.2% of gross value in suspended or delisted instruments.

Read the case →

How I work

  1. You send the files

    Exports as they come from Shopify, Stripe, a bank or a spreadsheet. If a file can't be used, you hear it on day one.

  2. Rules in writing

    Before counting: the key, the date, what counts as revenue, VAT, shipping, refunds, the time zone.

  3. Count, then recount

    Every figure is recounted by separate code that never saw the first result.

  4. You get the document

    Every figure with its status, the open questions, and a receipt with a checksum of every file.