Importing New Records - Customer Receipts
Follow the steps for Importing New Records ” with “

Field Name Required Type Sample Values Description
Customer_Receipt_Id No Key Id Field "123"  
Customer_Id Yes, unless lookup fields are used to identify the Customer Identifier "456" Must match an existing Customer Id in the system
Customer_Name No, unless Customer_Id is not specified Lookup "Smith Family" Must match an existing Customer name in the system
Person_Id No, unless "Finance Require Student" is checked Identifier "789" Must match an existing person Id in the system. See Application Setup for more details on "Finance Require Student" checkbox
Person_First_Name No Lookup "John" Must match an existing person first name in the system
Person_Last_Name No Lookup "Doe" Must match an existing person first name in the system
Person_Birthdate No Lookup "1990/01/01" Must match an existing person birthdate in the system
Person_Type No Datasource Data "Student" Must be either "Student" or "Inquiry" 
Name_On_Receipt No Text "John Smith"  
Receipt_Date Yes Date "2024/01/01"  
Entered_Date Yes Date "2024/01/02"  
Receipt_Method No Datasource Data "Check" Must match an existing Receipt method in the system
Receipt_Amount Yes Decimal "100.25"  
Reference_Number No Text "123abc"  
Reference_Date No Date "2025/02/06"  
Receipt_Memo No Text "Refund for overpayment"  
Internal_Memo No Text "Reviewed by accounting"  
Receipt_Account_Id Yes, unless lookup fields are used to identify the debit account Identifier "123" Must match an existing GL Account Id in the system
Receipt_Account_Number No, unless Debit_Account_ID is not specified Lookup "1-00-00-4165-127" Must match an existing GL Account number in the system
Deposit_Id No Identifier "456" Must match an existing Deposit Id in the system
Deposit_Date Yes Date "2024/02/06"  
Deposit_Description No Text "Tuition Deposit"  
Deposit_Account_Id No Identifier "789" Must match an existing GL Account Id in the system
Deposit_Account_Number No Lookup "1-00-00-4165-125" Must match an existing GL Account number in the system
Posted_Date No, unless Voided_Date is specified Date "2024/01/03"  
Finalized_Date No Date "2024/01/04"  
Is_NSF No Datasource Data "Yes" Must be one of: Yes or No
Voided_Date No, unless Is_NSF is specified Date "2024/01/05"  
Void_Comment No Text "Duplicate entry"  
Receipt_Classification_Id No, unless your school uses classifications Identifier "456" Must match an existing classification id in the system 
Receipt_Classification_Name No, unless your school uses classifications and Credit_Classification_Id is not specified Lookup "Overpayment" Must match an existing classification name in the system 
Earn_Date No Date "2024/01/06"  
Ar_Account_Id1 Yes, unless lookup fields are used to identify the AR account Identifier 89012 Must match an existing GL Account id in the system with type "accounts receivable"
Ar_Account_Number1 No, unless Ar_Account_Number is not specified Lookup "1-00-00-4165-127" Must match an existing GL Account number in the system with type "accounts receivable"
Ar_Account_Amount1 Yes Decimal "100.00" Sum of AR account amounts must match credit amount
Ar_Classification_Id1 No, unless your school uses classifications Identifier 90123 Must match an existing classification id in the system
Ar_Classification_Name1 No, unless your school uses classifications and Ar_Classification_Id is not specified Lookup "Customer Refund" Must match an existing classification name in the system
Customer_Invoice_Id1 No Identifier "123" Must match an existing Vendor Invoice ID in the system
Invoice_Alternate_Id1 No Identifier "ALT-1234" Must match an existing Vendor Alternate Invoice ID in the system
Amount1 No Decimal "1500.00"  
Liability_Account_Id1 No Identifier "123" Must match an existing GL Account Id in the system with type "Liability"
Liability_Account_Number1 No Lookup "1-00-00-4165-127" Must match an existing GL Account number in the system with type "Liability"

Note: Ar_Account_Id, Ar_Account_Number, Ar_Account_Amount, Ar_Classification_Id, and Ar_Classification_Name are repeated 4 more times (for a total of 5 potential AP Accounts).

Customer_Invoice_Id, Invoice_Alternate_Id, Amount, Liability_Account_Id, and Liability_Account_Number are repeated 9 more times (for a total of 10 potential Vendor Invoices)

See also

Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
    School Name *
    Relation to School *
    select
    Last Name *
    Your First Name *
    Your Email *
    Your Phone # *
    PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.