Importing Web Connect files into QuickBooks Desktop after sunset
When Intuit ends live bank feeds for your QuickBooks Desktop version, downloads stop; we show what works and how to keep reconciling without upgrading.
When Intuit discontinues your QuickBooks Desktop version, the live bank feed is one of the first services to go. The accounting itself is untouched. The register, the matching engine, and the reconcile module all live inside the program and keep working. You simply have to deliver the transactions yourself.
What actually stops working?
Intuit routes Desktop bank feeds through its own servers. Direct Connect and Express Web Connect sessions are negotiated by Intuit for each supported version, and once a version is discontinued, Intuit stops answering it. This cutoff has historically arrived about three years after a version ships.
Resetting the connection, deleting the online banking list, or removing and re-adding the account will not revive it. Those tools assume the servers still recognize your version. The Bank Feeds center then shows connection errors, or simply never downloads anything.
The program itself keeps opening, and your company file stays fully usable. Payroll and other connected services end at the same time, but none of that touches the ledger.
Does anything still match automatically?
Yes, and this is the part worth knowing: the matching engine is local. Once transactions reach the review window, the program compares each line against the register on amount, date, payee, and reference or check number.
Existing checks, deposits, bill payments, and card charges pair up and are marked cleared. Lines with no counterpart can be added as new transactions. Renaming rules keep running too, so recurring payees stay consistent across imports.
None of this depends on Intuit's servers. The only missing piece is delivery into the review window.
Downloading the statement file from your bank
Most banks that supported feeds also let you download a statement file in QuickBooks format, usually labeled Web Connect, with a .qbo extension. Sign in to the bank's website, choose the account, set a date range, and select QuickBooks or Web Connect as the format.
For the first download after the feed dies, set the start date to the day after your last successful live download. Record the end date of every file so the next one starts there without overlap. Keep each file in a folder named for the account and month, alongside a PDF of the same statement.
One caveat. QuickBooks checks the bank identifier embedded in the file against its internal list of known banks. If your bank offers only Quicken or plain OFX formats, the import may be rejected. Ask the bank specifically for the QuickBooks format; most banks that offered feeds also provide it.
Importing the file into the company file
Back up first, from the File menu, before the first import of each month. Then choose File, Utilities, Import, Web Connect File, and select the downloaded file. When prompted, map the download to the existing account rather than a new one. A wrong mapping splits your history across two registers.
The Bank Feeds window opens with downloaded lines on one side and the register on the other. Review the proposed matches, correct any that paired wrongly, and add the rest. Add Multiple handles a batch in one pass.
Overlapping date ranges are the main hazard. The window flags suspected duplicates, but it does not catch everything, so import ranges that do not overlap and check the first run carefully. If a duplicate slips through, delete the added transaction before you reconcile, not after.
Reconciliation keeps working the same way
Matched transactions arrive already marked cleared, so the formal reconcile becomes confirmation rather than data entry. Open Banking, then Reconcile, enter the statement's ending date and balance, and confirm the cleared items. The discrepancy should read zero. Finish the session, then save or print the reconciliation report.
Two habits keep the loop healthy. Run Verify Data from the File, Utilities menu after a heavy month of imports. If the file fails Verify and then Rebuild, treat it as a repair item rather than pushing on; our QuickBooks Verify and Rebuild repair service exists for exactly that state. For the wider close, our notes on reconciliation practice with QuickBooks cover what a clean month-end looks like when feeds are manual.
A sunset removes the automation, not the accounting. Once the rhythm of download, import, match, and reconcile is in place, the register stays as current as it ever was, on the version you already own.