Journal Entry Import

This article will explain how to use the Import feature within the Journal Entry function in Softbase. This feature allows users to import an excel file containing GL Transactions, which can then be added to a Journal Entry.

To begin, use the provided Journal Entry Import example file to populate the Account Numbers, Amounts, Descriptions, and other relevant information that can be entered in a Journal Entry. Save this file on your local machine so it can be accessed when running Softbase. The headers in the file can be left in place.

Next, open the Journal Entry Window in Softbase from the Accounting Tab. Create a new Journal Entry by assigning the next Journal Number or manually entering one. Assign the Effective Date for the period in which you want the posting to be, and then select "Add" to create the Journal Entry Header.

Then, select the Import Button from the Journal Entry Window. From the dropdown menu, choose the first option if you do not want to add a decimal after the Account Number in the Import File. If you do want to add a decimal, select one of the other options and select "OK" when ready.

Next, choose the location of the Journal Entry Import file you created in step 1 from the Select File window and click "Open". This will import the file into Softbase, and you will see the imported lines in the Journal Entry Window data grid.

If any value imported is not recognized as valid by Softbase, it will be highlighted in red in the data grid. You can select that field to edit the value. Once the transaction is balanced, select the "Post" button from the Journal Entry Window to finalize the import.