Transaction Types in Matching Rules

When creating custom matching rules or matching transactions manually, keep the transaction types in the context of whether the transactions are from the imported bank data or general ledger account in NetSuite.

The imported bank data is from the perspective of the financial institution, but account transactions are from your perspective. This means that debits in the bank statement are recorded as credits in the general ledger account, and the reverse is also true.

For example, a customer payment that you deposit into the bank appears as a credit type on the bank statement, but appears as a debit type in the general ledger bank account.

Some transaction types are not available as matching rule sub-types. If you want a rule to run for transactions of the following types, choose All Imported and All NetSuite from the Transaction Type lists:

• Cash Sale

• Customer Refund (not supported for the Check Number field)

• Customer Credit (not supported for the Check Number field)

• Cash Refund (not supported for the Check Number field)

Note:

To make rules that run on the transaction number, match the Transaction ID from the imported bank line with the NetSuite Check Number. The NetSuite Check Number in the Custom Matching Rule window corresponds to the:

• Check # on Bill Payments, Checks, Customer Payments, and Cash Sales.

• Deposit # on Deposits.

• Transfer # on Transfers.

• Entry No. on Journal Entries.

• Reference # on Credit Card Charges and Credit Card Refunds.

The following table demonstrates how you can map transaction types.

Imported Bank Data Types	General Ledger Account Transaction Types
ACH	Bill Payments
	Checks
	Customer Payments
	Deposits
	Journal Entries
	Transfers
Checks	Bill Payments
	Checks
	Customer Payments
	Deposits
	Journal Entries
	Transfers
	Credit Card Refunds
Credits	Customer Payments
	Deposits
	Journal Entries
	Transfers
	Credit Card Refunds
Debits	Bill Payments
	Checks
	Journal Entries
	Transfers
	Credit Card Charges
Deposits	Checks
	Credit Card Refunds
	Customer Payments
	Deposits
	Journal Entries
	Transfers
Fees	Checks
	Credit Card Charges
	Deposits
	Journal Entries
Interest	Checks
	Credit Card Charges
	Deposits
	Journal Entries
Others	Bill Payments
	Customer Payments
	Journal Entries
	Transfers
	Checks
	Deposits
	Credit Card Charges
	Credit Card Refunds
Payments	Bill Payments
	Checks
	Credit Card Refunds
	Deposits
	Journal Entries
	Transfers
Transfers	Bill Payments
	Checks
	Credit Card Refunds
	Journal Entries
	Transfers

Related Topics

Creating User Transaction Matching Rules

User Matching Rule Example

General Notices