How to convert Quickbooks (QBO) Journals to SoftLedger Journals

Created by Travis Lander, Modified on Thu, 28 Apr, 2022 at 7:35 PM by Travis Lander

Description

If you are upgrading to SoftLedger from Quickbooks (QBO), read through the process and example file in this article to convert your historical journal transactions to the SoftLedger Upload Template to bring in historical activity. Be sure to also review the Beginning Balance article if choosing to start from a point in time rather than importing historical journals. You can do a combination approach of entering beginning balances from a point in time, e.g. start of the fiscal period, as well as converting journal entries from that point in time forward via this approach.


Gather and Export QBO Journals

From Quickbooks, be sure to export the journals with as much details as possible to be sure to have all fields necessary to be able to populate the required fields in the SoftLedger upload format. See this article from QBO in reference how to export journals.


Convert to the SoftLedger Format

Once you have the detail from QBO, the next step is to take the journals and convert them into the SoftLedger Journal format for bulk upload. 


Be sure that you have set up your SoftLedger system with your Locations, Accounts, and any other details (e.g. Cost Center), that you wish to tag journal entries with prior to completing this process.



See the below file that includes example journal data converted to the SoftLedger import format. This example file was set up using the below process:


Download the Example QBO to SoftLedger Journal Conversion File


  1. On the Journal tab (QB report) , create formulas (highlighted in orange) to complete the blank journal rows
  2. Copy these to the SL Template tab, determining which columns to use in which places (e.g. Date to Date fields)
  3. Add filters to the SL Template tab and filter on the Date field for "Blank" rows, which you can then delete before the file will be ready for upload


Note: All columns highlighted in YELLOW are required for the SoftLedger Journal Upload, see this SL Bulk Upload article for more details.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article