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