Ramadan & Zakat Planner — Excel & Google Sheets (EN + DE)
Plan a calm Ramadan in one workbook: work out zakat from the figures you enter, log sadaqah, budget the month, plan iftar and suhoor for 30 days, and keep Eid gifts and the last ten nights in view. Excel and Google Sheets, English and German, no interest calculations.
A Ramadan planner and a zakat calculator in one file that stays with you. You type today's gold and silver prices, choose the gold or silver nisab, and list your assets and the debts due now. The workbook works out net zakatable wealth, whether you are at or above the nisab you chose, and 2.5% zakat due. It does not decide a fiqh position for you.
Around that sit the tools for the month itself: a sadaqah log that totals gifts dated in your Ramadan range, a Ramadan income-and-expense budget (some actuals are filled from the other sheets), a 30-day iftar and suhoor planner with a grocery list, an Eid gift and expense sheet, and a giving plan for nights 21–30 with the odd nights marked. A dashboard brings the totals together.
The first day of Ramadan and whether the month has 29 or 30 days are yours to set and to confirm locally. The sample file uses 8 February 2027 only as an approximate example date.
What's included
- English sample workbook with fictional figures, plus a blank file ready for your own numbers
- German sample and blank workbooks with the same structure (Beispiel + Leer)
- A two-page quick-start PDF (English and German): how to open the files in Excel or Google Sheets
- Sheets: Start here, Settings, Dashboard, Zakat (assets, debts due now, nisab test, 2.5%, payment log), Sadaqah, Ramadan Budget, Iftar & Suhoor (30 days and a grocery list), Eid, Last 10 nights, and License
- A currency label you set yourself (USD, EUR, GBP, CAD, AUD, CHF, or another)
How to use it
- Unzip the download. Open the file in Microsoft Excel (2016 or later), or upload it to Google Drive and open it with Google Sheets. The formulas avoid Excel-only functions, and LibreOffice Calc works too. No macros.
- Fill in Settings, including the first day of Ramadan (confirm locally), 29 or 30 days, and today's gold and silver prices per gram.
- Enter your assets and the debts due now on the Zakat sheet, then use the other sheets as the month unfolds. Teal cells are for your entries; grey cells calculate automatically.
Please note
- This is a digital download. Nothing is shipped.
- Not a fatwa. The workbook only does the arithmetic on what you enter. It is not religious, financial, tax, or legal advice. Scholars differ on some of these questions (nisab metal, worn jewellery, which debts to deduct, how to value investments). For your own situation, please consult a qualified scholar or your local zakat authority.
- Confirm Ramadan and Eid dates with your local moon sighting or Hijri calendar.
- No interest is calculated anywhere in the workbook.
- Personal use for you and your household only. Please do not resell, share, or redistribute the files.
- Sample figures, names and menus are fictional.
- Designed by Wellkept. AI tools assisted in building these templates and images; every workbook is checked before release.
Deutsch
Deutsche Version inklusive: Ramadan- & Zakat-Planer mit Zakat-Rechner, Sadaqa, Ramadan-Budget, 30-Tage-Plan für Iftar und Suhur mit Einkaufsliste, Eid und den letzten 10 Nächten, als Beispiel- und Leerdatei für Excel und Google Tabellen. Ohne Zinsberechnung. Keine Fatwa: Die Arbeitsmappe rechnet nur mit Ihren Eingaben und ist keine religiöse, finanzielle, steuerliche oder rechtliche Beratung. Ramadan- und Eid-Daten bitte lokal bestätigen. Digitaler Download.