QuickBooks Bookkeeper — Setup, Transaction Categorization & CPA Reporting
Worldwide
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/weekHourly
- 1-3 monthsDuration
- IntermediateExperience Level
- Remote Job
- Ongoing projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Interviewing:1
- Invites sent:7
- Unanswered invites:5
About the client
- United StatesPalatine1:14 PM
- $198 total spent1 hire, 0 active
- 6 hours
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers 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