About

Project Overview We need an experienced QuickBooks Online (QBO) pro to fully reconcile all 2024 accounts and produce lender- and tax-ready reconciliation reports. This is time-sensitive: work must be completed within 14 hours of contract start. We will hire quickly. We estimate 6-8 hours for reconciliation. The revenue for the year was only $54K with about 5 payments per month and 30-40 expenditures per month. Our goals: Get 2024 books tax-ready (we’re on an extension). Provide a clean, defensible package for a USDA loan application (reconciled accounts + clean financials). What you’ll reconcile (2024 period: 01/01/2024–12/31/2024) Primary Business Checking (and any connected savings, if applicable) PayPal (and/or other payment processors connected to QBO, if applicable) We will provide 2024 bank and PayPal statements as PDFs and Accountant-level access to QBO. Context you should know (why this matters) Prior bookkeeping introduced issues (possible duplicate PayPal postings, failed ACHs marked as paid, owner funds misclassified as income). Balance sheet shows A/R from 2021–2023 still open; we will handle write-offs after reconciliation. There’s an Opening Balance Equity balance from prior setup and a “Due from Owner” line misclassified to liabilities — those are out of scope for this job unless you note specific fixes we should make next. Scope of Work (this job = Reconciliation only) Complete reconciliation of all 2024 months for each bank/PayPal account in QBO. Match/clear transactions to statements; properly link invoice payments to deposits. Identify & fix common issues encountered during reconciliation: Duplicate income (e.g., PayPal app Sales Receipt and bank Deposit both booked to income). “Cash on hand”/Undeposited Funds misroutes. Owner contributions/transfers accidentally posted to income. Payments marked received with no clearing deposit (ACH failures). Do not post journal entries to force reconciliation unless clearly documented and approved. Prefer source-transaction fixes (match, reclassify, delete duplicates). Do not write off Accounts Receivable, alter opening balances, or clear “Opening Balance Equity” in this phase. If you see specific corrections needed, list them for our next phase. Deliverables (required for payment release) Reconciliation Reports (PDF) for each 2024 account, each month, showing $0 difference. Bank Register(s) and PayPal ledger for 2024 (export or screenshots sufficient) showing reconciled status. Deposit Detail (2024) and Transaction Detail by Account – Income (2024) reports (Excel or PDF). A one-page summary of issues you found and how you resolved them, plus a short “Next Actions” list for: A/R cleanup by customer/invoice (write-offs to be done next phase) Misclassified “Due from Owner” (reclass recommendation) Any remaining app/rule fixes to prevent future duplicates Success Criteria All 2024 accounts fully reconciled in QBO with $0 differences. Cash-basis income for 2024 closely aligns to actual deposits after removing owner funds/transfers. Clear, reproducible audit trail (no unexplained journal entries to income or A/R). Deliverables received within 14 hours of contract start. Access We’ll Provide QBO Accountant user invite (with 2FA coordination if needed). PDF statements (2024) for bank and PayPal. Any processor exports (CSV/PDF) if helpful. A short owner note identifying known cancelled contracts and failed ACHs to speed up linking. Fixed Price & Timing Fixed price: $225 for the entire 2024 reconciliation scope above. Deadline: complete within 14 hours of contract start. Must-Have Qualifications Proven QBO reconciliation expertise (50+ months reconciled or multiple full-year projects). Comfortable with PayPal/QBO integrations and duplicate-entry remediation. Strong understanding of matching invoice payments to bank deposits and clearing Undeposited Funds. Ability to document fixes and leave a clean audit trail (no “mystery” JEs). Nice-to-Haves QBO Advanced/Elite ProAdvisor certification. Lender/underwriter-ready reporting experience. Forensic cleanup experience (e-comm or service businesses with processors). How to Apply (please answer all) Confirm you can start immediately and finish within 14 hours of hire. Share two recent QBO reconciliation examples (describe the accounts, integrations, and challenges). Describe your approach to PayPal duplicates and ACH failures in QBO (1–2 paragraphs). Confirm you agree to the fixed price $225 for the scope above and that write-offs/OBE reclass are out of scope (you’ll list recommendations, not perform them). Confirm you can provide the deliverables listed (recon reports, Deposit Detail, TDBA – Income, summary memo). Notes We’ll post a separate follow-on job for: A/R write-offs (credit memos), “Due from Owner” reclass, and clearing Opening Balance Equity — likely awarded to the same freelancer if reconciliation is executed cleanly.