How to use Pre-Built Reports
Updated
by
Vanessa Borges
How to use Pre-Built Reports
- Navigate to Finance > Reports.
- From the Reports dropdown, select the type of report you want to generate.
Here are the different types of reports you can generate:
- Audit & Error Corrections: This report shows journal entries marked as auditor entries or error corrections, helping identify and track adjustments or discrepancies.
- Balance Sheet: Displays the balances of assets and liabilities, helping the city understand how much cash is available after liabilities are paid.
- Chart of Accounts: Lists all General Ledger accounts, along with the account type, fund, department, and line account. This provides an organized view of the city’s financial structure.
- Check Register: Shows a list of all checks issued during a specific period. It indicates whether the check has cleared, was manually written, or was voided.
- Expense History: Shows a history of journal entries posted to each General Ledger expense account for a specified time period. This helps track past spending.
- History: Lists all journal entries posted to each General Ledger account during a specified time period, covering all account types (not just expense accounts).
- Income Statement: Summarizes revenue and expense account balances. This helps the city monitor its revenue to ensure it can cover its expenses.
- Revenue: Lists each revenue account with details including the annual budget, month-to-date balance, year-to-date balance, and any uncollected amounts.
- Revenue & Expense: Shows both revenue and expense accounts with their annual budgets, month-to-date balances, year-to-date balances, and any uncollected or unexpended amounts.
- Revenue History: Displays the history of journal entries posted to each General Ledger revenue account during the specified time period.
- Transaction Register: Shows a list of all bank transactions during a specified period, including deposits, withdrawals, and transfers.
- Treasurer Report: Summarizes each fund’s financial status, including the ending balance from the previous month, revenue received this month, expenses paid, and the final fund balance. The fund balance represents the total cash in a particular fund.
- Trial Balance: Displays the balances for assets, liabilities, revenues, and expenses, ensuring the city’s financial records are balanced.
- Auditor's Report: Lists checks issued over a specified dollar amount, helping auditors focus on large transactions.
- Claims Report: Shows claims (scheduled or paid) during a specified period. This report is typically used to present claims to the council for approval.
- Vendor Activity: Shows invoices paid during a specified period. You can filter this report to show activity for 1099 vendors specifically.
- Set the Date to define the report's time period.
- Click Run.
- The report will display as a table. You can export it as a spreadsheet by clicking Export.
