Monthly_Analysis_Report

Monthly Analysis Report

A Monthly Analysis Report provides a summary of business tax collection activity for a specific month. Printing this report helps a tax clerk review monthly trends, verify totals, and compare activity across reporting periods.

You might print the report to support reconciliation, prepare monthly financial reviews, research variances, or provide documentation for audits and management reporting. The report also helps maintain a historical record of monthly tax collection activity.

Printing a Monthly Analysis Report

Set up the report options and send the report to the printer.


Do this...

1. Open Connect Business Tax Collection > Reports > Monthly Analysis Report.

2. Select a report title.

3. Enter the Report Dates.

Report Dates is the report date range. The report will use the report date range to select transactions to print on the report.

Do you want to use the fiscal year end as the report end date?

  • Yes, I want to use the fiscal year end. This is the default setting.

  • No, I want to use a different date. Change the Report Date, or click Advanced Options.


4. Select the Include Transactions Based On.

A transaction is an exchange or transfer of goods, services, or funds. Use Payment Applied Date to include transactions based on the date when the payment was allocated. Use Tax Return Filing Date to include transactions based on the date when the tax return was filed. Use Tax Return Period End Date to include transactions based on the last date recorded in the selected period.


5. Set up the option to Include Items With No Activity.

This option will include businesses, tax types, and fees that do not have any transactions recorded during the date range.


6. Set up the option to Only Include the Top [ _ ] Businesses.

Use Only Include the Top [ _ ] Businesses you can choose to print all of the businesses that meet the report selection criteria, or you can print a specific number of businesses. For example, enter 20 in the Only Include the Top [ _ ] Businesses field to only print the amounts for the top twenty businesses based on the amounts filed for the selected date range.


7. Set up Amounts Based On.

The base is the option that serves as the basis for calculating an amount. The based on option allows you to determine the amount based on the reporting category or selected tax types/fees. Use Report Category to base amounts on transactions. For example, selecting the Taxable Amount reporting category will report amounts based on the taxable amount found in each business's file. Use Selected Tax Types/Fees to base amounts on tax types and fees that are associated with each business. For example, use this option to select all businesses that have an NSF Check Fee.

What do you want to do?

  • I want to base amounts on a reporting category. Click to select Reporting Category. Use the drop-down list to select a reporting category.

  • I want to base amounts on a tax type or fee. Click to select Selected Tax Types/Fees. Click the Select button. Use the Selection form to choose the tax types and fees. Click OK. To print a total for each tax type and fee instead of including the transaction detail, click to select Summarize the Selected Tax Types/Fees.


8. Enter the Fiscal Year Ends In.

A fiscal year refers to twelve consecutive months an organization uses to account for and report on its business operations. Typically, organizations use a fiscal year ending December 31. However, some governmental units end their fiscal year end on June 30.

In what month does the fiscal year end?

  • Use the Fiscal Year Ends In drop-down list to select the month when the fiscal year ends.


9. Click Print (CTRL+P).

The report prints.

 

Amounts based on

The base is the option that serves as the basis for calculating an amount. The based on option allows you to determine the amount based on the reporting category or selected tax types/fees. Use Report Category to base amounts on transactions. For example, selecting the Taxable Amount reporting category will report amounts based on the taxable amount found in each business's file. Use Selected Tax Types/Fees to base amounts on tax types and fees that are associated with each business. For example, use this option to select all businesses that have an NSF Check Fee.

What do you want to do?

  • I want to base amounts on a reporting category. Click to select Reporting Category. Use the drop-down list to select a reporting category.

  • I want to base amounts on a tax type or fee. Click to select Selected Tax Types/Fees. Click the Select button. Use the Selection form to choose the tax types and fees. Click OK.

Fiscal year ends in

A fiscal year refers to twelve consecutive months an organization uses to account for and report on its business operations. Typically, organizations use a fiscal year ending December 31. However, some governmental units end their fiscal year end on June 30.

In what month does the fiscal year end?

Use the Fiscal Year Ends In drop-down list to select the month when the fiscal year ends.

Include items with no activity

This option will include businesses, tax types, and fees that do not have any transactions recorded during the date range.

Include transactions based on

A transaction is an exchange or transfer of goods, services, or funds. Use Payment Applied Date to include transactions based on the date when the payment was allocated. Use Tax Return Filing Date to include transactions based on the date when the tax return was filed. Use Tax Return Period End Date to include transactions based on the last date recorded in the selected period.

Only include the top [ _ ] businesses

Use Only Include the Top [ _ ] Businesses you can choose to print all of the businesses that meet the report selection criteria, or you can print a specific number of businesses. For example, enter 20 in the Only Include the Top [ _ ] Businesses field to only print the amounts for the top twenty businesses based on the amounts filed for the selected date range.

Report dates

Report Dates is the report date range. The report will use the report date range to select transactions to print on the report.

Do you want to use the calendar year as the report range?

  • Yes, I want to use the calendar year. Continue to the next step.

  • No, I want to use a different date range. Change the Report Date, or click Advanced Options.

Reporting category

The Reporting Categories are categories that you can set up to report amounts for a group of accounts. Use Report Category to base amounts on transactions. For example, selecting the Taxable Amount reporting category will report amounts based on the taxable amount found in each business's file.

Selected tax types/fees

Use Selected Tax Types/Fees to base amounts on tax types and fees that are associated with each business. For example, use this option to select all businesses that have an NSF Check Fee.

Summarize the selected tax types/fees

If amounts are based on the selected tax types and fees, then you have the option of summarizing amounts by tax type/fee. Print a single row for each business that shows the total amounts for the selected tax types and fees.

Do not select this option to print a row for each business and tax type/fee.

 

 

    • Related Articles

    • Monthly Checklist Basics

      Like the Daily Checklist, the purpose of the Monthly Checklist is to help you remember to perform the tasks that only occur once a month. When you want to complete the Monthly Checklist is really whatever works best for you. Running the Monthly ...
    • How do I verify the monthly pay periods?

      A pay period is the interval in which you choose to pay your employees. Use Verify Monthly Pay Periods to check if the Pay Code Monthly Pay Period Summary totals match the totals for each pay code in the employee record. Verifying monthly pay periods ...
    • How do I verify the monthly pay period summary?

      Use Verify Monthly Pay Periods to check if the pay code monthly pay period summary totals match the totals for each pay code in the employee record. Verifying the monthly pay period summary 1. Open Connect Payroll > Organization > Checkout. 2. Click ...
    • How do I verify the monthly pay period summary?

      Use Verify Monthly Pay Periods to check if the pay code monthly pay period summary totals match the totals for each pay code in the employee record. Verifying the monthly pay period summary 1. Open Connect Payroll > Organization > Checkout. 2. Click ...
    • Lookback Report

      The Lookback Report determines employee eligibility for the Affordable Care Act (ACA). The report will count the average number hours worked by an employee during the date range to determine if the employee meets the ACAs weekly hours worked test. ...