The fastest way to move multiple transactions at once

QuickBooks Online does not have a built-in "copy and paste" feature for entire transaction rows the way a spreadsheet does. Instead, you move multiple lines by selecting them individually, then using the duplicate or export function, or by copying transaction details manually between entries. The method you use depends on whether you are duplicating similar transactions, moving data between accounts, or transferring information to another program.

Most people trying to copy multiple lines are actually trying to do one of three things: duplicate a recurring transaction pattern, move line items from one transaction to another, or export data to work with elsewhere. Each has a different fastest route.

Key Takeaways

  • QuickBooks Online does not let you select and copy multiple transaction rows like a spreadsheet; you must duplicate transactions one at a time or use the recurring transaction feature.
  • To duplicate a single transaction with all its line items, open it, click the Copy button, and modify the date and account details before saving.
  • For transactions that repeat the same pattern, create a recurring template once, then generate copies automatically on a schedule you set.
  • To move line items between transactions, you must manually re-enter them or export the data to a spreadsheet, edit it there, and import it back.
  • The Batch Actions feature in QuickBooks Online lets you change categories or accounts for multiple existing transactions at once, but not copy them.

Duplicating a single transaction with all its lines

If you have one transaction with multiple line items and need to create an identical or similar one, the Copy button is the fastest method. Open the transaction you want to duplicate—whether it is an invoice, bill, check, or journal entry. Look for the Copy button in the top right corner of the transaction window, next to the Edit and Delete buttons.

Click Copy. QuickBooks creates a new transaction with all the same line items, accounts, and amounts. Change the date, customer or vendor name, or any other details that need to be different, then click Save and Close. This works for invoices, bills, purchase orders, checks, and journal entries. It does not work for transactions that are already marked as paid or closed.

Creating a recurring transaction template for repeated patterns

If you enter the same transaction pattern weekly, monthly, or on any regular schedule, a recurring template saves far more time than copying. Go to the Settings gear icon in the top left, then select Recurring Transactions. Click New and choose the transaction type—invoice, bill, check, or journal entry.

Fill in all the line items, accounts, and amounts exactly as they should appear each time. Set the frequency (weekly, monthly, quarterly, yearly, or a custom interval) and whether QuickBooks should create the transaction automatically or remind you to review it first. Save the template. From then on, QuickBooks generates a copy on the schedule you set, and you only need to adjust the date or amount if it changes.

This is the only way to truly automate copying multiple lines in QuickBooks Online. Manual copying works for one-time duplicates, but recurring templates handle the repetition.

Moving line items between two different transactions

QuickBooks does not let you cut and paste individual line items from one transaction to another. If you need to move a line from one invoice to another, or from a bill to a journal entry, you must manually re-enter it. Open the source transaction, note the account, description, and amount of the line you want to move, then open the destination transaction and type it in.

For larger batches of line items, export both transactions to a spreadsheet, edit them there, and import the corrected data back. Go to Reports, select the report type that shows your transactions (such as Transaction List by Date), filter to show only the transactions you need, then click the Export button. Open the file in Excel or Google Sheets, make your changes, save it, and import it back into QuickBooks using the Import Data tool under Settings.

Using Batch Actions to change accounts for multiple existing lines

Batch Actions is a feature that lets you modify multiple transactions at once, but it changes existing data rather than copying it. Go to the transaction list (such as Expenses or Sales), select the checkboxes next to the transactions you want to modify, then click Batch Actions at the bottom of the screen.

You can change the category, account, customer, or vendor for all selected transactions in one step. This is useful if you entered ten invoices to the wrong customer and need to reassign them, or if you categorized expenses incorrectly and need to move them all to a different account. It does not copy the transactions; it edits them in place.

Exporting multiple transactions to work with them outside QuickBooks

If you need to copy transaction data to Excel, Google Sheets, or another program, use the Export button on any report. Go to Reports, select the report that shows the data you need (such as Transaction List by Date, Profit and Loss, or Balance Sheet). Filter the date range and transaction types to show only what you want to copy.

Click the Export button (usually in the top right), choose Export to Excel or Export to CSV, and save the file. Open it in your spreadsheet program, make any changes you need, and save it. You can then import the corrected data back into QuickBooks if needed, or keep it in the spreadsheet for your own records or to share with an accountant.

Why QuickBooks Online does not work like a spreadsheet

QuickBooks is built around transactions, not rows. Each invoice, bill, or check is a single object with its own rules, approval workflows, and audit trail. Copying rows like a spreadsheet would break that structure and make it harder to track where money actually went. That is why QuickBooks forces you to duplicate entire transactions or use templates, rather than letting you grab random line items and paste them anywhere.

If you find yourself constantly wishing QuickBooks worked more like Excel, that is often a sign you should be using a spreadsheet for that particular task, or that your chart of accounts needs reorganizing so you do not have to move lines between transactions as often.

Frequently Asked Questions

Can I copy a line item from one invoice to another?

Not directly. You must manually re-enter the line item in the second invoice, or export both invoices to a spreadsheet, copy the row there, and import the data back. For a single line, manual entry is usually faster.

What is the difference between Copy and Duplicate?

In QuickBooks Online, Copy and Duplicate are the same thing. The button may say either one depending on the transaction type, but both create a new transaction with the same line items and accounts.

Can I select multiple transactions and copy them all at once?

No. You can select multiple transactions to change their category or account using Batch Actions, but you cannot copy them all at once. You must duplicate them one at a time, or create a recurring template if they follow a pattern.

How do I copy a transaction to a different company in QuickBooks Online?

QuickBooks Online does not have a built-in way to copy transactions between companies. You must export the transaction data from one company, import it into the other, and manually adjust any account numbers or customer names that differ between the two.

Can I copy a transaction that is already marked as paid?

No. You can only copy open or draft transactions. If the original transaction is closed or paid, you must create a new one from scratch or use a recurring template for future copies.