Office - General Ledger - Journal Entries

Table of Contents


Overview

Using the Journal Entry wizard allows clubs to make changes to the General Ledger as needed. While many of the processes in CMA do this, the Journal Entry Wizard does so directly.

Required Permissions

  • Create Journal Entries (V)

  • Approve Journal Entry Batches (V, E, C, D)

  • Import Annual Journal Entries (V)

  • Un-post Journal Batch (V)


Accessing the Tool

  1. Navigate to the General Ledger Module and select Journal Entry Wizard.

  2. The system will prompt for a date selection unless other unposted journal entries exist. If other entries exist and a new entry is required select the Quick Add Button.

Making an Entry

  1. Within the Create Journal Entries screen, type or use the lookup to select the appropriate account(s).
    Please Note: Once you begin typing in the account cell, the lookup will populate with that information in the search bar.

  2. Under Ref (reference) the values or text can be used to help match up common entry lines.

  3. The description field contains more information about the line entry.

  4. Next, enter either a debit or credit. Be sure the opposing field has a $0 value.

  5. Continue to enter as many lines as needed to make the batch ensuring that the Debits and Credits balance (contain the same total value.

Review the Batch

  1. Click the Preview button to review the batch before posting.
    Please note: If any changes need to be made close the preview. Re-enter the journal entry wizard and select the batch.

  2. Verify all the information and click Post Batch.

  3. Review all posted batches in the Approve Journal Entry Batches section of the General Ledger module.

Memorized Entry

  1. Once all the lines are entered, check the Create Memorized Entry box at the bottom of the window.

  2. Preview and Post the batch.

  3. Now any time a new batch is built use the Import Memorized Entry button to pull in those saved entries.

Importing Journal Entries

To import a journal entry;

  1. Access the Journal Entry Wizard and select Quick Add.

  2. Select Import from CSV.

  3. Browse to locate the file.

  4. Select an existing template or create a new one.

    • NOTE: If creating a new template, please reach out to support for assistance mapping your template for future use.

  5. Select Finish if your template already exists, if you do not have a template, please reach out to support for assistance mapping the template.

  6. Review and finalize the journal entry.

Journal Entry CSV Format

Please click here to see an example of the Journal Entry import .CSV

  • Column A - The Ledger Account Number.

  • Column B - The Ledger Department number.

  • Column C and D - These are just like they are in the JE Wizard, two columns for descriptive information.

  • Column E The Debit Number.

  • Column F The Credit Number.

Journal entries should be entered with consideration to how money will move between accounts.

  • Every cell in the import must have a value.

  • If there is a credit number, on the same line you will need to place a 0 in the debit column.

  • Do not use a total column, the 6 columns shown are all that can be included. The file must be balanced.

  • Debits and Credits need to be in a decimal format on the .csv but not in a currency format, do not use currency symbols.

  • Save in the .csv format.


Best Practices

  • Place offsetting entry lines in succession to make verification easier.

FAQs

  1. Can I put any number of accounts in one batch?

    1. Yes you can just remember that the credits need to equal the debits.

  2. How do I edit a Batch after I posted it?

    1. Go to the Approve Journal Entry Batches section of the General Ledger Module and find the batch in question. Unpost it then open the Journal Entry Wizard and double click on the now open batch.