Manual:General Ledger: Difference between revisions
No edit summary |
|||
| (34 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
== | [[Category:Applications]] | ||
==Screens== | |||
{{#dpl: | |||
category=General Ledger | |||
|columns=3 | |||
|namespace=Screens | |||
|shownamespace=false | |||
|ordermethod=title | |||
|order=ascending | |||
|format=<ul class="list-3-columns">,<li>[[%NAMESPACE%:%TITLE%|%TITLE%]],</li>,</ul> | |||
}} | |||
'''Adding an Account Number''' | ==Configuration== | ||
: | |||
==Utilities== | |||
==Reports== | |||
==General Ledger== | |||
=== Chart of Accounts === | |||
'''Menu Location:''' General Ledger / Chart of Accounts<br> | |||
{{EpiphanyHelpText|Screen|5}} | |||
::a. | '''Important Fields:'''<br> | ||
::b. | : 1. Account Number | ||
::c. | ::* Example: 03.750.4311 | ||
:::• | ::**03 = Facility/Site | ||
::** 750 = Department | |||
::** 4311 = Detail | |||
: 2. Balance<br> | |||
: 3. Account Name<br> | |||
: 4. Account Type – displays Account Type and Code <br> | |||
::* A = Asset | |||
::* Q = Equity | |||
::* E = Expense | |||
::* L = Liability | |||
::* R = Revenue | |||
: 5. Detailed Type – displays Detailed Account Type<br> | |||
::* Asset | |||
::* Equity | |||
::* Expense | |||
::* Liability | |||
::* Revenue | |||
: 6. Default Acct For<br> | |||
::*{{EpiphanyHelpText|Detail|834}} | |||
: 7. Bank Info<br> | |||
::*{{EpiphanyHelpText|Detail|9804}} | |||
: 8. Summary Account Information<br> | |||
::* Summarizes all accounts by Detail (i.e. 4311)<br> | |||
: 9. Sub-Accounts – displays all sub-accounts of GL Account Number<br> | |||
: 10. Facility – displays Facilities GL Account Number is linked to<br> | |||
: 11. Department – displays Departments GL Account Number is linked to<br> | |||
'''Adding an Account Number'''<br> | |||
:'''Menu Location:''' General Ledger / Chart of Accounts<br> | |||
:1. Click [[File:Add.png]] | |||
:2. Enter new Account Number | |||
:3. Select Account Type | |||
:4. Select Detailed Type | |||
:5. Select Default Acct For, if applicable | |||
:6. Enter Bank Info, if applicable | |||
:7. Enter Balance, if applicable | |||
:8. If Summary Account, check the Summary Account box | |||
:::Summary Accounts are "Virtual" accounts used in Epiphany to show the combined value of several accounts (i.e Cost of Sales may have Sub-Accounts of Purchases, Change of Inventory, etc.). Summary Accounts can be used in Custom GL Reports. They cannot be posted to directly in Journal Entries. | |||
:9. Account Groupings | |||
::a. Facility | |||
:::Facility is only populated when using Summary Accounts. The Facility Code is normally prepended to the start of the standard GL Account in the format [Facility Code].[Department Code].[Account Number]. | |||
::b. Depatment | |||
:::Department is only populated when using Summary Accounts. The Cepartment Code is normally prepended to the start of the standard GL Account in the format [Facility Code].[Department Code].[Account Number] | |||
::c. Update Accounts button | |||
:::• This button will automatically create and remove GL Accounts as necessary for every combination of Facility and Department defined under Account Groups. | |||
=== Journal Entry === | |||
'''Menu Location:''' General Ledger / Journal Entry<br> | |||
# Enter date if different from current date | # Enter date if different from current date | ||
# Enter Journal Desc (description of Journal Entry) | # Enter Journal Desc (description of Journal Entry) | ||
# Ledger Entries | # Ledger Entries | ||
:a. Add Account Number to be Debited | |||
:b. Add Account Number(s) to be Credited | |||
::*Note: after entering the amount use the Up or Down keys to toggle between DB and CR | |||
'''Recurring Journal Entry''' | '''Recurring Journal Entry'''<br> | ||
: | :'''Menu Location:''' General Ledger / Journal Entry<br> | ||
# Recurring Qty: Enter number of months to recur | # Recurring Qty: Enter number of months to recur | ||
# Click Recur Monthly button | # Click Recur Monthly button | ||
::* Example: Enter 11 in Recurring Qty field and click Recur Monthly button | ::* Example: Enter 11 in Recurring Qty field and click Recur Monthly button | ||
[[File: | :::[[File:GL_RecurringJE.png]] | ||
::* If correct, click Yes; otherwise, click No to clear dialog box and return to Journal Entry and change Recurring Qty. | ::* If correct, click Yes; otherwise, click No to clear dialog box and return to Journal Entry and change Recurring Qty. | ||
::* Upon clicking Yes, a separate Journal Entry for each month is added to the Journal Entries. | ::* Upon clicking Yes, a separate Journal Entry for each month is added to the Journal Entries. | ||
::* Dollars can be divided over allotted number of months to reflect income more accurately for work done throughout the year | ::* Dollars can be divided over allotted number of months to reflect income more accurately for work done throughout the year. | ||
'''Reverse Journal Entry''' | '''Reverse Journal Entry''' | ||
: | :'''Menu Location:''' General Ledger / Journal Entry<br> | ||
# Enter Date to reverse the Journal Entry | # Enter Date to reverse the Journal Entry | ||
# Click Reverse button | # Click Reverse button | ||
::• Example: Reversing Date entered is 1/1/ | ::• Example: Reversing Date entered is 1/1/2020 | ||
:::[[File:GL_ReverseJE.png]] | |||
::• If correct, click Yes, otherwise, click No to clear dialog box and return to Journal Entry to change Reversing Date. | ::• If correct, click Yes, otherwise, click No to clear dialog box and return to Journal Entry to change Reversing Date. | ||
::• Upon clicking Yes, a separate Journal Entry is entered for the date specified and indicates Reversing entry in parentheses: | ::• Upon clicking Yes, a separate Journal Entry is entered for the date specified and indicates Reversing entry in parentheses: | ||
:::[[File:GL_SuccessfulReverseJE.png]] | |||
<br> | |||
'''Journal Entry Templates''' | '''Journal Entry Templates''' | ||
: | :'''Menu Location:''' General Ledger / Journal Templates<br> | ||
# Enter Template Desc | # Enter Template Desc | ||
# Enter Account Numbers to be debited and credited | # Enter Account Numbers to be debited and credited | ||
'''Apply Journal Entry Template''' | '''Apply Journal Entry Template''' | ||
: | :'''Menu Location:''' General Ledger / Journal Entry<br> | ||
# Click Apply Template button | # Click Apply Template button | ||
# Select appropriate Template | # Select appropriate Template | ||
| Line 83: | Line 111: | ||
'''Journal Entry Report''' | '''Journal Entry Report''' | ||
: | :'''Menu Location:''' General Ledger / Reports / General Journal Report<br> | ||
Report includes: | ::Report includes: | ||
::* Journal ID | ::* Journal ID | ||
::* Journal Date | ::* Journal Date | ||
| Line 95: | Line 123: | ||
::* Credit Amount | ::* Credit Amount | ||
=== Budget === | |||
'''Menu Location:''' General Ledger / Budget<br> | |||
# Enter Budget Year | # Enter Budget Year | ||
# Enter Account Number to be impacted | # Enter Account Number to be impacted | ||
# Enter dollar amounts in appropriate Months | # Enter dollar amounts in appropriate Months | ||
=== Default Accounts === | |||
'''Menu Location:''' General Ledger / Default Accounts<br> | |||
Define default account for entries (once defined, accounts will be linked to Chart of Accounts) | Define default account for entries (once defined, accounts will be linked to Chart of Accounts) | ||
# Click Add | # Click Add | ||
| Line 108: | Line 136: | ||
# Enter Account Number | # Enter Account Number | ||
=== Payment Types === | |||
'''Menu Location:''' General Ledger / Payment Types<br> | |||
# Enter Description | # Enter Description | ||
# Enter Account Number | # Enter GL Account Number to Debit | ||
::* Common Payment Types | |||
::**Cash | |||
::**Check | |||
::**Credit Card | |||
::**Pay Pal | |||
::**Refund | |||
::**Wire Transfer | |||
=== Reports === | |||
* Standard Balance Sheet | |||
* Standard Income Sheet | |||
* Standard GL Detail | |||
* Custom GL Reports | |||
* Custom GL Report Maintenance | |||
* Close Books | |||
* Trial Balance | |||
* See Insight Reporting for all General Ledger reports | |||