General Ledger History |
See Also General Ledger Button Voiding a Check Voiding a Transaction Protected Fields
See the How to document #756 on General Ledger History.
The General Ledger History contains all the transactions that have been posted to the ledgers. A separate ledger is maintained for each owner, property, and management group.
For large databases, see Help Document #743 which explains the History Filters.
Transactions can be limited to a specific ledger by selecting it using the ledger or unit field Find List.
Use the ledger or unit field to select a specific ledger’s history for review. Whichever is used, transactions for that ledger will display. The number of GL transactions in the database will determine the date range of the transactions displayed - see History Filters. To limit the transactions to just those for a specific unit, first select a unit and then mark the Show Only Transactions for This Unit checkbox. This will filter out other unit and non-unit specific transactions. Once a ledger is selected only units owned by that ledger will display in the unit Find List.
The General Ledger history displays all transactions posted to each ledger, except for transactions voided as of the same day posted. Revenue and Expense transactions in GL History are the only transactions that appear on owner statements. Ledger / Unit These fields are used to select the ledger transactions that display. By default the drop down list will contain all owners. You can use the restriction box on the right to limit the ledger drop down list to any of the other profile groups. Clicking the ledger flashlight button while the field is empty will display the owner Find list. Selecting a different profile group from the restriction box drop down list will change the active find list.
Once the ledger is chosen, protected fields with information about it will display. The action buttons can be used to Filter or Edit the transactions. From the Edit screen you can click the General Ledger button to view the raw data.
There are buttons on the right that will display additional information. Ledger Info – clicking this button will display information about the ledger. Receivable History - this will display information on the amount showing in the Receivables protected box. It is the amount of charges owed to the owner. Edit by Control # - clicking this button will bring up a screen that allows you to search the transactions in the GL History by the Control #. Every transaction posted is assigned a unique control #. TABS – Revenue & Expenses; All Accounts; Open Credits; Accounts Receivable; Accounts Payable The Revenue & Expenses tab shows only those transactions that are income, expense or equity accounts.
The All Accounts tab shows all parts of the transactions set for all account types.
The Open Credits tab shows all transactions that affected open credits.
The Accounts Receivable tab shows the accounts receivable transactions. Accounts receivable is an accrual account (see below). Until you mark the Accrual radio button you will only see the Cash transactions.
The Accounts Payable tab shows the accounts payable transactions. Accounts payable is an accrual account (see below). Until you mark the Accrual radio button you will only see the Cash transactions. Show Set / Show All These buttons display the General Ledger Raw Data. Show Set displays just the transactions posted to the general ledger as a result of the highlighted transaction. Show All shows all the general ledger data for all ledgers. Operating The balance in the owner’s ledger account. This is the sum of all income, expense and equity account types on a cash basis. The operating amount is the bank accounts not marked "Escrow Deposit Analysis", less current liabilities less Escrow Deficit. Cash Owner money being held in bank accounts that are not marked Escrow Deposit Analysis. If the Cash amount is more than the Operating amount, there is money in the bank that is not available to the owner – most commonly security deposit funds and tenant open credits. Deposits Sum of all accounts with an Account Type of Current Liabilities that are denoted as Escrow Deposit Analysis. See Escrow & Deposits and the example below. Escrow The amount being held in bank accounts denoted in Setup as Escrow Deposit Analysis. See Escrow & Deposits and the example below. Payables This is an accrual basis amount. It is the sum of all transactions posted to the accounts payable account specified in the posting table. It includes all unpaid invoices, any unpaid management fees on rent charged but not received, and any transactions posted directly to the AP account.. To determine what makes up this number you can view the Accounts Payable tab, or run the unpaid payables report or a detailed trial balance for the account AP with accrual as the accounting method. The unpaid payables report will detail the unpaid invoices portion of the number. The detailed trial balance includes all the debits and credits to the account for the date range selected. To find the makeup of the number, cross out corresponding debits and credits. Receivables This is an accrual basis amount. It is the sum of all transactions posted to the accounts receivable account specified in the posting table. It can include all unpaid charges that are owed to the owner. This includes rent charged but not received. To determine what makes up this number you can view the Accounts Receivable tab, or run the aged owner receivables report or a detailed trial balance report for the AR account with accrual as the accounting method. This will not show however transactions posted directly to the AR account. Assets This is a cash basis amount and is the sum of all transactions posted to asset accounts that are not bank accounts. Liabilities This is a cash basis amount that is the sum of all transactions posted to liability accounts. Reserve The total amount in accounts marked with an account type of capital reserve. Cash, Accrual, Modified Cash These Note: When the escrow and deposit amounts do not match it means that funds need to be moved to or from the escrow bank account. The situation can occur when a security deposit is deposited in the checking account and when a refund is processed.
See Owner Distribution Check Calculations to see how the amounts displayed here are used to compute the owner’s distribution check.
When the Available Cash and cash amounts do not match, money has probably been received or disbursed to an asset or liability account type. Example: A tenant owes $1,000 for rent and $1,000 for security deposit and sends you one check for $2,000. You deposit it into the checking bank account. At this point the screen would show:
You then move the $1,000 security deposit to the escrow bank account. The screen would show:
Then you need to set aside $100 for the owner’s taxes. A journal entry moving the $100 to a tax holding (liability) account. The screen would show:
|
radio buttons select the