Enhanced interface

Sales Register report

The Sales Register report displays the invoices you sent to customers in the specified time period, and any account adjustments that were entered. Each transaction that's listed shows the date, customer ID and name, invoice or adjustment number, due date, description (if any), amount, and amount paid.

Using the report, you can:

View invoices and adjustments
See the payment details for invoices, including the payment method and date
See credit details, including which invoices a particular adjustment was applied to
See subtotals of invoice amounts by customer or location

In the HTML view, the dates in the date column are links that enable you to drill down to the corresponding transaction.

For information on terms that may differ in your location, see Terminology across locales.

To generate this report, go to Accounts Receivable > All > Reports > Registers > Sales.

Subscription	Accounts Receivable
User type	Business, Employee, Approval
Permissions	Sales register report: Run

View a monthly report

On the report settings page, select View.
The report displays all results for the default reporting period.
To refine the report, select Customize.

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

You can use trial-and-error to get the precise results you want. Just fill in the desired fields, and select View to see the report. If the results aren't what you want, select Customize to return to the report setup page and refine the report further. Repeat this process until you're satisfied.

For complex financial reports that will be run regularly, save the report after you're done setting it up. The next time you're ready to run the report, you only have to change the As of date before running the report.

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.

To set the time period:

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

You can use the Filters section to filter the list of invoices and adjustments by customer or customer type. In addition, you can optionally include additional information about how invoices were paid, or how adjustments were applied to invoices.

To customize your report results, change the filters as follows:

To show results for a specific customer, select the From Customer dropdown list, and then select the customer you want the report to include.

How to use the From and To fields

All From and To field pairs work the same way. Use them to get search results in as broad or as fine a range as you need, from everything in the system down to a single specific object.

To run this report for a single object:

From the From dropdown list, select the object you want.
From the To dropdown list, select the same object.

To run this report for a specific range of objects:

From the From dropdown list, select the object that you want at the beginning of the range.
From the To dropdown list, select the object that you want at the end of the range.

To run this report for all objects:

Leave both fields blank.

If you have a large number of objects or the report takes too long to process, use the From and To fields to run a series of smaller reports. For example, you can run five reports, one each for objects whose names begin with A-E, then F-J, K-O, P-T, and U-Z.

An object is a catch-all term that refers to any specific data item in the system. Customers, vendors, items, and accounts are all examples of objects.

To show results for a specific customer type, select the Customer type dropdown list, and then select the customer type you want the report to include.
Select whether you want to Display transaction details for invoices and adjustments, such as the account, department, location, allocation, and memo.
Select whether you want to show details about how invoices were paid and how adjustments were applied. If multiple payments were made toward an invoice, or if an adjustment was applied to multiple invoices, this detail is broken out into several lines.
- To display details about how customers paid (such as the payment method and payment date), select the Display payment details checkbox.
- To display details about where adjustments were applied, select the Show credit details checkbox. Selecting this option changes the Paid by column to a Paid by/Paid to column and adds information about the invoices to which the adjustment was applied.
If you do not want the report to display invoices that have already been paid, select the Hide paid documents checkbox.
If you want the report to display only invoice line items that have been released for payment, check the Show only released line items checkbox.

Filter option	Notes
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.
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.
Transaction currency	Include only transactions in the currency specified.
Territory
Display transaction details	This option adds additional detail for each transaction in the report, including the Account label (or GL Account), Department, Location, Allocation, and Memo. By default this checkbox is unchecked, which means the report will not include any details.
Display payment details	This option operates at the document level and shows how the invoice was paid. By default this checkbox is unchecked, which means the report will not include payment details.
Show credit details	This option shows how adjustments were applied to invoices. Selecting this option changes the Paid by column to a Paid by/Paid to column and adds information about the invoices to which the adjustment was applied.
Hide paid documents	Select this option if you’re interested in viewing only those invoices that have not yet been fully paid. This removes the paid invoices from the report to make it simpler to sort through. By default this checkbox is unchecked, which means the report will include paid invoices as well as unpaid ones.

Formatting

Use this section to specify the sort order and to change the page layout of the report.

To format this 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", 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 option	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
Group by	You can group invoices by customer or location and display subtotals. Otherwise, the default is None.

Format option

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

Group by

You can group invoices by customer or location and display subtotals. Otherwise, the default is None.

Titles and footer

Titles, subtitles, and footers apply only to the PDF version of this report.

Generate a PDF version

Open the report and select Graph.
From the graph page, select Print.

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 Sales Register report consists of the following columns:

Report Column Heading	Description
Date	The date on which you sent the invoice to the customer
Customer ID	The ID associated with your customer followed by the customer's name
Invoice no./Adjustment no.	The customer's invoice number with your company
Due Date	The date on which the invoice was due
Descr	A description of the products or services the customer bought
Currency
Txn Amount
Amount	The amount of the invoice
Amount Paid	The amount the customer paid your company

You can select any link to drill down to the details.