The General Ledger area of Umbria Profit module allows you to review your firm's General Ledger setup as well as all ledger activity. It consists of the Accounts, Expenses, Income, Transactions, Payroll Info, and Allocation tabs.
In addition to reviewing the data, you can also add new accounts.
A list of all accounts defined in the General Ledger displays. You can filter the list to show only accounts associated with a certain department or office, or you can select an account Class Type of Assets, Equity, Expenses, Liability, or Revenue. You can also enter a portion of a specific account number, and click Search.
Account information displays in the following columns:
Column | Description |
---|---|
Account# | Unique identifying ledger account number. |
Classification | Specific classification defining the type of account. See Classifications Tab. |
Class Type | Broad classification describing the basic account type. See Classification Types Tab. |
Office | Office to which this account is associated, if applicable. |
Department | Department to which this account is associated, if applicable. |
Person | Person to which this account is associated, if applicable. |
Balance | Current account balance based on transaction activity. |
To set up an allocation rule for one or more accounts:
To add an account mapping between the GL account to the salary account:
Note: Before you run an allocation, you must set up the salary to GL mapping.
To add a new account:
The Expenses tab shows a list of all expense transactions recorded in the system. You can use the Period filter to change the time period for which you are viewing expenses, or you can enter a portion of the account number or transaction description in the search field and click Search.
To manually allocate an expense:
The Income tab shows a list of all expense transactions recorded in the system. You can use the Period filter to change the time period for which you are viewing expenses, or you can enter a portion of the account number or transaction description in the search field and click Search.
The Transactions tab lists all transactions that have affected General Ledger account balances, both expenses and income. The far right column of the list shows the allocation method that was applied to this transaction. You can use the Period filter to change the time period for which you are viewing expenses, or you can enter a portion of the account number or transaction description in the search field and click Search. You can also select an Allocation Method from the drop-down to view just transactions that were allocated accordingly.
On this tab, you can see all payroll information that has been imported from the Excel payroll import. You can change the Period for which payroll information is displayed, and you can also select one or more timekeepers from the Users drop-down and click Search to narrow this list of results accordingly. Click Delete Payroll, if you want to change the payroll information or remove a payroll.
The Allocation tab displays all allocated transactions, at the allocation level. Each row in the list represents the allocated portion of a transaction; therefore, multiple rows might have the same value in the Trans# column.
The following filters are available for the Allocation tab:
Filter | Description |
---|---|
Target | Select Office, Department, or Person and then choose the specific entity the expense or income was allocated to from the second drop-down list. |
Rule | Select a particular allocation rule to see only the transactions that were allocated according to that rule. |
Account | Enter a portion of the account description. |
Suspended Account | By default, this is set to No to hide activity on suspended accounts from the list, but you can switch to Yes. |
Period (You can also select Custom Period and enter a Start Date and End Date) |
|
List information displays in the following columns:
Column | Description |
---|---|
Trans# | System-assigned transaction number. |
Allocation Date | Date this allocation was made. |
Rule | Allocation rule that was used for the allocation. |
Account | General Ledger account impacted by the allocation. |
Target Type | Displays Firm, Office, Department, or Person. |
Target Entity | If the Target Type was Office, Department, or Person, displays the specific entity. |
Amount | Total amount allocated. |