I run a small business and need a working Excel spreadsheet that helps me track monthly income and expenses — and generates totals that I can use for:
Universal Credit reporting (monthly net income)
Carer’s Allowance (annual income total)
HMRC Self-Assessment (annual income, expenses, net profit)
I already have a file with the right structure — but the formulas and calculations aren’t working properly, especially when entering my own data. I need someone to either fix it or rebuild it cleanly from scratch.
✅ What It Must Do: Income and Expenses Tabs
Date, Description, Amount, and Category columns
Dropdown list of expense categories (including “Online & Website fees”)
Input dates in UK format (DD/MM/YYYY)
Optional: highlight if a date is invalid or won’t be counted
Summary Tab
Monthly breakdown of:
Total Income
Total Expenses
Net Profit
Totals that auto-update from the Income/Expenses tabs
Annual totals
Clear value for:
Universal Credit reporting (monthly income)
Carer’s Allowance reporting (annual income)
Annual Expense Breakdown
Sums up each category over the full year
Monthly Category Breakdown
Shows how much was spent in each category per month
I have a template that almost works — but formulas don’t pull data correctly when I enter my own info.
Rails, React & Deployment Fixes Category: Backend Development, Frontend Development, JavaScript, Node.js, PostgreSQL, React.js, Ruby On Rails, Web Development Budget: $2 - $8 USD
05 Nov 2025 23:02 GMT
50$ Fix Facebook Ad Restrictions Category: Account Management, Ad Planning & Buying, Advertising, Digital Marketing, Facebook Ads, Facebook Marketing, Internet Marketing, Marketing Strategy, Social Media Management, Social Media Marketing Budget: $10 - $30 USD
Live2D Avatar Layer Separation Category: 2D Animation, 2D Drawing, 3D Modelling, Photoshop, After Effects, Animation, Clip Studio Paint, Graphic Design Budget: €8 - €30 EUR
05 Nov 2025 22:58 GMT
True Life Love Story Documentary Category: Audio Editing, Audio Services, Film Production, Script Writing, Video Editing, Video Production, Voice Over, Voice Talent Budget: $3000 - $5000 USD
05 Nov 2025 22:57 GMT
Consultant for Bookkeeping in India Category: Accounting, Accounting Tutoring, Bookkeeping, Financial Consulting, Tax Compliance Budget: €2 - €6 EUR
Golf Company Logo Category: Graphic Design, Logo Design Budget: $250 - $750 USD
05 Nov 2025 22:53 GMT
QuickBooks Online Training Video Category: Accounting, Bookkeeping, Content Creation, Intuit QuickBooks, Video Production, Voice Over Budget: $30 - $250 USD
05 Nov 2025 22:52 GMT
Mentor Freelance Web & Copywriting Category: Article Writing, Content Marketing, Content Writing, Copywriting, CSS, HTML, Internet Marketing, JavaScript, Web Development, WordPress Budget: $10 - $30 USD
05 Nov 2025 22:49 GMT
Google Maps Scraping ‑ Photographers Category: Data Collection, Data Entry, Data Mining, Data Processing, Data Scraping, Excel, Python, Web Scraping Budget: $10 - $30 USD
05 Nov 2025 22:49 GMT
Microsoft 365 Admin Configuration Category: Cloud Computing, Microsoft 365, Microsoft Azure, Microsoft Exchange, Microsoft Outlook Budget: $25 - $50 CAD