Import Documents

To enter payment and transaction details for documents, upload files must be created or downloaded for the required document type.

Some document types have a specific comma-separated values (CSV) template and Status Quo Function (SQF) file that must be used. Where required, the files are included in the help centre topics or available from our Support team.

Before Importing Documents

If upload files are not provided for a document type, the CSV template and SQF file must be created.

For document types that have specific SQF and CSV upload files:

  1. Download:
    • The required comma-separated values (CSV) template for the document type
    • The required document type Status Quo Function (SQF) file
  1. In the CSV template:
    1. Enter all the payment or transaction details for the documents.
    2. Delete the column headings row.
    3. Save a copy of the CSVfile with a meaningful name.

Upload Document Details

  1. Go to Options, then select Import....
  2. Upload the SQF file, select Format File.
  3. Choose how to process documents with errors, either:
    • Post documents with errors to the hold database — in Post details to, select Errors To Hold.
    • Do not post documents and display error details in a report — clear selection of Errors To Hold.
  4. Set Section to Document Detail Postings.
  5. To upload the copy of the document template with the payment or transaction details, select Data File.

  6. Check the details in Sample match the data expected for the Column Name.

    If the details do not match, change the order of the columns in the data file, then upload it again.

  7. To confirm the details match the expected data, select Save.
  8. Import the document details file.