# Budget & Bill Tracker

## Dashboard
A quick‑glance page that pulls data from the other databases.

- **Current Balance**: `{{Accounts.Total Balance}}`
- **Upcoming Bills (Next 7 days)**: Linked view of **Bills** filtered by *Due Date* ≤ `today + 7`.
- **Monthly Spend Summary**: Linked view of **Transactions** grouped by *Category* for the current month.
- **Savings Goal Progress**: Progress bar using a formula property in **Accounts**.

> 💡 Tip: Pin the Dashboard to the top of your sidebar for instant access to your financial health.

## Accounts
Database of all financial accounts (bank, credit cards, cash, investment, etc.).

| Name            | Type          | Institution      | Currency | Balance | Goal (Optional) | Last Updated |
|-----------------|---------------|------------------|----------|---------|-----------------|--------------|
| Checking Account| Bank Account  | Chase            | USD      | $3,452  | —               | 2026‑06‑20   |
| Credit Card     | Credit Card   | Capital One      | USD      | -$1,120 | —               | 2026‑06‑19   |
| Savings Account | Savings       | Ally             | USD      | $8,750  | $10,000         | 2026‑06‑18   |
| Cash Wallet     | Cash          | —                | USD      | $150    | —               | 2026‑06‑20   |

**Key properties**  
- **Balance** (Number, formatted as currency) – updated manually or via synced integration.  
- **Goal** (Number) – optional savings target; used in the Dashboard progress bar.  
- **Last Updated** (Date) – helps you spot stale data.

> 💡 Tip: Set a weekly reminder to reconcile each account’s balance to avoid drift.

## Bills
Database tracking recurring and one‑off bills.

| Bill Name      | Category   | Amount | Due Date   | Recurrence | Status   | Account Paid From |
|----------------|------------|--------|------------|------------|----------|-------------------|
| Rent           | Housing    | $1,250 | 2026‑07‑01 | Monthly    | Upcoming | Checking Account |
| Electricity    | Utilities  | $85    | 2026‑06‑25 | Monthly    | Due Today| Checking Account |
| Netflix        | Entertainment| $15 | 2026‑06‑30 | Monthly    | Upcoming | Credit Card |
| Car Insurance  | Insurance  | $120   | 2026‑07‑10 | Annual     | Upcoming | Savings Account |
| Dental Check‑up| Health     | $200   | 2026‑07‑15 | One‑time   | Planned  | Credit Card |

**Key properties**  
- **Recurrence** (Select): *One‑time, Weekly, Monthly, Quarterly, Annual*.  
- **Status** (Select): *Paid, Due Today, Upcoming, Overdue, Planned*.  
- **Account Paid From** (Relation → Accounts).  

> 💡 Tip: Enable the “Remind me on the day before” toggle in each bill’s page to get Notion notifications.

## Transactions
Database of every income and expense entry.

| Date       | Description      | Category      | Amount | Type   | Account      | Linked Bill |
|------------|------------------|---------------|--------|--------|--------------|-------------|
| 2026‑06‑14 | Salary June      | Income        | $4,800 | Income | Checking Account | — |
| 2026‑06‑15 | Grocery Store    | Groceries     | $132   | Expense| Credit Card  | — |
| 2026‑06‑20 | Electricity Bill | Utilities     | $85    | Expense| Checking Account | Electricity |
| 2026‑06‑22 | Netflix          | Entertainment | $15    | Expense| Credit Card  | Netflix |
| 2026‑06‑25 | Interest Income  | Investment    | $45    | Income | Savings Account | — |

**Key properties**  
- **Type** (Select): *Income / Expense*.  
- **Account** (Relation → Accounts).  
- **Linked Bill** (Relation → Bills, optional).  

> 💡 Tip: Use the “+” button on the bottom of the table to quickly add a transaction while on the mobile app.

## Monthly Reports
Views that turn raw data into actionable insights.

1. **Spending by Category** – Table grouped by *Category*, sum of *Amount* where *Type = Expense* for the current month.  
2. **Income vs. Expenses** – Bar chart (via Notion’s built‑in chart block) comparing total income and total expenses.  
3. **Bill Calendar** – Calendar view of **Bills** filtered to the current month, color‑coded by *Status*.  
4. **Net Worth Tracker** – Formula in **Accounts** that sums all *Balance* values; plotted over time in a line chart.

> 💡 Tip: Duplicate the “Monthly Reports” page each month and rename it (e.g., “May 2026 Report”) to keep a historical archive.

## Settings & Automation
A simple page to store preferences and optional automations.

- **Currency**: USD (change if needed).  
- **Default Account for New Expenses**: Credit Card.  
- **Zapier / Make.com Integrations**:  
  - New transaction email → create entry in **Transactions**.  
  - Upcoming bill reminder → send Slack/Email notification 1 day before due.  

> 💡 Tip: If you use a bank that offers CSV exports, import the file into **Transactions** via Notion’s CSV import to bulk‑add recent activity.

## How to import into Notion
1. In Notion, create a new page where you want the template.  
2. Click **Import** → **Markdown & CSV** and select this `.md` file.  
3. Notion will create the headings and plain tables.  
4. For each table (Accounts, Bills, Transactions):  
   a. Click the three‑dot menu on the table → **Turn into → Database → Full‑page** (or **Inline** if you prefer).  
   b. Verify property types (Number, Select, Relation, Date, etc.) match the descriptions above; adjust as needed.  
   c. For Relation columns, link the corresponding databases (e.g., set **Account** in Transactions to relate to **Accounts**).  
5. Duplicate the **Monthly Reports** page for each new month and adjust the filter dates.  
6. (Optional) Set up Zapier/Make.com automations using the URLs of the databases (found in the database’s **Copy link** menu).  

Your Budget & Bill Tracker is now ready to use—track every dollar, never miss a due date, and watch your financial goals come to life!