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

Was this article helpful?