To develop the foundation of a tailored small business accounting system that aligns with Quadratic Sound’s operational needs and workflows. The system will support better visibility into financial activity, including income, expenses, invoicing, and reporting. It will be designed with long-term flexibility in mind, allowing for future automation, integrations with third-party tools, and potential scalability as the business grows.

Scope & Deliverables

1) Needs Assessment

• Review current processes (e.g., expense tracking, client payments, royalties)
• Identify key pain points and gaps in visibility

2) System Planning

• Define core system features (e.g., categories, summary views, filters)
• Choose tools (Google Sheets + Apps Script OR Python-based CLI/cloud scripts)

3) Prototype Development (Pick One Path)

> Spreadsheet-based prototype (Google Sheets + Apps Script)

• Custom transaction template
• Automated summary tables (monthly, category-based)
• Simple email/Discord alert trigger

> OR Scripted backend prototype (Python or Node.js with cron/webhooks)

• Process CSV or form input
• Generate and email simple reports
• Categorize and label expense data

4) Final Recommendations

• Submit documentation: workflow overview, prototype features, test data
• Suggest potential next steps (e.g., report exports, simple dashboards, future integrations)

🧑‍🏫 Mentorship Support

Two experienced mentors will guide the intern through each phase of the project. Support includes:

• Kickoff alignment session
• Daily check-ins and async help via Discord/GitHub
• Feedback on logic, code, and usability
• Guidance on scope management and real-world application

🎓 Ideal Learner Background

This project is best suited for learners with knowledge in:

• Financial technology fundamentals
• Spreadsheet automation OR scripting
• Data analysis or reporting tools