QuickBooks Online Bank Reconciliation: A Contractor’s Monthly Checklist

A contractor at her desk working through a bank statement and reconciliation checklist while a laptop shows a bank reconciliation screen, with the company service van visible through the window

If you run a construction, HVAC, plumbing, electrical, landscaping, or other trades business, your bank activity can change quickly. Customer deposits arrive. Materials are purchased. Payroll is processed. Subcontractors are paid. Credit card charges build up between jobs.

When those transactions are not reviewed consistently, your QuickBooks Online file can become difficult to trust. You may see a bank balance that does not match your books, expenses that are not assigned to the right job, or duplicate transactions that make your reports unreliable.

That uncertainty creates stress.

A monthly QuickBooks Online bank reconciliation gives you a dependable way to compare your records with your actual bank and credit card statements. The goal is not simply to make a number reach zero. The goal is to create accurate, organized records you can use to make decisions with confidence.

Bank Feeds Are Not the Same as Reconciliation

QuickBooks Online bank feeds save time by downloading transactions from your financial institution. They are helpful, but they do not complete the bookkeeping process for you.

A downloaded transaction may still need to be:

  • Matched to an existing invoice, bill, or payment
  • Added to the correct account
  • Assigned to a customer or project
  • Reviewed for duplicate entries
  • Coded as a business or personal transaction
  • Connected to payroll, subcontractor, or credit card activity

Bank feeds show what the bank is sending to QuickBooks Online. Reconciliation compares your completed records to the official statement from the bank or credit card company.

Both steps matter.

A clean bank feed supports efficient bookkeeping. A completed reconciliation gives you confidence that the records agree with the statement for a specific period.

Your Contractor-Focused Monthly Reconciliation Checklist

1. Gather Your Statements and Supporting Records

Start with the documents for the month you are closing. Gather:

  • Business checking and savings statements
  • Business credit card statements
  • Payroll reports
  • Contractor or subcontractor payment records
  • Loan or equipment payment details
  • Deposit records
  • Notes about unusual or large transactions

If your accounts close on different dates, reconcile each account according to its own statement period. Do not assume every account ends on the last day of the month.

A simple document routine makes the monthly close easier. Upload statements and supporting records to a shared folder so your bookkeeper can work remotely without waiting for paper documents or last-minute emails.

2. Update QuickBooks Online Bank Feeds

Open the bank transactions area in QuickBooks Online and review each connected account.

For every item, decide whether to:

  • Match it to a transaction already recorded
  • Add it as a new transaction
  • Exclude it because it is a duplicate, personal item, or transaction that should not enter the books

Do not automatically add everything.

For example, a customer payment may already be recorded against an invoice. Matching the downloaded transaction prevents you from recording the deposit a second time. Similarly, a check that was entered manually may later appear in the bank feed. Adding both entries creates a duplicate.

Take time to review the “For Review” area. It is one of the most important places to catch errors before they affect your reconciliation.

Bookkeeping professional and contractor reviewing reports together

3. Look for Missing and Duplicate Transactions

Missing transactions are common when bank feeds disconnect, payments clear later than expected, or a transaction is accidentally excluded.

Compare the statement to your QuickBooks Online register. Look for:

  • Checks listed on the statement but missing in QuickBooks
  • Bank fees or interest
  • Customer deposits
  • Payroll withdrawals
  • Subcontractor payments
  • Credit card charges
  • Loan payments
  • Transfers between accounts

Then look for duplicates. A duplicate may appear when you manually enter a transaction and later add the same item from the bank feed.

Common warning signs include:

  • Two transactions with the same date and amount
  • A manual check and a downloaded check for the same payment
  • A credit card payment recorded as both an expense and a transfer
  • A customer deposit entered manually and then added again from the bank feed

Correct the issue before completing the reconciliation. If the duplicate or missing transaction belongs to a previously reconciled period, proceed carefully. Changes to completed periods can affect earlier financial reports.

Assign Transactions to the Right Job

For contractors, reconciliation is only one part of creating useful books. You also need to connect income and costs to the work they belong to.

Before completing your monthly review, ask whether the transaction should be assigned to a specific customer, project, class, or job.

Pay particular attention to:

  • Materials purchased for a specific project
  • Equipment rentals
  • Permits and job-related fees
  • Employee labor
  • Subcontractor bills and payments
  • Customer deposits
  • Progress payments
  • Change-order income
  • Job-related fuel or travel

A payment can be correctly recorded in the bank account and still be incomplete from a job-costing perspective.

If a $4,000 materials purchase is coded only to a general materials expense account, your overall profit and loss statement may be accurate. But you may not know which job used the materials or whether that project is still profitable.

Our job costing and project revenue service helps contractors connect revenue and costs so job performance is easier to understand.

4. Reconcile Each Bank Account

Once the bank feed is reviewed and missing or duplicate transactions are addressed, open the reconciliation screen in QuickBooks Online.

For each account:

  1. Confirm the last statement ending date.
  2. Enter the statement ending date.
  3. Enter the ending balance exactly as shown on the statement.
  4. Compare the listed transactions with the statement.
  5. Mark each transaction that cleared during the statement period.
  6. Review the difference as you work.
  7. Continue until the difference is $0.00.
  8. Finish and save the reconciliation.

The beginning balance deserves special attention. If it does not agree with the previous statement or completed reconciliation, do not simply force the account to balance. Review earlier transactions and reconciliation changes to find the source of the problem.

A zero difference is important. But accuracy matters more than speed.

5. Reconcile Business Credit Cards Separately

Credit cards need their own monthly review. The process is similar to a bank reconciliation, but the transaction flow is different.

Review:

  • Purchases
  • Credits and refunds
  • Finance charges
  • Payments
  • Business and personal activity
  • Job-related purchases
  • Card fees

When you pay a credit card from your business bank account, the payment should be reflected in both places:

  • As a payment or credit on the credit card account
  • As a withdrawal from the bank account

That payment should generally be recorded as a transfer rather than a new expense. Otherwise, the same purchase may be counted twice.

Credit card reconciliations can also reveal purchases that were never assigned to a job. Review large materials, equipment, fuel, and supply purchases before closing the month.

Contractor and bookkeeping professional reviewing project costs and financial paperwork

6. Review Payroll Transactions

Payroll should be checked against payroll reports and bank activity each month.

Confirm that:

  • Net payroll withdrawals agree with the payroll records
  • Payroll tax payments are recorded correctly
  • Payroll-related fees are included
  • Employee reimbursements are not confused with wages
  • Payroll clearing accounts do not carry unexplained balances
  • Labor costs are assigned to the right period or project when appropriate

Payroll entries can be confusing because one payroll run may include employee wages, employer taxes, deductions, and fees. The bank may show one withdrawal while the accounting records contain several related entries.

If payroll is not reviewed monthly, small differences can accumulate and become difficult to resolve later.

Our payroll and subcontractor bookkeeping support helps keep employee payments, vendor records, and 1099-related information organized throughout the year.

7. Review Subcontractor Payments

Subcontractor activity deserves a separate check because payments may be made by bank transfer, check, credit card, or bill payment.

Confirm that each subcontractor payment has:

  • The correct vendor name
  • The correct payment date
  • The correct amount
  • The correct expense or cost category
  • The appropriate project assignment
  • Supporting documentation when needed

Also review whether vendor information is complete. Keeping subcontractor records organized during the year makes year-end 1099 preparation less stressful.

You do not want to wait until January to discover that several payments were recorded under inconsistent vendor names or that important details are missing.

What to Do When the Difference Is Not Zero

A reconciliation difference does not always mean the books are seriously wrong. It does mean something needs attention.

Work through this order:

  1. Confirm the statement ending date.
  2. Confirm the statement ending balance.
  3. Check that the beginning balance is correct.
  4. Look for missing transactions.
  5. Look for duplicate transactions.
  6. Review transfers between accounts.
  7. Check for transactions entered with the wrong amount.
  8. Review transactions dated outside the statement period.
  9. Look for previously reconciled transactions that were edited or deleted.

Avoid creating a random adjustment just to make the difference disappear. An unexplained adjustment may hide the real problem and make future reporting less reliable.

If earlier reconciliations were changed, a cleanup or catch-up review may be the better starting point. Our cleanup and catch-up bookkeeping service can help identify what needs to be corrected before establishing a consistent monthly rhythm.

A Simple Monthly Close for Better Decisions

After completing the reconciliation, review a few reports while the information is current:

  • Profit and loss statement
  • Balance sheet
  • Accounts receivable
  • Accounts payable
  • Job profitability or project cost reports
  • Unpaid payroll or contractor obligations
  • Available cash compared with upcoming commitments

This is where reconciliation becomes more than a bookkeeping task.

You can see whether cash is available for the next payroll run. You can identify a job with rising material costs. You can notice unpaid customer invoices before they create pressure. You can plan with current information instead of relying on an old spreadsheet or an estimated bank balance.

Bring Clarity Back to Your Monthly Books

QuickBooks Online works best when it is maintained consistently. Bank feeds, job-cost assignments, credit card reviews, payroll records, and subcontractor payments all need to fit into one organized process.

You do not have to manage every detail alone.

Thank Heavens Bookkeeping’s monthly bookkeeping service is built around a steady remote-friendly workflow for contractors and trades businesses. We keep QuickBooks current, reconcile accounts, review job-related activity, and provide clear records you can use.

The result is practical and personal:

  • More accurate records
  • Better visibility into cash and costs
  • Fewer duplicate or missing transactions
  • More confidence in job performance
  • Less time spent chasing spreadsheets

Clear books create better decisions.

Contractor reviewing organized financial reports with a bookkeeping professional

Ready for a More Reliable Monthly Rhythm?

If your QuickBooks Online reconciliation is behind, unclear, or taking too much of your time, there is a practical next step.

Request a quote from Thank Heavens Bookkeeping and tell us what your current monthly close looks like. We will help you identify the right starting point and create a bookkeeping process that brings more organization, visibility, and peace of mind to your business.

A steadier month starts with records you can trust.