How I Use the QuickBooks Online Bank Feed in Cleanup Work
Most bookkeepers use the QuickBooks Online bank feed to match and categorize transactions. I use it for that too, but in cleanup work, that is only part of what makes it useful.
The bank feed gives me a view of the underlying bank and credit card activity that I can sort, search, compare, and use throughout a cleanup project. I use it when I review a file, when I scope the work, when I determine what records I need, while I am making corrections, and again when I am checking my work. This valuable tool gives me an efficient way to see what is there, what may be missing, and what deserves a closer look.
Finding Missing Transactions Before the Cleanup Starts
Early in a file review, I want to know whether the bank feed activity is even complete for the period. If I am reviewing January through December 2025, for example, I will look at both the For Review and Categorized tabs and sort the transactions by date.
Bank feeds disconnect. Transactions fail to download. Connections get reestablished without anyone realizing that several weeks of activity never came through. If I see transactions through March 14 and then nothing again until April 25, that gets my attention.
A gap like that usually means transactions are missing and will need to be added, often through a CSV upload. It also prompts me to consider what else could be missing. This matters when I am scoping the project. If I am estimating the activity in a file based only on what is currently visible, a six-week hole in the bank feed can make the file look considerably smaller than it really is. Even when nothing is missing, a quick pass through the feed gives me a feel for transaction volume and how activity moves across the period, which helps when I’m sizing up the work.
Finding Things the Intake Form Did Not Tell Me
Sorting by Description is another simple way I use the bank feed during a review. Payroll is a good example.
I ask firms which payroll provider the client uses, and they’ll tell me Gusto, ADP, QuickBooks Payroll or something else. Then I look at the actual bank activity. It is not unusual to discover that the client uses that provider now, but used a completely different payroll company during part of the cleanup period. If the client switched halfway through a twelve-month cleanup period, I need reports from both systems. The client may not think to mention the old provider, but the bank activity usually gives it away.
The same thing happens with payment processors and other third-party systems. I may see recurring deposits from PayPal, Stripe, Square, Venmo, or another provider that was never mentioned on the intake form. That tells me there may be another source of activity I need to review and possibly another set of reports I need to request.
This is one reason I do not rely entirely on questionnaires when I scope a cleanup. The answers are helpful, but the file often has more to say.
Using the Bank Feed to Diagnose Income
During my review of a file, I also use the bank feed as a broad diagnostic tool for income. I can sort the deposits for the period and compare the overall level of money coming into the business with the income reported on the Profit and Loss. I am not using deposits to calculate income. I am looking for whether the two broadly make sense together. That is not the same as saying every deposit is income. It is not. Deposits can include loan proceeds, owner contributions, transfers, refunds, and plenty of other things.
One of the most common things I see is deposits related to business income that are materially lower than the income reported on the Profit and Loss. That can be a sign that recorded income has been duplicated or is otherwise inaccurate. It does not tell me exactly what is wrong, and there may be a valid explanation for the difference. But it gives me a direction for the review and tells me that I need to look more closely at how income is being recorded.
This is especially useful early in a cleanup review because it helps me identify possible income-recording issues and gives me a direction for the rest of the review.
Looking for Large or Unusual Transactions
Sorting by amount is another quick way to see what deserves a closer look. A large deposit may be perfectly legitimate income. It may also be loan proceeds, an owner contribution, a transfer from another account, or something else entirely. A large payment may represent equipment, a loan payoff, a major repair, a distribution, or another transaction that should not simply disappear into a routine expense category.
I am not drawing conclusions based on the amount alone. I am using the amount as a flag. Large and unusual transactions often prompt clarifying questions, additional investigation, and sometimes requests for supporting documents.
Following Payments Back to the Balance Sheet
Payments to credit card companies, lenders, and financing providers can also tell me quite a bit. If I see regular payments going to a credit card vendor or loan provider, I can compare that activity to the Balance Sheet. Is there an account set up for that credit card or loan? Is the balance being maintained? Does the activity in the bank feed make sense in relation to what is being reported on the Balance Sheet?
Sometimes the payment itself has been categorized as an expense instead of being recorded against the related liability account. Other times the liability account exists but has not been maintained properly. Either way, the bank feed can point me toward something that needs further review.
Using the Bank Feed as a Correction Tool
I also use the Categorized tab for some of the same work people commonly handle through the Accountant Reclassify tool. The bank feed gives me very good visibility into the transaction detail, and in some situations I find it easier to work from there.
I can sort transactions, review the bank description, update missing vendor or customer names, and correct certain categorizations. That becomes especially useful when I am looking for patterns.
Suppose a bank rule was created to categorize City of Austin transactions to Permits and assign City of Austin as the vendor. That sounds reasonable until you discover that the rule was broad enough to grab every transaction beginning with the word "City." Now several transactions have the correct category but the wrong vendor.
Sorting the Categorized tab by Description makes those transactions easy to identify. I can review them together and correct the vendor names without hunting through reports one transaction at a time.
The same approach can expose category errors. If twenty Shell transactions are categorized to Fuel and one is sitting in Auto Repairs, it stands out immediately when the transactions are grouped together. That kind of anomaly can be much harder to notice when reviewing only the Profit and Loss, or even the Reclassify tool.
Why I Like Bank Feed Activity in Cleanup Work
Whenever possible, I prefer to have the bank and credit card activity represented through the bank feed. If transactions are missing, I will often obtain the activity from the financial institution or convert statement data to a CSV file and upload it. I can then match the downloaded or uploaded bank activity to transactions that were already entered manually. That gives me another point of comparison.
Manual entries to a bank or credit card register such as checks, deposits, bill payments or journal entries are not always wrong, but during cleanup work I regularly find entries that were entered with the wrong date, amount, account, payee, or other detail. Having the actual bank or credit card activity visible makes those differences much easier to find. It also makes the eventual reconciliation process cleaner because I have a consistent view of the activity that actually occurred through the account.
The Bank Feed Is More Than a Data Entry Screen
The QuickBooks Online bank feed is obviously useful for day-to-day transaction processing. For cleanup work, I use it much more broadly. It helps me understand what happened in the file, identify what may be missing, verify information I have been given, compare activity to the financial statements, spot unusual transactions, identify third-party systems, follow activity back to the Balance Sheet, make corrections, reconstruct activity, and perform final quality-control reviews.
It is not the only tool I use when reviewing or cleaning up a QuickBooks Online file. But after hundreds of cleanup projects, it has become one of the places I look repeatedly throughout the process. The QBO bank feed will not tell me everything, but if you know what you are looking for, it tells you quite a lot.
Valerie Armstrong is a QuickBooks Online cleanup specialist and founder of CleanUp Consultants, helping accounting, bookkeeping, and tax firms resolve challenging client files with confidence. With hundreds of cleanup projects completed over the last eight years, Valerie brings professional judgment, investigative thinking, and valuable experience to the work, collaborating with firms to provide clear, reliable QuickBooks Online files for their clients.