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.

You are not allowed to post directly to GL Accounts defined on the Company Setup that have sub-ledgers associated with them. These GL Accounts are:

• Account AR

• Account AP

• Account Finished Good Inventory

• Account Subassembly Inventory

• Account Raw Material Inventory

• Current Year Earnings

• Retained Earnings

You must use Sales Invoices, Purchase Invoices, or Item Journals to adjust the GL Accounts balance for these accounts. Read Company Setup for more field help.

If you are importing the “beginning trial balance”, follow these steps:

1. Replace those “system” GL Accounts on the Company Setup with a dummy GL Account.

2. Post the General Journal.

3. Populate these GL Accounts again.

4. Delete the dummy GL Account.

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.