Karteikarten
Advanced Reporting
Karten in diesem Stapel (56)
- 1RPM- Chain of franchises that use APM
- Have a different pricing structure compared to our other customers
- cannot make changes to GL Accounts, change or go through special migrations/cancellation without corporate approval - 2Trust Account Balance- Selects properties by the operating bank account
- Shows cash balances in the operating and escrow key cash accounts
- Deposit & Additional deposit GL account totals; Escrow Cash Balance Mismatch
- Columns for Available Funds calculation/Owner Payment Calculation - 3Bank Account Activity Report- Should be representative of a true “check register”
- Displays bank level transactions for the specified bank account and date range - 4Bank Account Association ReportLists all properties and their bank account association (can be filtered for a specific bank and cash account association)
Useful for ensuring all 1150 and 1160 accounts should be switched or not during a bank switch. - 5Balance Sheet- Balances your Asset with your Capital and Liabilities as of a certain date
- Run in Accrual to see AR/AP accounts
- Asset (includes Cash) = Liability + Capital
Automatically populated Capital fields CRE/CPYRE(more on this later) - 6Aged Payables Summary- Find amount payable left on outstanding bills as of certain date
- 7- Aged Receivable Detail- Find outstanding charges as of a certain date
- Does not include Prepayments
- Can show $0 charges from move-ins where proration set to $0 - 8- Cash Flow- Shows net change in all income and expense accounts over a specific date period
- Respects Ownership change when run by owner - 9Income Statement- Shows net change in Income and Expense accounts
Can ONLY show Income and Expense accounts
Can only be run per month, not specific dates
If accrual is enabled, can show Modified Accrual (cash in income, accrual in expense) - 10Why might the General Ledger not match the balance sheet or Cash Flow?- If the reversal of an item does not fall within the same date range, there will be a difference between the reports.
- Client will want to locate the reverse item and date it back to the same date or remember to run GL with reversed transactions. - 11Soft Close Journal Entry- At the end of each property’s fiscal year, AppFolio uses this transaction to automatically zeroe out the balance in each property’s Income & Expense GL accounts
- Can never view or directly edit this Journal Entry. - 12General Ledger will not carry....- expenses from one year to another
Moves the balances into these “GL”s to:
CRE & CPRE
The names of these two GLs cannot be changed, ever
Appears only on the Balance Sheet and Trial Balance - 13CRECalculated Retained Earnings
-this fiscal year’s net income
-Run a cash flow or income statement for this year, look at the Net Income column - 14CPYREall prior fiscal year’s net income
- Run a Cash Flow from 01/01/1000- End Of Last Year, look at the Net Income column - 15If client wants to “zero out” Calculated Prior Year’s Retained Earnings and move the balance to another GL account:- Create an income GL account exempt from 1099 reporting
- Enter a JE that debits income (assuming CPYRE is positive) and credits the GL of their choice (generally Retained Earnings or another Capital Account)
- Enter for the end of last year, typically the last day.
- Each property will need its own journal entry - 16If client is doing an ownership change and wants a completely clean balance sheet which does not include CRE or CPYRE or any other capital account balance..Have them create a new property.
AppFolio reports are run by property and not by owner. CRE/CPYRE, Distributions will carry over on balance sheet to new owner.
Close out property on the old property and transfer all tenants into the new property - 17Beginning cash + net change in income and expenses should equal to actual ending cash should match, but don't. Why?- Items which don't impact operating cash but impact something on cash flow
- Ex. owner held SD paying off a rent charge
Items which may not impact something included on cash flow but impact operating cash
Ex. Owner Distribution/Contribution - 18Amt./R total on Aged Receivable Detail & Acct./R line on balance should match. Why?Aged Receivable Detail shows total amount of open charges in “Amount Receivable” Column
Balance sheet in accrual, the Accounts Receivable GL should equal amount of all open charges (assuming no accounting errors) - 19Steps to fix Aged Receivable Detail not matching Balance Sheet1. Run the Balance Sheet on a Cash Basis - Check for balance in A/R & edit/reverse/re-enter with different GL
2. Look for receipts paying off future dated charges
- Run Charge Detail Report - 20General Ledger matches Owner Statement balance. Client asks why AF over/underpaid owner. Solution1. Determine what owner payment calculation numbers would be based on the date the owner payment was created, run: Trust Account Balance
2. Run General Ledger
Anything created or edited after the owner payment would bring the property balance negative:
Backdated checks
Reversed / NSFed receipts
Edited Transaction dates
Edit JE amounts - 21Trial balanceLists all GL accounts with activity during the filtered date range.
Shows balance forward, total debits, total credits, and ending balance for each
A summarized General Ledger
Good report for bringing over YTD numbers for all GL accounts - 22Chart of AccountsLists all GL accounts and displays their settings
Group by options to see what is subject to mgmt fees, late fees, not included in 1099s, etc. - 23Check Register Detail(Enhanced)Report that shows you checks and payments
Used to figure out what eCheck batches consist of/match to Rec
Add in Column for ACH Batch Generation Date
Group by Check #
Check Register can be customized as a double check for payments that is sometimes required by a bank. (Positive Pay) - 24Deposit RegisterGroup of Deposits
Useful for finding NSFs - 25Bill DetailSearch for bills
Look for paid/unpaid bills
Search by specific GL account or vendor
Search for bills by payment date or bill date - 26Charge DetailFind charges
Find Other Receipts and charges into prepaid rent
Find when charges are paid with a receipt before charge date - 27Directories- Great report for finding information displayed on an individual page.
- Use to find hidden items, contact information, Late Fee Information, Online Portal Status - 28When we use a mortgage to buy a property we debit and credit what?Debit Asset, Credit Liability
- 29Mortgages establishing entryDebit Cash/Property/Land, Credit Mortgage/Loan Principle
- 30Payments for our loan will impact what?Mortgage or Loan Principal (liability)
Interest & Escrow (expense)
-Escrow expense includes taxes and insurance - 31Mortgages recurring payment entryDebit Mortgage/Loan Principle/Interest & Expense
Credit Cash - 32Mortgage and Loan Tracking- Loan types outside of Fixed-Rate Loans will need to be tracked manually.
- Mortgage Principal Balance must be up-to-date when using this feature.
- System will show payment schedule and help auto-generate payments for principal, interest, and escrow. - 33Dual Operating AccountsMany of our larger clients have a separate bank account used specifically for expenses
Income is received into main operating account, transferred to an expense operating account, then expenses are paid from the expense operating account - 34Dual Operating Accounts Setup1. Enabled in Success Admin Settings(After Pres Permission)
2. Create the new expense cash account (if not already created)
3. Set as a key account
4. Set on property page(s) by CCR(that’s you!) - 35Prepayments as Income Allows clients to treat prepayments as income the moment they are received for the following:- Management Fees
- Owner Payment Calculation
- Available Funds
- Report Prepayments as Income instead of Liability on Reports - 36Prepayments as Income - Management Fees & Owner PaymentsEnables management fees to be collected based on the prepayment receipt date.
Prepayments are no longer subtracted from the Pay Owners calculation - 37Prepayments as Income - Management Fees & Owner PaymentsAdmin Success Setting -> Enable Collection of Management Fees on Prepayments
Subject Prepayments GL account to Management Fees: Yes - 38Prepayments as Income - Reports & Avail. FundsPrepayments show as Income on reports instead of as a Liability
Prepayments are no longer subtracted from the Available Funds calculation - 39Prepayments as Income - Reports & Avail. FundsSetup:
Change Prepayment GL Account from Liability to Income
Removes Prepayments from being on the Security Deposit Funds Detail report
Recalculate Balances
Accounting -> GL Accounts -> Tasks - 40Prepayments as Income - Receipt Entry*For Prepayments receipts to be considered income for the owner, they must now be entered as:
Prepaid Future charges
OR
Prepaid *Insert any GL Account* - 41Prepayments marked as Nonewill be withheld from the Owner Payment Calculation as “Unassigned prepayments”
- 42Delinquency/Delinquency (As Of)Shows tenants, their status, balance owed, age of delinquent charges, and more!
Balance listed here is balance on tenant ledger - not necessarily unpaid charges - 43Security Deposit Funds DetailDisplays Tenant Level Liability
Defaults to Security and Additional Deposit Key Accounts
Can be run for any liability GL (Prepayments!)
Will always show tenant status as of now, so as of date will not show tenants who were active at a certain time. - 44Tenant TicklerDisplays move ins, move outs, and notice dates per occupancy within a specified date range
Can be used to track move ins per leasing agent
Recommend when clients are trying to find the completed movein/moveout on the dashboard. - 45Tenant Unpaid Charges SummaryShows unpaid charges as of a given date
As of date is the charge date, not receipt date - 46Resident Financial ActivityDisplays the tenant’s beginning balance, ending balance, all charges and payments, and the GL account associated with each
Grouped by unit and tenant
Can only be run for a property, property group or owner
Run for all properties by creating a property group with all properties - 47Receivables Activity ReportReport that details payment types used by tenants
Useful for targeting tenants to promote online payment adoption - 48Rent Roll/Rent Roll (Itemized)List of units grouped by property, that displays financial information like monthly rent charge
Lots of relevant columns to add (sqft, deposit, rent/sqft, annual rent)
Shows current tenants as of a certain date - 49Property PerformanceSee the total of rent, application fees, and late fees charged as well as management fees
- 50Additional FeesShows additional setup on each property
Useful to audit your Additional Fees
Group by Suppressed, Sort by Account to ensure Suppressed Fees Set up correctly
Group by Account, Sort by Percentage to ensure setup for specific GL accounts was correct across the board - 51BudgetsEnter a total for the year, system breaks down over each month
Fill in months individually
Fill with prior year or actuals based on YTD
Able to import/export budget - 52Reports to Know - BudgetsAnnual Budget Comparison
Budget Comparison
Budget Detail - 53Vendor 1099 ReportsVendor 1099 Summary
Vendor 1099 Detail
Check Register Detail (Enhanced)
Property Directory
Shows the vendor 1099 payer (optional column)
Vendor Ledger is NOT good to use
Filtered by bill date, not payment date - 54Client Usage ReportInternal Only Report
Shows many different internal metrics
Good for:
Knowing when to send a case to loyalty - 55Other reports for V+ Service UsageAutomated AP
Bill Pay/eCheck
Lisa
Mailing Service - 56Summary ReportsLeasing Summary (unit types)
Occupancy Summary (unit types)
Owner Leasing
Informationen
- Beschreibung
- Karteikarten am Advanced Reporting, erstellt von Matthew Kelley am 01/10/2021.
- Erstellt von
- Matthew Kelley
- Aufrufe
- 4
- Bewertung