QuickBooks' method of importing bank transactions from a downloaded file (QBO/OFX format) rather than a direct bank feed. The user downloads a file and then imports it manually into QuickBooks.
Understanding Web Connect
Web Connect is QuickBooks' method for importing bank and credit card transactions from a downloaded file rather than through an automated direct bank feed. The user downloads a QBO or OFX file (from their bank website or a conversion tool), then imports it into QuickBooks using the "Upload from file" or "Web Connect" option.
During the Web Connect import process, QuickBooks asks the user to map the file to the correct bank or credit card account in their company file. QuickBooks then reads the transactions, checks FITIDs to prevent duplicates, and adds new transactions to the account register for review and categorization.
Web Connect is the fallback import method when direct bank feeds are unavailable, unreliable, or when importing data from non-bank sources (like marketplace settlement reports converted to QBO format). It gives the user more control over what data is imported and when.
Why It Matters for Ecommerce
Web Connect is how most ecommerce sellers import converted marketplace data into QuickBooks. After using PrimeConnect to convert Amazon settlement reports, Shopify payouts, or bank CSVs into QBO format, the Web Connect import is the final step that gets the data into your accounting system. Understanding this process helps troubleshoot import issues.
Practical Example
You convert your Amazon settlement report to QBO format using PrimeConnect. In QuickBooks Online, go to Banking → Upload Transactions → drag the QBO file. QuickBooks asks you to map it to your checking account. It detects 150 new transactions (checking FITIDs against existing entries) and adds them to your review queue for categorization.
Related Terms
QBO (QuickBooks Online / Web Connect)
A variant of the OFX format used by QuickBooks to import bank transactions via Web Connect. Despite the name, QBO files work with both QuickBooks Online and QuickBooks Desktop.
File FormatBank Feed
A direct, automated connection between a bank and accounting software that downloads transactions in real time. Eliminates the need for manual file downloads but is not available at all banks.
File FormatOFX (Open Financial Exchange)
An open standard XML-based format for exchanging financial data between institutions, software, and services. Supports bank statements, credit card statements, and investment data.
Put This Knowledge Into Practice
Now that you understand web connect, use PrimeConnect's free accounting tools to convert your ecommerce data into QuickBooks-ready formats — 100% browser-based.
Browse Free Tools