Quickbooks Accountant Batch Entry
This tutorial shows how to do quick Batch Entry in the Quickbooks accountant edition. You can create transactions in Excel, copy and paste into the Batch Entry form, or use the ProperConvert app that can extract transactions from PDF, QBO, QFX, OFX, QIF, CSV, Excel, Mt940 files and copy formatted data into the clipboard ready to paste in Quickbooks (in the converter app, click on the CSV tab and select the target as a batch entry.
To open the Batch Entry form, in Quickbooks Accountant edition, select Accountant, Batch Enter Transactions. There are different transaction types:
- Checks,
- Deposits,
- Credit Card Charges
- Credits
So if you have data in Excel and you format data in an expected way, like Dates, expected Date format, Payee, Account, Amount, Memo. Then you can copy from Excel and paste it here without using the tool. But if you have something like OFX format or PDF, you cannot really do that, but with the ProperConvert you can do it. All you have to do is the following:
- Start the ProperConvert app
- Load a file with Transactions
- Click On the CSV tab on the right sidebar
- Set the CSV target as "QuickBooks Batch CCard"
- Click the Convert button to save formatted data in the clipboard
- Switch to Quickbooks Batch entry and press CTRL+V to paste data
- Save created transactions in Quickbooks