How to Import Deposits into QuickBooks: Desktop & Online (2026 Guide)

Importing deposits into QuickBooks is the process of recording funds received into your bank accounts, making reconciliation and reporting seamless. Whether you use QuickBooks Desktop or Online, deposits can come from customer payments, refunds, or other sources, and importing them in bulk saves time compared to manual entry.

However, errors can occur during import deposits into QuickBooks, such as “Error 3120: Invalid account mapping” or “Error 3140: Deposit amount mismatch”, which can disrupt your books if not resolved promptly. Proper preparation of your Excel or CSV files, correct mapping to bank accounts, and understanding the difference between payments and deposits are essential to prevent duplicate income and reconciliation issues.

Using tools like Dancing Numbers can simplify this process by automating mapping and offering safe undo options. In this blog post, we’ll discuss how to import deposits into QuickBooks Desktop and Online, prepare your files, handle errors, and use Dancing Numbers for faster imports.

The Golden Rule: Deposits vs. Payments (Avoiding Duplicate Income)

Before you start, you must understand one simple rule. Deposits and payments are not the same thing. Many users ignore this and later face duplicate income issues.

When you receive money from a customer, it is called a payment. When you move that money into your bank account, it becomes a deposit. If you record both separately without linking them, your income will be counted twice.

For example, if you receive Rs. 5,000 and then again import a Rs. 5,000 deposit, QuickBooks may show Rs. 10,000.

So, always be clear about this difference before you import deposits into QuickBooks. It will save you from major errors later.

Preparing Your Excel/CSV Template for Success

When you plan to import deposits into QuickBooks, your Excel or CSV file is the most important step. If the file is messy or incomplete, your import will fail or create wrong entries. A clean and well-structured file helps QuickBooks understand your data correctly. It also saves you time during mapping and reduces the chances of duplicate or incorrect deposits.

Required Fields: Date, Account, and Amount Mapping

To successfully import deposits into QuickBooks Desktop or Online, your file must include some basic fields. These fields tell QuickBooks where and how to place your data.

QuickBooks requires certain key fields for deposits to import successfully:

• Date: The date of the deposit in MM/DD/YYYY format.
• Account: The bank or cash account where the deposit should be recorded.
• Amount: The total deposit value.

Without these fields, QuickBooks may fail the import or create incomplete transactions. Ensure your spreadsheet clearly labels each column and formats data consistently.

Handling ‘Bank Fees’ and ‘Cash Back’ Deductions

Deposits often include fees or cash back that reduce the net amount received. To account for these:

• Include separate columns for Bank Fees and Cash Back.
• Deduct fees from the total deposit to match your bank statement.
• Map these amounts to the correct expense accounts in QuickBooks to maintain accurate reporting.

Date	Account	Amount	Bank Fees	Cash Back
04/05/2026	Checking Acct	1000	25	0

Tip: Properly formatting your file avoids common errors like “Error 3120: Invalid account mapping” or “Error 3140: Deposit amount mismatch” for a smooth import, whether you are using QuickBooks Desktop or Online.

How to Import Deposits into QuickBooks Desktop?

QuickBooks Desktop requires careful preparation and mapping because it lacks a native bulk deposit import feature. Let’s break down how to import deposits into QuickBooks Desktop step by step so you can avoid errors and save time.

Step 1. Open the Correct Company File

Before importing, ensure you are working in the right QuickBooks company file, especially if you manage multiple organizations.

• Launch QuickBooks Desktop.
• Verify the company file you are in matches the organization for which the deposit is intended.
• Switch files if necessary to avoid importing deposits into the wrong company.

Step 2. Navigate to the IIF Import Menu

QuickBooks Desktop uses IIF files for importing deposits, so you need to access the import utility first.

• Go to File < Utilities < Import < IIF Files.
• This menu allows you to locate and upload your formatted deposit file.

Step 3. Locate and Select Your IIF File

Make sure the IIF file you are importing is correctly named and prepared for QuickBooks.

• Find the file received from your donation system or banking source.
• Name the file as Bank Deposit-YYYY-MM-DD.DB.IIF.
  • YYYY-MM-DD represents the deposit date.
  • DB may vary if you have multiple databases.
• Select the correct file for import.

Step 4. Import the Data

Once your file is ready, you can bring it into QuickBooks Desktop.

• Click Open to start the import process.
• Wait for the notification that confirms successful import.
• The message “Your Data has been Imported” indicates the upload is complete.

Step 5. Verify Imported Deposits

Always check your deposits after import to ensure everything matches your records.

• Open the Bank Deposit screen in QuickBooks.
• Review deposit amounts, dates, and accounts.
• Confirm that no data is missing or misallocated.

Native Limitations of QuickBooks Desktop Imports

QuickBooks Desktop does not support direct Excel or CSV deposit uploads, which can make importing deposits tricky.

• Only IIF files are natively supported for bulk imports.
• No preview or mapping tool is available, increasing the risk of errors.
• Mistakes cannot be easily undone; backing up your company file is essential.
• Users often encounter errors like “Invalid Account Reference” if account names don’t match exactly.

Setting Up the Chart of Accounts for Deposit Mapping

Before you start the import process, you must check your Chart of Accounts. This is a critical step that many users skip, which later causes errors.

Deposits must be assigned to the correct bank and income accounts in QuickBooks Desktop.

• Confirm that the bank account exists in the Chart of Accounts.
• Make sure income and other “Received From” accounts are already set up.
• Match the account names in your spreadsheet exactly with QuickBooks.
• Categorize any fees or deductions under the correct expense accounts.

How to Import Deposits into QuickBooks Online from Excel/CSV?

If you’re planning to import deposits into QuickBooks Online from a CSV file, it requires a clear sequence of steps to ensure transactions are mapped correctly and recorded in the right account.

Step 1. Open QuickBooks Online and Access Banking

Before uploading your deposits, you need to log in and navigate to the banking section where deposits are managed.

• Log in to your QuickBooks Online account.
• Locate the Banking section in the left corner of the screen.
• Click on the Banking button to open the transactions interface.

Step 2. Initiate the File Upload Process

QuickBooks Online allows CSV uploads through the Banking menu, which you need to access before selecting your file.

• Click on the Update drop-down list.
• Select File Upload from the options.
• If no connected accounts appear, click on Upload deposits/transactions manually.

Step 3. Select Your CSV File

Once the upload interface is open, you need to choose the correct CSV file containing your deposit data.

• Click Browse to locate your CSV file on your computer.
• Select the file and click Open to upload it into QuickBooks Online.

Step 4. Map Deposits to the Correct Bank Account

Before importing, QuickBooks needs to know which account the deposits belong to.

• Click Next after selecting your file.
• From the drop-down labeled Account, choose the bank account where the deposits should be recorded.
• Place a check mark on the box labeled Transaction to confirm the data.

Step 5. Begin the Import Process

Once the CSV is mapped to the correct account, you can start importing the deposits.

• Click Next to proceed.
• Hit Yes to confirm and begin the import process.
• Wait for the import to complete; larger files may take a few minutes.

Step 6. Verify Imported Deposits

After import, reviewing deposits ensures that your data matches your bank records and there are no errors.

• Open the Bank Deposit or Banking section to see the uploaded transactions.
• Confirm that deposit amounts, dates, and accounts are correct.
• Correct any mismatched deposits before reconciliation.

Mapping CSV Columns to the QBO “Bank Deposit” Screen

Mapping tells QuickBooks what each column in your CSV represents before final import.

• After selecting your CSV, QuickBooks will ask you to map columns.
• Match your spreadsheet’s columns (Date, Amount, etc.) to QBO deposit fields.
• Carefully check Deposit To Account so the funds go to the right bank account.
• Confirm previewed transactions look correct before finishing.

Managing Multi-Factor Authentication (MFA) During Data Uploads

Security measures like MFA can appear while accessing QuickBooks Online or linked bank data.

• If prompted, complete the MFA challenge (email, app, SMS, or authenticator).
• MFA may appear when connecting bank accounts or accessing certain upload features.
• Ensure you have access to your authentication device before importing.
• Completing MFA helps protect your financial data while uploading deposits.

Import Deposits into QuickBooks Online using Dancing Numbers Online

Dancing Numbers Online streamlines the deposit import process, allowing you to upload, map, and import transactions into QuickBooks Online in bulk, saving time and avoiding errors.

Step 1: Open Dancing Numbers Online

Begin by accessing the Dancing Numbers platform to prepare your deposit import.

• Open your web browser and go to Dancing Numbers Online.
• Log in using your QuickBooks Online credentials if prompted.
• Ensure your QuickBooks Online account is connected to Dancing Numbers.

Step 2: Navigate to the Import Section

Dancing Numbers separates its tools into import, export, and delete functions for easy navigation.

• On the dashboard, locate the Import section.
• Click on Start under the Import box to begin the deposit upload process.

• Select the Transactions option.
• Go to the Banking and Others section and click on Deposits

Step 3: Select the File to Import

Choose the deposit file you want to upload to QuickBooks Online.

• Click Please Select your File.
• Browse and select the CSV or Excel file containing your deposit data.
• Click Import to confirm your file selection.

Import Deposits into QuickBooks Desktop using Dancing Numbers

If you are using QuickBooks Desktop, the manual import process can feel technical and time-consuming. This is where tools like Dancing Numbers make things much easier. They simplify complex steps and help you import deposits into QuickBooks Desktop quickly and accurately, even if you are working with large datasets.

Here are the steps to import Deposits using Dancing Numbers Desktop. Before this, make sure you have taken subscription and connect it with Intuit.

• Open Dancing Numbers Desktop by double clicking on its app logo.
• Now, Click on Import.

• From the Transaction section, click Deposits in the Banking menu.
• Upload your File.
• Now, you start field mapping to ensure the columns of your file match the exact fields of QuickBooks Desktop.
• You will get a file preview, check if all the data required is present. If yes, click on Next.
• Lastly, click on Import, and now you will get notified when the import is successfully completed.

Troubleshooting ‘Error 3120’ and ‘3140’ During Desktop Import

If you plan toimport deposits into QuickBooks Desktop, you might encounter Error 3120 or Error 3140. These are common issues related to file format, missing accounts, or incorrect data.

Error 3120

Error 3120 occurs when QuickBooks Desktop detects a missing or incorrect header in your IIF or Excel file, or when the deposit data does not match the expected format.

• Check that your import file includes required headers like DATE, ACCOUNT, AMOUNT, and CUSTOMER if applicable.
• Make sure all account names in your file match exactly with the QuickBooks Chart of Accounts.
• Avoid special characters or extra spaces in account names.
• If using IIF files, ensure the file is not corrupted and follows QuickBooks Desktop’s formatting rules.

Error 3140

Error 3140 usually appears when the import references a non-existent customer, account, or class in QuickBooks Desktop.

• Verify that all customers, accounts, and classes referenced in your file already exist in QuickBooks Desktop.
• Correct any mismatched names in your Excel/IIF file.
• Ensure that split deposits are properly formatted and assigned to valid accounts and classes.

---

Frequently Asked Questions