Paid Invoices Import

Summary: This article explains what the Paid Invoices Import is for and the steps required to perform the import.

 


Paid Invoices Import

Use the Paid Invoices Import to import invoices that were paid outside Vantaca. Vantaca creates an Action Item for each imported invoice, so you can maintain accurate books without manually entering each externally paid invoice.

Note: Unlike other imports, the Paid Invoices Import cannot be reversed on the front end. Contact Vantaca Support for assistance with reversal.

 

Creating an Import

Note: You'll need the Append permission under Settings > Roles > Import > Paid Invoices to perform the import.

  1. Navigate to Settings > Imports > Imports.
  2. Click +New Import.
  3. Select the Paid Invoices Import Type.

The only available Import Mode is Append.

  1. Select an Invoice Category Action Type from the Action Type dropdown.
    This dropdown doesn't display Invoice Category Action Types that don't have a deleted Prepaid Expense Additional Step.
  2. Upload the import file. The following fields can be imported:
  • AssocCode: Required column and field
  • ServiceProviderID: Required column and field
  • BankAccountID: Optional column
  • GLCode: Required column and field
  • GLDetailDescription: Optional column and field
  • Fund: Optional column and field
    Note: Defaults to Operating if left blank.
  • Amount: Required column and field
  • PaidDate: Required column and field
  • InvoiceNo: Required column and field
  • CheckNo: Required column
  • PayType: Required column
    Note: If left blank, defaults to Misc Check upon import.

Important: Enter the PayType that matches how the invoice was actually paid outside Vantaca (for example, ACH vs. Check). A mismatched PayType can prevent the imported invoice from closing out correctly.

Attachments

Was this article helpful?

0 out of 0 found this helpful
Please sign in to leave a comment.

Comments