# Small Business Bookkeeping Hub

## Dashboard
A quick‑glance page that surfaces the most important numbers and actions for the month.

| Metric | This Month | YTD | Target |
|--------|------------|-----|--------|
| Revenue | $12,340 | $78,560 | $15,000 |
| Expenses | $7,210 | $45,300 | $6,500 |
| Net Profit | $5,130 | $33,260 | $8,500 |
| Outstanding Invoices | 4 | 12 | ≤ 5 |
| Tax Due (Quarterly) | $1,200 | — | $1,200 |

> 💡 Tip: Pin this Dashboard to your sidebar for instant access each morning.

## Transactions Ledger
All cash movements recorded in a single source of truth. Use the table below as a starter; in Notion it will become a full‑featured database.

| Date | Description | Category | Account | Amount | Type | Receipt |
|------|-------------|----------|---------|--------|------|---------|
| 2024‑06‑01 | Website hosting renewal | Operating Expense | Business Checking | -$120.00 | Expense | 📎 |
| 2024‑06‑03 | Client: Acme Corp – Project X | Income | Business Checking | +$2,500.00 | Income | 📎 |
| 2024‑06‑07 | Office supplies (Staples) | Supplies | Business Credit Card | -$45.67 | Expense | 📎 |
| 2024‑06‑12 | Payroll – July (partial) | Payroll | Business Checking | -$1,800.00 | Expense | 📎 |
| 2024‑06‑15 | Tax refund (Q2) | Tax | Business Checking | +$300.00 | Income | 📎 |

> 💡 Tip: Attach the digital receipt in the **Receipt** column (use Notion’s file upload) for audit‑ready records.

## Accounts & Reconciliations
Track each bank, credit card, and cash account, plus a simple reconciliation view.

| Account Name | Type | Institution | Last Reconciled | Balance (Notion) | Balance (Bank) |
|--------------|------|-------------|-----------------|------------------|----------------|
| Business Checking | Bank | Chase | 2024‑06‑10 | $10,420.00 | $10,420.00 |
| Business Credit Card | Credit | American Express | 2024‑06‑08 | $2,350.00 | $2,350.00 |
| Petty Cash | Cash | — | 2024‑06‑01 | $150.00 | $150.00 |

> 💡 Tip: Run a monthly reconciliation checklist (see **Reconciliation Checklist** page) and mark each account as “✅ Reconciled”.

## Invoicing & Receivables
Generate, send, and track invoices. The table below will become an **Invoices** database.

| Invoice # | Client | Issue Date | Due Date | Amount | Status | Link |
|-----------|--------|------------|----------|--------|--------|------|
| INV‑2024‑001 | Acme Corp | 2024‑06‑03 | 2024‑06‑17 | $2,500.00 | Paid | 📎 |
| INV‑2024‑002 | Beta LLC | 2024‑06‑10 | 2024‑06‑24 | $1,200.00 | Sent | 📎 |
| INV‑2024‑003 | Gamma Co | 2024‑06‑15 | 2024‑06‑29 | $850.00 | Overdue | 📎 |

> 💡 Tip: Use Notion’s **Formula** property to auto‑calculate “Days Late” (`dateBetween(now(), prop("Due Date"), "days")`) and set a conditional color badge.

## Expense Categories & Budgets
Define categories, assign budget limits, and monitor spend.

| Category | Monthly Budget | YTD Spend | Variance |
|----------|----------------|-----------|----------|
| Advertising | $800 | $2,300 | -$200 |
| Office Supplies | $300 | $1,050 | +$150 |
| Travel | $500 | $1,200 | -$300 |
| Professional Services | $1,200 | $3,600 | -$600 |

> 💡 Tip: Link each transaction’s **Category** to this table (Relation) to enable roll‑up of actual spend vs. budget.

## Tax & Compliance Calendar
A calendar view (in Notion) with key tax dates, filing deadlines, and reminders.

| Date | Event | Frequency | Notes |
|------|-------|-----------|-------|
| 2024‑07‑15 | Quarterly Estimated Tax (Q2) | Quarterly | Pay via EFT to IRS |
| 2024‑08‑01 | Payroll Tax Filing | Monthly | Submit Form 941 |
| 2024‑09‑30 | Sales Tax Return | Quarterly | File with state |
| 2024‑12‑31 | Year‑End Financial Close | Annual | Prepare for tax season |

> 💡 Tip: Set a Notion reminder 7 days before each deadline to avoid late penalties.

## Reconciliation Checklist
A simple checklist page to run after month‑end.

- [ ] Verify all bank transactions are entered in **Transactions Ledger**.  
- [ ] Attach missing receipts.  
- [ ] Reconcile each account in **Accounts & Reconciliations**.  
- [ ] Review **Expense Categories & Budgets** for overspend alerts.  
- [ ] Confirm all invoices in **Invoicing & Receivables** are marked correctly (Paid/Sent/Overdue).  
- [ ] Update **Tax & Compliance Calendar** with any new filing requirements.  

> 💡 Tip: Duplicate this checklist each month and rename it “Reconciliation – {Month YYYY}” for a historical audit trail.

## 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 page hierarchy and plain tables.  
4. For each table you want as a database:  
   a. Click the three‑dot menu on the table → **Turn into → Database → Table – Full page** (or Inline).  
   b. Add the appropriate **Property Types** (Date, Number, Select, Relation, Files & media, Formula, etc.) matching the column headers.  
   c. Set up **Relations** between:  
      - **Transactions Ledger** → **Expense Categories & Budgets** (Category)  
      - **Transactions Ledger** → **Accounts & Reconciliations** (Account)  
      - **Invoices** → **Clients** (if you create a separate Clients database).  
   d. Add **Roll‑up** properties where needed (e.g., total spend per category).  
5. Convert the **Tax & Compliance Calendar** table into a **Calendar** view: click **Add a view** → **Calendar**, set the date property to “Date”.  
6. Duplicate the **Reconciliation Checklist** page each month and rename accordingly.  
7. Pin the **Dashboard** page to your sidebar for quick access.  

Your Small Business Bookkeeping Hub is now ready to capture every transaction, keep finances organized, and stay compliant—all within Notion. Happy bookkeeping!