# Convert Wells Fargo Bank Statement to QBO

- Author: SimpleBankConvert (https://www.simplebankconvert.com)
- Published: 2026-04-21
- Updated: 2026-04-21
- Category: PDF bank statements
- Canonical: https://www.simplebankconvert.com/blog/convert-wells-fargo-bank-statement-to-qbo

> Convert a Wells Fargo bank statement to QBO from the PDF: handle its deposits and withdrawals columns, daily balances and check rows, then import it.
To convert a Wells Fargo bank statement to QBO, copy each row of the transaction history into a table, turn the deposits and withdrawals columns into one signed amount, keep check numbers with their rows, and skip the balance figures. Then prove the table against the statement's opening and closing balances before you build and import the QBO file.

## Wells Fargo download or Wells Fargo PDF: which gets you a QBO file?

Try the bank's own download first. Look in Wells Fargo online banking for a way to export recent activity in a QuickBooks format, because a bank-made file needs no conversion at all. The PDF route is for the months that download no longer reaches, or for statements from an account you can no longer sign in to.

Use this quick sort before you start:

- **Recent months, account still open.** Download the activity from online banking in the QuickBooks format, if your screen offers one, and import that file.
- **Older months.** Download the monthly statement PDFs from the statements area and convert them.
- **Both.** Choose one cutover date. Use the download from that date forward and converted PDFs for every month before it, with no overlap.

The overlap rule matters more than it sounds. A bank download and a converted PDF describe the same transactions with different internal IDs, so QuickBooks cannot tell they are the same. Importing both for the same week gives you every line twice.

The rest of this post assumes you are on the PDF route. Download statements from the bank's site rather than scanning paper copies, because a downloaded PDF holds real text that can be read exactly.

## Reading the Wells Fargo deposits and withdrawals columns

A Wells Fargo checking statement usually lists activity in a transaction history table with money in and money out in two separate columns, typically headed along the lines of deposits/credits and withdrawals/debits. A QBO file wants one signed amount per row. Make money in positive and money out negative, then drop the two original columns.

Work row by row, in the order the statement prints them:

1. Copy the date, the description and whichever money column has a figure.
2. If the figure is in the deposits column, keep it positive.
3. If it is in the withdrawals column, put a minus in front.
4. Remove dollar signs and thousands separators, so $1,250.00 becomes 1250.00.
5. Give each date its year from the statement period at the top of the first page.

### Descriptions that run onto a second line

Wells Fargo descriptions for transfers and ACH payments can be long, and the PDF may wrap them. A line with text but no date and no amount belongs to the row above it. Join the two before you move on. A row in your table with a description and no amount is almost always a missed join.

### Same signs as other banks

The money-in-positive rule is the same for every bank account you convert. Card accounts are the exception, because a purchase increases what you owe. Card PDFs from other issuers need their own sign check; the guides to [converting a Capital One statement to QBO](/blog/convert-capital-one-statement-to-qbo) and [importing an Amex statement into QuickBooks](/blog/how-to-import-amex-statement-into-quickbooks) show that side.

## What is the ending daily balance on a Wells Fargo statement?

The ending daily balance is the account balance after the bank's nightly processing for a day. The [Wells Fargo deposit account agreement](https://www.wellsfargo.com/assets/pdf/small-business/agreement.pdf) defines it as reflecting all posted deposits and withdrawals from that processing, calculated once a day. It is a balance, not a transaction, so it never becomes a row in your file.

If your statement prints a balance column with that name, you will notice it is blank on some rows. When several transactions post on the same day, only the last row for that day shows the balance, because there is only one end-of-day figure. That is normal. It does not mean a balance is missing.

The blanks make the column less handy for checking each row, but it still works as a check once per day:

- Start from the previous day's ending daily balance.
- Add that day's deposits and subtract its withdrawals.
- Compare the result with the balance printed on the day's last row.

A mismatch on one day narrows a missing or wrongly signed row down to that day's handful of lines, which is far faster than searching a whole month. The agreement also notes that the ending daily balance and the available balance can differ. Your statement and your import file follow the posted figures, so ignore the available balance you might see in the app.

## Check rows and check images in a Wells Fargo statement

A paid check appears in the transaction history as a withdrawal, usually with its check number in a column of its own or in the description. Keep the number with the row, because QuickBooks can use it to match the check you already wrote. The check image pages some statements carry hold no new rows and are skipped.

### Where the check number goes

In a QBO file, each transaction can carry a check number field separate from the description. If you build the file through a CSV first, put the number in the description, such as "CHECK 1047", so it survives. Either way, do not let the check number end up in the amount column. A check number of 1047 read as a dollar figure is a classic way to throw the balance off by exactly that amount.

### The image pages

According to the same agreement, Wells Fargo does not return paid checks with statements but makes copies available online, by phone or at branches, and offers a check image service that puts images of paid checks on your statement. If you see pages of small check pictures at the back, they repeat checks already listed in the history. Do not read them as transactions. Keep them in the original PDF for your records.

## Proving the Wells Fargo QBO file against the statement summary

Before you build the file, prove your table with the statement's own numbers. The opening balance, plus every deposit, minus every withdrawal, must equal the closing balance. If your statement prints totals for deposits and withdrawals in an activity summary, those give you two more checks that each side is complete.

Here is a worked example. The business, payees and amounts are made up, for a March 2026 statement with an opening balance of 6,412.50.

| Printed date | Check no. | Description | Deposits | Withdrawals | Ending daily balance | Signed amount |
| --- | --- | --- | ---: | ---: | ---: | ---: |
| 3/2 | | Mobile deposit | 950.00 | | | 950.00 |
| 3/2 | | ACH debit Granite Payroll Svc | | 2,180.00 | 5,182.50 | -2180.00 |
| 3/5 | 1046 | Check | | 425.00 | 4,757.50 | -425.00 |
| 3/11 | | Online transfer from savings | 1,500.00 | | | 1500.00 |
| 3/11 | | Purchase Tidewater Hardware | | 63.18 | 6,194.32 | -63.18 |
| 3/19 | 1047 | Check | | 1,100.00 | 5,094.32 | -1100.00 |
| 3/24 | | ACH credit Marlow Events LLC | 3,275.00 | | 8,369.32 | 3275.00 |
| 3/31 | | Monthly service fee | | 10.00 | 8,359.32 | -10.00 |

Now run the three checks.

1. **Deposits.** 950.00 plus 1,500.00 plus 3,275.00 is 5,725.00. That should match the deposits total in the activity summary.
2. **Withdrawals.** 2,180.00 plus 425.00 plus 63.18 plus 1,100.00 plus 10.00 is 3,778.18. That should match the withdrawals total.
3. **Balance.** 6,412.50 plus 5,725.00 minus 3,778.18 is 8,359.32, which equals the last ending daily balance and the statement's closing balance.

Notice the blank balances on the first and fourth rows. Each sits on a day with a second transaction, so the day's figure appears only once, on the later row. The daily check still works: 6,412.50 plus 950.00 minus 2,180.00 gives the 5,182.50 printed for 2 March.

If a total is off, the size of the gap points you to the cause. A gap equal to one amount is a missed or doubled row. A gap of twice one amount is a flipped sign.

SimpleBankConvert is being built to merge the two money columns into one amount and put every date in one format, which covers the slow part of this table. It is in early access and accounts are not open, so the [get started page](/get-started) is where to leave your email.

## Importing the Wells Fargo QBO file into QuickBooks

QuickBooks Online takes a QBO file through its bank upload, where you pick the account the transactions belong to. QuickBooks Desktop opens the same file as a Web Connect import. In both, choose the Wells Fargo account deliberately and check the balance on the statement end date afterwards.

### QuickBooks Online

[Intuit's page on uploading transactions manually](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) recommends a QBO file for a list of transactions, and sets a limit of 350 KB and 1,000 lines per upload. One month of a business checking account is normally far below that. When you upload, select the QuickBooks account that represents this Wells Fargo account, then review the lines it brings in before you add or match them.

### QuickBooks Desktop

Desktop reads the file as Web Connect. Open it from the import menu, and when Desktop asks which account to use, link it to the existing Wells Fargo account rather than creating a new one. Bringing a whole year of old statements into Desktop has its own order of work, and [importing old bank statements into QuickBooks Desktop](/blog/import-old-bank-statements-into-quickbooks-desktop) covers it.

### After the import

Compare the QuickBooks balance on the statement's closing date with the statement's closing balance. If they match, move to the next month. Import months oldest first, so each one starts where the previous one ended.

## Wells Fargo combined statements with savings on the same PDF

A combined statement shows more than one account on a single PDF, often checking and savings for the same owner. The Wells Fargo agreement describes combined statements for accounts with a common owner, with the first account listed treated as the primary one. Each account still needs its own QBO file.

Split the PDF by account before you build anything:

- Find where each account's transaction history begins. Each has its own account number, opening balance and closing balance.
- Make one table per account and run the balance checks for each.
- Build one QBO file per account and import each into its matching QuickBooks account.

Transfers between the two accounts appear on both histories, once as a withdrawal and once as a deposit. That is correct, because each account really did move. When you review them in QuickBooks, record the pair as one transfer rather than as an expense and a separate income.

Other banks print multi-account summaries in their own way. Citi, for example, can open with summary pages for several accounts, and [converting a Citi bank statement to QBO](/blog/convert-citi-bank-statement-to-qbo) shows how to find the right section there. The same principle holds at every bank: one account, one table, one file.