Welcome to Gravity Help
...
Automated Bank Reconciliations
Bank Matching Screen
the bank matching screen provides a way of reviewing bank transactions and matching them to gravity's activity some of the features include auto match using algorithms to match the activity between the bank and gravity rules using rules to create transactions in gravity from the bank activity see bank reconciliation rules docid\ p7w4nmbua1vdv zsgqx8e creating transactions manually creating transactions in gravity download download bank transactions the bank matchings screen can be utilized with or without conducting a bank reconciliation in instances where a bank reconciliation is not being performed, transactions can still be created and will be staged for matching once the reconciliation is carried out process the recommended bank matching process is as follows download new bank activity auto match connect bank transactions to gravity transactions match manually match transactions rules select and process transactions with rules create create any transactions that are missing in gravity bank matching screen sections bank information (1) bank account select the bank account to be evaluated bank reconciliation if an existing bank reconciliation is in process it will automatically populate or you can select an in process reconciliation reconcile transactions this can only be set to yes if a bank reconciliation is selected if set to yes the form will allow you to complete the reconciliation process on the transactions if set to no you will only be able to create but not reconcile transactions reconciliation information (2) this section will show the status of a bank reconciliation when the difference equals $0, the reconciliation is balanced note the balance do not automatically update to refresh the balances select the update balances button also once the difference is $0 you will still need to set the bank reconciliation record to completed filters (3) you can filter the bank transactions grid to see specific views all see all transactions unmatched only show transactions that are waiting to be matched with gravity transactions investigate only show transactions that have been marked for investigation matched only show transactions that have been matched pending matched only show transactions that have a pending match status from the auto match process or have been created when the reconcile transactions was set at no on this view you can process all pending matches applied rules only show transactions where rules have been applied on this view you can process all pending rules actions (4) under the actions are you can perform the following create rule allows you to create rules that can be applied to unmatched transactions auto match will set transactions to a pending matched status when the amount and date range between the bank and gravity match (note if there is more than 1 valid match for a transaction the status will not be set) process bulk process of selected transactions where rules have been applied download will download transactions from the bank or credit card accounts that have been connected grid selection (5) you can select between the bank transactions view and the gravity transactions view the gravity transaction view is helpful to see unmatched transactions in gravity additionally in the "select columns to display" area you can turn on or off columns to make the bank transaction grid easier to work with grid actions select rule select a rule to be used in creating a gravity transaction match manually select a gravity transaction to match to the bank transaction ignore remove the transaction from the screen create create a manual gravity transaction investigate set the transaction status to be investigated later rules rules can be created so they can automatically match based on information in the transaction (contains the word gas) or be manually selected rules are based on the direction of the transaction, money coming in or going out of an account match allows you to match one or more gravity transactions to the bank transaction potential matches are listed in the middle and can be selected with the "+" next to it if multiple transactions are need to complete the match you can change the search amount at the top, select the transaction to complete the form you will need all the transaction in the bottom section to equal the amount of the bank transaction note transactions can be linked beginning with either bank transactions or gravity transactions when initiating with gravity transactions, users have the capability to associate them with one or more bank transactions create multiple transaction types can be created from the bank transaction creat multiple transactions in gravity's bank transaction screen select the transaction type, complete the form and select create transaction un match previously match bank transactions can be un matched this allows user to correct errors made in the matching process ignore if a transaction is not needed in the matching process, the ignore option will remove it from the screen investigate a transaction can be deferred for further investigation by selecting the investigate option at a later time, users may apply the investigate filter to review the items that have been set aside