QuickBooks Online Cleanup, Square Integration Repair & Reconciliation (Jan–Jul 2026)
Worldwide
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/weekHourly
- < 1 monthDuration
- ExpertExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
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
- United StatesOrange8:30 PM
- $7.7K total spent34 hires, 3 active
- 35 hours
- Retail & Consumer GoodsSmall company (2-9 people)
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