The General Ledger (GL) Code Import comes complimentary with every CivicRec Implementation. This article outlines the process and requirements for submitting the GL Code Import Template. 

Instructions 

1. Download the GL Code Import Template to your desktop.
2. Complete the following columns:
   • Column A - GL Code: Required field with no formatting requirements (100 characters or less)
   • Column B - GL Code Description: Required field that accepts only alpha and numeric characters (100 characters or less)
   • Column C - GL Code Account Type: Required field and must be one of the following
     • Asset
     • Liability
     • Revenue
3. Save the completed template and submit it to your Implementation Consultant/Project Manager on Mavenlink.

Tips

• Must have (at least) one Asset Account for Payments and any Pre-Funded Scholarships.
  • When customers pay, their money passes through the Payment Account and is directed to the appropriate Revenue Account.
  • If you do not have a pre-determined Asset Account, one will be created during your Configuration Training.
• Must have (at least) one Liability Account for each Refund Type, any Post-Billed Scholarships, and/or if you plan on issuing Gift Cards.
  • When a customer is refunded, the money is taken out of the appropriate Revenue Account and passes through the appropriate Refund Account (Liability) and back to the customer, with the exception of Credit/Debit Card refunds).
  • If you do not have pre-determined Liability Accounts, each Refund Type Liability Account will be created during your Configuration Training.
• Must have [at least] one Revenue Account to direct payments and for reporting purposes. This could include a catch-all if you are a small operation or hundreds if you’re a larger operation.
  • Note: CivicRec does not support Fund Accounting

Template Example

Finished Import Example

To view GL imports in CivicRec, navigate to Configuration > Financial Settings > GL Configuration > Chart of Accounts 

Resources

• Project Deliverables