Transaction Types in Matching Rules
When creating custom matching rules or matching transactions manually, remember if the transaction types are from imported bank data or a general ledger account in NetSuite.
Imported bank data uses the bank’s perspective, but account transactions use yours. Debits on the bank statement appear as credits in your general ledger, and inversely.
For example, a customer payment deposit appears as a credit on the bank statement, but as a debit in your general ledger account.
Some transaction types can’t be used as matching rule sub-types. To run a rule for these types, pick All Imported and All NetSuite in 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 |