Importing New Records - Journal Entry Items
Follow the steps for Importing New Records

Field Required Type Sample Value Notes
Transaction_Date Yes Date "2024/12/30"  
Journal_Entry_Memo Yes Text "Monthly close"  
Journal_Entry_Note No Text "Additional details"  
Posted_Date No, unless journal entry is posted or if Voided_Date is specified Date "2024/12/30" Must fall within an open fiscal year
Voided_Date No, unless Void_Comment is specified  Date "2024/12/31" Must fall within an open fiscal year. Must be after transaction_Date. 
Void_Comment No Text "Incorrect entry"  
Account_Id Yes, unless lookup fields are used to identify the account Identifier "123" Must match the GL account ID in the system.
Account_Number No, unless Account_Id is not provided Lookup "4000" Must match the GL account number in the system.
Amount Yes Decimal "1500.00" Must be greater than 0. Must have balanced debits and credits if posting
Credit_Or_Debit Yes Datasource Data "Debit" Must be either "Credit" or "Debit."
Item_Memo No Text "Office Supplies"  
Fixed_Asset_Id No Identifier "456" Must match a valid fixed asset ID if specified. If specified, the General Ledger (GL) accounts used must match the designated GL accounts for those fixed assets. 
Fixed_Asset_Name No Lookup "Computer" Must match the name of the fixed asset if specified
Fixed_Asset_Identifier No Lookup "COMP" Must match a fixed asset identifier in the database if specified
Item_Classification_Id No, unless your school uses classifications Identifier "789" Must match a valid classification ID if specified.
Item_Classification_Name No Lookup "General Admin" Must match the classification name in the system if specified.

Note: All rows with the same Transaction_Date and Journal_Entry_Memo will be recorded in the same journal entry. These rows will need matching Journal_Entry_Note, Posted_Date, Voided_Date, and Voided_Comment. 

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.