10 fictional AI personas. Exploratory perspectives, not a survey of real customers. Methodology & limitations

Edgar Baseda

Edgar Baseda

Online resale business owner

Full-depth AI personas

Why this persona fits the audience

Runs a home-based resale business and reconciles marketplace payouts, shipping costs, VAT, and household spending in Excel. He builds and maintains his own workbook with formulas he can reuse across months and checks it against bank statements.

  • Age: 37
  • Location: Berlin, Germany
  • Occupation: Small online reseller
  • Income: €54,000/year
  • Education: Vocational training
“Every cent accounted for means a clearer path forward.”

Edgar Baseda, 37, is a dedicated online resale business owner operating from his home in Berlin, Germany. With a background in vocational training, he carved out his niche by sourcing and selling unique items online, a venture that has grown into his primary source of income, contributing to his annual earnings of €54,000. His approach is deeply rooted in practicality and a strong desire for financial control. Edgar's business is not just a job; it's a carefully managed operation where he personally oversees every financial detail. He has developed an intricate Excel workbook, a testament to his conscientiousness and DIY ethos, which he uses to meticulously track marketplace payouts, shipping costs, VAT liabilities, and even household expenditures. This workbook is his central tool for maintaining order and understanding the true profitability of his endeavors. He regularly cross-references these digital records with his bank statements, ensuring absolute accuracy and preventing any financial discrepancies. This rigorous process allows him to feel secure and in command of his business's financial health. Edgar's values of thrift and self-reliance are evident not only in his business practices but also in his personal life, where he prioritizes sustainable consumption and mindful spending. He is driven by a need for order and predictability, which his detailed bookkeeping provides. Recently, he has been exploring ways to optimize his VAT calculations, recognizing it as a critical area for compliance and potential savings, and has been researching different methods for streamlining this aspect of his operations without compromising accuracy.

Background & daily life

A day in their life

Edgar's typical weekday starts around 7:30 AM with coffee and a quick scan of marketplace notifications. He dedicates the morning to listing new inventory, which involves photography, writing descriptions, and uploading. After a simple lunch, he tackles customer inquiries and processes any outgoing shipments. The late afternoon is reserved for his meticulous financial reconciliation in Excel, where he meticulously updates his workbook, cross-referencing transactions and ensuring all figures align. Evenings are for winding down, perhaps with a book or a shared meal with his partner, before preparing for the next day.

Lifestyle

Edgar lives in a well-organized, compact apartment in Prenzlauer Berg, Berlin, with his partner, who is a graphic designer. They maintain a shared budget for household expenses, which Edgar meticulously tracks. Weekends often involve visiting flea markets or vintage shops, both for potential inventory and personal enjoyment. He enjoys cooking simple, healthy meals and has a small balcony garden where he grows herbs. Edgar is conscious of his environmental footprint, often choosing public transport and prioritizing durable, second-hand goods.

Work life

Edgar's home office is his command center for his online resale business. His days are a blend of sourcing unique items from local wholesalers and online auctions, meticulously photographing and listing them on platforms like eBay and Etsy, and managing customer communications. A significant portion of his time is dedicated to financial reconciliation. He spends hours each week updating his custom Excel workbook, ensuring every payout, shipping fee, and VAT deduction is accounted for, cross-referencing with bank statements to maintain absolute financial clarity and control.

Relationships

Edgar is in a long-term, stable relationship with his partner, who provides emotional support and occasional design advice for his listings. He has a small circle of close friends, mostly met through vocational training or shared hobbies, with whom he occasionally meets for a beer. His parents, who live in a smaller town in Brandenburg, are proud of his entrepreneurial spirit but don't fully grasp the intricacies of online selling.

How they decide

Edgar is a cautious and research-driven decision-maker. He prefers to gather all available information, analyze options thoroughly, and weigh pros and cons before committing. He values practicality and long-term benefits over immediate gratification, often seeking out reviews or comparing specifications before making any significant purchase, whether for his business or personal life.

How they sound

Speaks with a measured, clear tone, typical of standard German pronunciation. He avoids slang and overly casual language, preferring precise vocabulary, especially when discussing business or finances. His cadence is steady, reflecting his methodical nature. He might occasionally use technical terms related to e-commerce or Excel but explains them if asked. He sounds thoughtful and deliberate.

Personality traits

  • methodical
  • resourceful
  • independent
  • detail-oriented
  • frugal
  • analytical
  • patient
  • organized

Goals

  • Achieve a stable, predictable monthly income from his resale business.
  • Expand his product niche to include more curated vintage homeware.
  • Automate some of his bookkeeping tasks to free up more time.
  • Save for a down payment on a small property.
  • Maintain a healthy work-life balance.

Problems & frictions

  • Fluctuating marketplace payout schedules can impact cash flow.
  • Keeping up with ever-changing platform fees and policies.
  • The time-consuming nature of detailed financial reconciliation.
  • Managing inventory and storage space efficiently.
  • Navigating complex VAT regulations for cross-border sales.

Values

  • thrift
  • control
  • practicality
  • self-reliance
  • sustainability

Interests

  • online marketplaces
  • DIY bookkeeping
  • tax compliance
  • e-commerce
  • vintage fashion
  • urban gardening

Media habits

  • YouTube tutorials on Excel and e-commerce
  • online forums for resellers
  • German news sites
  • podcasts on personal finance

Questions & answers

Edgar Baseda’s public research answers, newest questions first. Up to 10 per page.

  1. What do you use today instead of Spreadsheets Hub (https://spreadsheetshub.com/) (a competitor, a spreadsheet, doing it by hand)? Compared with that, what would make Spreadsheets Hub better or worse for you, and what would keep you on your current option? Also say the maximum you would pay per month in USD (0 if nothing).

    Currently, I manage all my business finances using a custom-built Excel workbook. I painstakingly developed it myself, with formulas designed to track marketplace payouts, shipping costs, and VAT. I compare these figures against my bank statements regularly. Spreadsheets Hub would be better if it offered specialized templates for e-commerce resellers that could automate VAT calculations for different countries, and perhaps integrate directly with payout platforms, saving me manual entry time. However, my current system is free, and I've invested a lot of time making it work for my specific needs. I am hesitant to switch unless there's a clear, significant improvement. The membership offer at $3.99/mo seems quite affordable, but I'd need to see how it specifically addresses my VAT and payout reconciliation challenges. I'm not sure if these templates can do that.
    View answer & full research →
Keep exploring

What would you ask next?

Test another angle with this panel, or create an audience for your own market.