Free tools Windows power users keep installed
One-click scans. No signup required.
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
To reconcile a bank account in QuickBooks Online, compare the transactions in the account register with one specific bank statement until the difference is zero. Prepare the statement, open Accounting > Reconcile, select the correct account, enter the statement ending date and ending balance, and mark only transactions that appear on that statement. If the beginning balance is wrong, investigate the opening balance or a change to an earlier reconciliation before creating any adjustment.
Intuit’s screen labels and workflows can change by region, user role, product rollout, or edition. Use the labels shown in your account while following this process.
What reconciliation does—and what it does not do
Reconciliation is a statement-based check. You choose a bank account and a defined statement period, then compare QuickBooks transactions with the bank’s statement. The beginning balance, statement ending date, statement ending balance, and selected transactions all have to describe the same account and period. Matching individual deposits, withdrawals, fees, transfers, and other activity is meaningful only after those control figures are correct.
Recommended Free Tools
The target is a zero difference. When the difference is zero and the statement details agree, the QuickBooks ending balance and the account statement should be the same. Intuit describes the control this way: “After you reconcile an account, your QuickBooks ending balance and account statement should be the same.” A zero difference is not proof that every transaction is economically correct; it means the selected QuickBooks activity mathematically agrees with the statement you entered.
#1 Best Overall
- Powerful Turbo Fan:CAGIWIRU Electric Air Duster have reached speed up to 130000RPM,Can efficient remove dust and debris.With LED light and Three Adjustable Speed to meet with different cleaning tasks.
- With Attached USB C Fasting Charging cable.Charing 3 hours,Enjoy up to 240 minutes of use on the lowest setting, For third speed can use for 25mins.with four charging options to meet with your needs.
- Wide Application: attached 5 different nozzles,making it suitable for a variety of scenes, such as car,pet, pc, keyboards, and other electronic devices. It also serves for office and home clean duster.
- Handy Design & Portable:Cordless air duster electric nozzle is Light weight and small size, design and comfortable to hold and space saving, convenient to carry around. You can put it in your room or inside the car without taking up space.
- Economical &Reusable: Built durable materials with a long-lasting battery,our CAGIWIRU air duster it's a sustainable alternative to disposable air cans.
Before you start: assemble the right records
Get the complete bank statement
Use the statement for the exact account and period you are reconciling. Have its beginning balance, ending date, ending balance, and transaction pages available. A downloaded PDF or online statement is fine as a reference; the important point is that the statement is final for that period, not an interim balance from the bank’s website.
Confirm the account
If your company has several accounts at the same bank, verify the account name and last four digits before entering figures. Reconciling a checking account against a savings statement can produce a plausible-looking but useless result.
Review downloaded bank-feed activity
For a connected account, review transactions downloaded through the bank feed. Match them to existing entries, categorize and post them where appropriate, and exclude items that should not enter the books. Do not mark a bank-feed item as reconciled merely because it downloaded; it must belong to the statement period and agree with the statement.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →Decide whether this is a first reconciliation
The starting-balance investigation differs depending on whether the account has ever been reconciled. For a first reconciliation, the common problem is an incorrect opening balance. For a previously reconciled account, the current beginning balance should equal the ending balance from the last completed reconciliation.
How do I reconcile a bank account in QuickBooks Online?
- Open the reconciliation screen. In QuickBooks Online, go to Accounting > Reconcile.
- Choose the account. Select the bank or credit-card account that appears on the statement. If several accounts are listed, check the account identity before continuing.
- Check the beginning balance. Compare the beginning balance shown by QuickBooks with the appropriate prior balance. For a new account, use the bank statement from the day before you began tracking the account. For an established account, compare it with the prior reconciliation’s ending balance.
- Enter statement details. Enter the statement’s ending date and ending balance exactly as printed. Do not substitute today’s online balance or a balance from a different statement cycle.
- Compare each transaction. Work through deposits, payments, transfers, fees, interest, and other entries. Mark a QuickBooks transaction only when the amount, date, and payee or description correspond to an item on the statement. Look for transactions on the statement that are missing from QuickBooks and for QuickBooks entries that are duplicated or have not cleared.
- Investigate the difference. The difference should move toward zero as valid statement items are selected. If it does not, stop and diagnose the cause instead of forcing the remaining amount with an unsupported adjustment.
- Finish and retain the report. When the difference is zero and the statement date and ending balance have been rechecked, complete the reconciliation. Keep the resulting reconciliation report with your accounting records.
Intuit’s reconciliation workflow includes AI Powered Reconciliation only in QuickBooks Online Plus, QuickBooks Online Advanced, and Intuit Enterprise Suite according to the cited workflow guidance. Availability and plan names can change, so rely on the feature list displayed in your account rather than assuming it is included in another edition.
Rank #2
- Screen Cleaner is Your Screen’s New Bestfriend! - EVEO is proud to present a screen cleaner that’s perfectly suited for your TV. Meet your new screen cleaner, computer screen cleaner, laptop cleaner, iPad cleaner, Macbook,tv cleaner or any other electronic device. Our screen cleaner spray and wipe along with the included plush microfiber cloth, easily removes dust, fingerprints & other smudges on the screen’s surface. Clean effectively for a streak-free screen
- Gentle on your Screens - Our screen cleaner spray and wipes is compatible to be used even for the most sensitive LCD, LED, CRT, and OLED screens in proper use. Be at ease knowing that this product is compatible with all the major brands: LG, SONY, Samsung, Sharp, iPad, iPhone, Android screens, Kindle, PC monitors - we’ve got you covered! Can be used as LCD screen cleaner, tv cleaner, smart tv screen cleaner, and more
- Premium Super Soft Plush Microfiber Cloth - Included in this efficient screen cleaning kit. This screen cleaner spray and wipe has our signature plush microfiber cloth specially designed to comply with screens and monitors and leave them streak-free. Has been shown to effectively absorbs stubborn stains, zero streaks, and no fiber shedding. Always use this together with our screen cleaner for the best results
- Easy-to-Use Screen Cleaner Kit + microfiber cleaning cloth - The EVEO Screen Cleaning Kit will easily be your new favorite tool when it comes to taking care of the things you love most, quick and easy solution for a streak-free screen. Simply screw on the sprayer gun on the screen cleaner bottle. Spray the cleaning liquid onto the microfiber cloth, then wipe the screen until desired cleanliness & shine is achieved.
- Quality Screen Care Kit Worth Purchasing - Enjoy a convenient Screen Cleaner anytime, anywhere you need it. Your satisfaction is our top priority. We stand behind the quality of our products and that’s why, you shouldn’t be worrying at all. We manufacture the Best Screen Cleaner. and can be used for laptop cleaning kit, laptop screen cleaner, tv screen cleaner for smart tv. MacBook screen cleaner, monitor cleaner or screen cleaner spray for electronic devices with microfiber cleaning cloth
Why is my beginning balance off?
First reconciliation: verify the opening balance
If this is the first time the account has been reconciled, compare the QuickBooks opening balance with the actual bank statement for the day before the account began being tracked. A wrong opening balance is a common first-reconciliation issue. Check whether the opening figure reflects the bank account’s real balance at that cutoff date and whether any transactions from before tracking began were entered again.
Do not correct an opening balance simply to make the current difference disappear. Trace the source of the figure to the bank statement and the records used when the account was created. If the business started with an outstanding check, deposit, loan transfer, or owner contribution, determine whether that item belongs in the opening balance or should appear as a dated transaction.
Previously reconciled account: compare the prior ending balance
For an account reconciled before, the current beginning balance should agree with the ending balance on the last reconciliation. Intuit states that you check the beginning balance each time you reconcile. If the figures differ, open the Reconcile Discrepancy Report and inspect the listed changes.
Each row in that report identifies what changed and the reported effect on the discrepancy. Open the transaction’s history and the report’s “What happened” details, then compare the change with the bank statement and your accounting records. Correct only a change that was actually made in error. A suggestion in the discrepancy report is evidence to investigate, not proof that the underlying transaction should be edited.
Changes that commonly alter a beginning balance
- An opening balance was entered incorrectly.
- A transaction that had already been reconciled was edited, deleted, voided, moved to another account, or changed from reconciled to another status.
- A bank-feed transaction that had been categorized and reconciled was returned to pending.
- A transaction dated before the previous reconciliation was reconciled manually after that reconciliation.
Deleted or voided activity may require the account’s Audit log. Manually reconciled entries can be reviewed in the account register. Check the original statement and supporting records before restoring, recreating, or changing anything.
Rank #3
- 【Large size】：Measuring 800 x 300 mm/ 31. 5×12 inches, which is wider and taller than others. Large mouse pad can perfectly fit your keyboard and mouse of any size, and there is also ample space for peripherals such as phones, tablets, etc.
- 【LED backlight mouse pad】：Blade Hawks RGB mouse pad provides 7 static modes and 7 dynamic modes will give you the options you are looking for. Power-off memory function remembers the last lighting mode you selected. The super glow fiber Chroma will give you a colorful gaming setup that you want.
- 【Anti-slip rubber base】：Made from Natural rubber, this gaming mousepad will firmly grip your desktop, allowing you to enjoy the ultimate precision in the games you are most passionate about. It also comes with a texture that enhances this ability even further.
- 【Smooth and waterproof surface】: Micro-textured cloth surface, for extremely precise mouse control and a smooth movement. When liquid splashes on the gaming mouse pad, it forms water droplets and slides down. Will not delay your work or gameplay.
- 【Plug and play】: This mouse and keyboard pad is powered by USB, plug and play, no driver required. One button control light modes. Press one time to change the lighting mode, press twice to change the brightness, press and hold about 3 seconds turn ON/OFF.
Why doesn’t QuickBooks match my bank statement?
A mismatch usually comes from one of four places: an incorrect control balance or date, an omitted statement item, a duplicate or wrong QuickBooks entry, or a change to a transaction from an earlier reconciliation. Diagnose in that order so that you do not alter historical transactions while looking for a simple data-entry error.
1. Recheck the statement controls
- Confirm that the selected QuickBooks account is the account named on the statement.
- Confirm that the statement ending date is the actual statement date, not the date you downloaded it.
- Re-enter the statement ending balance from the statement, including the sign and decimal places.
- Verify the beginning balance against the prior reconciliation or the day-before-tracking statement.
2. Search for missing statement activity
Compare the statement line by line with the register. Typical omissions include monthly service charges, interest, electronic transfers, cash withdrawals, deposits in transit, and checks that were entered under a slightly different date or amount. Enter a genuinely missing transaction using the correct date, payee, account, and amount, then return to reconciliation. A bank-feed download is not a substitute for the statement: a feed can be delayed, duplicated, or excluded.
3. Look for duplicates and wrong amounts
Two QuickBooks entries for one deposit or payment will make the difference wrong even when both entries are individually marked. Compare transaction numbers, dates, payees, and amounts. If a statement amount differs because of a fee or a split transaction, determine whether the bookkeeping entry represents the bank’s full posting rather than casually changing the amount on a reconciled item.
4. Check uncleared timing differences
A check issued near the statement date may remain outstanding, while a deposit made late in the period may appear on the next statement. Leave a valid timing difference uncleared; do not create a balancing entry just because the bank has not posted it yet. The next statement should contain the item if it is legitimate.
5. Investigate historical changes
If the current beginning balance is different from the prior ending balance, use the Reconcile Discrepancy Report, transaction history, Audit log, and account register to identify the change. Compare it with the actual statement and your internal records before deciding whether to restore the original transaction or record a correcting entry.
Rank #4
- 【Softer and More Comfortable】Vaydeer wrist rest has unique diamond pattern, which is the combination of softness and aesthetics. The materials of wrist rest are improved into higher quality memory foam and covered with silky smooth lycra. The computer wrist rest makes you as comfortable and cushiony as like rest your wrists on clouds.
- 【Ergonomic Wrist Saver】The wrist rests for keyboard and mouse comes with a 17.32×3.15×0.83 inch keyboard wrist pad and a 5.94×3.15×0.83 inch mouse wrist support. Based on ergonomic design, the unique concave shape is the perfect fit for your wrist joints. The wrist rest pad fits most computer keyboards and laptops, improve hand and wrist posture, release your wrist and arm stress.
- 【Non-Slip Rubber Bottom】Featuring an anti-skid silicone base on the bottom, this wrist keyboard support stays firmly in place on your desk, preventing the padding from sliding around, ensuring stable and consistent wrist support during extended computer sessions.
- 【Better Experience & Pain Relief】Our keyboard arm rest is beneficial to alleviate the soreness caused by direct contact and friction between your arm and a hard desk surface, reducing the risk of wrist fatigue or carpal tunnel. The soft texture of memory foam can evenly distribute the pressure around your wrists and provide good support with just enough give.
- 【Helpful in Multiple Scenarios】Whether you're working, studying, writing, typing, gaming, this keyboard and mouse rest combo is an essential accessory to add comfort and support to your hands and wrists. It’s also a great gift for men, women, family, friend, coworker, gamer, teacher, etc.
How to correct a discrepancy without damaging prior reconciliations
Choose the smallest correction that is supported by evidence. Changing an unrelated transaction to force a zero difference can make the current report appear complete while corrupting the books and every later reconciliation.
When a missing transaction is the cause
Enter the transaction with the date and amount shown by the bank, assign the correct category or transfer account, and then select it during reconciliation. If the transaction belongs to an earlier closed or reconciled period, ask an accountant how to record the correction without misstating that period.
When a duplicate is the cause
Identify which entry is the legitimate bookkeeping record and which is the duplicate. Check whether either entry has already been reconciled, posted to payroll or tax records, or used in another report. Remove or correct only the duplicate after confirming the bank statement and the audit trail.
When an earlier reconciled transaction changed
Use the discrepancy report to document the original status, the change, and its effect. If the edit, deletion, void, move, or unreconcile action was accidental, restore the transaction or make a documented correcting entry according to your accounting policy. If the change was intentional, preserve the explanation and supporting documentation; do not automatically reverse it.
Unreconcile one transaction versus undoing a full reconciliation
These are different operations with very different consequences.
Best Value
- 【No Drill Mounted】Cable management tray can be assembled in as little as 3 minutes or less-simply. Side clips easily clampe the edge of desk, pass through the holes on the sides, and secure excess cables with baskets. Desk cable management supports inward or outward installation to meet your needs in different scenarios, and provides you with great convenience when collecting and organizing wires.
- 【Rubber Pad Protects Desk】Wire organizer under desk built-in soft rubber pads on the clamp protect your desk from scratches, so you will not damage your furniture or office.
- 【Sturdy and Beautiful】Cord management under desk is made of high-quality carbon steel and holds about 15 lbs. The wire basket has 2 holes on each side of the tray to enable your cables to pass freely. Cable baskets are suitable for desk thickness use from 0.4" to 2.4".
- 【Space Saving & Keep Organized】Desk cable management tray holds all your power cords, outlet strips, USB hubs and computer transformers hidden from your feet, and the data cables will not enter the vacuum cleaner to keep your desk clean and tidy. Desk wire organizer is also suitable for use in the kitchen and outdoors.
- 【Reduce Safety Risks】Cable tray under desk keeps all plugs away from your kids, no more worry about tripping. Using 2 holes wire tray saves extra space, helps you easily cabling and wire protection. The mesh design is not easy to accumulate dust, but avoids safety accidents caused by messy wires.
| Decision point | Unreconcile one transaction | Undo a full reconciliation |
|---|---|---|
| Scope | Changes the register status of a specific transaction. | Undoes the selected reconciliation and any reconciliations completed after it. |
| Report effect | Does not delete the entire reconciliation report. | Deletes the reconciliation report and its attachments for the affected reconciliation. |
| Balance effect | Can change the beginning balance of the next reconciliation. | Resets the account’s beginning balance to the previous reconciliation’s ending balance and reverts affected transactions to cleared or uncleared. |
| Use when | You have verified that one item was reconciled by mistake. | A whole reconciliation is wrong and later reconciliations can be safely revisited. |
| Precaution | Verify the item is the actual cause before changing its status. | Download needed attachments first and consult an accountant when the period or correction is uncertain. |
How do I unreconcile a single transaction?
Use this path only after confirming that the transaction is the problem. Intuit’s instructions describe opening the account register and cycling the transaction’s reconciliation status from R (reconciled) to C (cleared) and then to blank (uncleared), saving after the status is changed. Labels and register behavior can vary, so follow the current controls in your account.
- Open the bank account’s register.
- Locate the specific transaction and review its history.
- Change the reconciliation status from R to C, then from C to blank so the item is uncleared.
- Save the transaction.
- Recheck the next reconciliation’s beginning balance and the discrepancy report.
Removing a cleared or reconciled item can alter the next reconciliation’s beginning balance. If the status change does not explain the discrepancy, restore the original status rather than leaving the account less accurate.
How do I undo a reconciliation in QuickBooks Online?
A full undo is a historical operation, not a routine way to clear a small difference. Intuit says that undoing a selected reconciliation also undoes reconciliations completed after it, changes reconciled transactions back to cleared or uncleared, resets the beginning balance to the prior reconciliation’s ending balance, and permanently deletes the reconciliation report and its attachments.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallOutdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware match- Identify the exact reconciliation that is wrong and determine whether every later reconciliation can be revisited.
- Download or otherwise preserve any reconciliation reports and attachments you need before undoing.
- Confirm that you have an allowed role. The current help guidance lists Primary Admin, Company Admin, In-house accountant, and an accountant user with access to the client company; permissions and labels may change.
- Use the account’s reconciliation history and the current undo command shown in QuickBooks Online.
- After the undo, correct the supported transaction or balance issue, then reconcile the affected statements again in chronological order.
Because a full undo can affect closed periods, financial statements, tax work, and later reconciliations, consult an accountant when you cannot establish the correct correction from the statement and audit trail.
End-of-reconciliation checks
Before selecting the completion control, verify all four of these items:
- The account and statement period are correct.
- The beginning balance agrees with the prior reconciliation or the documented opening balance.
- The entered ending date and ending balance match the statement.
- The difference is zero after reviewing missing, duplicate, and not-yet-cleared transactions.
Keep the completed reconciliation report with the statement and supporting documentation. It provides the baseline for the next beginning-balance check and helps explain a future discrepancy.
Practical troubleshooting checklist
- Difference equals a familiar bank fee: Check whether the fee is absent from QuickBooks; record it with the correct expense account instead of using a generic adjustment.
- Difference equals one transaction exactly: Search for a missing, duplicate, or incorrectly dated entry, then compare its history before changing status.
- Beginning balance changed since last month: Run the Reconcile Discrepancy Report and inspect the Audit log and register for edits, deletions, voids, moves, pending changes, or manual reconciliations.
- Everything appears marked but the difference remains: Recheck the statement ending balance, date, account, and decimal placement; selection alone cannot correct a wrong control figure.
- You cannot prove which correction is right: Preserve the statement and report, avoid forcing an adjustment, and ask an accountant to review the affected period.
Recordkeeping and handoff to an accountant
Save the statement, the completed reconciliation report, explanations for unusual timing differences, and evidence for any correction. When handing the issue to an accountant, identify the statement period, the original and current beginning balances, the discrepancy amount, the transaction IDs involved, and whether anyone has already edited or unreconciled an item. Intuit documents accountant-user access for bookkeeping, tax preparation, and troubleshooting; use the access method and permissions currently available in your account.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
