Amora Kids Financial Management App MVP Summary

Objective

Develop a user-friendly financial control system using Google Sheets and Google Apps Script to manage Amora Kids' finances effectively. The system will track fixed bills, catalog renewals, daily sales, investments, and provide monthly summaries with an emphasis on brand-aligned design and interactivity.

---

Key Components

1. Dashboard
2. Fixed Bills
3. Catalog Renewals
4. Daily Sales Log
5. Investments
6. Monthly Summary
7. Archives

---

1. Dashboard

Purpose

• Central hub for navigation and key financial metrics.
• Display visual summaries and charts.

Features

• Branding: Include Amora Kids logo at the top.
• Key Metrics: Show Total Revenue, Total Expenses, Total Investments, Net Profit.
• Navigation Buttons: Buttons linking to each sheet (e.g., Fixed Bills, Investments).
• Charts: Visual trends for revenue, expenses, and investments.

Design Tips

• Use brand colors (Pink, Purple) for buttons and highlights.
• Bold fonts for key figures.
• Align content centrally for clarity.

---

2. Fixed Bills

Purpose

• Track recurring monthly expenses.
• Monitor payment statuses.

Columns

1. Expense Name
2. Due Date
3. Amount
4. Payment Status (Paid/Unpaid)
5. Action (Checkbox)

Features

• Checkboxes: Mark bills as paid.
• Conditional Formatting:
  • Highlight overdue bills in Red.
  • Upcoming bills in Yellow.
  • Paid bills in Green.
• Automations:
  • onEdit script to update Payment Status when checkbox is checked.

Design Tips

• Bold, Purple headers with light background.
• Alternating row colors for readability.

---

3. Catalog Renewals

Purpose

• Manage inventory purchases.
• Track expected purchase dates and confirmations.

Columns

1. Date of Purchase
2. Product Name
3. Quantity Purchased
4. Cost
5. Expected Purchase Date
6. Purchase Confirmed? (Yes/No)
7. Action (Checkbox)

Features

• Checkboxes: Confirm purchases.
• Conditional Formatting:
  • Yellow for upcoming purchases.
  • Red for overdue.
  • Green when confirmed.
• Automations:
  • onEdit script to update status and date when checkbox is checked.

Design Tips

• Use brand colors for alerts and confirmations.
• Clear, consistent formatting.

---

4. Daily Sales Log

Purpose

• Record daily sales data.
• Monitor revenue trends.

Columns

1. Date
2. Sales Amount
3. Notes

Features

• Data Validation: Ensure dates and amounts are entered correctly.
• Summation: Total Revenue calculated for Monthly Summary.

Design Tips

• Simple, clean table with bold headers.
• Consistent font and alignment.

---

5. Investments

Purpose

• Track capital contributions and business investments.
• Assess the ROI of investments.

Columns

1. Date
2. Investment Type
3. Description
4. Amount
5. Investment Category
6. Expected ROI (%)
7. Actual ROI (%)
8. Notes

Features

• ROI Calculation: Manual or formula-based entry of Actual ROI.
• Categorization: Differentiate between Owner Contributions and Business Investments.
• Conditional Formatting: Highlight investments with lower than expected ROI.

Design Tips

• Use Purple headers and light background.
• Align numerical data to the right for clarity.

---

6. Monthly Summary

Purpose

• Provide an overview of financial performance.
• Summarize revenues, expenses, investments, and net profit.

Columns

1. Month
2. Total Revenue
3. Total Fixed Bills
4. Total Catalog Renewal Costs
5. Total Investments
6. Total Monthly Expenses
7. Net Profit

Features

• Automatic Calculations:
  • Formulas to pull data from other sheets.
• Net Profit: Calculated by subtracting Total Expenses from Total Revenue.

Design Tips

• Highlight Net Profit with conditional colors (Green for positive, Red for negative).
• Clear, bold fonts for key figures.

---

7. Archives

Purpose

• Store historical data after closing each month.
• Maintain records for future reference.

Features

• Automated Archiving: closeMonth script to archive data and reset sheets.

---

Automations with Google Apps Script

1. onEdit(e) Function

• Purpose: Automate actions when checkboxes are checked.
• Usage:
  • Updates Payment Status in Fixed Bills.
  • Updates Purchase Confirmation in Catalog Renewals.
  • Changes row colors accordingly.

2. closeMonth Function

• Purpose: Archive current month's data and reset sheets.
• Usage:
  • Creates a new archive sheet for the month.
  • Clears data from active sheets for the new month.

---

Design and Formatting Summary

• Headers: Bold, Purple or Green text with light background.
• Alternating Row Colors: Light gray or light purple for readability.
• Buttons and Alerts:
  • Pink buttons for actions.
  • Conditional formatting colors:
    • Yellow for warnings.
    • Red for overdue.
    • Green for confirmed/completed.
• Fonts: Use Roboto or Open Sans for clarity.
• Alignment: Consistent alignment of text and numbers.
• Visual Consistency: Uniform design elements across all sheets.

---

Implementation Steps

1. Set Up Sheets: Create each sheet as outlined.
2. Design Formatting: Apply headers, colors, fonts, and layouts.
3. Insert Data: Add sample data to test functionality.
4. Set Up Automations: Implement onEdit(e) and closeMonth scripts.
5. Add Interactive Elements: Create buttons and assign scripts.
6. Test Functionality: Ensure all features work as intended.
7. Finalize Design: Make adjustments based on testing and feedback.

---

Calculating Actual ROI

1. Identify Investment Cost: Amount from the Investments sheet.
2. Determine Net Profit from Investment:
   • Calculate additional profit generated due to the investment.
3. Apply ROI Formula:

   ROI (%) = (Net Profit from Investment / Cost of Investment) * 100
   

4. Record in Investments Sheet: Enter the Actual ROI (%) in the appropriate column.

---

Next Steps

• Implement the MVP: Use this summary to set up your financial control system.
• Customize as Needed: Adjust features to fit your specific requirements.
• Seek Assistance: Reach out if you need help during implementation.

---