Account Matching Report Components
This section lists all the SuiteApp's report components.
Report Headers
The report header contains additional filter and pagination preferences to narrow down the report.
|
Header Item |
Description |
|---|---|
|
Export |
Enables you to export the report. For more information, see Exporting the Account Matching Report. |
|
As of End of End Period |
Switch this filter on to display transactions applied to a transaction line after the selected end period as Unapplied. The report provides a snapshot of the financial state at the end of the selected end period. Switch this filter off to display transactions posted after the selected end period as Applied, like other matched transactions.
Note:
The value in the Remaining Amount column may change when you switch this feature on and off. |
|
Rows per Page |
Sets the number of rows displayed on each page of the data grid. The maximum number of rows per page is 500. |
|
Show Transaction |
Select which set of transactions to display in the report. If the account has an opening balance, all transactions from previous accounting periods are grouped under Opening Balance with a line number of 1. |
|
Paging Toolbar |
Click the arrows to go to the next or previous page. |
|
Total |
Shows the total number of transactions. The Total is calculated as the sum of the opening balance and the number of transactions between the start and end periods. The opening balance is assigned a value of 1 if it includes any transactions, regardless of how many, and 0 if it includes none. For example, if an opening balance contains 10 transactions, it's assigned a value of 1. |
Report Sections
The report contains sections that provide information about the debit and credit amounts.
|
Header Item |
Description |
|---|---|
|
Opening Balance |
This header is displayed when transaction lines from previous periods are either unmatched or matched with transaction lines from the selected start period or later. |
|
Balance |
This section shows the opening balance amount of the report. |
|
Total |
This section shows the total amounts of the debit and credit column at the end of the selected end period. |
|
Closing Balance |
This section shows the closing balance amount of the report at the end of the selected end period. |
Report Columns
The left side of the report, from the Period column to the Link column, is sourced from the GL account data. While the right side of the report, from the Applied Trans Type column to the Code column, is sourced from the payment application feature of NetSuite.
The following table lists the Account Matching Report columns and their descriptions:
|
Column Name |
Description |
|---|---|
|
Period |
Shows the period of the transaction. The period format depends on the following conditions:
|
|
Trans Date |
Shows the date of the transaction. |
|
Trans Type |
Shows the type of the transaction. |
|
Document Number |
Shows the document or transaction number. |
|
Entity |
Shows the entity linked to the transaction line. |
|
Line Memo |
Shows the memo of the transaction line. |
|
Memo |
Shows the memo of the transaction. |
|
Fx Amount |
Shows the foreign currency amount of the transaction, along with a description when the transaction is recorded in a foreign currency.
Note:
The Base Currency shows the selected subsidiary’s currency. |
|
Debit |
Shows the debit amount of the transaction in the subsidiary’s currency. |
|
Credit |
Shows the credit amount of the transaction in the subsidiary’s currency. |
|
Remaining Amount |
Shows the amount that isn't applied to other transactions. A positive amount is highlighted in green, while a negative amount is highlighted in orange. |
|
Links |
Shows the number of child transactions that are applied to the parent transaction. |
|
Applied Trans Type |
Shows the transaction type of the applied transaction. If the column cell shows Unapplied Amount, you can click this link to apply the transaction to another open transaction. For more information, see Matching Transactions Manually. If the As of End of End Period filter is switched on, you can hover over the information icon to see the application date of the child transaction. |
|
Applied Doc Number |
Shows the document or transaction number of the applied transaction. |
|
Applied Amount |
Shows the amount applied to the parent transaction. |
|
Applied Date |
Shows the date when both transactions are applied. |
|
Code |
Shows the matching code that defines how the transactions are applied. The codes are a combination of the applied transaction’s internal IDs. |