Receipt Importing

Overview

This article details how to import simple receipts using the Veracross Importer tool.

Enter the Data into the Simple Receipt Template

  1. Navigate to the Import Processing homepage, select Invoke Importer and log in.
  2. Select New Data Import.
  3. Select Accounting: Receipt Import and download the Accounting: Receipt CSV template.
  4. Enter the Receipt data into the import template (see sample template and field definitions below).
  5. Save the CSV file to your computer and specify a file name that identifies the contents or purpose for the file.

Field Definitions

  • Household:  Household name
  • VX_Household_id:  Household ID number from Veracross
  • paying_person:  Paying person name (optional)
  • vx_paying_person_id:  Person ID number from Veracross (optional)
  • apply_to_person:  Apply to Person’s name
  • vx_apply_to_person_id:  Apply to Person’s ID number from Veracross
  • receipt_date:  Date of receipt
  • receipt_type:  Type of receipt (check, credit card, cash, etc.)
  • receipt_category:  Category of receipt (misc cash receipt, deposit, invoice payment, etc.)
  • amount:  Amount of receipt
  • description:  description
  • school_year:  4 digit number representing the school year of receipt (ie. School Year 18-19 = 2018)
  • catalog_item:  catalog item ID from Veracross (optional)
  • Check_number:  Check Number (optional)
  • cash_gl_account:  Cash GL Account associated with receipt
  • cr_gl_account:  CR GL Account associated with receipt

Load the Receipt Template into the Database

  1. Navigate to the Import Processing homepage, select Invoke Importer and log in.
  2. Select New Data Import.
  3. Select Accounting: Receipt Import.
  4. Select the Choose File option, and locate and select the template file saved in the process documented above.
  5. Click Import button to load the template data into the Veracross database.

Validate the Receipt Data

After the raw data has been loaded into Veracross, it must be validated to ensure that all required information was provided in conformity with Veracross standards.

  1. On the Import Processing homepage, under the AR/Billing Importers section, review the Unprocessed receipts and Invalid Receipts Report. If there are receipts in these reports, this signifies some information needs to be updated.
  2. Update the information accordingly. 
  3. Once updates have been made, in the Processing section, click on Receipt Import Processing.
  4. Choose Import Option – Validate Receipts.
  5. Click Add Receipt Import Processing.
  6. Re-run the Validate/Process Receipt Import to see the processing status change to Validated and move to the "Receipts Ready to Import" report. 

Create the Receipts

This process will create the Simple Receipt based off of each row in the imported CSV file.

  1. If all receipts have been validated, In the Processing section, click on Receipt Import Processing.
  2. Choose Import Option – Import Receipts.
  3. Click Add Receipt Import Processing.

View the uploaded Receipts in your Unposted Simple Receipt Header Listing report.

Possible Errors

  • If the Receipt Type of "FACTS" is chosen, all Student's will need an Agreement Number populated on their Finance Tab.  Otherwise, an error message will be received and the receipts may not be imported.