You can't import categorized transactions into QuickBooks Online through the bank upload with the categories intact. The upload reads only a date, a description and an amount, so a category column is ignored. To keep your categories, set up bank rules before uploading, or bring the history in as journal entries, which carry an account on every line.
Does the QuickBooks Online bank upload keep a category column?
The QuickBooks Online bank upload does not keep a category column. Intuit's help article on manually uploading transactions says a CSV needs three columns (date, description, amount) or four (date, description, credit, debit). There is no field for a category, so the mapping screen has nowhere to put one.
That design follows from what the upload is for. It imitates a bank feed. A bank knows when money moved, how much and what the merchant called itself. It does not know that the hardware store purchase was a repair rather than an office supply. Deciding that is your job, and QuickBooks asks you to do it on the review screen after the rows arrive.
So a spreadsheet that took you hours to categorize loses that work on the way in, unless you plan for it. The extra column is harmless. You can leave it in the file and simply not map it, or delete it before saving. Either way, every row lands on the review screen with a suggested category from QuickBooks or with none at all.
What the upload does keep
The upload keeps three things from each row: the date, the description text and the signed amount. The description is the one that matters for categories. Whatever you put in that column is the text QuickBooks and your bank rules will read. A clear, consistent description makes the categorizing after the upload far quicker, which is the next section's subject.
Bank rules that put categories back on uploaded transactions
Bank rules are the supported way to get categories applied during an upload. Intuit's upload article says that if you want uploaded transactions categorized as they come in, you should set up bank rules first. Intuit's guide to bank rules explains that a rule enters the category and description for you.
According to that guide, each rule can test up to five conditions. A condition looks at the description, the bank text or the amount, and checks whether it contains a word, does not contain it, or is exactly a value. When a row matches, the rule can set the transaction type, the category, the payee and tags. A rule can even split one transaction across several categories by percentage or by amount.
Rules have an order. The same guide says QuickBooks applies only one rule per transaction, starting with the rule at the top of the list. Put narrow rules above broad ones. A rule for "AMAZON WEB SERVICES" should sit above a rule for anything containing "AMAZON", or your hosting bill will be filed with office supplies.
Review or auto-post
A rule can either suggest its category and wait for you, or post the transaction straight into the books. Intuit's guide calls the second option auto-post and says those rules run when you sign in or upload a file. It also warns that with auto-post on, you won't get a chance to review transactions before they are added. For a first upload of old history, leave rules in review mode. Check that they did what you expected, then switch the reliable ones to auto-post.
Rules behave the same way for a connected bank feed. If you plan to connect the bank later, the rules you build now keep working, as the guide to downloading bank transactions into QuickBooks Online through a bank feed explains.
Turning a categorized spreadsheet into a set of bank rules
A categorized spreadsheet is a rule list waiting to be written. Sort it by category, look at the descriptions under each one, and find the word or phrase that every row in that group shares. That shared text becomes the condition, and the category becomes the rule's result.
The table below is a worked example with made-up rows. It shows five categorized lines from a spreadsheet and the rule each one suggests.
| Description (example) | Your category | Rule condition | Rule result |
|---|---|---|---|
| CITY POWER CO AUTOPAY | Utilities | Description contains "CITY POWER" | Utilities |
| GOOGLE *WORKSPACE | Software | Description contains "WORKSPACE" | Software subscriptions |
| SHELL OIL 5521 | Vehicle fuel | Description contains "SHELL OIL" | Vehicle: fuel |
| CHECK 1042 | Contractor | (no reliable text) | No rule: categorize by hand |
| ONLINE TRANSFER TO SAV | Transfer | Description contains "TRANSFER TO SAV" | Transfer to savings account |
Most rows become rules cleanly. The check is the exception. A check line says only "CHECK" and a number, which tells a rule nothing about who was paid. Rows like that need a person on the review screen, so do not spend time trying to force a rule onto them.
Testing the rules on one month
Build the rules, then upload a single month before the rest of the year. On the review screen, compare the categories QuickBooks applied with the categories in your spreadsheet for that month. Fix any rule that misfired, and adjust the order if a broad rule caught rows meant for a narrow one. Only then upload the remaining months. One test month costs a few minutes, while a bad rule applied to twelve months costs an afternoon of re-categorizing.
A spreadsheet row split across two categories, such as one store receipt that was part supplies and part equipment, is a special case. The post on importing split transactions into QuickBooks Online covers how a bank upload handles those.
Imports that carry a QuickBooks account on every line
The journal entry import is the main QuickBooks Online import that carries an account on every line. A journal entry file names the account for each debit and each credit, so your category travels with the amount. The post on importing journal entries into QuickBooks Online covers its columns and how to keep each entry balanced.
In a journal entry built from a bank line, one side is the bank account and the other side is your category. A $64 fuel purchase becomes a debit of 64 to the fuel expense account and a credit of 64 to the checking account. Do that for every row, and the categories in your spreadsheet arrive exactly as you wrote them.
That precision has a price. A journal entry posts to the books straight away. It skips the review screen, so it will not be matched against anything the bank feed later downloads. If a feed or an upload brings in the same transaction afterwards, you will have it twice, once as a journal entry and once as a bank line waiting for review.
Payment processors complicate this further. A Stripe payout is one bank line, but behind it sit many sales and fees, each with its own category. The guide to importing Stripe transactions into QuickBooks Online explains how to bring in the gross sales and fees from Stripe's report alongside the bank payout.
Should categorized history go in as journal entries?
Journal entries suit categorized history that will never meet a bank feed, such as closed accounts or years before the books moved to QuickBooks. For any account that is still open, the bank upload plus bank rules is safer, because every line goes through review and can be matched later.
A short way to decide:
- Use the bank upload and rules when the account is still open, when you will reconcile it in QuickBooks, or when a feed might connect later.
- Use journal entries when the account is closed, when you only need totals by category for a past year, or when your accountant asks for summarized entries.
- Use neither for a handful of rows. Typing three transactions by hand is quicker than building any file.
Some people choose a middle path for old years: one journal entry per month that posts the total for each category. That keeps the reports right without importing hundreds of lines. It also means you lose the detail of individual payments in QuickBooks, so keep the original spreadsheet with your records.
Accounts held in another currency add one more decision, because the account itself has to be set up in that currency before anything is imported. The guide to importing foreign currency transactions into QuickBooks Online covers that setup.
Category names that don't match the QuickBooks chart of accounts
The most common mistake with categorized data is assuming your spreadsheet's category names exist in QuickBooks. A rule or a journal entry can only point at an account that is already in the chart of accounts. "Gas" in your sheet and "Vehicle: fuel" in QuickBooks are different names, and no rule will guess they match.
Before you build any rule or file, list every distinct category in the spreadsheet. Next to each one, write the QuickBooks account it belongs to. Three outcomes are possible:
- A match exists. Use the QuickBooks name in the rule or in the journal entry file.
- A close account exists. Fold the spreadsheet category into it, so the chart of accounts stays short.
- Nothing fits. Create the account in QuickBooks first, then point the rule or file at it.
Both a bank rule and a journal entry file need the account to exist before they can point at it, so create any missing accounts before you build either one. Doing the mapping on paper first is quicker than stopping halfway through a batch of rules to add an account.
If your categorized data started life as PDF bank statements, the description text is the part worth protecting, because rules read it. SimpleBankConvert is being built to turn a PDF statement into an upload file with the description kept on one line. It is not open yet, and SimpleBankConvert's get started page lets you ask for a place.