1. Accounting
  2. General Accounting
  3. Account Matching Report SuiteApp
  4. Using the Account Matching Report SuiteApp
  5. Exporting the Account Matching Report

Exporting the Account Matching Report

After generating a report, you can export the report in CSV format.

To export the Account Matching Report

  1. Generate an Account Matching Report. For more information, see Generating the Account Matching Report.

  2. Click Export to generate a CSV file of the report.

    Note:

    If the Export button remains dimmed, in the Show Transactions field, select Load more data so the system can load the rest of the transactions. You can only click Export when the report has finished loading all the transactions.

  3. On the CSV Report Dashboard window, you can either click Download All Files, or choose which CSV file you want to download.

If you want to open the CSV file, you can use a text editor.

The following table lists the columns unique to the exported CSV file and their descriptions:

Column Name

Description

Is Opening Balance

The column cell shows True for one of the following reasons:

  • The transaction with an unapplied amount is from an accounting period before the start period.

  • The amount is applied to transactions after the start period.

The column cell shows False if the transaction falls within the start and end period.

GL Number

The general ledger number of the transaction.

Note:

This column is only available if the GL Audit Numbering feature is enabled. For more information, see Enabling GL Audit Numbering and Setting Preferences.

Applied Debit Amount

The debit amount of the transaction that's applied to another transaction.

Applied Credit Amount

The credit amount of the transaction that's applied to another transaction.

Important Things to Note

  • Each exported CSV file can have up to 1,000,000 rows, and the file size is approximately 200 megabytes.

  • A group of CSV files can have up to 4 files, with index numbers starting at 1. When you download a group of files, each file is named in order, like AMReport1.csv, AMReport2.csv, and so on.

    With 4 exported CSV files, you can have up to 3,400,000 transaction lines, including all child transactions.

    To download a single file, click the name of the file. Alternatively, if you want to download all files at the same time, click Download All Files.

  • The Applied Debit Amount and Applied Credit Amount columns are only in the CSV file. These columns don't show up on the Account Matching Report page.

  • The total Debit and Credit amounts in NetSuite may not match the Applied Debit Amount and Applied Credit Amount totals in the CSV file.

    This behavior is expected because a parent transaction amount can be applied to several child transactions, and the applied amount can be either a debit or a credit. However, the total applied amounts will always match the parent transaction's original amount.

    Tip:

    You can use the SUM (n:m × 100) ÷ 100 function in your exported CSV file to match the total Debit and Credit amounts in NetSuite. Here, n is the first row number and m is the last row number in the CSV file.

Related Topics

General Notices