1 of 5
Batch Entry QuickBooks
2 of 5
Batch Transaction Dialog Box
In the Enter Batch Transactions dialog box, right click your cursor in the first field you want to post, then select Paste from the right click menu, your data from Excel will populate the grid. In this example my cursor is in the Date field.
3 of 5
Click The Customized Columns Button
Click the Customized Columns button to open dialog box that allows you to select and order the columns of data you wish to paste into QuickBooks. You need to insure that your columns are in the exact same order as the columns of your Excel spreadsheet.
4 of 5
Fields With Missing Data
For any fields with missing data, begin typing or use the dropt-down for the proper information for the field. The field displayed below is Account so QuickBooks will display available names in the list.
5 of 5
Review Bank Account Register
Review your bank account register to verify the newly added transactions.