Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello there, @sreedhar-a-oremu. I'm here to share details as to how you can import journals in QuickBooks Online (QBO).
QBO has multiple ways of importing transactions. One of these is to import an Excel file. However, it's currently limited to customers, suppliers, accounts, bank data, and products and services.
With this, I'd recommend looking for a third-party app and integrating it to QBO so you can import your journals. Visit the Apps menu's Find Apps tab to find the appropriate one that best suits your business needs.
Once you're done, you can pull up the Journal report from the Reports menu's Standard tab. It lets you view all your journals within a specific period.
Also, to answer the most frequently asked questions about importing information to QBO, I would encourage you to check out this article: Importing Data Overview.
I'm always around to help if you have other importing concerns and questions about managing transactions in QBO. Enjoy the rest of your day, @sreedhar-a-oremu.
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 utilize an importer tool
https://transactionpro.grsm.io/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