All resources · 🛠 Tech & Productivity · العربية
Excel for Accountants: 40 Formulas & Templates
40 essential Excel formulas for accounting (English + French function names), with ready layouts for bank reconciliation, aged receivables, VAT, payroll and month-end.
Price: ⭐ 29 Telegram Stars
Open in Telegram
What's inside
- 1. Setup that saves hours (EN + FR + AR)
- 2. Formulas 1–10: summing and counting
- 3. Formulas 11–20: lookups and matching
- 4. Formulas 21–30: dates, ageing and periods
- 5. Formulas 31–40: tax, payroll, rounding and checks
- 6. Template A: bank reconciliation (rapprochement bancaire)
- 7. Template B: aged receivables (balance âgée clients)
- 8. Template C: month-end close checklist
- 9. Shortcuts accountants use every day
Free preview
1. Setup that saves hours (EN + FR + AR)
- French Excel uses French function names and semicolons: SUM(A1,A2) becomes SOMME(A1;A2). Each formula below gives both names.
- Turn every data range into a Table (Ctrl+T / Mettre sous forme de tableau). Formulas then expand automatically and use readable names like Ventes[Montant].
- Store amounts as numbers, never text. If a column aligns left, it is text: fix with =VALUE(A2) / =CNUM(A2) or Data > Convert.
- One sheet for raw data, one for parameters (rates, accounts), one for reports. Never type a rate inside a formula.
بالعربية: إذا كان إكسل عندك بالفرنسية فاستعمل أسماء الدوال الفرنسية والفاصلة المنقوطة. حوّل كل جدول إلى "جدول" (Ctrl+T) وضع النسب في ورقة إعدادات منفصلة.
The full resource continues in Telegram. Preview free, pay only if you want it.
Open in Telegram