Spreadsheets Projects

opportunity

Shift planning / Rota management

I need to create a spreadsheet / database which we put all of our staff onto, we need to see which staff are available (depending on what they want to work) who is confirmed booked for a shift and who is proposed for one. Many thanks,

opportunityurgent

Reformatting and cleaning data from an old CRM

I have several excel spreadsheets with excessive data which need cleaning and updating then putting into a workable format

End 23, 24 and 25 accounts needed

end of 23, 24 and 25 accounts to be prepared. Complicating factors Multiple bank accounts. Interspersed personal spending. Suggest master spreadsheet with transactions and I can remove personal expenditure. Urgent requirement - by Thursday or can push to Friday this week.

opportunity

“Experienced CPA/accountant for Bank Statement & Dividend Audit

“Looking for a professional accountant or bookkeeper to analyze 5 years of bank statements. Must be able to reconcile transactions with dividend payouts, withdrawals, and bank charges, and provide clear year-by-year summaries of income, expenses, and investments. Experience with Excel or accounting software preferred.” Reconcile all transactions, withdrawals, and bank charges. Extract and summarize dividends received by name and amount. Provide clear year-by-year summaries of income, expenses, and investment activity. Deliver results in an easy-to-read table or spreadsheet format showing dividends, withdrawals, fees, and notes.

opportunity

RESEARCH POKEMON CARD LISTINGS ON EBAY - ONGOING WORK

FIND POKEMON CARDS THAT MEET SPECIFIC CRITERIA LISTED FOR SALE ON EBAY. PAID PER VIABLE CARD YOU FIND. ONGOING WORK WITH NO MAXIMUM. YOU CAN MAKE A LOT OF MONEY IF YOU ARE ORGANISED AND WORK HARD. ADD EVERY CARD VIABLE TO SPREADSHEET. PAID £2 PER VIABLE CARD. FIRST PAYMENT IS £300 FOR 150X VIABLE CARDS.

Client Support Coordinator

I'm looking for an experienced Client Support Coordinator to manage client records and ensure smooth day-to-day client operations. What you'll do: • Create and maintain client files with contact details, service plans, and progress notes • Build and manage trackers to monitor open issues, follow-up statuses, and resolution times • Analyse key performance metrics and produce regular reports for management • Manage client budgets, generate invoices, and track expenses • Use spreadsheet tools for scheduling, resource allocation, and monitoring project timelines If you're organised, detail-oriented, and experienced in client support, send me a proposal!

Compelling E-commerce Product Descriptions

I’m ready to refresh my online store and need persuasive, search-friendly product descriptions that turn casual browsers into buyers. I’ll supply a spreadsheet with each item’s specs, images, and a short brand-voice guide; you return polished copy in the same sheet, formatted for quick upload to Shopify. Timing matters—I’d like the full set finished within the next month. All writing must be original, clearly highlight benefits and key features, and flow naturally for both customers and SEO. When you apply, focus on your experience crafting product copy. A brief note plus links or files showing live listings you’ve written is all I need to see if we’re a fit. Once we connect, I’ll confirm the exact product count, word range, and agreed milestones so we can hit the ground running and make these items shine.

Repairs and Monitoring system

I require a designer to develop a simple, user-friendly Repairs and Monitoring system to manage walkabouts, repairs and health & safety issues across five accommodation schemes. Existing Excel spreadsheets define required data; the task is to integrate these into a cohesive solution—link sheets, create dropdowns, automate data population, implement tracking and status updates, and produce clear reports. The system must accommodate staff with limited computer skills, be reliable, and easy to maintain.

Online Research Assistant for Simple Data Collection

Project Description We are looking for a freelancer to assist with a small online research project. The task involves finding publicly available information online and organizing it into a spreadsheet. Tasks may include: * Searching for business or website information online * Collecting publicly available details * Entering the information into a spreadsheet * Organizing the data in a clear and structured format Requirements: * Basic internet research skills * Familiarity with Google Sheets or Microsoft Excel * Good attention to detail * Ability to follow simple instructions Budget This is a small fixed-price project with a budget between $40 and $120 depending on experience and completion time. Additional Information The task is expected to take a few hours. Detailed instructions and an example spreadsheet will be provided after the project begins. Please submit a short proposal describing any experience you have with research or data entry.

opportunity

Simplifying our Master pricelist

We require an expert to streamline our Master pricelist spreadsheet. The workbook contains extensive data, numerous VLOOKUP operations, and synchronization with our Sage database via the "Sage Data" sheet. Despite a reduced upload copy, the file remains sluggish—taking over a minute to open and delay when saving/closing. Deliverables: optimize formulas, restructure for performance, implement efficient lookup/indexing strategies or Power Query/SQL alternatives, and provide a lean, responsive workbook with documented changes and recommendations.

Starting to use my dormant Ltd company

Hi, I have been trading as a sole trader for a number of years, and I have a dormant limited company that I would now like to begin trading through. I am looking for accountancy support, including: • Preparation of company accounts and corporation tax filings • My personal self assessment tax return (I am the sole director and shareholder) • Monthly PAYE, with a basic salary up to the personal allowance threshold if appropriate, and setting up and running payroll with HMRC • Advice on taking the remainder of my income as dividends My company year end is 30 April. I was planning to start trading on 1 May, although I am due several larger payments in April. Please could you advise whether it might be better to bring the year end forward? I work in Financial Services and all payments in and out are straightforward. There is no VAT. Could you give me a quote for the services above? I am not currently using accounting software. I can work with spreadsheets or with Pandle, which I have already signed up for. Thank you, Andy

Marketplace Data Collection

We are looking for a freelancer who can quickly collect listings from several online marketplaces. Task: - Find 3,000 listings on the marketplaces listed below that meet our criteria. - Add all listings to an Excel spreadsheet. - You must be registered on the platforms to open contact details and include them in the Excel file. Marketplaces: - Osta.ee - Skelbiu.lt - eMAG - Bazar - Allegro - OLX Requirements: - Attention to detail - Ability to work quickly and accurately - Registered accounts on the platforms to access contact details Deadline: The work must be completed within 3 days. Payment: Payment is negotiable. Important: We need someone who can start working immediately.

opportunity

Accounts for Companies House & HMRC CT600 for micro entity

Prepare and file micro-entity annual accounts with Companies House and HMRC (CT600). Produce draft accounts based on the existing submission, reconciling figures to match Companies House and CT filing requirements. Provide the accounts in an Excel or Numbers spreadsheet with correct check figures and working schedules. Company turnover ~£300k. Include a brief assessment of bookkeeping/accounting issues and recommendations to address gaps prior to final submission.

I need a ACCOUNTS ASSISTANT to work with us for the long term!

My client is a Bed Manufacturer in the UK. They are in need of a accounts handler to create invoices for their trade customers, so the company will provide simple price spreadsheet and the chosen candidate will work using the priceless to create invoices to existing trade clients. The trade orders will be emailed and you will then create invoices using a web based accounting software. If any accounts are overdue you will then need to chase the customers by email to remind them to pay the balance. This is a exciting role for long term, please send proposal to be paid weekly in pound sterling.

Data Engineer(Salesforce CRM)

We are looking for an experienced Data Engineer to help clean, standardize, and structure large volumes of real estate and regulatory compliance data. This role focuses on transforming messy, inconsistent datasets into a reliable and scalable data foundation that supports reporting, compliance tracking, and future automation. You will work closely with our business and technical teams to understand data logic, resolve inconsistencies, and design a clean, structured data environment. Responsibilities -Review and analyze existing datasets (leases, units, tenants, occupancy, rent, compliance) -Identify inconsistencies, duplicates, and missing or conflicting records -Standardize naming conventions, unique IDs, and relationships -Clean and transform data from spreadsheets, CSVs, and system exports -Build master datasets for properties, units, tenants, and leases -Develop repeatable data-cleaning workflows or pipelines -Implement data validation and quality checks -Create documentation (data dictionary, mappings, business rules) -Generate exception reports for data issues requiring review Required Skills -Strong experience with SQL and Python -Experience with ETL / data transformation workflows -Solid understanding of data modeling and relational databases -Experience cleaning messy, multi-source datasets -Strong knowledge of data validation and data quality practices -Ability to work independently and communicate clearly

Data engineer

We are seeking an experienced Data Engineer to help organize, clean, and structure complex real estate and regulatory compliance data across multiple sources. This role focuses on transforming inconsistent datasets related to leases, occupancy, tenants, and rent information into a reliable and scalable data foundation. The ideal candidate will review existing data, identify quality issues such as duplication and missing fields, and design standardized schemas and relationships. You will build transformation workflows to clean and normalize data from spreadsheets, databases, and system exports. In this role, you will create master datasets for properties, units, households, leases, and compliance tracking while implementing validation rules and exception reporting. You will also document data definitions, mapping logic, and business rules to support transparency and long-term maintainability, while collaborating with stakeholders to translate operational requirements into structured data models. Strong proficiency in SQL and Python is required, along with hands-on experience in ETL/ELT workflows and relational data modeling. Experience working with messy, Excel-heavy datasets and building data quality checks is essential, and familiarity with tools like dbt, Airflow, or cloud platforms such as Snowflake or BigQuery is highly preferred. Success in this role means delivering a clear, consistent source of truth for lease and occupancy data, reducing inconsistencies, and preparing the data environment for reporting, automation, and future product development.

Telesales for SaaS / Hospitality

We are looking for a confident and friendly outbound telemarketer to help introduce our software platform, to UK B&Bs and glamping sites. It is a simple operations and compliance dashboard built specifically for small hospitality businesses. It helps owners manage room cleaning status, maintenance issues, staff accounts, and compliance documentation in one organised system. Your role will be to call independent B&Bs and glamping pod sites across the UK and introduce the platform in a professional, conversational way. This is not a hard sales role. We are not looking for aggressive selling. We are looking for someone who can speak naturally and confidently to business owners. What You’ll Be Doing • Calling a provided list of UK B&Bs and glamping sites • Speaking to owners or managers • Introducing Us clearly and simply • Identifying whether they currently use paper, WhatsApp, or spreadsheets • Offering a free trial (Simple Signup via Email directly on site) • Logging outcomes of each call You will be provided with: • A call script • A product overview • A call list (est. 50 to begin) • A VoIP phone number (We use Voipfone, you MUST be able to setup confidently) • Clear guidance on positioning Ideal Candidate • Native or fluent English speaker • Clear, professional phone manner • Confident speaking with UK business owners • Experience in telemarketing, lead generation or appointment setting • Reliable and organised • Comfortable tracking results in a spreadsheet Bonus (not required): • Experience in hospitality sector • SaaS sales experience What We’re Looking For • Someone calm and professional • Not pushy or overly scripted • Able to handle objections naturally • Focused on generating interest and free trial sign-ups • British Time Zone Project Details If performance is strong, this will become ongoing weekly work. We are building a long-term system and want someone reliable who can grow with the project. Please include: • Your experience with outbound calls • Your hourly rate • Your availability per week • A short voice sample **This post is for 5 hours, as a trial - this could lead to ongoing work if it works out well.** AI, Generic Copy & Paste responses will be REJECTED. You MUST know how to setup VoIP - we will provide number, extension and passcode. 3rd time posting this role to due freelancer incapable of carrying out the task at hand.

opportunity

AI Monitoring Platform for UK Company Alerts

Project Title: AI Monitoring Platform for UK Company Financial Distress & Insolvency Alerts (SIC-Based) Project Overview: I’m looking for an experienced developer (or small team) to build an AI-powered monitoring platform or intelligent agent that tracks UK companies within pre-defined SIC codes and automatically alerts me when there are signs of financial distress or insolvency. The system should continuously monitor company data, detect risk signals, and provide both real-time alerts and structured reporting. Core Objective: To proactively identify companies within selected industries that are: Experiencing financial decline (e.g. credit score drop) Entering insolvency processes (e.g. notice of intent to appoint administrators) Showing early warning signs of distress Key Functional Requirements: 1. Company Data Collection The platform must: Pull and maintain a live database of UK companies filtered by selected SIC codes Sources should include: Companies House API Commercial data providers such as Creditsafe, Experian, Dun & Bradstreet (or similar via API) 2. Data Monitoring (Automated & Ongoing) The system should periodically (daily or weekly) re-check and update the following: Credit score (via commercial providers) Filing timeliness (overdue accounts, confirmation statements, etc.) Insolvency indicators: Notice of Intent to Appoint Administrators Administration Liquidation CVAs Director changes: Appointments Resignations 3. Financial Data Enrichment (Important) Where available, the platform should also pull and display from latest filed accounts: Turnover / Revenue Balance sheet data (e.g. total assets, liabilities, net assets) This can be sourced from: Companies House filings (accounts data) Or via commercial data providers if more structured/standardised 4. Alert Triggers The platform must generate alerts when: A company’s credit score drops by 5% or more Include the exact percentage drop in the alert Any insolvency-related event is detected, including: Notice of Intent for Administration Administration Liquidation 5. Alert Delivery Alerts should be sent via: Email (minimum requirement) Ideally also: Slack / Microsoft Teams Web dashboard notifications 6. Reporting (Key Requirement) The system must automatically generate and send: Daily report Weekly report Monthly report Each report should be delivered as a spreadsheet (Excel or Google Sheets) and include: Columns to include (minimum): Company Name Company Number SIC Code Date of event/activity Type of event (e.g. credit score drop, insolvency notice, director change) Previous credit score New credit score % change in credit score Filing status (on time / overdue) Insolvency status Director changes (summary) Turnover (latest available) Key balance sheet figures (assets, liabilities, net position) Reports should clearly show date-stamped activity and allow filtering/sorting. 7. Dashboard / Interface (Preferred) A simple dashboard to: View and filter companies by SIC code Track alerts and risk levels View historical changes and trends Export data 8. AI / Intelligence Layer (Optional but Preferred) Identify early warning signals before insolvency Highlight patterns (e.g. repeated late filings + score decline) Rank companies by risk level or likelihood of distress Technical Requirements: Experience integrating APIs (Companies House + credit agencies) Ability to build automated data polling (scheduled jobs) Cloud-based database and infrastructure Alerting and reporting automation Scalable architecture Data Sources (Must Be Used): Companies House API (free, primary source) Commercial credit data providers such as: Creditsafe Experian Business Dun & Bradstreet Please advise on: Best provider(s) to use API access requirements Ongoing data/licensing costs Deliverables: Fully functioning monitoring and alert system Automated reporting (daily, weekly, monthly) Spreadsheet output format Documentation and user guidance Ability to adjust SIC codes and thresholds Optional ongoing support Nice to Have: CRM integration (e.g. Zoho) Webhooks for automation Customisable reporting Data visualisation Budget & Timeline: Open to proposals – please include: Estimated cost Timeline Recommended tech stack Relevant experience / similar projects

opportunity

Data Entry + Web Research: Add Hotels & Restaurants

We’re building a global hotels & restaurants review platform and need a reliable assistant to add venues and complete their profiles so users can review them. This is ongoing work. We’ll start with a paid test batch, and if quality is strong we scale weekly. What you will do For each hotel/restaurant you will: Add the venue to our platform Fill in profile details accurately: Name Full address + city + country Category (hotel/restaurant + type) Website Phone (if available) Opening hours (restaurants) Short description (2–3 sentences, clean English) 5–10 high-quality photos (from official sources only, with links saved) Social links (Instagram/Facebook if available) Ensure formatting is consistent and error-free Rules (important) Accuracy > speed (no wrong addresses, no fake info) Use official sources first (official website, Google Maps, official social pages) Don’t upload random copyrighted images from blogs—use official/press/Google Business where allowed and always save the source link Every entry must be clean, consistent, and review-ready Starting Scope (Test) 50 venues as a paid test (mix of hotels + restaurants) If quality is good: 200–500 venues/week ongoing What I need from you You are detail-obsessed Strong English writing (short descriptions) Fast, accurate web research Comfortable with spreadsheets + admin dashboards Deliverables Completed venue profiles in the platform A Google Sheet log with: Venue name Link to the profile on our site Source links used (website, maps, photos source) To apply, answer these Have you done similar work (directory listings / web research / data entry)? How many venues can you do per day while staying accurate? Confirm you can follow strict formatting and provide a source link for photos/info. Your price for the first 50 venues (fixed) and your price per 100 after. Bonus (optional) If you can also find direct contact emails for owners/managers, mention it.

Build UK activity and experience operator company database

Overview We are building a structured database of UK activity, tour and experience operators. This is a research-focused project requiring accurate company information plus verified senior decision-maker contact details. Pricing Structure & Proposal Requirements This project is structured as fixed-price batches. We are not publishing a budget range and will be assessing proposals based on methodology, accuracy and commercial fit. Proposals without clear pricing will not be considered. Please provide fixed prices for the following: Trial Batch: 50 completed records Production Batch: Per 1,000 completed records Your proposal should also include: Estimated turnaround time per batch Scope of Work – UK Operator Research (Manual List Building) Research UK-based operators that both take bookings and directly deliver experiences, tours or activities themselves. Include only the actual service providers. Exclude agents, resellers, marketplaces, aggregators or any business that does not run and fulfil the activity in-house. Companies must control and fulfil the experience themselves and must not operate solely as listing platforms, brokers, agents, or ticket resellers. Use the attached market categories document as the target markets. Data Required (columns in spreadsheet) Company Information Company Name Website URL City or Region (UK only) Activity Category Source (Google Maps, Tripadvisor, Viator, GetYourGuide etc.) Decision-Maker Information Full Name of Senior Decision Maker Job Title (Owner, Founder, Managing Director, General Manager, Head of Operations etc.) LinkedIn Profile URL Verified Work Email Address (personalised to the named contact only) Mobile Phone Number (if publicly available) Office Phone Number Booking system used (Bókun, FareHarbor, Rezdy, TrekkSoft, Regiondo, Beyonk, TicketingHub, Bookeo, BookingLive, Xola, bookinghound etc) Quality Expectations UK-based companies only Must have a working website Senior decision makers only Emails must be verified and belong to the named individual Email addresses must be validated using recognised professional verification methods and must not be guessed, pattern-generated, or sourced from bulk lead databases. No generic inboxes Phone numbers must be publicly listed or clearly attributable to the company Profiles must be validated against a current LinkedIn page LinkedIn profiles must clearly show the individual’s current role at the listed company. Profiles without visible company alignment may be rejected. No duplicates One company per row Quality Benchmarks Relevance (Pass / Fail) Companies must be genuine operators that run and deliver their own activities. Decision-Maker Accuracy Contacts must hold senior roles such as Owner, Founder, Managing Director, General Manager or Head of Operations and be validated via LinkedIn. Email Standards Only verified work emails for the named senior decision maker are accepted. Data Structure & Consistency Correct spelling, clean clickable URLs and consistent formatting are required. Trial Batch Benchmarks The first batch will be reviewed against the following benchmarks: Minimum 80% relevant companies Minimum 60% verified senior emails Project Structure & Commitment Phase 1 – Trial Batch The project will begin with an initial trial delivery of 50 completed records. This phase will be used to evaluate research quality, relevance and adherence to the requirements. Phase 2 – Scaled Delivery If the trial batch meets expectations, the project may continue in larger batches of up to 1,000 records at a time. Flexible Engagement This is an ongoing research engagement rather than a fixed-volume contract. Work may be paused or stopped by the client at any stage, during or after any batch, without further commitment or obligation and for any reason. Additional batches must not begin without explicit approval. File Format Microsoft Excel (.xlsx) or Google Sheets format only UTF-8 compatible text formatting Data Ownership All data created as part of this project becomes the sole property of the client upon payment and may not be reused or resold elsewhere. Right to Pause or Stop The project may be paused or stopped after any delivery for any reason by the buyer. Client Acceptance Rights The client reserves full discretion to accept or reject any submitted batch based on relevance, accuracy, structure, or adherence to the requirements outlined in this brief. Acceptance is confirmed only when the client explicitly approves the batch in writing within the platform. If a batch does not meet expectations or benchmarks, the client may reject the submission and discontinue the engagement immediately. If a batch is rejected, the client will not release payment for that milestone. Trial Batch Evaluation The initial 50-record trial batch will be assessed against the stated quality benchmarks. Failure to meet benchmarks may result in rejection of the batch and closure of the contract without further obligation.