The GoldFinch Import General Journal routine is used to upload and validate the raw CSV data so that the General Journals can be correctly created in GoldFinch.
Prepare General Journal Template
The General Journal template will be used to import the General Journals. Sample data is available on the template for you to use as a guide.
Make sure the total amount by Posting Date is zero.
Save the file as a CSV.
Import General Journal Template
Open the App Launcher. Search for Import General Journals.
From the General Journal View, select the Import CSV button.
Select Choose File, then browse to select the file to be imported.
Select Upload File.
The function will bring the data into the Import General Journal object.
Once the values have been imported, you can review and update the data before the General Journals are created.
In the General Journal View:
Select the individual Import General Journal(s).
After selecting the records, click the Create Transactions button to process the data and to create General Journals.
You can only select 200 lines at a time to create a General Journal. Make sure the total amount of every 200 lines is 0. Otherwise, you will have to update the General Journal field on General Journal Lines to combine them into one General Journal, so you can post.
After General Journals have been successfully created, the Processed field on the Import General Journal records will be checked and set to true.
If GoldFinch encounters any errors while creating a transaction from the Import General Journal records:
The Error will be populated into the Error Text field on the Import General Journal records.
Use the Error Text field to correct the Import General Journal records and resolve the errors.
Once all errors have been resolved, rerun the process by selecting the Import General Journal records and clicking the Create Transactions button.
If necessary, multiple Import General Journal records may be deleted at the same time:
Select the individual Import General Journal record(s) that you would like to delete.
Click the Mass Delete button to delete the data.