Pocketjr Finance resources
Free monthly expenses Excel template
Download a ready-made Excel workbook for your monthly budget in Egyptian pounds: editable categories, planned vs actual totals and a daily expense log that adds up automatically.
Download the workbook
The file has three sheets: Monthly budget, Daily expense log and Instructions. It opens in Excel, Google Sheets, LibreOffice and phone spreadsheet apps.
The file is generated inside your browser. Nothing is uploaded, and the numbers you type into the workbook are never sent to Pocketjr.
Monthly budget sheet
Enter your monthly income and a planned amount per category. Actual is calculated from the daily log, Variance = Planned − Actual, and totals plus income left over appear underneath.
| Category | Planned (EGP) | Actual (EGP) | Variance (EGP) | Notes |
|---|---|---|---|---|
| Rent / housing | Your amount | Automatic | Formula | |
| Electricity | Your amount | Automatic | Formula | |
| Water and gas | Your amount | Automatic | Formula | |
| Internet and mobile | Your amount | Automatic | Formula | |
| … and 11 more editable categories | ||||
Included categories: Rent / housing, Electricity, Water and gas, Internet and mobile, Groceries, Eating out, Transport and fuel, Education, Health and medicine, Personal care and clothes, Outings and entertainment, Gifts and occasions, Debt or instalments, Savings, Other.
Daily expense log sheet
Record each purchase on its own row. Category and payment method use drop-down lists so totals stay accurate.
| Date | Category | Description | Amount (EGP) | Payment method | Notes |
|---|---|---|---|---|---|
| … | … | … | … | … | … |
Payment methods: Cash, Debit card, Credit card, Wallet, Bank transfer, Other.
How to use it
- Enter your expected monthly income in cell B2 of the Monthly budget sheet.
- Type a planned amount for each category in the Planned column. Rename, add or delete categories to match your life; there are no suggested amounts.
- Every time you spend, add a row to the Daily expense log with the date, category, description, amount and payment method.
- The Actual column adds up the log for each category automatically, and Variance shows Planned minus Actual. A negative variance means you spent more than planned.
- Review the totals weekly and adjust your plan. Start a fresh copy of the file each month.
- This file was created in your browser. Pocketjr did not receive or store any of your numbers.
Spreadsheet or app?
A spreadsheet suits you if you like working in Excel. If you would rather log spending from your phone in seconds, try Pocketjr: a recordkeeping tool for income and expenses (not a bank or payment wallet). Guest mode works without sign-up but stays on this device; with an account your records sync across devices.
Try Pocketjr freeWork out your daily spending limit
Frequently asked questions
Is the monthly expenses template really free?
Yes. The Excel file is free to download and use, and you do not need an account.
Does it work in Google Sheets or on my phone?
Yes. It is a standard .xlsx file, so you can open it in Microsoft Excel, Google Sheets, LibreOffice or a phone spreadsheet app. Formulas and drop-down lists work in all of them.
Are my numbers sent to Pocketjr?
No. The file is built inside your browser when you click download. Nothing you type in the workbook is uploaded to Pocketjr.
Why are there no suggested amounts?
Costs differ a lot between households and cities, so the template starts empty. You enter your own planned amounts based on your real bills.
Related: How to make a monthly budget · How to track daily expenses
The template is a general organisation tool, not financial advice.