QuickBooks Bookkeeper — Setup, Transaction Categorization & CPA Reporting

Posted 12 hours ago

Worldwide

Summary

QuickBooks Bookkeeper — Setup, Transaction Categorization & CPA Reporting Immediate Start | Fixed-Fee Project | Potential Ongoing Work I am looking for an experienced QuickBooks Online bookkeeper to set up QuickBooks, organize my business transactions, and prepare a CPA-ready expense package. I would like to start immediately and ideally complete the initial project within 5–7 days. Background I own BDMAC Consulting. Over the past several years, my activities have included general/technology consulting, business development, extensive networking, horse racing-related business opportunities, and significant research/ideation across multiple potential businesses. I have now decided to move forward initially with acquiring/opening a Minuteman Press commercial printing franchise and want clean accounting in place going forward. Milestone 1 — Current Project I do not currently use QuickBooks. I want the selected bookkeeper to recommend the appropriate QuickBooks Online plan, help establish the account, and create an appropriate Chart of Accounts. I Will Provide Prior-year filed tax return Prior-year Excel expense summary submitted to my CPA Original detailed prior-year transaction file (approximately 1,800 transactions) List of applicable bank accounts and credit cards Access to current-year bank/card information Assistance establishing secure read-only access where available Answers to legitimate transaction questions The prior-year information is a reference/template. I do not want the prior year reconstructed or audited. I want the appropriate historical information entered into QuickBooks efficiently and the prior classifications used as a reference for the current year. What I Need The selected bookkeeper will: Recommend and help set up QuickBooks Online Establish the Chart of Accounts Efficiently enter/import relevant prior-year historical information Collect and organize bank/card statements where secure access permits Import current-year bank and credit-card transactions Review and categorize transactions Use prior-year classifications as a reference while improving classifications where appropriate Create rules for recurring transactions Identify transfers, payments and duplicates Reconcile applicable bank and credit-card accounts Produce a high-level Excel expense summary by category for my CPA Provide transaction-level detail supporting those totals Produce P&L, Balance Sheet and General Ledger Transaction Categorization I am hiring a bookkeeper specifically because I do not want to manually categorize hundreds or thousands of transactions myself. My activity has involved consulting, networking, business development, meetings, travel, research and evaluation/development of new business opportunities. Merchant name alone may therefore not always provide enough context. Please perform the initial categorization yourself using the prior-year records and your bookkeeping judgment. If genuinely unsure, send exceptions to me in batches with your proposed classification, and I will provide the business context. My CPA will make final tax-treatment decisions. Deliverables At completion I expect: Properly established QuickBooks Online Appropriate historical information entered Current-year transactions categorized and applicable accounts reconciled Clean/consistent expense categories CPA-ready Excel summary of expenses by high-level category Detailed transaction backup supporting those totals P&L, Balance Sheet and General Ledger Small exception/CPA-review list QuickBooks, the transaction detail and the CPA summary should reconcile. Communication I want this to be relatively hands-off for me. Handle routine transactions independently and consolidate genuine questions. Please provide brief progress updates at approximately 25%, 50%, 75% and completion. Fixed-Fee Proposal Milestone 1 will be awarded on a fixed-fee basis. I am intentionally not providing a target budget or expected hours. Please provide: Your total fixed fee for Milestone 1 Your estimated total hours to complete Milestone 1 QuickBooks Online experience/certifications Experience with similar transaction cleanup/reconciliation projects Earliest date you can start Expected completion date Confirmation that your fixed fee covers all Milestone 1 deliverables What you will need from me to begin Any assumptions or exclusions included in your bid Immediate availability is strongly preferred. I would ideally like Milestone 1 completed within 5–7 days. Future Work Milestone 2: Set up accounting for my Minuteman Press acquisition, including acquisition costs, equipment/assets, financing, revenue/COGS, payroll, A/R, A/P, franchise fees and management reporting. Milestone 3: Potential ongoing monthly bookkeeping. I am looking for someone who can ultimately own the bookkeeping function with limited administrative involvement from me.

  • Less than 30 hrs/week
    Hourly
  • 1-3 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
Mandatory skills
Intuit QuickBooks
Bookkeeping
Activity on this job
  • Proposals:20 to 50
  • Interviewing:
    1
  • Invites sent:
    7
  • Unanswered invites:
    5
About the client
Member since Oct 22, 2021
  • United States
    Palatine1:14 PM
  • $198 total spent
    1 hire, 0 active
  • 6 hours

Explore similar jobs on Upwork

Accounting
Bookkeeping
Financial Accounting
Bookkeeping
Administrative Support
Microsoft Excel
Intuit QuickBooks
Accounting Software

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