Case study

Check parser 1-OFD in Excel

A utility for extracting electronic receipts from letters from the 1-ofd.ru service and uploading data to Excel

Python openpyxl

Open project ↗

01 Task

I wanted to get a tool that would parse 1-OFD checks from mail and write them into Excel

02 Solution

Wrote a parser in Python. Collects letters from 1-ofd.ru, pulls out positions and check amounts and puts them into a ready-made Excel table

03 Solved tasks

Wrote check parser 1-OFD in Python
Set up receiving letters from 1-ofd.ru
Implemented extraction of positions and check amounts
I uploaded data into a ready-made Excel table

04 Result

Manual transfer of receipts is completely gone, keeping track of expenses has become much easier