# Deposits Imported as Withdrawals in QuickBooks

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: Undoing and fixing imports
- Canonical: https://simplebankconvert.com/blog/deposits-imported-as-withdrawals-in-quickbooks

> Why deposits are imported as withdrawals in QuickBooks when a file's signs are reversed, and how to remove the batch, flip the amounts and import again.
Deposits imported as withdrawals in QuickBooks almost always mean the file's amount signs are reversed: money in carries a minus and money out carries none. QuickBooks reads a minus as money leaving the account. Remove the whole batch, flip every amount in the file, or use the reverse option while mapping, then import it again.

## Why do deposits import as withdrawals in QuickBooks?

QuickBooks reads a bank file from the account holder's side. A positive amount is money coming into the account, and a negative amount is money going out. When a file was built the other way round, every deposit lands as a payment and every payment lands as a deposit. The data is complete. Only the direction is wrong.

The reversed file usually comes from one of three places:

- **A spreadsheet made by hand.** Someone typed withdrawals as positive numbers because that is how the statement prints them, with no minus sign in sight.
- **A card or loan export.** Some lenders and card issuers export from their own side of the account, where your purchase is a positive balance increase. That suits their books, not yours.
- **Swapped columns in a four-column file.** A file with separate credit and debit columns gets its headers mislabelled, so the column of deposits is mapped as debits.

The flip is total in the first two cases and easy to see. The third case can be partial if only some rows were moved between columns by hand. Partial flips are harder to spot and are covered in the next section.

## Spotting a sign-flipped deposit batch before anything is accepted

A reversed batch is easiest to catch on the review tab, before anyone accepts a line. Look for your largest regular deposit, such as a customer payment or a payout, and see which column it sits in. If it shows as a payment, the batch is probably reversed. Then check the total.

The quick test is the balance. Take the statement's opening balance, add the file's deposits and subtract its withdrawals. You should reach the statement's closing balance. In a fully reversed file, you reach a figure that is off by twice the net movement of the month. The example table shows how that looks. All values are made up for illustration.

| Date (example) | Description | Statement shows | Reversed file shows | Corrected amount |
| --- | --- | --- | --- | ---: |
| 03/02 | Customer payment, Lane Hardware | Deposit 1,250.00 | -1,250.00 | 1,250.00 |
| 03/05 | Rent, Main Street Lofts | Withdrawal 900.00 | 900.00 | -900.00 |
| 03/09 | Card processor payout | Deposit 410.35 | -410.35 | 410.35 |
| 03/14 | Phone bill | Withdrawal 82.10 | 82.10 | -82.10 |
| 03/20 | Bank fee | Withdrawal 12.00 | 12.00 | -12.00 |

In this example the net movement is plus 666.25. The reversed file moves the balance by minus 666.25 instead, so the account ends 1,332.50 below the statement. When a gap is exactly twice the month's net movement, a full flip is the cause. If the gap is twice one transaction, only that row is flipped.

Dates can go wrong in the same file. A batch with reversed signs that also lands in the wrong year has two separate faults, and [imported transactions with the wrong year in QuickBooks](/blog/imported-transactions-have-the-wrong-year-in-quickbooks) covers the date side.

## Does the reverse all values option fix flipped deposits?

Yes, for CSV uploads to QuickBooks Online, if you catch the problem while mapping. The mapping step shows a preview of your transactions. When the signs look backwards there, a reverse option flips every amount in the file before anything is imported, so no batch needs removing afterwards.

[Intuit's guide to manually uploading transactions](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) says to check during mapping whether the amounts show correctly as positive or negative, and to select reverse all values if they are reversed. The same guide describes the two CSV layouts: three columns of date, description and amount, or four columns of date, description, credit and debit.

The option has limits:

- **It flips everything.** A partly reversed file stays wrong, because the rows that were right become wrong.
- **It does nothing after the upload.** Once the lines are on the review tab, the option is behind you. Clear the batch and upload again.
- **It belongs to the CSV path.** A QBO file goes in without a mapping step, so a reversed QBO file has to be fixed at the source.

## Clearing a sign-flipped batch out of QuickBooks Online

In QuickBooks Online, a reversed batch comes out line by line from the Bank transactions page. Exclude every line still on the review tab. For lines someone already accepted, open each from the accepted tab, select Undo, and exclude it once it is back in review. Then upload the corrected file.

[Intuit's article on fixing duplicate bank feed transactions](https://quickbooks.intuit.com/learn-support/en-us/help-article/duplicate-transactions/fix-duplicate-transactions-quickbooks-online-bank-feeds/L1fjxl88f_US_en_US) gives the steps. The accepted tab is called Categorized or Posted depending on your screens. You select the link in the Added or Matched column, then Undo, and the line goes back to For review. A line still tied to another record has to be unmatched before it can be excluded.

Reversed lines that were accepted can do more damage than they look. A deposit accepted as an expense may have been matched to a bill. A payment accepted as a deposit may have been matched to an open invoice and marked it paid. Undo disconnects those matches, but check the invoices and bills afterwards, because they may need to be reopened or paid again with the right record.

## Clearing a sign-flipped Web Connect batch out of QuickBooks Desktop

QuickBooks Desktop takes bank files as Web Connect (QBO) files, and once you add the lines they become ordinary register entries. There is no batch undo. You either restore a backup made before the import or delete the reversed entries from the bank register yourself.

A backup is the clean route if nothing else happened since. [Intuit's article on restoring a backup company file](https://quickbooks.intuit.com/learn-support/en-us/help-article/back-data/restore-backup-company-file/L2FptZyV1_US_en_US) starts from File, then Open or Restore Company. It warns that restoring into the same folder as your current file may overwrite your data, and says to rename one of the files or use another folder. A restore takes you back to the moment of the backup, so anything entered after it has to be entered again.

If work was entered after the import, delete the reversed lines in the register instead, then download the corrected file. Desktop has its own rules about downloaded lines you have not added yet. The post on [deleting downloaded transactions in QuickBooks Desktop](/blog/delete-downloaded-transactions-in-quickbooks-desktop) covers that list and what removing it means for later downloads.

## Flipping deposit and withdrawal amounts in the CSV itself

Fixing the file itself is the safest repair, because the corrected file can be checked against the statement before it goes anywhere. In a three-column file, multiply the amount column by minus one. In a four-column file, swap the credit and debit headers, or swap the two columns of numbers.

For a spreadsheet, the steps are short:

1. Add an empty column next to the amount column.
2. In its first row, enter a formula that multiplies the amount by -1, then fill it down.
3. Copy the new column and paste it over the old amounts as values only.
4. Delete the helper column and save the file as CSV.
5. Check the balance test from the earlier section before uploading.

Keep the date column untouched while you work. Spreadsheets reformat dates when a file is opened and saved, and a corrected file with mangled dates trades one fault for another.

Some files mix bank lines with other records, such as a sales list exported next to the deposits. Those belong in a different import. Customer invoices, for example, go in through their own route, which the guide to [importing invoices into QuickBooks Desktop from Excel](/blog/import-invoices-into-quickbooks-desktop-from-excel) explains. Keep the bank file to the lines printed on the bank statement.

When the source is a PDF statement, the sign decision happens while the file is built. SimpleBankConvert is being built to merge a statement's withdrawal and deposit columns into one amount column, with money going out shown as a minus. It is not open yet. [The get started page](/get-started) takes your details for an invitation.

## Credit card files where charges arrive as deposits

Credit card accounts are the usual exception, because a charge raises what you owe. On a card account in QuickBooks, a purchase should still go in as money spent and a payment to the card as money received. A file exported from the card company's side often shows the opposite.

The sign that matters is how QuickBooks will read the line in that account, not how the card statement prints it. A purchase of 45.00 needs to land as a charge, and a payment of 500.00 from your checking account needs to land as a credit to the card. If the first upload shows your payments as purchases, the file has the card company's signs, and the whole batch needs the same reversal as a reversed bank file.

Check the card payment from both sides. It leaves the checking account as a withdrawal and arrives in the card account as a payment. If both files were reversed, both sides are wrong in matching ways, and the transfer between the two accounts will still look balanced. Compare each account's ending balance with its own statement to catch it.