About

Hello! I run multiple faceless YouTube automation channels, each with its own monthly and yearly Profit & Loss statements maintained separately in Google Sheets. I need an experienced Excel/Google Sheets expert to create a master consolidated Profit & Loss dashboard that will: Pull data dynamically from each individual channel’s Google Sheets using IMPORTRANGE or similar functions Aggregate monthly and yearly revenue, expenses, and profits across all channels Provide easy-to-read summaries and charts (monthly trends, yearly totals, channel comparisons) Be flexible/scalable to add new channels in the future Have clear, user-friendly tabs for monthly P&L, yearly summary, and visual charts Budget: Open to proposals based on experience and delivery time. Please include examples of similar projects or dashboards you have built in your proposal.