If importing invoices with project IDs the following fields are required:

  • Invoice Amount
  • Dr Amount
  • Dr Account
  • Project Amount
  • Project ID
The mapping for each field is as follows:
  • Debit Side:
    • For the Recurring Invoice Distribution Amount -->This will be mapped to the Amount under Recurring Invoice Distribution
    • For the Recurring Invoice Account number --> This will be mapped to the Debit Account number under Recurring Invoice Distribution
    • For the Debit Transaction Distribution Project Amount --> This will be mapped to the Amount Under Debit Transaction Distribution
    • For the Debit Transaction Distribution Project ID --> This will be mapped to the Project ID under Debit Transaction Distribution
NOTE: If importing Credit Distribution the Credit Distribution will need to be added to the excel file as well.  And the mapping for this is below:
  • Credit Side:
    • For the Recurring Invoice Distribution Amount -->This will be mapped to the Amount under Recurring Invoice Distribution
    • For the Recurring Invoice Account number --> This will be mapped to the Credit Account number under Recurring Invoice Distribution
    • for the Credit Transaction Distribution Amount --> This will be mapped to the Amount Under Credit Transaction Distribution
    • For the Credit Transaction Distribution Project ID --> This will be mapped to the Project ID under Credit Transaction Distribution