Import Bypass AP Vendor Payments
Overview
The GoldFinch Import General Journal routine can be used to upload and validate the raw CSV data so that the Bypass AP Vendor Payments can be mass created and posted in GoldFinch.
This routine can be used to import the Company’s Credit Card expenses, Employee reimbursable expenses, and other ongoing expenses without going through the Accounts Payable module.
Prepare the Bypass AP Vendor Payments Template
Fill in the template. Sample data with instructions is available on the template to use as a guide.
Bypass AP Vendor Payments Import Template 052724.csv
Before you save the file, remove all rows before the column header row.
Save the file as a CSV.
Import the Bypass AP Vendor Payments Template
Open the App Launcher. Search for Import General Journals.
From the Bypass Vendor Payments 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.
Process Records
Once the values have been imported, you can review and update the data before the Vendor Payments are created.
In the Bypass Vendor Payments View, select Import General Journal(s) that have not been processed.
After selecting the records, click the Create Transactions button to process the data and create Vendor Payments.
GoldFinch creates a Vendor Payment Batch for each unique combination of Bank, Currency, and GL Ledger.
After Vendor Payments have been successfully created, the Processed field on the Import General Journal records will be checked and set to true.
After all Vendor Payments are created, create the Batch Post button on the Vendor Payment Batch page to post.
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.