Compare · bank feeds

The feed tells you what arrived. The statement tells you what happened.

Running QuickBooks Online on the bank feed? It saves real typing, and it is a fine daily view. What it cannot do is prove that everything arrived, and that is exactly the part a bookkeeper or tax preparer answers for.

Sources cited for every claimQuickBooks Online and every Windows Desktop versionAny bank, any period
Bank statement · First Harbor
A sample statement from the fictional First Harbor Bank: beginning balance, deposits, withdrawals and ending balance
Ending balance ties outcredits, debits, balance
A feed has no statement totalsnothing to tie the month to
Sample firm, invented data
The gaps

What a feed leaves out.

90 days

QuickBooks does not download anything older, or anything still pending.1

48 hours

How long a posted transaction can take to reach QuickBooks.1

2 figures

Ending balance and ending date: what QuickBooks asks you to take from the statement to reconcile.5

Feeds are convenient, and convenience hides the gaps. Here is what the providers' own documentation says:

Not there yet, or not any more

Pending items and anything older than 90 days never arrive.1 A month that closes on the 31st is not complete on the 31st.

A history set by the bank

How far back the feed reaches is up to the bank: from 90 days to 24 months.2 A new client's prior year is often out of reach.

Silent gaps

Feeds go quiet when the bank has an error or processing is delayed.3 Nothing in the feed tells you a week is missing.

Duplicates and wrong buckets

Reconnecting an account, or importing a file that overlaps the feed, can bring the same transaction in twice.7 Active feeds can still produce inaccurate financial statements.4

Nothing to tie out

Reconciling in QuickBooks means checking against the statement's ending balance.5 The statement is the reference; the feed is a copy of part of it.

Not a document you can keep

The IRS lists account statements among the documents that support expenses. A feed is not a document.6

The record

Why the statement is the record.

“For most small businesses, the business checking account is the main source for entries in the business books.”
Internal Revenue Service, What kind of records should I keep 6

The statement carries everything the feed lacks: the opening balance, the deposits and withdrawals totals, the count of items and the ending balance. A month that ties to those numbers is a month you can sign, and it is why firms that use feeds still reconcile against the statement every month.5

The statement's own summary: the four numbers every month has to tie to. Sample firm, invented data.
The statement's own summary: the four numbers every month has to tie to. Sample firm, invented data.
The catch

Everyone agrees the statement is the record. Getting it into QuickBooks is the problem.

Type every line

The most reliable way and the most expensive hour in the firm, every month, for every client.

Accurate, and slow

Run it through a converter

A spreadsheet comes out and the typing starts again: categorize, import, fix, check. We compared that here.

Cheap, and half done

Trust the feed alone

Convenient, until the month the feed missed a week. The record and the books only meet at reconciliation, if someone has time.

Easy, and unproven
The answer

The ease of the feed. The reliability of the statement. And more.

What if the statement were as easy to use as the feed? That is QBuddy. Send the PDF or CSV and he reads every transaction, including the checks, from the document the bank stands behind. Then he goes further than either a feed or a typist:

BalanceProof

Every total, proven before anything posts

QBuddy compares what he read with the PDF statement's own credits, debits and ending balance. If one disagrees, he stops before QuickBooks and shows you which total is off, and by how much. A feed cannot do this: it never had the totals.

BalanceProof on the review screen, magnified: Validation Passed, and the statement's deposits matched with what was read
Checks

The payee and the memo, not just CHECK 3051

QBuddy reads the check images on the statement, so every check arrives with who was paid and what for.

Checks on the review screen, magnified: each with its payee, memo and original date
Rules

Rules that follow each client

Made once, on that client's own chart of accounts. Every later statement arrives categorized, and if the client moves from Desktop to Online, every rule comes along.

A quick rule in QBuddy, magnified: the keyword to match from the description and the QuickBooks account it goes to

Any bank, any period

The statement exists for every account and every month, including the ones the feed never reached.

One click into QuickBooks

QuickBooks Online or any Windows Desktop version, chosen per client. No import files.

The firm on one screen

Statements, clients, who did what, and an ROI report in your own minutes and hourly cost.

The screens on this page are QBuddy with a sample firm and invented data.

Watch: the feed is a help, the statement is the record (45 seconds)
Side by side

Three ways to get a month into QuickBooks.

Bank feedTyping the statementQBuddy
SourceThe bank's data stream, as deliveredThe statementThe statement
Complete monthPending, older and delayed items can be missingComplete, if nobody skips a lineComplete, and proven against the bank's totals
HistorySet by the bank, from 90 days to 24 monthsAny periodAny period
Statement totals to tie outNone: a current balance, not the monthOn the page, checked by handChecked against the bank before posting
Handwritten checksA line that says CHECKRead and keyed by a personPayee and memo read from the image
Effort per statementLowHoursMinutes, your team only reviews
DestinationQuickBooks Online mostlyEither, keyed by handQuickBooks Online and every Windows Desktop version, one click
In practice

Keep the feed. Close from the statement.

Use the feed for

  • A quick daily look at the accounts
  • Catching a large item between closes
  • Clients who like seeing activity early

Use QBuddy from the statement for

  • The books of record, tied to the bank
  • Every account and month the feed misses
  • Catch-up work and a new client's prior year
  • The month you sign and the return you file
The short version: the reconciliation that used to close the month becomes a confirmation of what BalanceProof already checked.
Sources

Where every claim comes from.

Every number on this page links here. Each source opens the original page in a new tab.

  1. quickbooks.intuit.com
    Intuit · QuickBooks help: Find missing downloaded transactions

    “QuickBooks doesn't download pending transactions or transactions older than 90 days.” “It may take up to 48 hours for transactions to come over to QuickBooks.”

  2. quickbooks.intuit.com
    Intuit · QuickBooks help: Connect bank and credit card accounts to QuickBooks Online

    When an account is connected, how far back the download reaches depends on the bank: “Download timespans vary by bank, ranging from 90 days up to 24 months.”

  3. plaid.com
    Plaid (bank data provider for many apps) · Transactions troubleshooting

    Industry documentation for apps that receive bank data. Common causes of missing transactions include “The institution is experiencing an error.” and “Processing of the transactions has been delayed.”

  4. polaristaxandaccounting.com
    Polaris Tax & Accounting · Why QuickBooks bank feeds create problems

    A CPA firm's article: “A QuickBooks file can have active bank feeds and still produce inaccurate financial statements.” On duplicates: “They often happen when users manually enter transactions and later accept the same transaction from the bank feed.”

  5. quickbooks.intuit.com
    Intuit · QuickBooks help: Reconcile an account in QuickBooks Online

    “Enter the Ending balance and Ending date from your account statement.” Then: “Continue matching until the Difference is $0.00.”

  6. irs.gov
    IRS · What kind of records should I keep

    “For most small businesses, the business checking account is the main source for entries in the business books.” Account statements are listed among the documents for expenses.

  7. quickbooks.intuit.com
    Intuit · QuickBooks help: Fix duplicate transactions in QuickBooks Online Desktop bank feeds

    “This can happen if you reconnect an account, import a file that overlaps with your bank feed, add a downloaded transaction instead of matching it, or record the same sale in two different ways.”

Keep going

Read next

See a month the feed got wrong.

Book a 15-minute demo and bring that statement. We will run it live and tie it out to the bank.