📊 MOLIYA MAVZULARI
1️⃣ P&L (Foyda va zarar)
P&L (Foyda va zarar)
P&L yasalishi
P&L gorizontal tahlil
📌 Biznes foydami yoki faqat aylanmayaptimi — shu yerda aniqlanadi.

2️⃣ Cash Flow (Pul oqimi)
Cash flow 1 (asoslar)
Cash flow 2 (chuqurlashuv)
Cash flow 3 (tahlil)
Cash flow hisoboti yaratish
Cash flow reja–fakt
📌 Foyda bor, lekin pul yo‘q — degan muammo aynan shu yerda yechiladi

3️⃣ Balance (Balans)
Balance (Balans hisoboti)
📌 Kompaniya moliyaviy holatini bir kunda ko‘rish.

📈 GOOGLE SHEETS MAVZULARI
4️⃣ Hisob-kitob formulalari
SUMIFS
COUNT / COUNTA + FILTER
LET funksiyasi

5️⃣ Ma’lumot importi va tahlil
IMPORTRANGE
QUERY
FILTER+ SORT
QUERY+IMPORTRANGE

6️⃣ Hisobot va tahlillar
Ombor hisoboti tayyorlash
ABC analiz
KPI hisoblash
BYROW funksiyasi
INDEX+MATCh

7️⃣ Boshqa
Ruxsatlarni sozlash
Matnlarni ajratish

8️⃣Tayyor templatelar namunasi
CRM(Lidlar bilan ishlash)
O'quv markaz nazorati
Texnikalarni kunlik ijaraga berish
Binolar ijarasi oldi debitor-kreditor
Ombor hisoboti
Savdo do'konlari
Telegram bot+Cash flow hisoboti
Telegram bot + Savdo uchun ERP
Mijozlarga qarzdorlik eslatmalari

9⃣AI bilan ishlash
AI bilan cash flow hisoboti tayyorlash 1
AI bilan Cash floe hisobotini tayyorlash 2
AI bilan video tayyorlash

Aloqa uchun: @Ravshanbek_Finance
🔗 Kanal 👉 @Googlesheets_Finans