Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI'll guide you on how you can import journal entries from the spreadsheet, ddoran.
For now, importing journal entries from the spreadsheet is unavailable. As a workaround, you can enter the data manually or you can search and use a third-party application instead. This is one of the great ways so you can save time and reduce manual errors.
You can check out supported apps through our QuickBooks Apps Store or from the Apps menu.
To do so, here's how:
Furthermore, you may want to export some of your list reports to Excel, check out this article for the complete steps: Move Your List To QuickBooks Online.
Reach out to us if you need further assistance when importing journal entries. The Community is always right here to help you anytime.
Prepare your JE data with the following template
| RefNumber | TxnDate | PrivateNote | IsAdjustment | Currency | ExchangeRate | Account | LineAmount | LineDesc | Entity | Class | Location |
| 101 | 01/10/2020 | Wire Transfer | FALSE | Savings | -50.00 | Credit Savings | |||||
| 101 | 01/10/2020 | Wire Transfer | FALSE | Checking | 50.00 | Debit Checking | |||||
| 102 | 01/10/2020 | Wire Transfer | FALSE | Savings | 200.00 | Debit Savings | |||||
| 102 | 01/10/2020 | Wire Transfer | FALSE | Checking | -200.00 | Credit Checking |
then use an importer tool to proceed
https://get.transactionpro.com/qbo
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here