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
Learn More
- QBO - What is QBO (web connect) file format?
- QFX - What is QFX file/format and how to open it?
- OFX - What Is OFX File Format and How to Open it?
- QIF - What is QIF file/format and how to open it?
- QuickBooks - How to import transactions into Quickbooks
Related articles
- How to Convert Bank Statement PDF to CSV
- Convert PDF to OFX
- Convert PDF statements to a QuickBooks-compatible format
- Convert PDF to QFX and import into Quicken Classic
- Convert PDF to QIF and import into Quicken Classic, Banktivity, YNAB, MYOB
- Getting Started Notes
- How To Open Transaction Files In Excel