It is necessary to create a fully automated accounting system for the good cause of Google Sheets.
Goal:
More information about Monobank, LiqPay, and IBAN (PrivatBank) is processed automatically without manual editing and copying.
---
Data sources:
Monobank — automatic API for mobile devices
2. LiqPay - API or automated CSV encryption
3. IBAN (PrivatBank) — reading API and CSV from Google Drive
---
About what happened:
RAW tables (raw data)
Created based on conspiracy:
Monobank_RAW
LiqPay_RAW
IBAN_RAW
These sheets should automatically receive data from sources (API or Drive).
---
2. CLEAN tables (processed data)
Separate processed tables created:
Monobank_Clean
LiqPay_Clean
IBAN_Clean
In these tables, each transaction should have the correct fields:
date
transaction type (Income / Expense)
amount (in number format, expenses with a negative sign)
currency
payment / charge
purpose
source (Monobank / LiqPay / IBAN)
(optional) category / project
Automatic work: automatic processing, duplication, incorrect formats.
---
3. Top-six "Operation"
Compiled a consolidation list:
automatic robot-cleaners CLEAN-tabs
works without duplicating transactions (by identifier or (hash proposal)
carefully inserted without any movement
---
4. Analytics / Reporting
Conspiracy theorists:
Balance for balance
Income/expense by months
Distribution by sources (Monobank / LiqPay / IBAN)
Distribution by categories / projects
Ready dashboard for grant report submission
---
Final requirements:
Our system operates automatically
Some information about movements and formula insertions
Reading data structure
Documents: where to change API keys, how to add new sources or categories