Quickbooks Pro Advisor

Posted yesterday

Worldwide

Summary

We need QuickBooks Online set up to track two brands separately and caught up for about 18 months. About the business • Company: Epic Entertainment Inc, a California C-corp. • Brand 1, Epic Entertainment: audio/video, lighting, and event production for weddings and special events, plus DJ, trivia/bingo hosting, and photo booths. • Brand 2, Butlerz Rents: a DBA of Epic Entertainment Inc. Rents tables, chairs, linens, flatware, glassware, dance floors, and string lighting for weddings and events. • Banks: UMB Bank (separate accounts for each brand) and Wells Fargo. • Card payments: Stripe. • Goal: reports for each brand alone and combined, with shared expenses split by percentage. 1. Setup [ ] Check our QuickBooks plan and upgrade to Plus if needed, since class tracking requires it. [ ] Turn on class tracking with two classes, Epic Entertainment and Butlerz Rents, assigned per line. [ ] Turn on the warning for transactions with no class assigned. [ ] Clean up the chart of accounts for an event production and rental business: separate income accounts for each service line and rental category, and note which accounts belong to which brand. 2. Bank and payment connections [ ] Connect every account: UMB (separate accounts for each brand), Wells Fargo, and any business credit cards. [ ] Set up Stripe so payouts record as gross sales minus fees and refunds, not one lump deposit. Recommend the best connector app for this. [ ] Set up how cash, check, Venmo, or Zelle payments get recorded, if we take them. 3. Rules and splits [ ] Build bank rules for recurring vendors, including our standard percentage splits between brands. [ ] Set rules to suggest, not auto-add, so I review everything. [ ] Split loan payments into principal and interest. [ ] Split payroll entries into wages and taxes, and by brand. [ ] Handle transfers between our own accounts and credit card payments so they don't show as income or expenses. 4. Catch-up (about 18 months) [ ] Set opening balances as of the catch-up start date, coordinated with our CPA. [ ] Categorize and assign a class to every transaction since then. [ ] Reconcile every month against bank and credit card statements. [ ] Close and lock reconciled months. 5. Tax and compliance questions Please review these with us and our CPA: [ ] Should Butlerz collect and remit California sales tax on rentals? [ ] Cash or accrual basis for a C-corp our size? [ ] How should wedding deposits taken months in advance be handled? [ ] How should personal expenses paid from business accounts be recorded? [ ] Which purchases should be depreciated vs. expensed, and at what dollar threshold? 6. Reports and training [ ] Saved reports: P&L by class, P&L for each brand alone, balance sheet, cash flow, and expenses by vendor. [ ] A monthly P&L by class emailed to me automatically. [ ] A 30–60 minute training on my daily routine: reviewing the bank feed, approving suggestions, and adjusting a split. [ ] A short written cheat sheet of that routine. Before hiring Please quote two options: (1) setup and catch-up only, and (2) setup and catch-up plus ongoing monthly bookkeeping. • Are you a certified QuickBooks Online ProAdvisor? Have you worked with event or rental businesses? • Is the catch-up a flat fee or hourly? What's your estimate for 18 months? • What does ongoing monthly bookkeeping cost, and what does it include?

  • Hours to be determined
    Hourly
  • 6+ months
    Duration
  • Intermediate
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type

Contract-to-hire opportunity

This lets talent know that this job could become full time.
Learn more
Skills and Expertise
Intuit QuickBooks
Bookkeeping
Activity on this job
  • Proposals:50+
  • Last viewed by client:yesterday
  • Interviewing:
    1
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Mar 8, 2018
  • United States
    Arroyo Grande12:05 AM
  • $88K total spent
    27 hires, 1 active
  • 3,445 hours
  • Large company (100-1,000 people)

Explore similar jobs on Upwork

Bookkeeping Deliverables
Bookkeeping Skills
Bookkeeping
QuickBooks Online
Accounting Deliverables
Accounting
CPA
Bookkeeping

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo