Skip to main content
Skip table of contents

Import General Journals

Overview

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.

GJ Import Template 090123.xlsx

Save the file as a CSV.

Import General Journal Template

  1. Open the App Launcher. Search for Import General Journals.

  2. From the General Journal View, select the Import CSV button.

  3. Select Choose File, then browse to select the file to be imported.

  4. Select Upload File.

The function will bring the data into the Import General Journal object.  

Process Records

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.

Error Resolution

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.

Mass Delete

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.