There are a number of ledger reports available. The list below is just a sample of the reports already created in PROMAS and the reports you can create or customize. For the most up-to-date list of reports available see Version 12 reports. To see the options available, see How to Run Reports. Or the Help document #702.
OPTIONS
Clicking the <Options> button gives you further options to modify the report.
Financial Report tab (only for financial reports)
Financial Report - choose the report you want to modify.
Report Style - choose the style: Custom; Month to Date; Quarter to Date; Year to Date; Custom and Month to Date; Custom and Quarter to Date; Custom and Year to Date; Month and Year to Date.
Account Grouping - can be Account Type, Account Section or None
Override Accounting Method - you can choose Cash, Accrual or Modified Cash. Mark the Enable checkbox if you are changing this.
Override Fiscal Year Start Month - Choose a month other than the default (January) and mark the Enable checkbox.
Include Columns - If you have selected 2 time periods for the report, like Month and Year to Date, you can choose to include columns showing the dollar difference or Percentage of Income.
Other Options
•
|
Show Ledger Codes - this will print out the ledger code as well as the account name.
|
•
|
Consolidate Ledgers- this will consolidate all ledgers selected into one report.
|
Financial Advanced tab (only for financial reports)
You can choose to include or exclude an additional account or account list on the report.
REPORTS
Balance Sheet
A balance sheet reports on assets, liabilities and equity for a ledger. It is run for a specific date. Assets should equal liabilities plus equity.
Cash Flow Details
This report lists all transactions that have affected the ledger, whether it was a credit or debit and the affect on the bank balance. It includes security deposits, open credits and other liabilities. The balance is the balance in every bank account.
Cash Flow Statement and Cash Flow Statement (12 months)
This report is run for a specific date and gives a year-to-date balance that includes all transactions that happened since the beginning of the fiscal year. It has a beginning balance as of the last day of last year. That balance is the amount of money in all the banks for the ledger as of that date.
Following the beginning balance it shows Income (including other income) and Expenses (including other expenses) followed by a Net Income (Loss) figure - the total of the income and expenses for the time period chosen.
Following that is a section for Adjustments which has the transactions posted for account codes that are equity (like Cash Contribution or Cash Distribution) or liability (like Tax Set Asides and Security Deposits). Then a Net Balance Change and an Ending Balance. The ending balance is the amount of money in all the banks for the ledger as of the report date.
General Ledger Activity (by Account)
This report lists each transaction posted during the date range selected. The transactions are sorted by account. It lists the date, check #, payee or ledger.
General Ledger Activity (by Date)
This report lists each transaction posted during the date range selected. The transactions are sorted by date. It lists the date, check #, payee or ledger.
General Ledger Activity (by Ledger and Account)
This report lists each transaction posted during the date range selected. The transactions are sorted by ledger. It lists the date, check #, payee or ledger. It includes a beginning balance, running balance and ending balance.
General Ledger Summary (by Ledger and Account)
This report lists a sum of each account code sorted by ledger.
Income Details
This report is run for a time period, so you can choose the beginning and ending dates for the report. It shows detailed transactions for Income and Expense, with totals, followed by a Net Income (Loss) total. Under Other it lists equity transactions (like Cash Distribution and Cash Contribution) and account types of Other Income and Other Expense with an ending balance.
Each line shows the from (ledger) and the for (unit). If the property ledger and the unit have the same long description, there is only a from listed.
Income Statement - see Statement Comparision
This report is run for a date range. It gives a summary of income and expenses with a Net Income (Loss) total. Following that total Other Income and Other Expense accounts are listed, ending with a Net Income (Loss) total. It has no beginning and ending balances. Equity and Liability accounts are not included.
Account Grouping - default is None
Income
Expenses
Other (income and expenses)
With Account Grouping set at Account Type or Account Section (assuming you have created account sections). there are two formats available. Without using the switch detailed below, the layout will be Multistep.
Multistep layout:
Income
Taxable Income
Total Income
Expenses
Total Expenses
Net Operating Income (Loss)
Other
Other Income
Other Expenses
Singlestep is an optional layout. To use this layout, go to Setup, Processing Defaults, Options tab. In the Comments field type /singlestep.
Singlestep layout:
Income
Other Income
Expense
Other Expense
Income Summary
This report is run for a time period, so you can choose the beginning and ending dates for the report. It has a beginning balance, then shows the Income and Expense totals, with a Net Income (Loss) total. Following that are listed Other Income and Other Expense totals. Under Adjustments it lists equity totals (like Cash Distribution and Cash Contribution) with an ending balance.
Ledger Actual Fees
This report lists management fee and leasing fee taken during the date range selected for each ledger.
Ledger Aged Invoices
All unpaid invoices, grouped by age, then by ledger. It will include voided transactions where the posting date and void bridge the report date.
Ledger Aged Invoices Summary
This report lists totals for outstanding invoices, with totals given for 30, 60 and 90 days as of the report date. It will include voided transactions where the posting date and void bridge the report date.
Ledger Analysis
It will show information on any of the accounts that are suspect: Cash does not equal Operating; Deposits do not equal Escrow; multiple cash bank accounts for a ledger; any ledger with open credits; discrepancy in Open Credits between tenant accounts and owner ledger. It will indicate when money needs to be moved from Cash accounts into Escrow accounts.
Ledger Balances
This report has a line for each ledger with the balance in that ledger as of the report date. It has columns for Distribution Reserve (set in the profile), Distribution Deficit (how much the Balance is below the Distribution Reserve), Base Reserve and Base Deficit (how much the Balance is below the Base Reserve).
Ledger Cash Analysis
This report lists each ledger. It has columns for Cash; Escrow; Bank (all banks added together); Operating; Security; Open Credit; Impound (liability codes marked Impound); Other (other liabilities)
Ledger Cash Analysis (Suspect)
Similar to the Ledger Cash Analysis except it only shows those ledgers that have a discrepancy between Escrow and deposits.
Ledger Charge Activity
This report lists all charges posted during the date range sorted by the ledger they are payable to. It lists the charge code, tenant and unit as well as the amount of the charge and how much is currently due on the charge.
Ledger Disbursements
This report lists all the checks written and all ACH transactions from a ledger for the report dates you choose. Information includes check #, bank account, bill code, unit, ledger and memo.
Ledger Disbursements for Bills
This report lists all the checks written from a ledger for the report dates you choose. This excludes distribution and refund checks and checks where the payee is the ledger.. Information includes check #, bank account, bill code, unit, ledger and memo.
Ledger Disbursements by Check
This report lists all the checks written from a ledger for the report dates you choose. This includes invoice checks, distribution checks, refund checks and single checks. Information includes check #, bank account, bill code, unit, ledger and memo.
Ledger Receipt Activity
This reports lists all the tenant payment activity for each ledger for the date range selected. It includes the date, who made the payment, memo, amount and a breakdown of each charge paid.
Ledger Unpaid Invoices
This report lists all unpaid invoices by ledger. It includes the date, invoice number, vendor, description and amount.
Operating Statement - see Statement comparison
This report gives a year-to-date balance as of the selected date. It shows the Income and Expense totals, with a Net Income (Loss) total. Under Other it lists other income and other expense totals. Under Adjustments it lists equity transactions (like Cash Distribution and Cash Contribution) and account types of Other Income and Other Expense with an Net Balance Change and ending balance.
Retained Earnings Statement - see Statement comparison
Beginning and ending balance
Liability accounts are not included.
Trial Balance
The bank balance includes amounts received but not yet deposited to the bank account.
This format reports the balance in each account for the date selected. The balance is shown as a debit or credit depending on the account type. Total debits should equal total credits. It has a separate page for each ledger.
Trial Balance Details
This report lists each transaction, by ledger and account.
Trial Balance Summary
This is similar to the Trial Balance but it does not put a page break between ledgers.
|