Daily report
Laporan Harian: the four forms a crypto asset trader files with OJK each day. Pick a date in the sample period, generate the report, and download it on the regulator's Excel template.
Monthly report
Laporan Bulanan: customer numbers and the three top-20 customer lists for one month, on the regulator's Excel template.
Data
The sample database every report on this site is computed from, at the moment you press Generate. All of it is made up: the customers, their ID numbers, the transactions and the prices belong to no real person or company. It holds no login or password data.
About
What the tool is for
A crypto asset trading platform in Indonesia reports to the financial regulator, Otoritas Jasa Keuangan (OJK), every day and every month, on Excel templates the regulator provides. The reporting follows SEOJK 20/SEOJK.07/2024 and POJK 27/2024.
I built a tool that produces those reports from the platform's database: it works out customer fund balances, trades by customer group and by asset, holdings, customer numbers and the top-20 customer lists, and fills the regulator's templates. It was built for real reporting work and was also my bachelor's thesis.
What this demo is
This page is that tool's logic re-implemented to run in your browser. It is not the original code. The original is a Python web application (Flask, SQLAlchemy, Pandas, OpenPyXL); here the same queries run on SQLite compiled to WebAssembly, and the same cells of the same templates are filled by a small TypeScript module. There is no server behind it.
Original Python source on GitHub
The re-implementation was checked against the original: for every day from 1 January to 31 March 2025 and for each of the three months, the original Python generators and this version were run on the same sample database, and every figure and every filled Excel cell matched.
What is different from the original
- The data is made up. Customers, ID numbers, wallets, holdings, transactions and prices for January to March 2025 are sample data. The company name, address and director written into the Excel files are placeholders.
- No login. The original asks you to sign in. This demo skips that, and the sample database it ships has no user or password data in it.
- Consistency checks. The checks beside each report were added for this demo. The original tool does not run them.
Where things run
Reports are generated in your browser. The date or month you pick and the files you download are not sent anywhere. The site counts page views with Cloudflare Web Analytics, and that is its only outside request.
The Excel files are demonstrations on sample data. They are not filings.