- \n
- The left-hand side shows the extracted NetSuite GL transactions and the right-hand side shows our imported bank transactions.<\/li>\n<\/ul>\n
![\"\"](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/Side-by-side-bank-reconciliation-625x256.png\")
<\/p>\n- \n
- The GL transactions are linked to either a cash GL account or a credit card type GL account.<\/li>\n<\/ul>\n
![\"GL](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/GL-transactions-ABR-625x338.png\")
<\/p>\nTo initiate the process, we will click on the Auto-Match<\/strong> button, which will look for exact amount matches between the GL and the Bank.\u00a0 But we can make the process smarter by creating configurable Auto-Match rules by transaction type<\/strong>.\u00a0 Checks, deposits, and bank fees are example of different transaction types that can have their unique rules. For example, we can create a rule for checks that will only auto-match them together if both the amount and the check number agree.<\/p>\n
![\"ABR](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/ABR-Automatch-625x267.png\")
<\/p>\nOnce we Auto-Match process is completed, you have the ability to change the Display<\/strong> to either view all the transactions or the ones that matched or simply concentrate on the ones that didn\u2019t match. \u00a0The transactions that were auto-matched will have a sequential Match ID<\/strong> to identify them as cleared transactions.<\/p>\n
![\"ABR](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/ABR-MatchID-625x206.png\")
<\/p>\nIf we switch to our Unmatched<\/strong> transactions, we can focus on those transactions that did not meet my reconcile rules.<\/p>\n
![\"Reconcile](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/Reconcile-unmatched-transactions-625x202.png\")
<\/p>\n- \n
- One example is a transaction where the amounts agree but the check number is slightly different<\/strong>, failing one of my reconcile rules. In this case, as long as the total amount selected agree, I can manually Match\u00a0<\/strong>them.<\/strong><\/li>\n<\/ul>\n
![\"Manual](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/Manual-match-ABR-625x120.png\")
<\/p>\n<\/p>\n
![\"Manual](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/Manual-match-ABR-cont-625x248.png\")
<\/p>\n- \n
- Another example can be recurring charges on the bank side, like bank fees or interest revenue, which are not yet recorded on the GL side. We can use a Template to define what account will be affected on the GL side and specify when the Auto-Generate Template process will be kick off. In this case, it will create the GL transaction when it sees the word \u201cAmericaCharge\u201d in the bank description and I hit the Auto Generate<\/strong> This will create the GL entry for that transaction, bring it to the Reconcile window, and assign it a Match number.<\/li>\n<\/ul>\n
![\"Auto](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/Auto-Generate-ABR-625x269.png\")
<\/p>\n<\/p>\n
![\"ABR](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/ABR-Auto-Gen-Template-1-625x169.png\")
<\/p>\n- \n
- We can also have 2 transactions that need to match between the GL ($90) and the bank ($99), but the amounts are different (for example, an additional bank fee). I can click on the Create-GL Trx <\/strong>button, and it will know the cash GL account that it is crediting. The user has to input the offset GL account that this charge will go to. This process will update the NS Financials, will bring the ($X) transaction into the Reconcile window, and will auto-match it for me.<\/li>\n<\/ul>\n
![\"Create](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/Create-GL-ABR-625x221.png\")
<\/p>\n<\/p>\n
![\"Transaction](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/Transaction-entry-ABR-625x180.png\")
<\/p>\nIf we switch the view to my Matched transactions, I can see that all the exceptions that I had so far, are matched.<\/p>\n
![\"Exception](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/Exception-matching-ABR-625x223.png\")
<\/p>\n- \n
- Going back to the Unmatched transactions, I can see that I have one more scenario that did not meet my reconcile rules. On the right hand-side, I can see a bank deposit recorded as a lump-sum that is actually made of several transactions on the GL side<\/strong>. \u00a0Instead of looking up each transaction individually, I can use a filter to set a criteria to narrow down the list of outstanding transactions on either the GL or the bank side. In this case, I know that my deposits are customer payments<\/strong> in NS and I also know the date<\/strong>. Then, the Reconcile window will only show me the transactions that meet that criteria. I can mark them all, and if the totals agree, I can manually match those transactions.<\/li>\n<\/ul>\n
![\"Reconcile](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/Reconcile-rules-ABR-625x148.png\")
<\/p>\n<\/p>\n
![\"Display](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/Display-filter-ABR-625x257.png\")
<\/p>\n<\/p>\n
![\"Reporting](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/Reporting-ABR-625x291.png\")
<\/p>\nWhen my difference between the GL and the bank is zero, I can successfully Reconcile<\/strong>. Anything that didn\u2019t get match on the GL side during this process will continue to be on my outstanding list for future reconciliations.<\/p>\n
![\"ABR](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/ABR-Reconcile-bank-statement-625x264.png\")
<\/p>\n<\/p>\n
![\"ABR](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/ABR-Reconciliation-status-625x194.png\")
<\/p>\nAfter we finish the Reconcile process, we can view our Closing Balance Report<\/strong>, that will show us in summary the difference between my GL Account Balance minus my net outstanding NS transactions, to get to my calculated Reconcile Balance, which matches my bank balance. The second page will show the details of my outstanding transactions.<\/p>\n
![\"Closing](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/Closing-Balance-report-ABR-1-625x255.png\")
<\/p>\n![\"OUtstanding](\"https:\/\/erpsoftwareblog.com\/cloud\/wp-content\/uploads\/OUtstanding-Netsuite-Transactions-ABR-625x340.png\")
<\/p>\nClients across Canada and the United States use Nolan\u2019s ABR to reconcile high transaction volumes, multiple bank accounts and multiple currencies.<\/p>\n
Simplify and streamline your reconciliation process with us. Request a demo today<\/a>.<\/p>\n
<\/p>\n
- Going back to the Unmatched transactions, I can see that I have one more scenario that did not meet my reconcile rules. On the right hand-side, I can see a bank deposit recorded as a lump-sum that is actually made of several transactions on the GL side<\/strong>. \u00a0Instead of looking up each transaction individually, I can use a filter to set a criteria to narrow down the list of outstanding transactions on either the GL or the bank side. In this case, I know that my deposits are customer payments<\/strong> in NS and I also know the date<\/strong>. Then, the Reconcile window will only show me the transactions that meet that criteria. I can mark them all, and if the totals agree, I can manually match those transactions.<\/li>\n<\/ul>\n
- We can also have 2 transactions that need to match between the GL ($90) and the bank ($99), but the amounts are different (for example, an additional bank fee). I can click on the Create-GL Trx <\/strong>button, and it will know the cash GL account that it is crediting. The user has to input the offset GL account that this charge will go to. This process will update the NS Financials, will bring the ($X) transaction into the Reconcile window, and will auto-match it for me.<\/li>\n<\/ul>\n
- Another example can be recurring charges on the bank side, like bank fees or interest revenue, which are not yet recorded on the GL side. We can use a Template to define what account will be affected on the GL side and specify when the Auto-Generate Template process will be kick off. In this case, it will create the GL transaction when it sees the word \u201cAmericaCharge\u201d in the bank description and I hit the Auto Generate<\/strong> This will create the GL entry for that transaction, bring it to the Reconcile window, and assign it a Match number.<\/li>\n<\/ul>\n
- One example is a transaction where the amounts agree but the check number is slightly different<\/strong>, failing one of my reconcile rules. In this case, as long as the total amount selected agree, I can manually Match\u00a0<\/strong>them.<\/strong><\/li>\n<\/ul>\n
- The GL transactions are linked to either a cash GL account or a credit card type GL account.<\/li>\n<\/ul>\n