QuickBooks Online Cleanup, Square Integration Repair & Reconciliation (Jan–Jul 2026)

Posted last week

Worldwide

Summary

I am looking for an experienced QuickBooks Online bookkeeper with specific Square POS / Square-to-QBO reconciliation experience to clean up and reconcile approximately seven months of bookkeeping. This is a fixed-price project, not hourly. Business Setup * QuickBooks Online Plus * Square POS / Square payments * Chase business checking accounts * Chase business credit cards * Approximately 429 Square payouts from January–July 2026 * Two business locations * Stripe was discontinued at the beginning of January 2026 as we transitioned payment processing to Square Important Square Workflow The underlying Square sales transactions have already been imported into QuickBooks. Square Support has confirmed that some Square payouts/deposits need to be manually matched to the corresponding bank transactions in QBO. An important detail about our settlement process: Square processing fees are NOT deducted from each individual bank deposit. Square generally deposits the sales/payout amount into our checking account, while processing fees are accumulated and withdrawn separately by ACH, generally around the middle of the following month. Therefore, differences between Square activity and bank deposits should not automatically be assumed to be processing fees. The actual payout, bank deposit and separate fee ACH withdrawals need to be traced and reconciled. Current Issues The primary issues include: * Square payouts/deposits requiring manual matching in QBO. * Square Deposit/Clearing account not clearing correctly. * Some bank deposits may previously have been categorized directly to Sales Income instead of matched to the corresponding Square transaction. * Separate Square processing-fee ACH withdrawals need to be properly identified and recorded. * Month-end timing differences exist between sales, payouts and bank deposits. * Historical transactions need to be reviewed carefully before being changed. Detailed reconciliation workpapers from a previous bookkeeper are available and can be used as a starting point. Project Scope 1. Review the existing Square/QBO workflow and account mappings. 2. Manually match Square payouts/deposits to the appropriate bank transactions in QuickBooks. 3. Review and correct previously categorized deposits where necessary to avoid duplicate income. 4. Trace and properly record the separate Square processing-fee ACH withdrawals. 5. Verify that Square sales, sales tax, tips, refunds/adjustments, payouts and processing fees are accounted for correctly. 6. Reconcile and explain the Square Deposit/Clearing account, including legitimate month-end timing differences. 7. Reconcile all applicable checking and credit-card accounts from January 1 through July 31, 2026. 8. Review the existing Square integration/configuration and recommend changes only if actually necessary. 9. Do not delete, void or materially modify historical transactions unless the reason is verified. Uncertain items should be flagged for review. 10. Complete the actual corrections, matching and reconciliations inside QuickBooks Online. I am not looking for another Excel-only reconciliation project. Records Available I can provide: * QuickBooks Online access * Square access * Bank statements * Square reports * Previous detailed reconciliation workpapers The bookkeeper should be able to use these records to independently trace normal reconciliation issues. Only genuine exceptions requiring information not already available should need my input. Expected Deliverables * QuickBooks reconciled through July 31, 2026. * Approximately 429 Square payouts properly accounted for/matched. * Square processing-fee withdrawals properly recorded. * Square Deposit/Clearing account reconciled and explained. * Bank and credit-card accounts reconciled. * Incorrect or duplicate accounting entries corrected where verified. * No duplicate sales income created from Square deposits. * Brief exception list for anything genuinely unresolved. * Brief final summary of corrections made and recommended ongoing Square/QBO workflow. Project Structure I would like January completed first as the initial checkpoint. Once January is properly corrected and reconciled inside QBO and the Square workflow is confirmed, the same methodology can be applied to February through July. Please provide a fixed-price quote for the entire January–July project and your estimated completion time. When Applying Please answer: 1. What experience do you have specifically reconciling Square with QuickBooks Online? 2. Have you worked with Square clearing/deposit accounts and manual payout matching? 3. What is your fixed price for completing January–July? 4. What is your estimated completion time? 5. Briefly explain how you would approach the Square payout/clearing workflow described above. Please do not apply if your approach is primarily to export everything to Excel for analysis without completing the actual bookkeeping corrections and reconciliations inside QuickBooks.

  • Less than 30 hrs/week
    Hourly
  • < 1 month
    Duration
  • Expert
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Intuit QuickBooks
Bank Reconciliation
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:last week
  • Hires:
    1
  • Interviewing:
    4
  • Invites sent:
    6
  • Unanswered invites:
    1
About the client
Member since Aug 5, 2016
  • United States
    Orange8:30 PM
  • $7.7K total spent
    34 hires, 3 active
  • 35 hours
  • Retail & Consumer Goods
    Small company (2-9 people)

Explore similar jobs on Upwork

Accounting
Bookkeeping
Financial Accounting
Zoho Books
Accounting
Bookkeeping
Data Entry

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