Accountant tools: Batch enter transactions

If you want to copy multiple transactions (checks/cheques, deposits, etc…) from one company file to another, use the enter batch transactions feature in QuickBooks Desktop. This feature can help you save and manage your time efficiently.

To get started, follow these steps in the order shown.

1. From the Accountant menu, select Batch Enter Transactions.
2. From the Transaction Type drop-down, choose the transaction you need to enter. In all supported versions of QuickBooks, you have the option to enter multiple Cheques, Deposits, Credit card charges or credits, Invoices, Credit memos, Bills and Bill credits
3. Select the appropriate bank/credit card or AR/AP account from the drop down arrow. You can also choose Add New to set up the account.
4. Open the spreadsheet containing the transactions to paste into QuickBooks.
5. Arrange the columns in your spreadsheet to match the column order in the QuickBooks Batch Enter Transactions screen.
6. Highlight the transactional information, right-click it and select Copy.
7. In the Batch Enter Transactions screen in QuickBooks, right-click the first date field in the list and select Paste.
8. The information from the spreadsheet displays in the Batch Enter Transactions screen.
9. Continue adding all transactions.
10. Select Save Transactions then Yes to save.
11. A window displays the number of transactions saved. Select OK to finish the import.

You cannot export batch transactions but you can copy multiple transactions from one company file to another in a form that can be imported using the enter batch transactions feature.