Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI would like to upload an Excel spreadsheet into a Quick Books journal entry. Is this possible?
I know a way to import your journal entries in QuickBooks Online, JRDAY.
As of now, we can only import deposits, checks, and payments in QuickBooks Online. As a workaround, I'd suggest using a third-party tool to import your journal entries. You can check for supported apps on our QuickBooks Apps Store page or from the Apps menu.
Here's how:
In the meantime, I'd recommend visiting our QuickBooks Blog site. From there, you can read the latest news and updates from QuickBooks including product improvements, company news, and a lot more.
You can also import your lists to QuickBooks Online. This saves you from having to set up the items from your lists one by one.
Please come back and keep us posted on your progress in importing your journal entries. It's my priority to enter the transactions successfully.
Utilize an importer tool
https:// transactionpro.grsm.io/qbo
Prepare the 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 |
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.