# Import Split Transactions into QuickBooks Online

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: QuickBooks Online imports
- Canonical: https://simplebankconvert.com/blog/import-split-transactions-into-quickbooks-online

> How to import split transactions into QuickBooks Online when one payment covers several categories, and why a bank upload brings in each split as one line.
You cannot import split transactions into QuickBooks Online through the bank upload, because the file holds one amount per line. Each payment arrives as a single line. You then split it during review: open the line, choose Split, give each part a category and an amount, and save once the parts add up to the bank amount.

## Why a bank upload brings each split transaction in as one line

A bank upload brings each payment in as one line because the bank recorded it as one payment. Your statement shows a single amount leaving the account, and the upload file mirrors that. A split is something you decide about the payment, so it gets added after the line is in QuickBooks.

Intuit's [manual upload help page](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) gives the only two layouts the upload accepts: three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit). Neither has room for a category, let alone several categories under one payment. Extra columns in your file are not mapped to anything on the matching screen.

Some people try to fake a split by putting the same payment on two rows with smaller amounts. That breaks the link to the bank. Your statement shows one payment of the full amount, so two rows will not match it, and the account will no longer reconcile cleanly.

## Splitting an uploaded transaction in the For review tab

Splitting happens in the list of transactions waiting for review. Open the line, change it from Match to Categorize if QuickBooks suggested a match, select Split, and enter one category and amount per part. QuickBooks shows a Difference figure, and you can save once it reaches zero.

Intuit's [help page on categorizing and matching bank transactions](https://quickbooks.intuit.com/learn-support/en-us/help-article/banking/categorize-match-online-bank-transactions-online/L1bTafTz3_US_en_US) gives these steps. Here they are with a worked example. The values are made up.

A card payment of $412.50 at a warehouse store covered office supplies, cleaning supplies and staff refreshments.

1. Open the bank account's pending transactions and select the $412.50 line.
2. If the button reads **Match**, switch to **Categorize**.
3. Select **Split**.
4. First line: category Office supplies, amount 260.00.
5. Second line: category Cleaning supplies, amount 98.75.
6. Third line: category Staff meals, amount 53.75.
7. Confirm **Difference** reads $0.00. If it shows 10.00, a part is short by ten dollars.
8. Select **Split and add**.

Use the receipt to get the parts right. If you only know rough shares, ask your bookkeeper whether a reasonable estimate is acceptable for that kind of spending.

## Can any file carry split transactions into QuickBooks Online?

The bank upload cannot carry splits, but a journal entry import can, because each journal entry is built from several lines that must balance. That is a different tool with different rules. It suits adjustments and history, not routine bank lines you want to match against the bank.

For everyday spending, the practical answer is to upload the plain bank lines and split the few that need it. Most payments have a single category, so only a handful of lines in a month usually need splitting.

If a payment was in another currency, the split itself works the same way, but the amounts you enter must be in the account's currency. [Importing foreign currency transactions](/blog/import-foreign-currency-transactions-into-quickbooks-online) covers how QuickBooks handles the exchange side. When your bank offers no QuickBooks download at all, the plain file you split from still has to come from somewhere, and [what to do when your bank does not support QuickBooks downloads](/blog/bank-does-not-support-quickbooks-download) lists the options.

## Split transactions that hide a transfer inside an expense

Sometimes part of one bank line is a transfer between your own accounts and the rest is a cost. A loan payment that also covers an insurance charge is one example. A payment to your credit card that bundles a fee is another. The split has to keep the transfer part out of expenses.

In the split screen, the transfer part goes to the other account itself, such as the loan or the credit card account, rather than to an expense category. The cost part goes to its expense category as usual. Done that way, the other account's balance stays right and you avoid counting spending twice.

If the whole line is money moved between your own accounts, do not split it at all. Record it as a transfer, which [importing bank transfers](/blog/import-bank-transfers-into-quickbooks-online) walks through for both sides.

## When is a split transaction the wrong tool?

A split is the wrong tool when the payment needs details a category line cannot hold. Splitting a single bank deposit into several customer checks, for example, loses the check numbers and payers. It is also wrong when the parts happened on different dates, such as a monthly payment that settles several earlier bills.

For a deposit made up of several checks, record the checks individually and match the deposit to them. [Importing checks with their numbers](/blog/import-checks-into-quickbooks-online) shows how that works. For a payment that settles earlier bills, match the line to those bills instead of splitting it into categories, so the bills show as paid.

Before any of this, the bank lines have to arrive in QuickBooks in the first place. [SimpleBankConvert](/) is being built to turn a PDF bank statement into a CSV or QBO file for the upload, with money going out shown as a minus.