How to Reconcile Q2 Books for Mid-Year Performance Reviews

Key Takeaways

• Match every bank statement line to a categorised transaction to identify $0.00 discrepancies before the June 30 mid-year cutoff.
• Verify that your estimated tax payments for Q2 align with your actual net income to avoid the IRS underpayment penalty.
• Separate non-deductible personal draws from business expenses to clear up your Profit and Loss (P&L) statement.
• Calculate your debt-to-income ratio using current liabilities to ensure you stay within SBA loan covenant requirements.

This guide helps solo operators and small team owners move from 'guessing the balance' to having a clean, audit-ready set of books by June 30. By the end of this process, you will have a validated Profit and Loss statement and a Balance Sheet that reflects your actual cash position for the mid-year review.

What you'll need

• Access to your business bank and credit card portals for April, May, and June statements.
• A copy of your Q1 Reconciliation Report to check for carryover errors.
• Logins for peripheral payment processors like Stripe, Square, or PayPal.
• Physical or digital receipts for any large asset purchases over $2,500 (the de minimis safe harbor threshold).
• Your current payroll summary reports if you have employees or take a reasonable salary as an S-Corp.

Step-by-step

Step 1: Clear the Uncategorised Transaction Queue

Start by aggressive data entry. Most owners of 4-person print shops or HVAC outfits let the 'Uncategorised' or 'Ask Accountant' folder swell to dozens of items by June. Open your accounting software—whether it's QuickBooks, Xero, or a manual ledger—and assign a home to every mystery outgoing. If you spent $42 at a gas station, decide now if it was fuel for the van (an expense) or a soda and a snack (a personal draw).

Check for 'Owner's Draws' that shouldn't be there. If you used the business card for a personal dinner, code it as an Owner's Draw or Equity Distribution immediately. This prevents your business expenses from being artificially inflated, which would give you a false sense of how much it actually costs to keep the lights on. Many owners fail their mid-year review because they think their margins are slimmer than they actually are, simply due to sloppy personal spending hidden in the 'Supplies' category.

Step 2: Perform the Formal Bank Reconciliation

This is the mechanical part of the job. You aren't just looking at the balance; you are proving the balance. Compare your bank statement's closing balance for June 30 against your software's ledger balance. They should be identical down to the penny. If they aren't, you likely have a duplicate transaction or a missed entry. Common culprits include merchant fees that were deducted before the deposit hit your account.

If you use Square or Shopify, remember that the 'Gross' sale is your revenue, while the processing fee is an expense. Don't just book the 'Net' amount that hits your bank. If you do, your revenue numbers will be understated by 2.9% to 3.5%, making it harder to qualify for future financing. You can find more on managing these nuances in our guide on saving on batch fees.

Step 3: Validate Your Accounts Payable and Receivable

Look at your Accounts Receivable (A/R) aging report. If you see an unpaid invoice from April, it is time to make a decision. Is that customer ever going to pay? If a 12-person HVAC shop in Ohio is still waiting on a $1,200 check from two months ago, that 'asset' on the balance sheet is lying to them. Decide if you need to send it to collections or write it off to get a realistic view of your liquidity.

On the flip side, check your Accounts Payable (A/P). If you have bills sitting in the drawer that haven't been entered, your June 30 performance review will look better than reality. Enter every bill you owe, even if you don't plan to pay it until July. Accurate forecasting depends on knowing who has a claim on your cash. Refer to the Day One Checklist for a refresher on setting up these basic tracking habits.

Step 4: Compare Q2 Actuals to Your Budget

Now that the data is clean, run the Profit and Loss (P&L) report for April 1 through June 30. Compare these numbers to what you projected at the start of the year. If your 'Materials' cost is 20% higher than your Q1 average, you have a leak. Maybe a vendor hiked prices without telling you, or maybe your crew is wasting more product than usual.

This is the 'Review' portion of the performance review. If you identify a 5% drop in net margin now, you have six months to adjust your pricing before the end of the year. If you wait until tax season in April, the money is already gone. For specific help on margins, see our breakdown on painting contractor labor benchmarks.

Step 5: Check Estimated Tax Compliance

Total your net profit for the first half of the year. In the U.S., small business owners generally pay taxes as they go. The Q2 estimated tax deadline was June 17, but as you close your books on June 30, you need to ensure your payment was sufficient. If your Q2 profit was significantly higher than Q1, you might need to increase your Q3 payment to avoid the underpayment penalty.

Visit the IRS Interactive Tax Assistant to check your status or review IRS Publication 505 for rules on withholding and estimated tax. It is better to know you have a $4,000 tax 'debt' now than to be surprised next year when the cash has already been reinvested in equipment. If you missed the mark, review our guide for the catch-up process.

Common mistakes to avoid

• Ignoring the 'Check Numbers' sequence: If your checkbook skips from #105 to #108 in your ledger, you have missing data. Even if a check was voided, it must be recorded as such to keep the audit trail clean according to SBA record-keeping suggestions.
• Misclassifying Loan Payments: When you pay back an SBA loan, only the interest is an expense. The principal portion reduces your liability on the balance sheet but doesn't lower your taxable profit. If you book the whole $1,500 payment as an 'expense,' you are underreporting your income.
• Forgetting Depreciation: Many owners forget to account for the wear and tear on large equipment. While you might not do a full depreciation run until year-end, failing to acknowledge that your $50,000 van is losing value monthly can lead to an inflated sense of business net worth.
• Mixing Sales Tax with Revenue: If you collected $1,000 in sales tax for the state of Florida, that is not your money. It shouldn't show up as 'Income' on your P&L. It is a liability. Keeping it in the income column makes your business look more profitable than it is.

When to call a pro

While you can handle the monthly reconciliation, you should bring in a CPA or a qualified bookkeeper if you notice your 'Unreconciled Difference' remains above $100 after two hours of searching. Precision matters.

You should also consult a tax professional if you are considering making a large equipment purchase before June 30 to take advantage of Section 179 expensing. A pro can tell you if that deduction actually helps your specific tax bracket this year or if you should wait. Similarly, if you're transitioning from a sole proprietorship to an S-Corp mid-year, the legal and tax implications require professional oversight.

Closing your Q2 books is the only way to ensure the second half of your year is based on math rather than hope. Take the four hours on June 30 to get it right.

---

📋 Disclaimer

This article is for informational purposes only and does not constitute legal, tax, financial, or professional advice. Laws and regulations change frequently, and the information presented may not reflect the most current legal developments. Always consult with a qualified professional (CPA, attorney, financial advisor) before making business decisions based on this content. MyBizNerd may receive compensation through affiliate links, but this never influences our recommendations.

---