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.
Develop BI Tool with LLM & RAG Category: API Integration, Business Intelligence, ChatGPT, Data Analysis, Data Analytics, Data Processing, Data Visualization, Database Management, Large Language Model, Retrieval Augmented Generation (RAG) Budget: $10 - $30 CAD
12-Jul-2025 04:00 GMT
3D CAD Design for Gears and Sprockets Category: 3D CAD, 3D Design, 3D Drafting, 3D Modelling, CAD / CAM, Mechanical Design, Mechanical Engineering, Solidworks Budget: $15 - $25 USD
12-Jul-2025 04:00 GMT
Creative Video Editor Needed Category: A / V Editing, Adobe Premiere Pro, After Effects, Cinematography, Final Cut Pro, Video Editing, Video Production, Video Services Budget: ₹1500 - ₹12500 INR
12-Jul-2025 03:56 GMT
TradingView Pine Script Modification -- 2 Category: Algorithm, Analytics, Data Analysis, Data Visualization, Debugging, Financial Analysis, Financial Modeling, Pine Script Budget: ₹750 - ₹1250 INR
12-Jul-2025 03:53 GMT
SketchUp Expert for Cabinetry & Joinery Designs Category: 2D Drafting, 3D Modelling, 3D Rendering, 3D Visualization, AutoCAD, Building Architecture, Drafting, Furniture Design, Interior Design, SketchUp Budget: $10 - $20 NZD
12-Jul-2025 03:53 GMT
Comprehensive Product Data Collection Category: Data Analysis, Data Collection, Data Entry, Data Extraction, Data Management, Data Mining, Data Processing, Data Scraping, Web Scraping, Web Search Budget: ₹37500 - ₹75000 INR
making shoes banner with assest Social Media Post Designer Category: Adobe Illustrator, Photoshop, Creative Design, Digital Marketing, Graphic Design, Illustration, Logo Design, Social Media Marketing, Social Media Post Design Budget: ₹600 - ₹1500 INR
12-Jul-2025 03:51 GMT
Multilingual Technical Article Specialist Category: Canadian French Translator, Engineering, English (UK) Translator, English Translation, French Translator, Technical Translation, Technical Writing, Translation Budget: $250 - $750 USD
प्राथमिक कक्षा के लिए उत्तर लेखन Category: Classification, Copy Typing, Copywriting, Data Entry, Data Processing, Education & Tutoring, Educational Research, Social Media Copy, Video Editing, Video Upload Budget: ₹12500 - ₹37500 INR
12-Jul-2025 03:40 GMT
Investor-Ready Business PPT Design Category: Business Analysis, Business Writing, Data Visualization, Finance, Financial Research, Graphic Design, Market Research, Powerpoint Budget: $10 - $30 USD
