Credit Card Register report

View, reverse, and void credit card charges and payments using the Credit Card Register report.

Credit card charges can result from:

  • Paying bills in Accounts Payable using Credit card as the payment method.
  • Recording credit card transactions in Cash Management.

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

Subscription

Cash Management

User type

Business, Employee, Project Manager
Permissions

Credit Card Register report: Run

Credit Card Transactions: Delete, Reverse

View a monthly report

  1. Go to Cash Management > All > Reports > Registers > Credit card.

  2. On the report settings page, select View.

    The report displays all results for the default reporting period.

  3. 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 and specify how you want the report to appear.

Use trial-and-error to get the precise results you want.

Fill in the desired boxes, and select View to see the report. If after viewing the results you want to refine the report further, select Customize to return to the report setup page.  Repeat this process until you're satisfied. For complex financial reports you plan to run regularly, select a reporting period and memorize the report when you're done setting it up. Just change the As of date before running the report next time.

  1. 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, Intacct 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.

  2. 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 credit card and credit card vendor. As a general rule, to get fewer and more precise results in your report, set more filters.

  3. 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.

  4. Enter a title, subtitle, and footer text for your report.
  5. View, process, memorize, export, or customize the report or add it to the dashboard by selecting one of the following:
    6. To... ...select

    View the report now, in your browser.

    View

    Display the report now, in printable PDF format.

    Print

    Generate the report and store it for later access. Reports can be either stored in the My Stored Reports list or delivered to a cloud storage location, such as Dropbox. Learn more about processing and storing reports.

    Process & Store

    Add the report to your dashboard

    Add to Dashboard

    Memorize (that is, save) the report so that later you can refer back to it or modify and re-run it.

    Memorize

    Export the report to a separate file that you can then distribute or save to your local drive. File formats to which you can export the report data vary among reports.

    Export

    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:

    EITHER

    • Select the Reporting period down arrow, and then select the time period you want.
    • Enter an As of date (the date that Intacct will use as a baseline for the period you select. Leave blank for today's date).

    OR

Enter a specific Start date and/or a specific End date.

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 each item in the Time period section of this report settings page:

Time Period Box Notes Limitations

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.

Only works with As of date. Does not apply if you select a Start date or an End date.

As of date

The date used as a baseline for the reporting period you select. Leave this box blank to use today's date.

Only works with Reporting period. Does not apply if you select a Start date or an End date.

Start date, End date

Leave the Start date blank to include all information from the earliest date you entered data into your company up to and including the end date. Leave the End date blank to include all information from the start date up to today.

The format must be MM/DD/YYYY.

Prompt on run

Select this checkbox to force Intacct to wait for you (or anyone using this report) to enter a time period before it runs 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.

  1. To select a particular account, select the Credit card dropdown list, and then select the account you want the report to include.
  2. To show results for a specific vendor, use the Credit card vendor dropdown list.

The following table describes each item in the Filters section of this report settings page:

Filter Description

Credit card

The credit card that you want to include in the report.

Credit card vendor

The credit card vendor you want to include in the report.

Formatting

Use this section to change the page layout for this report.

  • 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 Notes

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).

  1. 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 type over any default name that the system may have automatically supplied in this box.  

  2. Enter the subtitle in the Report title 2 box.

    • The subtitle displays in smaller type, directly beneath the main title.
  3. 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, subtitle, and footer.

What's in this report?

The default Credit card register report consists of the following columns:

Report column heading Description

Account

The credit card account name.

Date

The date for the charge.

Vendor or Payee

Whether the charge was to pay off a bill or a miscellaneous charge entered in Cash Management.

Description

Any description that was entered when the charge was recorded (by a user or by Intacct).

Examples of system-generated descriptions include: "Card name liability transferred to AP" when you pay off charges in Cash Management, "Finance Charge" that you enter during reconciliation, "Transfer To CC Card" when you make a funds transfer, and so on.

Ref number

The transaction number for the charge.

Cleared

The date the charge cleared in the account reconciliation process. Transit indicates charges that have not yet been cleared.

Currency

For multi-currency companies, the currency used for the charge.

Txn charges or Charges

The amount of the charge.

Txn payments or Payments

The amount of any payment that has been made.

Balance

The current balance of the card.

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