Importing New Records - Miscellaneous Payments
Follow the steps for Importing New Records 

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 Identifier "789" Must match an existing person Id in the system
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 
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

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.