To batch enter transactions in QuickBooks Desktop, open Accountant > Batch Enter Transactions, pick the transaction type and the bank or card account, then paste rows copied from Excel into the grid. Review every row on screen before you choose Save Transactions. The tool is part of Desktop Accountant and Enterprise, not Pro or Premier.
Which Desktop editions have Batch Enter Transactions?
Batch Enter Transactions comes with QuickBooks Desktop Accountant and QuickBooks Desktop Enterprise. Intuit's help article on batch entering transactions names those two and no others. If your Desktop has no Accountant menu, you probably do not have the tool.
The quickest test takes a few seconds. Open your company file and look along the menu bar. If there is an Accountant menu with Batch Enter Transactions on it, you are set. If not, you are on a version without it, and the rest of this post explains what to do instead.
Without the Accountant menu
Pro and Premier users still have two routes for a pile of bank lines. The first is a Web Connect file, which brings the lines into the Bank Feeds Center for review and matching. The second is typing each item into the register or the Write Checks and Make Deposits windows. For more than a couple of dozen lines, the file route is usually the better use of time.
Asking your accountant
Accountant edition users can open a client's file, so another option is to send the spreadsheet to your accountant and let them batch enter it. If you go this way, agree in advance on which bank or card account the rows belong to and what date range they cover.
Transaction types the Batch Enter window accepts
The Batch Enter window takes checks, deposits, credit card charges and credits, invoices, credit memos, bills and bill credits, according to Intuit's batch entry article. You choose one type per batch. A month of mixed bank activity therefore goes in as at least two batches: one of checks and one of deposits.
The split matters when you plan the spreadsheet. A bank statement mixes money out and money in on one list. Before you copy anything, sort the rows by direction and keep them on separate tabs. Money out becomes a batch of checks against the bank account. Money in becomes a batch of deposits. Card statements follow the same rule, with charges in one batch and credits, such as refunds, in another.
Which type fits which bank line
| Statement line | Batch type | Account to pick | Example row |
|---|---|---|---|
| Debit card purchase from the checking account | Checks | Business Checking | 03/04/2026, Office Depot, 86.40 |
| Customer payment received by transfer | Deposits | Business Checking | 03/06/2026, Example Client LLC, 1,200.00 |
| Purchase on the business card | Credit card charges | Business Visa | 03/09/2026, Example Airline, 412.00 |
| Refund on the business card | Credit card credits | Business Visa | 03/12/2026, Example Airline, 412.00 |
The values are examples. A debit card purchase goes in as a check even though no paper check exists, because in Desktop a check is simply a payment out of a bank account. If you want the detail on numbering and payees for paper checks, importing checks into QuickBooks Desktop with check numbers covers it. For grouping several customer payments into one bank deposit, importing deposits into QuickBooks Desktop correctly explains how deposits relate to undeposited funds.
Ordering Excel columns to match the Batch Enter grid
The spreadsheet's columns must be in the same order as the columns in the Batch Enter grid, because a paste fills the grid from left to right with no mapping step. Open the Batch Enter window first, note its column order for the type you picked, then rearrange the sheet to match before you copy anything.
Intuit's article puts it simply: arrange your spreadsheet columns to match the order on the screen. There is no step where Desktop asks which column is the date. If the amount column sits where the payee column should be, the grid takes your amounts as payee names.
An example checks layout
For a batch of checks, a sheet laid out like the example below lines up with a typical grid. Confirm the order against your own screen, because the columns shown can differ by type and version.
| Date | Number | Payee | Account | Amount | Memo |
|---|---|---|---|---|---|
| 03/04/2026 | Office Depot | Office Supplies | 86.40 | Toner | |
| 03/05/2026 | 1042 | Example Landlord LLC | Rent Expense | 2,400.00 | March rent |
| 03/11/2026 | Example Telecom | Telephone Expense | 129.99 | Phone and internet |
All values are made up. Leave the number blank for card purchases that have no check number.
Cleaning the sheet before you copy
A few small fixes stop most paste problems:
- Amounts as plain numbers. Remove currency symbols and keep the amount positive. The batch type already says whether money is going out or coming in.
- Dates Desktop can read. Use the date format your computer's regional settings use, and check that every cell holds a real date rather than text.
- Accounts copied from the chart. Copy account names from your chart of accounts so they match exactly, subaccounts included.
- Payees that exist or can be added. A payee name not in your lists will need to be added during the save, so check spelling to avoid near-duplicates such as "Office Depot" and "OfficeDepot".
- No header row in the copy. Copy the data rows only, not the column titles.
Pasting and saving a batch of checks, deposits and card charges
Pasting a batch takes seven steps: back up, open Batch Enter, choose the type and account, copy the rows in Excel, right-click the first date cell and paste, review the grid, then save. Desktop reports how many transactions it saved. Work through one type at a time, finishing checks before you start on deposits.
The steps
- Back up the company file. Batch entry writes real transactions to your books, and a backup is the clean way back.
- Open the window. Choose Accountant > Batch Enter Transactions.
- Pick the type and the account. Choose the transaction type, such as Checks, then the bank or card account. Intuit's article notes you can use Add New if the account does not exist yet.
- Copy the rows in Excel. Select the data rows only and copy them.
- Paste into the grid. Right-click the first date field in the Batch Enter window and choose Paste. The rows fill the grid.
- Review on screen. Read down each column. Look for blank account cells, payees you do not recognize and amounts in the wrong column, and fix them in the grid.
- Save. Choose Save Transactions and confirm. Desktop shows how many transactions it saved. Choose OK.
Checking the result
After the save, open the bank or card register for the same dates. Count the new lines and compare the total to the spreadsheet. If the sheet held 48 checks totalling 9,315.27, the register should show 48 new payments adding up to the same figure. Then run a quick report by expense account to see that each row landed on the account you intended.
Card charges deserve one more check. If the card is also set up for downloads, read downloading credit card transactions into QuickBooks Desktop before you batch enter a period the download will also cover.
What happens when batch entered checks later arrive in a bank download?
A bank download that covers the same dates brings the same transactions in again. Desktop's Bank Feeds Center tries to match downloaded lines to items already in the register, and a batch entered check with the same amount and a close date is often offered as a match. Accept matches rather than adding the downloaded line as new.
Matching is not guaranteed. A check entered on March 4 that cleared the bank on March 9 has a five-day gap, and a check with no number has less to match on. When Desktop offers to add a line you already entered, stop and look for the existing item first. Adding it creates a duplicate that the next reconciliation will expose.
Picking one source per period
The cleanest rule is to choose one source for each account and period. If you batch enter January from a spreadsheet, start bank downloads from February 1. If downloads already cover January, use batch entry for something the bank does not send, such as paper checks written but not yet cleared.
When downloads fail instead
Sometimes people turn to batch entry because the bank download stopped working. If Desktop showed a sign-in error from the bank, QuickBooks error 103 and a rejected bank sign-in covers the cause. Fixing the connection may save you from typing a month of lines at all.
Batch entry slips that post to the wrong bank or card account
The most expensive batch entry mistake is choosing the wrong account at the top of the window. Every row in the batch then posts to that account, so a month of card charges can land in checking. Read the account name back before you paste, and again before you save, since one choice decides where the whole batch goes.
Other slips to watch for
- Mixed directions in one batch. A deposit pasted into a checks batch becomes a payment, doubling its effect on the balance. Sorting by direction first prevents this.
- Shifted columns. One missing column in the sheet shifts everything to its right. If memos show up as account names, the sheet is one column short.
- Rows saved twice. Saving, then pasting the same rows again into a fresh batch, posts them twice. Clear the sheet tab or mark it done once a batch is saved.
- The wrong year. Dates typed without a year can pick up the current year. Check the first and last date in the grid against the statement period.
Undoing a bad batch
Intuit's batch entry article does not describe an undo for a saved batch. Treat the backup as the undo. If only a few rows are wrong, fix or delete them in the register. If the whole batch went to the wrong account, restore the backup and run the batch again. Also note that the same article says batch transactions cannot be exported, so keep the spreadsheet as your record of what went in.
When the rows start in a PDF
Batch entry assumes the transactions already sit in a spreadsheet. If yours are on a PDF statement, getting them out is the slow part. SimpleBankConvert is being built to turn PDF bank statements into import files with money in and money out in one signed amount column, so splitting checks from deposits becomes a single filter. It is not open for accounts yet.