This window is accessed through the Accounting >> General Ledger >> G/L Entries menu. The window displays the transactions which have been posted to the G/L during the times defined in the search criteria.

Parts of the G/L Entry Window

	Begins the creation of a new general ledger entry. For more information on creating manual entries, click here.
	Opens the selected entry in the G/L Entry Detail window. For more information on the G/L Entry Detail window, click here.
	This function is unavailable in this window.
	This function is unavailable in this window.
	Prints a copy of the currently selected entry.
	Exports a copy of the currently selected entry. This only exports the selected lines to a text file. For an export of the GL entry in a special accounting format, use the Export G/L button.
	Exports the detail of the selected entry. For more information on using the Export G/L function, click here.
Clear Export GL	Resets the Exported Flag on the GL entry so that it can be exported again in the GL Accounting Export Format that is specified in Company Preferences.
	For the selected G/L entry, this button can be used to Reverse the G/L entry, which will make a duplicate of the entry with the debits and credits reversed. You generally use this to reverse the effects of a long ago/prior GL entry that has been put into your books. -or- Unpost the G/L entry. If its the same day and you have not put this G/L entry into your accounting system, you can unpost it and reprint your end of day reports. They will now exclude these G/L entries. Then you can make an adjustment if necessary and repost. The idea is that you only ever do this to a GL entry that is NOT in your accounting system and needs a manual adjustment prior to getting it there.
	Opens the selected entry in the Transaction History window to allow the user to see all transactions incorporated into the entry. For more information on the Transaction History window, click here.
	The search criteria options available for the window.
From To	The search criteria to be used for the search.
	Begins the search process.
Include:	The types of accounts to be included in the search. Check the box next to the ones to be included.
Date	When the entry was added to the General Ledger.
Journal #	The journal number assigned to the entry.
Description	A brief description of the entry.
Debit	The amount which was debited.
Credit	The amount which was credited.
Date Posted	The date which the entry was posted.
# Trans	The number of transactions which the entry is composed of.
Exported	Notes whether the entry has been exported or not.

Manual G/L entries are most commonly used to correct an entry when an incorrect G/L account is selected. They can also be used to account for expense transactions that take place outside of Theatre Manager.

 

Steps to Create A Manual GL Entry

In the Main Menu, selecting Accounting -> General Ledger -> G/L Entries

1. Inside of the Journal Entry Type Window, Click the New button

2. This opens up the GL Entry Detail Window. To start, enter the date you are creating the entry.

3. Enter a Description for the entry.
4. Enter a detailed note indicating the reason for the entry.
5. Click the Save button at the top of the window. After clicking Save, the G/L Entry Detail Window will update to allow input of the actual G/L entry.
6. Click the New button in the lower left corner of the G/L Entry Detail window.

7. Click the account icon to the right of the Account field.
8. Select the CREDIT G/L account.
9. Click the Select button in the lower right corner to select the account number.
10. If this GL Entry is for a specific event, use the lookup to locate the event code.
11. Enter the Amount of the CREDIT.
12. Click the OK button.
13. Click the New button in the lower left corner of the G/L Entry Detail window.
14. Click the account icon to the right of the Account field.
15. Select the DEBIT G/L account.
16. Click the Select button in the lower right corner to select the account number.
17. If this GL Entry is for a specific event, use the lookup to locate the event code.
18. Enter the amount of the DEBIT.
19. Click the OK button.

 

Depending on the date, the entry will be posted the next time the End of Day Wizard is run and the Post to G/L step is taken.

The General Ledger Entry Detail window is used for creating new G/L entries and examining posted entries.

Parts of the G/L Entry Detail Window

	Begins the creation of a new general ledger entry. For more information on creating manual entries, click here.
	Saves the general ledger entry.
	Duplicates the general ledger entry.
	Reverts to the last saved version of the general ledger entry.
	Deletes the general ledger entry.
	Prints a copy of the general ledger entry.
	Checks the spelling of all text entry fields.
	Reverses or unposts the currently selected entry. For more information on using the Unpost function, click here.
	Exports the detail of the selected entry. For more information on using the Export G/L function, click here.
Convert to Historical Entry	May be used one time only if the Year End Rollover created and End Of Day imbalance
G/L Entry Date	The date the entry was created.
	A mini-calendar for the purpose of date lookup.
Journal #	The journal entry number for the general ledger entry.
Description	A short description of the entry.
Note	A more detailed description of the entry.
Date Posted	The date the entry was posted to the general ledger.
# Transactions	The number of transactions included in the entry.
Source	The source of the entry.
	The G/L Detail tab is used for adding the debits and credits to the different general ledger accounts. For more information on the G/L Detail tab, click here.
	The Transactions tab is used to see all transactions that are incorporated into the entry. For more information on the Transactions tab, click here.

The Revenue Date Ending is be the last revenue date orders are to be selected for the sales entry. Orders which have been realized as revenue and have not been journalized will be selected if they are on or prior to this date. Refer to Default Data General Ledger Setup for more information on determining when an order is realized as revenue. The current date will automatically be displayed in the revenue date field.

When balancing is done the day of the sales, the date used will be the current date.

When balancing is done the day after the sales, the date used will be the previous day’s date -- the date the sales were entered. If correcting ticket orders caused new ticket orders, ticket exchanges, or ticket refunds, then the date used will be the current date -- when this is performed, new ticket sales that have been realized as revenue will be included in the sales entry creation.

It is recommended that if the balancing is performed the day after the ticket sales, then new ticket sales are not entered until the previous days sales are balanced. Creating the sales entry creates a general ledger entry that summarizes the sales revenue. A separate entry is created for each date which sales, exchanges, and refunds were recorded. When the entries are created daily and no corrections are made after posting, only one entry per day is created. When entries are created the day after sales, and corrections caused new orders, exchanges, or refunds to be created, two sales entries will be created for the same revenue date. One entry is created for the date of the original sale and the second entry is for the corrections entered the day after. The two sales entries must be manually combined when balancing to the deposit entry. If several days passed since the last Create Sales Entry was created, several sales entries are created, one for each day ticket activity was recorded.

1. Open the Main Menu Accounting >> Create Sales Entry.

   

   The Journal Entry Types window opens.

   

2. Click the New button.

   A G/L Entry Detail window opens.

   

3. Enter a Description of the entry and a detailed Note highlighting the reason for the entry.
4. Click the Save button.

   The entry is now created.

5. The GL Entry window will change to allow you to add lines to the entry.



6. Click the button at the bottom of the entry to add debits and credits as needed.

   A balanced entry will require the debits and the credits to add up to the same value. If the debits and credits do not balance it will cause the End of Day to be out of balance. The entry will need to be corrected before you can Post to the GL.

7. Add the details to the G/L Account Detail
   
   
   • Account: The GL Account for this Credit or Debit
   • Play/Event (Optional): The Play, Event or Game that this entry applies to
   • Theatre/Venue (Optional): The Theatre or Venue that this entry applies to
   • Memo: A short description of why this entry is being made
   • Amount: The credit or debit amount for this entry
   • Debit or Credit "radio" buttons: Allows you to choose whether this is a Debit or Credit entry.

Note: By adding the optional Play or Venue values, the GL entry can be tagged to that specific event or venue. Therefore, you can adjust values manually, as well as calculate the revenues by Venue. This could be helpful if you wish to compare how well Venue A does, compared to Venue B.

8. Close the entry to save the changes.

During the next End of Day, when the Post to GL step is done the entry will be journalized and posted.

	The General Ledger data can only be exported once. The entry is flagged as being exported when it is done so no one exports it twice by mistake. If you lose the export file, you'll need to clear the export flag using the Clear Export G/L button in the toolbar prior to exporting the entry again.
	GL Entries can only be exported if they: are posted to the GL - unposted GL entries cannot be exported as they are still subject to manual correction are not previously exported (the exported column will have a no in it). are selected in the list to be exported have the total of the Debits and Credits match in the database - to ensure consistency of data records

Exporting General Ledger Entries allows you to take the entries and import them into your accounting software package. They can be exported in one of two places with the same result and the export format is defined in company preferences. You can export:

• selected from the list of general ledger entries window. Only the ones you select can be exported, and only if they are not already exported
• all not-yet-exported GL entries using the export button on the final tab of the End of Day Wizard. This gives an automatic way of picking up all the latest GL entries that have been posted and its the preferred location to do the export

 

Exporting G/L Entries from the list

1. Click the G/L Entries button at the top of the window in Theatre Manager.

   

2. Set the date in the To and From fields for the transactions to be exported, and click the Search button.
3. Select the entries to be exported.
4. Click the Export G/L button.

   The user's operating system's Save dialog opens.

5. Enter a filename to save the export under and click the OK button.

   

   The file will now be saved in Tab Delimited format for import into another program. Please reference the program's help section for information on importing.

   

The Transaction Detail displays all information pertaining to a specific transaction. To view the detail of a particular transaction, select the transaction tab on a Patron's record and double click on the transaction. For more information on accessing the Patron Transaction tab, click here.

in order to make a correction to transactions the user MUST have a Master Users status in Theatre Manager. The same transaction history list can be accesses from many places in Theatre Manager such as the End of Day wizard, Plays & Dates, GL Entry Window, etc. The contents of the transaction list varies depending on the route used to access it.

1. Click the Transaction Tab in the patron window.

   The Transaction History Record opens.

   

   Click the Search button to view all transactions.

   

2. Double clicking on the selected transaction opens the Transaction Detail window.

   

3. Click Duplicate and Reverse button.

   A transaction can be duplicated (and reversed) to make a correction to a transaction that has already been journalized to the General Ledger. The result of duplicating a transaction is an un-posted journal entry which reverses the debit or credit result of the original transaction. This un-posted journal entry will be journalized the next time an End of Day, Create Sales Entry routine is generated.

   

   Click the No Button to cancel duplicating and reversing the transaction.

4. Click the to reverse debit or credit created in error.

   You use this to correct a transaction that has been created in error and has not yet been journalized to the General Ledger resulting in a reversal of the debit or credit created by this transaction. It can only be preformed by Arts Management. This is an option rarely used.