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.