NetCash Manual Match Bank Transactions
OVERVIEW
Bank transactions can be matched to GL transactions using automated matching rules, however, some transactions are not recurring or regular and will require a manual match to identify the GL transaction that relates to the bank transaction.
STEP BY STEP PROCESS
Navigate to NetCash > Bank > Match Bank Transactions
There are several tasks that can be completed from the Manual Match Bank Transactions Screen:
- Manual Bank to GL Match
- Creation of GL Transaction from Bank Activity
- Cash Application
- Bank Transfers
- Once all manual matches have been completed on this screen, follow the instructions in the NetCash Review Matches article
Manual Bank to GL Match
- Listed is the Bank Activity on the left and the GL Transactions on the right. Select one or many transactions to match between the two lists
- To do this select the checkbox next to the transactions and then select Match
- Once matched, the selected transactions will be removed from the screen
Creation of GL Transaction from Bank Activity
- Using the lists of Bank Activity there may be activity that should have a GL transaction which has not yet been created in the system
- To create this GL transaction, select the relevant bank activity from the list and select Create Transaction
- The new transaction from Bank Activity form will appear
- On this form, fill out the following:
| Field Name | Required | Description | Example |
| Type | Yes | Select the type of transaction to be created. | Journal |
| Entity | No | Select the entity that this transaction should be tagged to. | AA Becca Smith (Universal) |
| GL Offset Account | Yes | Select the GL account that this transaction should offset to. | 1090 Undeposited Funds |
| Line Memo | No | Identify the memo that should appear on the lines of the transaction. | NetCash Bank Match Create Transaction |
| Body Memo | No | Identify the memo that should appear on the body of the transaction. | NetCash Bank Match Create Transaction |
| Department | No | Enter the department that should be used for the bank account or for the offset account. If specified on the Bank Account Record, it will auto-populate on this form. | Administration |
| Class | No | Enter the class that should be used for the bank account or for the offset account. If specified on the Bank Account Record, it will auto-populate on this form. | Class - A |
| Location | No | Enter the location that should be used for the bank account or for the offset account. If specified on the Bank Account Record, it will auto-populate on this form. | Salt Lake City |
- (Optional) Selecting the NetSuite Form View button will switch the form to the native NetSuite form view
- Once all the desired fields have been entered, select Create
- The transaction has now been created and matched to the bank transaction
- To reference this transaction navigate to NetCash > Bank > Review Bank Matches and select the relevant match
Cash Application
Note that this section can also be accessed by navigating to NetCash > Bank > Cash Application
- Using the lists of Bank Activity, there may be a bill payment or deposit that has not been created in NetSuite and therefore, there is no matching GL transaction for the bank transaction
- To match to bills or invoices that do not have payment information created in NetSuite select the Cash Application button
- On this screen, the user can select the bank transaction and the corresponding non-cash GL transaction. NetCash will then create the necessary cash GL transaction and match it to the selected bank transaction. To do this select the checkbox next to the bank and non-cash GL transactions and select Match
- The cash application transaction has now been auto created and matched to the bank transaction
- To reference this transaction, navigate to NetCash > Bank > Review Bank Matches and select the relevant match
Bank Transfers
- If there is movement between bank accounts, this can be reconciled by selecting Bank Transfers
- Once the screen has refreshed, the screen will now show bank activity on both sides
- Filter by the applicable bank accounts, find the corresponding bank transfer transactions between the two bank lists, select the boxes to the left, and then select Book Transfer
- The NetSuite intercompany bank transfer transaction has now been created and matched to both bank transactions
- To reference this transaction, navigate to NetCash > Bank > Review Bank Matches and select the relevant match