Monthly Activity
The Monthly Activity report ages the AR and WIP beginning and ending balances, providing an overview of billable account activity.
Permissions Required for this Report
In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:
- Security group profile > Functional rights > Reports > Shared Library > Shared Views
- Security group profile > Functional rights > Reports > Firm Library > Custom
- Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
- Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
- Security group profile > Functional rights > Reports > Firm Library > <report name>
Reports in Foundation that are Comparable
In Practice Management, the comparable report is Monthly Activity (Custom Library). In Practice Advantage, there is no comparable report.
Report Specifications
The following report options and filters are available to determine the report contents.
Options and Settings | ||
---|---|---|
Option | Setting | Description |
Set Number of Days for Aging Period 1 |
Numeric |
Includes the number of days specified for aging period 1. Enter 0 to exclude this aging period. |
Set Number of Days for Aging Period 2 |
Numeric |
Includes the number of days specified for aging period 2. Enter 0 to exclude this aging period. |
Set Number of Days for Aging Period 3 |
Numeric |
Includes the number of days specified for aging period 3. Enter 0 to exclude this aging period. |
Set Number of Days for Aging Period 4 |
Numeric |
Includes the number of days specified for aging period 4. Enter 0 to exclude this aging period. |
Set Number of Days for Aging Period 5 |
Numeric |
Includes the number of days specified for aging period 5. Enter 0 to exclude this aging period. |
Set Number of Days for Aging Period 6 |
Numeric |
Includes the number of days specified for aging period 6. Enter 0 to exclude this aging period. |
Set Number of Days for Aging Period 7 |
Numeric |
Includes the number of days specified for aging period 7. Enter 0 to exclude this aging period. |
Select to Age Transactions Using… |
List |
Determines whether the transaction date or accounting period date is used to determine aging. |
Hide Comma |
Yes/No |
Includes or excludes commas in numbers. |
Hide Penny |
Yes/No |
Includes or excludes cents in amounts. |
Include Deleted Clients |
Yes/No |
Includes or excludes deleted client information |
Default Filters | ||
---|---|---|
Field Name | Operator | Value |
Transaction Date | Between |
First Day of Current Fiscal Year; Last Day of Current Fiscal Year |
Optional Filters | ||
---|---|---|
Available Fields | ||
Accounting Period Date |
Client ID |
Client Sub ID |
Business Code |
Client ID.Sub ID |
Client Type |
Client |
Client Name |
Current |
Client – Principal |
Client Office |
Financial Reporting Client Group |
Client Bill Manager |
Client Primary Service Type |
Line of Business |
Client Business Unit |
Client Region |
Manager |
Posted Date |
Return Group |
Transaction Date |
Primary Partner |
Tax Type |
|
Grouping | ||
---|---|---|
Available Fields | ||
Business Code |
Client Name |
Line of Business |
Client |
Client Office |
Manager |
Client - Principal |
Client Primary Service Type |
Primary Partner |
Client Bill Manager |
Client Region |
Return Group |
Client Business Unit |
Client Sub ID |
Sort Name |
Client ID |
Client Type |
Tax Type |
Client ID.Sub ID |
Financial Reporting Client Group |
|
Sorting |
---|
There are no sorting options for this report. |
Report Fields
The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.
Report Fields | |
---|---|
Field | Description |
Client |
The client name and client ID. |
Accounts Receivable <start date of the report> |
The net total of all receivable amounts as of the start date of the report. |
Invoices |
The total invoice amount (billed WIP +/- write up/down + sales tax) posted during the range selected. |
Payments |
The net total of all payments received and posted during the date range selected, regardless of the distribution status. |
Adjustments |
The net total of all debit and credit adjustments. |
Write-Offs |
The total of all AR write-offs for the date range selected. |
Misc Debit |
The miscellaneous charges, handling fees, and finance charges that are entered in AR. |
Credit Memos |
The total of all posted credit memos for the date range selected. |
Debit Memos |
The total of all posted debit memos for the date range selected. |
A/R Balance <ending date of the report> |
The sum of beginning AR + invoices - payments +/- adjustments - write-offs + misc debit - credit memos + debit memos +/- corrections +/- voids. |
Work in Progress <start date of the report> |
All open, posted, and billable WIP, including on hold and expenses as of the start date of the report. |
Time |
All open, posted, and billable time entered for the date range select. |
Expenses |
All posted, billable expenses entered during the date range selected. |
WIP Available |
The sum of beginning WIP + billable time + billable expenses +/- transfers +/- corrections. |
Billed Amounts |
The total WIP on posted invoices for the date range selected. |
Write Downs |
The total write downs for the date range selected, including WIP write-offs. |
Write Ups |
The total write ups for the date range selected. |
WIP Relieved |
The billed amounts - write up + write downs. This will be displayed as a negative number. |
Progress Bills |
The net of progress billed and progress applied for the period selected. |
Balance of WIP <ending date of the report> |
The WIP available - WIP relieved +/- progress bills. |
Beginning AR Percentages |
The percentage of total beginning AR by aging interval. |
Ending AR Percentages |
The percentage of total ending AR by aging interval. |
Beginning WIP Percentages |
The percentage of total beginning WIP by aging interval. |
Ending WIP Percentages |
The percentage of total ending WIP by aging interval. |
Monthly Activity Sample Report