We only migrate GL balance from previous year to QB currently. Going forward we want to migrate GL balance + transaction details of each account on QB. How to do that and is there a .csv format available for migration?
Nice to see you here in the Community, @ID1607. I'll share some steps to help you migrate your data transactions into QuickBooks.
Your QuickBooks Online reports and lists can be exported in simple ways. The information you add to your file can therefore be readily downloaded to your local hard disk.
Though, you can export them into individual Excel files contained in a zip format in one process.
Reports: General Ledger, Profit and Loss, Balance Sheet, Trial Balance, Journal.
Lists: Customers, Employees, Suppliers.
To export your report or list:
You'll be prompted with confirmation that the data has been exported. If you need to export a different report, here's how to export reports to Excel. For more details, open this article: Export data, reports, lists, and more from QuickBooks Online. It also contains steps on how to export non-posting transactions.
Another option that you may wish to consider is using a third-party application, which can integrate with the software. You can browse available apps at the following link: QuickBooks Apps.
For your banking transactions, you can upload the data via CSV file. QuickBooks supports a 3 or 4-column format for your banking data. For more information and detailed instructions, please go to this link: Import bank transactions using Excel CSV files.
After checking the format, you can follow these steps to import:
For complete instructions on how to upload your data, see this article: Manually upload transactions into QuickBooks Online.
I've attached an article about importing transactions, like how to fix bank upload errors in QuickBooks:
If you need assistance with exporting transactions, click the Reply button and post a comment. I’ll get back to help you. Have a wonderful day ahead.
Nice to see you here in the Community, @ID1607. I'll share some steps to help you migrate your data transactions into QuickBooks.
Your QuickBooks Online reports and lists can be exported in simple ways. The information you add to your file can therefore be readily downloaded to your local hard disk.
Though, you can export them into individual Excel files contained in a zip format in one process.
Reports: General Ledger, Profit and Loss, Balance Sheet, Trial Balance, Journal.
Lists: Customers, Employees, Suppliers.
To export your report or list:
You'll be prompted with confirmation that the data has been exported. If you need to export a different report, here's how to export reports to Excel. For more details, open this article: Export data, reports, lists, and more from QuickBooks Online. It also contains steps on how to export non-posting transactions.
Another option that you may wish to consider is using a third-party application, which can integrate with the software. You can browse available apps at the following link: QuickBooks Apps.
For your banking transactions, you can upload the data via CSV file. QuickBooks supports a 3 or 4-column format for your banking data. For more information and detailed instructions, please go to this link: Import bank transactions using Excel CSV files.
After checking the format, you can follow these steps to import:
For complete instructions on how to upload your data, see this article: Manually upload transactions into QuickBooks Online.
I've attached an article about importing transactions, like how to fix bank upload errors in QuickBooks:
If you need assistance with exporting transactions, click the Reply button and post a comment. I’ll get back to help you. Have a wonderful day ahead.
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