Warehouse Billing Reports: 300 Manual Downloads in One Click
Anas Yaseen
From the client's review: "Now our repetitive task is done by one click! GREAT I love this"
The problem
A fulfillment warehouse in Germany bills its business customers twice a month. Each bill needs 4 reports per customer from Pakaneo, their warehouse software. By hand that was 9 to 10 clicks and 1 to 2 minutes per customer. One billing round had 75 customers and 300 reports across two accounts: up to 2.5 hours of clicking.
What I built
A simple dashboard anyone on the team can run:
Pick customers by name from a saved list
Pick the dates and which of the 4 reports
Pick one account or both, then click Download
Watch the progress and get every report in one dated folder
The hard part
Each report took 30+ seconds to build in a new tab. So the tool logs in once, then asks the site for the files directly, many at a time. The first big run got 95 of 100 reports, because the site slows down when too many are requested at once. Retries, pauses and a list of failed files fixed it. Later, some customers got an empty file from the wrong account, so the team now picks the account.
Results
Up to 2.5 hours saved per billing round
39 customers, 156 reports, 0 failed
About 19 minutes, with nobody clicking
The client came back for a second order
Tech: Python, Playwright, aiohttp, Flask
Full case study: https://mranas.dev/work/warehouse-billing-reports
Like this project
Posted Oct 19, 2026
A fulfillment warehouse in Germany downloaded 4 billing reports per customer by hand, up to 300 per billing round. Now the team picks customers and dates in a dashboard and clicks Download. One run: 39 customers, 156 reports, 0 failed, in about 19 minutes.
