# Import Payments into QuickBooks Online Against Invoices

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: Invoices, bills and lists
- Canonical: https://simplebankconvert.com/blog/import-payments-into-quickbooks-online

> How to import payments into QuickBooks Online so each customer payment closes the right invoice, plus the bank deposit match that follows.
There is no built-in file option to import payments into QuickBooks Online against open invoices. You record each one with the Receive payment form, use an app from the QuickBooks app store, or match bank deposits to invoices. Whichever route you take, every payment must point at a specific invoice, or the invoice stays open.

## Is there a payments option on the QuickBooks Online Import data screen?

No. The Import data screen covers lists and a set of transaction types, and customer payments are not one of them. Intuit's [common questions about importing data to QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/common-questions-importing-data-quickbooks-online/L4OYJRFdj_US_en_US) lists what can come in from a file, and receive-payment records are absent from that list.

That list does include invoices, bills, journal entries, deposits and purchase orders. People who have just loaded a year of invoices often expect the payment side to work the same way, and it does not. The upload you used for invoices has no partner for the money that settled them. The purchase order upload is a good contrast: the guide to [importing purchase orders into QuickBooks Online](/blog/import-purchase-orders-into-quickbooks-online) shows a transaction type that does have a file route, with its own columns and limits.

### Why a payment is harder to import than an invoice

An invoice stands on its own. It has a customer, a date and lines. A payment is a link between two things: the money received and one or more open invoices. A file import would need to say which invoice each dollar settles, how much of it, and where the money went next. That extra layer is why Intuit leaves payments to the form and to connected apps.

### QuickBooks Desktop is different

Desktop users work with a different set of file imports, built around older formats and with less checking of what goes in. If you work in both products, the guide to [importing purchase orders into QuickBooks Desktop](/blog/import-purchase-orders-into-quickbooks-desktop) walks through how Desktop's file imports behave and what they skip checking.

## Three routes for getting invoice payments into QuickBooks Online

Invoice payments reach QuickBooks Online by one of three routes: typing each one into the Receive payment form, using a third-party app that writes payments through Intuit's connection, or matching incoming bank deposits to open invoices. The right one depends on how many payments you have and how much detail you already hold in a spreadsheet.

| Route | Good fit | What you need first |
| --- | --- | --- |
| Receive payment form, one at a time | Up to a few dozen payments a month | A list of who paid, how much and for which invoice |
| App from the QuickBooks app store | Hundreds of payments, or the same file every month | The app's own template, plus time to test it on a copy |
| Matching bank deposits to invoices | Each payment arrives in the bank as its own deposit | Bank lines in QuickBooks, by feed or by file |

The table is a starting point, not a rule. A business with thirty checks a month that all arrive in one deposit might still use the form, because the bank shows only one line for all thirty.

### Testing an app before you trust it

If you choose an app, run it on a handful of payments first. Open each invoice afterwards and confirm the balance due dropped by the right amount. Apps differ in how they treat a payment that names no invoice: some apply it to the oldest open invoice, some leave it as a credit. Know which before you load a full month.

## A payment list laid out against open invoices

A payment list is a spreadsheet with one row per payment-to-invoice pairing. It needs the customer name, the payment date, the amount, the payment method, a reference such as a check number, and the invoice number it settles. A payment that covers two invoices takes two rows sharing the same reference.

Here is an example list for one week. The names and figures are made up for illustration.

| Customer | Payment date | Method | Reference | Invoice | Amount applied |
| --- | --- | --- | --- | --- | --- |
| Pine Hollow Vet Clinic | 04/06/2026 | Check | 5512 | 2207 | 1,200.00 |
| Pine Hollow Vet Clinic | 04/06/2026 | Check | 5512 | 2214 | 300.00 |
| Ridgeway Florist | 04/07/2026 | ACH | RF-0407 | 2210 | 845.50 |
| Calder Street Gym | 04/08/2026 | Check | 1093 | 2212 | 400.00 |

The first two rows are one check for 1,500.00 that settles two invoices. Kept like this, the list answers every question the Receive payment form will ask. It also makes the later bank match easy, because you can total any group of rows and compare it with a deposit.

### Partial and short payments

A customer who pays less than the invoice total is common. Put the amount actually received in the list and leave a note on the row. When you record it, QuickBooks keeps the rest of the invoice open. Do not round the figure to the invoice total to make the sheet tidy; the open balance is the true state of that account.

## Recording each customer payment with the Receive payment form

The Receive payment form is where a customer payment meets its invoice in QuickBooks Online. You pick the customer, enter the amount, choose the deposit account and tick each invoice the money pays. Intuit's guide to [recording invoice payments in QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/invoicing/record-invoice-payments-quickbooks-online/L4ZadDW7F_US_en_US) gives the full sequence.

Working from the payment list above, the steps for one payment are:

1. Select + Create, then Receive payment.
2. Choose the customer exactly as named in the list.
3. Set the payment date and payment method, and type the check number or other reference.
4. Pick the deposit account. The next section explains the choice.
5. Enter the total received in Amount received.
6. Under Outstanding Transactions, tick each invoice this payment covers.
7. If the money covers less than the ticked invoices, adjust the figures in the Payment column so they add up to the amount received.
8. Save the payment (Intuit's guide shows Record and close), then move to the next row of your list.

Intuit notes that when you tick several invoices, the open balance of each one fills the Payment column. That default is right for a payment that clears them all. For a short payment it overstates what was paid, which is why step 7 matters.

### Speeding up a long list

Sort the list by customer before you start. With all of one customer's rows together, the form stays on the same name and you only change the invoices you tick. Mark each row as done in the spreadsheet as you save it, so an interruption does not leave you guessing where you stopped.

## Undeposited Funds or the bank account for a recorded payment?

The deposit account on a payment should mirror how the money reached the bank. If the bank shows each payment as its own deposit, send the payment straight to the bank account. If several payments went to the bank together on one deposit slip, send them to Undeposited Funds and combine them afterwards in a bank deposit.

Intuit describes [the Undeposited Funds account](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-deposits/whats-undeposited-funds-account/L6Jan3iRK_US_en_US) as a holding place for payments you plan to combine before they go to the bank. Its own example is five checks of 100 recorded separately, then grouped so QuickBooks shows the single 500 deposit the bank shows.

### A worked three-check deposit

Here is an example using the payment list. The figures are illustrative.

- The check from Pine Hollow Vet Clinic for 1,500.00 and the check from Calder Street Gym for 400.00 went to the bank together on April 9.
- The ACH from Ridgeway Florist for 845.50 arrived on its own on April 7.

The two checks go to Undeposited Funds when you record them. On April 9 you create a bank deposit, tick both, and save it for 1,900.00. The bank statement shows one 1,900.00 deposit, and it matches. The ACH payment goes straight to the checking account when you record it, so it matches the 845.50 bank line without a deposit step.

The trap is mixing the two habits. Payments left sitting in Undeposited Funds never meet a bank line, and the account balance grows month after month. A quick look at that balance at month end tells you whether anything is stuck.

## Customer payments counted twice through categorized bank deposits

The most common mistake with customer payments is recording the income twice. It happens when a payment is entered against its invoice and the matching bank deposit is also categorized as income during bank review. The invoice income is then counted once from the invoice and again from the deposit.

When a bank line arrives for money you already recorded, it should be matched, not categorized. QuickBooks often offers the match itself when the amount and date line up with a recorded payment or bank deposit. If it offers a category instead, look for the payment before you accept. A deposit that matches nothing yet may be a payment you have not recorded, which is the cue to go back to the form, not to post it to a sales account.

### Spotting double income after the fact

The symptom is an income report that looks too high while accounts receivable looks too low, or a customer with invoices marked paid and a bank deposit in a sales account for the same amount. Run a report of deposits categorized to income accounts for the period and compare each one with your payment list. Any amount that appears in both is a duplicate.

### Cleaning up a bad bank import

Sometimes a whole month of bank lines went in and was categorized before anyone recorded payments. Undoing each categorized line is the careful fix. If the bank upload itself was wrong, with the wrong account or the wrong dates, starting that bank account over can be quicker; the guide to [deleting all bank transactions in QuickBooks Online](/blog/delete-all-bank-transactions-in-quickbooks-online) explains what that removes and what it leaves.

### Where the bank lines come from

Matching only works when the bank side is present and complete. Most people get it from a bank feed or a file their bank offers. If a client only has PDF statements, [SimpleBankConvert](/) is being built to turn those statements into a CSV or QBO file for the QuickBooks Online bank upload, which would give each recorded payment a deposit line to pair with.