Types of Reports

This article outlines the different reports currently available in Vantaca and what they report on. For more information on how to view reports, click here.

Reports are split into six categories.

Accounting

Admin Billing Report
Shows a number of statistics across all associations in your database, including ACH and AP Drafts, Collections, and Violation letters. Full article with details on each field coming soon.

Bad Financial Summary
Shows all associations in your database with incomplete financials per the Financial Summary screen. Prints in portrait orientation.

Bad Financial Summary (New)
Shows all associations in your database with incomplete financials per the Financial Summary screen. Can be customized to only show individual types of out of balance associations. Prints in landscape orientation.

Bank Account Balances
Excel-only report. Shows the balances and GL Accounts of all bank accounts in your database.

Billing Report
Shows all primary assessment charges currently set up in your database.

Cash Forecast Report
This Report shows the beginning balances of your account, then uses the YTD Actuals and your Budget to show what has been spent YTD and forecast the rest of fiscal year based on this data. 

Clean Financial Summary
Shows all associations with complete financials per the Financial Summary screen.

Daily Bank Unreconciled Items
Shows unreconciled bank-side items across all associations and all bank accounts.

Error Report
Shows all action items of the Alerts category created during the date range.

Full Invoice List
Excel-only report. Shows all invoices in the database. Equivalent to exporting from the Service Providers > Invoices page.

Merged Owners w/ Credit
Shows all homeowners with more than one property and with a credit balance across all associations.

Service Contract w/ No Activity
Shows all Service Contracts that have not generated an invoice within a month before the set beginning date.

Vendor Usage Report (by Association)
Shows total invoices and non-invoice action items for all service providers, grouped by association.

Vendor Usage Report (by Vendor)
Shows total invoices and non-invoice action items for all service providers, grouped by service provider.

Association

ARC Report
Shows all ARC Request action items with a step in the given time range. Can adjust details shown and filter the action items by their current status.

Association List
Shows a list of all associations and their Tax IDs.

Collections Report
Shows all Collections action items with a step in the given time range. Can adjust details shown and filter the action items by their current status.

Homeowner Charge Percentages
Shows all Charge Percentages currently set up in the association.

Homeowner Charge Tags
Shows all Charge Tags currently set up in the association.

Homeowner Other Tags
Shows all Other Tags currently set up in the association.

Open Invoices Report
Shows all open Invoice action items for the association, grouped by service provider.

Owner Transfer Report
Shows all ownership transfers that were processed during the time period, as defined by all action items that had a step with the "Create New Owner Action Item" additional action created.

Violations Report
Shows all Violations action items with a step in the given time range. Can adjust details shown and filter the action items by their current status.

Work Order Summary
Shows all Work Order action items with a step in the given time range. Can adjust details shown and filter the action items by their current status.

Financials

Annual Budget Comparison
Compares annual GL budgets and actual data for the current fiscal year, the last fiscal year, and the next fiscal year, if budget information is available.

Annual Budget Comparison with Percent
Compares annual GL budgets and actual data for the current fiscal year, the last fiscal year, and the next fiscal year, if budget information is available with a column for percent difference.

AP Aging
Shows invoices that have been expensed but not yet paid as of the end date.

AR Aging Reports
Shows owners with money owed.

AR Aging
Shows money owed by owners as of the process date, and can be filtered to include or exclude previous owners and charges outside of the Assessment charge type.

AR Aging (No Credit Balances)
Same as the AR Aging report, but does not include any instances in which the owner has a credit balance in non-Credit type charges at the process date.

AR Aging By Fund

Same as AR Aging, but with charges broken out by Fund.

AR Aging By Year
Same as AR Aging, but with charges split out based on the year they were charged.

AR Aging Summary
Same as AR Aging report, but without charge breakdown. Helpful for large associations. 

Balance Sheets
Shows asset vs liability and equity GLs.

Balance Sheet (2 Col)
Depicts the GL by Fund, split into the Operating or Reserve group as dictated by the Report Group setup in Association > Funds.

Balance Sheet (Funds)
Splits the GL by Fund, with each Fund in its own column.

Balance Sheet (w/ Codes)
Identical to the Balance Sheet - Consolidated, but includes the Codes for each GL Account.

Balance Sheet - Consolidated
Disregards Funds, instead grouping totals purely by GL Account.

Balance Sheet - Groups Only
Disregards funds and groups totals purely by GL Group.

Balance Sheet by Fund
Splits the GL by Fund, with each Fund shown in its own section one after the other.

Balance Sheet Monthly Comparison
Compares the data as presented by the Balance Sheet - Consolidated for the chosen "current" month and the month immediately before.

Balance Sheet W/ Breakout
Similar to the Balance Sheet - Consolidated, but includes a breakout of the individual GL Accounts that splits their total into their Funds.

Bank Reconciliation
Shows the reconciliation summary of each of the association's bank accounts as well as their reconciled and unreconciled items for the given period.

Bank Register
Shows all items on the Association Bank Register (Association > Bank Register) with dates from the beginning of the month to the chosen date. Does not include deleted items.

Budget
Shows all budgets set for the Fiscal Year of the selected process date.

Budget Spread Report
Shows all budgets set for the Fiscal Year of the selected process date as compared to the actual value of each GL Account, including the variance.

Cash Disbursement
Shows Transfers and Invoices from the Association Bank Register and how their totals are assigned to each GL Account. Runs from the beginning of the month to the set process date.

Cash Disbursement (Variable Start Date)
Identical to the Cash Disbursement report but the start date can be manually set. Defaults to the beginning of the month.

Deposit Register
Shows deposit items it the Association Bank Register for the given timeframe. This is all items of the types Manual Owner Deposit, Transfer In, Lockbox Deposit, ACH Deposit, Credit Card Deposit, and Misc Deposit.

Equity Report

Shows all Equity GLs for an Association, with a breakdown by Fund. 

GL Trial Balance Reports
Shows debits, credits and balances for GL account items.

GL Trial Balance
For the timeframe passed in, defaulting to the beginning of the month through to the end date, shows each GL Account that has been touched and all items that have touched it, split into Debits and Credits. Also shows the Beginning Balance and Ending Balance for the time period.

GL Trial Balance (Expense Only)
Same as the Gl Trial Balance, but only shows GL Accounts of the Expense type.

GL Trial Balance By Fund
Splits out the GL Trial Balance into Funds, and can filter down to showing individual Funds.

GL Trial Balance By Groups
Same as the GL Trial Balance, but defaults to the last year and allows you to filter to individual GL Groups and GL Accounts.

GL Trial Balance Summary
Same as the GL Trial Balance, but does not include the individual item breakdown for each GL Account, instead just showing the totals for each Account over the time period.

Income Forecast Report
Similar to the Budget Spread Report, but shows real values for all past months and budget values for all future months.

Income Statements
Shows income vs expense GLs over the current period (usually monthly) and YTD, as well as their budget values for comparison.

Income Statement (2Col)
Splits the GL by Fund, split into the Operating or Reserve group as dictated by the Report Group setup in Association > Funds.

Income Statement - Consolidated
Consolidates the Funds into a single Operating Fund and shows a monthly current period.

Income Statement - Groups Only
Removes the individual GL Account totals, instead just showing the GL Groups.

Income Statement - Quarterly
Same as the Income Statement - Consolidated but with a quarterly current period.

Income Statement By Groups
A standard Income Statement with additional filtering by GL Group.

Income Statement Summary
Shows Income Statement totals on a month by month basis for the entire year, formatted similarly to the Budget Spread Report.

Income Statement Summary - Consolidated
Same as the Income Statement Summary but with Funds consolidated into a single Operating Fund.

Income Statement Summary - Rolling 12 Month
Same as the Income Statement Summary but runs on a rolling 12 months instead of Fiscal Year. Ex: April - March when Fiscal Year is Jan-Dec.

Income Statement W/ Breakout
Same as the Income Statement - Consolidated but with an additional breakout of the individual GL Accounts that splits their total into their Funds.

Income Statement with Cash Flow
Same as the Income Statement W/ Breakout but with an additional Cash Flow section, which includes GL Types outside of Income and Expense for any GL Accounts with Budgets set up.

Income Statement with Codes
A standard Income Statement with no consolidation by Fund.

Income Statement Yearly Comparison (Month)
Shows a comparison of monthly values as in the Income Statement with Codes for the current period's month and the same month one year ago.

Income Statement Yearly Comparison (YTD)
Shows a comparison of YTD values as in the Income Statement with Codes for the current period's Fiscal YTD to the same YTD one year ago.

Prepaid Homeowners
Shows all owners with a total in their Credit charge type as of the chosen date.

Proposed Annual Budget
Shows the current Budget set up by GL Account as compared to the Budget set up for the next fiscal year. This shows both income and expense GLs. 

Receivables Type Balance
Shows owner ledger charges and payments over a given date range alongside prior and current balance grouped by charge and owner.

Receivables Type Balance By Year
Same as the Receivables Type Balance report but groups charges by the year they were charged in, similarly to the AR Aging by Year report.

Reserve Summary Report
Shows contributions, expenditures, transfer activity, and balances for GL Accounts set to be put in the Reserve Summary Report per the Association > GL Accounts screen.

Reserve Summary Report By Fund

Similar to Reserve Summary Report, but GL Accounts are further broken down by Fund. 

Reserve Summary Report YTD
Same as the Reserve Summary Report, but defaults to YTD instead of MTD.

Homeowner

All Addresses (Current Resident) Export
Excel-only report. This report exports all addresses on the Homeowner > Contact Info page, and lists “Current Resident” for the owner name for the Property Address if that’s not the Primary Mailing Address.

All Addresses Export
Excel-only report. This Report exports all addresses in Homeowner > Contact Info, as well as the Property Address. This includes both those marked as "Mailing" addresses, and those not marked as such.

All Board Members
Excel-only report. A list of all board members and their contact information across all associations in the database.

Homeowner Mailing Labels
Creates mailing labels for owners, formatted to print on an Avery 8160 label sheet.

Homeowner Transaction History
Shows all transactions over the date range for the homeowner currently selected. If you're not sure what homeowner is selected, go to Homeowners > Ledger to easily check.

Homeowner Transaction History By Charge
Same as the Homeowner Transaction History report, but groups transactions by their charge type.

Lease Report
Shows all tenants in the association including their contact information and leasing period.

Mailing Addresses Export
Excel-only report. This report exports all addresses in Homeowner > Contact Info that are marked as “Is Mailing Address.” (If there are none, the Property Address will be listed.)

Meeting Sign-in
Lists all homeowners alongside their contact information and a signature line.

Meeting Sign-In (Consolidated)
Similar to the Meeting Sign-in, but much smaller and with a few additional fields: a Proxy check box and an Ownership Percentage if the owners are set up with an Assessment with a percentage-type charge.

Owner Violation Report

Similar to the Violation Report at the Association Level. This report will show all violations received by a certain homeowner during a chosen time. This can by filtered using the same parameters as the Association Violation Report.

Transaction History By Association
Shows the Homeowner Transaction History report but for all owners in the association. This can also be run to include all Previous Owners, or only Previous Owners with a balance. 

Settings

Master GL Account List
Shows all GL Accounts set up in your database.

Statements

Homeowner statement reports. These reports must be run with the homeowner in question selected. If you're not sure what homeowner is selected, go to Homeowners > Ledger to easily check.

Statement (Last 2 Months)
The statement runs with values over the last two months.

Statement (Last Month)
The statement runs with values over the last month.

Statement (Last Zero Balance)
The statement runs with values since the last time the homeowner had a $0 balance.

Statement (YTD)
The statement runs with values over the current year.