AR Reclassification Report
The Accounts Receivable (AR) Reclassification report displays a list of documents with data that was reclassified from one account to another in the past month and the names of those who reclassified them.
Suppose your company has several users who have permission to change accounting data for invoices and/or adjustments that have already been partially or fully paid. Use this report to see a list of those transactions and who reclassified them.
Who typically needs this report?
Accountants and controllers, those responsible for managing the company’s financials. You can use this report as an audit trail.
For information on terms that may differ in your location, see Terminology across locales.
To generate this report, go to Accounts Receivable > All > Reports > Reclassification.
| Subscription | Accounts Receivable |
|---|---|
| User type | Business |
| Permissions | Reclassification Report: Run |
View a monthly report
- When the report page appears, select View.
- A report showing all results for the month to date appears in your browser.
- To refine the report, select Customize to return to the main report page, and follow the steps in Customizing and Running This Report below.
Some of your customized settings persist from session to session, but others do not.
When you return to this page again, the following settings retain previously made changes:
- All fields in the Format section
- All fields in the Titles section
- Check boxes and option buttons in the Filters section
For example, if you enter My latest report into the Report title 1 field, the next time you run this report the Report title 1 box displays My latest report.
The following fields display default settings every time you return to this page to run this report. If you changed any of these settings the last time you ran this report, you have to change them again. These fields do not retain changes:
- Time period section
- Dropdown in the Filters section
Customize and run
Before running the report, you can select the time period and types of items to include as well as specify how you want the report to appear.
-
Select the reporting period from the dropdown menu, or enter the start and end dates you want the report to cover. If you do not specify a reporting period, the system generates a report for the current month to date.
You can specify either the reporting period or the start and end dates, but not both.
-
Set the filters to get the specific data you want.
Filters enable you to include or exclude specific types of data in the report, such as vendor and location. As a general rule, to get fewer and more precise results in your report, set more filters.
-
Format the report.
Format options vary from report to report. Generally, you can set the layout of the report and/or arrange how to group and display the data contained in the report.
- Type a title, subtitle, and footer text for your report.
-
Do one of the following:
How to work with reports To: Select: View the report now, in your browser.
View
Display the report in PDF format so you can print it or save it to your local drive.
Print
Generate the report and store it for later access. Available formats include HTML, printable (PDF), Excel, CSV (comma-separated value), and Text. Reports can be stored:
- In Intacct
- In the My stored reports list
- Delivered to a cloud storage location, such as Dropbox
Learn more about processing and storing reports.
Process and store
Add the report to your dashboard.
Add to dashboard
Memorize (that is, save) the report in the Memorized reports list so that later you can refer back to it or modify and re-run it.
You can schedule memorized reports to run on a recurring basis. Intacct can automatically email the reports or deliver them to a cloud storage location.
Memorize
Export the report to a separate file that you can then distribute or save to your local drive. Available file formats vary among reports.
Export
After you run a report, you can either email it to others or return to the Report Settings page to refine the results.
Share and refine reports After running the report, to... Select Email the report to others.
Email
Return to the main report page and refine the report further.
Customize
Time period
You can use one of the pre-defined reporting periods available from the Reporting Period and As of Date boxes, or create your own reporting period using the Start Date and End Date boxes.
In the Time period section, do one of the following:
- Use the Reporting period dropdown list to select the reporting period. Either enter a date in the As of date field or use the calendar tool to select a date.
- Enter a specific Start date, End date, or both. Alternatively, use the calendar tool to select the desired dates.
If you complete all the time period fields (that is, if you fill in the Reporting period, As of date, Start date, and End date fields), Sage Intacct generates your report based on the start and end dates. It ignores the As of date.
The following table describes the fields in the Time period section.
| Field | Description |
|---|---|
|
Reporting period |
These periods are relative to the As of date. All periods begin on the first day of the period, such as the first day of the month, quarter, or year that you select. |
|
As of date |
The date that Intacct will use as a baseline for the reporting period you select. Defaults to today's date. |
|
Start date |
Leave the Start date blank to include all information from the earliest date of your Intacct data up to and including the end date. |
|
End date |
Leave the End date blank to include all information from the start date up to today. |
|
Prompt on run |
Select this checkbox to force Intacct to wait for you (or anyone using this report) to enter a location, department, and/or time period before it will run the report. |
Report filters
Use the filters to focus the results of your report. In effect, filters enable you to isolate and assemble just the data you want. You can set any combination of filters. To customize your report results, change the filters as follows:
In the Filters section:
EITHER
- To show results for a specific document, select the Document number dropdown list, and then select the number of the document to view.
OR
- To show results for a specific vendor type, select the Customer Type dropdown list, and then select the vendor type you want the report to include.
- Consultants and distributors are two examples of vendor types.
- To show results for a specific vendor or range of vendors, use the From customer and To customer dropdown lists.
-
To filter the report by geographic location, either enter the name of the region, country, state or territory, or city in the Location dropdown list. Or, select the location from the list.
Enter or select a location if you want to run this report at the top level. The system uses the location that you specify to determine the appropriate currency.
- To filter the report by department within the company, enter the name of the department in the Department dropdown list. Or, select the department from the list.
-
If you want the report to cover certain locations regardless of what's selected in the Location dropdown list, use the Show for dropdown list to select the locations for the report:
- All locations: To include data for all locations regardless of the entity that you're currently using.
- This location: To include data only for the entity that you're currently using.
- Child locations: To include data only for the locations that are child locations of your current entity. For example, if your current entity is California, and you have child locations for San Francisco and Los Angeles, use this option to have the report include data only for Los Angeles and California.
- To show only transactions reclassified by a specific person, select that person's user ID from the User ID dropdown menu.
- Select the type of transactions to include in this report:
- Invoices only: include only invoices that were reclassified
- Adjustments only: include only adjustments that were reclassified
- Sales Only: include only sales transactions that were reclassified
- All: include invoices, adjustments, and sales transactions that were reclassified
In a multi-entity environment, you can filter by location, department, or both.
| Filter Box | Notes |
|---|---|
|
Document number |
Include reclassified data only from the specified document. |
|
Customer type |
Include data only for the type of customer specified. By default this box is blank, which means the report will include all customer types. |
|
From customer, To customer |
Includes data only for a specific customer or range of customers. By default these boxes are blank, which means the report will include all customers. |
|
User ID |
Include only transactions reclassified by the person with the specified user ID. |
|
Include |
Include only the type of reclassified transactions specified. |
Formatting
Use this section to specify the sort order and to change the page layout of the report.
- To sort the report results, select the Sort by dropdown list, and then select the category to sort by.
The abbreviation "desc" after an option means "Descending order", such as reverse alphabetical or reverse numerical order.
- To change the page layout, select the Page orientation dropdown list, and then select either Portrait or Landscape.
The following table describes each item in the Format section of this report settings page:
| Format Box | Notes |
|---|---|
|
Sort by |
Date is the default. |
|
Page orientation |
Portrait is the default layout. Portrait: display or print the report pages vertically. Landscape: display or print the report pages horizontally. |
Titles and footer
Titles, subtitles, and footers apply only to the .pdf version of this report. (Select Print to get the .pdf version).
-
Enter the title in the Report title 1 box.
- This title displays in large type at the top of the page, directly under your company name.
- You can enter over any default name that the system might have automatically supplied in this box.
-
Enter the subtitle in the Report title 2 box.
This subtitle displays in smaller type, directly beneath the main title.
- Enter the footer text in the Footer text box. Footer text displays at the bottom center of the report.
You can use up to 80 characters, including spaces, in each title and subtitle, and footer.
When outputting to PDF, Standard reports automatically include the Created on timestamp and page number at the bottom of the page.
What's in this report?
The default AP Reclassification report consists of the following columns:
| Report Column Heading | Description |
|---|---|
|
Customer |
The ID and name of the customer. |
|
Document number |
The number assigned to a document. |
|
Type |
The type of transaction that was reclassified. |
|
Document date |
The date on which the document was created. |
|
GL posting date |
The date on which the reclassified transaction posted to the GL. |
|
Reclassification date |
The date on which the transaction was reclassified. |
|
User |
The ID of the person who reclassified the transaction. |
You can select any link to drill down to the details.