
We’ve set up the Bank Reconciliation module for several clients recently—which brings great functionality and is an easy addition to any AccountMate system—so here’s an overview of the benefits and implementation for anyone who isn’t already using it.
Of course the Bank Reconciliation module provides a user friendly means of reconciling your bank statement (which may even be automated by importing files from your bank), but it’s a reliable means of validating your balance sheet, reducing the number of Journal Entries, and creating Positive Pay files (required by many banks for fraud protection, this is a list of checks you’ve written so they know which ones to clear). The most immediate benefits most clients see, though, is clear instant visibility to your cash position without having to refer to Excel spreadsheets which may or may not be up to date.
If you’re not already licensed for it, the module is a flat price regardless of your concurrent user count and we typically implement in two hours of NexLAN billable time.
In the first hour, we provide training—in your system with your transactions—to demonstrate how Accounts Payable and Payroll checks flow automatically into the Bank Reconciliation module, how Accounts Receivable cash receipts get recorded as Bank Deposits, how miscellaneous items (like bank fees and interest income) get entered as “Other Disbursements” and “Other Receipts” (automatically hitting GL), and the actual reconciliation process.
You’ll then be ready to reconcile your first bank statement—with perhaps a little free NexLAN telephone and email support. I expect you’ll also have numerous historical transactions which cleared prior to your bank statement so, in the second hour, we’ll clear out those historical transactions so your subsequent reconciliations will be even easier.
In short, implementing the Bank Reconciliation is an inexpensive and simple way to expand the functionality of your existing AccountMate system in critical ways—so give us a call to discuss the details.
Finally, a heads up, the next release of AccountMate/LAN—which will be V10.2 for that platform—is expected to be announced in June. We’ll have full details in our next NewsLine, and the registration link for the new function webinar has already been published here. Will see you there!
Regards,
https://nexlan.com
HubSpot CRM Webinar
One of the top CRM (Customer Relationship Management) platforms is HubSpot, and now you can enjoy its power integrated with AccountMate/SQL!
HubSpot provides full-featured management of companies, contacts, prospects, actions, notes, reminders, appointments, integrated email, quotes, sales, inventory analysis, pipeline management, analysis/reporting and more. Most importantly, HubSpot is Internet-based, so it’s run-anywhere, and available with low-cost subscription pricing.

AccountMate Training Classes
Due to recent events, the next Core Product Training class will be presented online only. Sessions will broken into morning and afternoon sessions Monday through Friday, with the next dates Monday, June 8th, through Friday, June 19th.
The online format provides the flexibility to attend all sessions, or only those that apply to you and your business. To help you decide which session(s) to attend, see the course description here and Course Outline here.
Cost is $300 per session or $2,500 for all sessions, but remember you receive one seat per year to a complete set of sessions with your Lifecycle subscription.
Finally, if you have special training needs—maybe a specific topic or module—then we’re happy to point you to pertinent info or do a short online training session. Remember, training is your best investment!
Tech Note: Understanding the Effect of Blanket Purchase Orders and Blanket Sales Orders
Tech Note: Understanding How AccountMate Handles Special Characters in Key Fields
Technical Tips
Versions: AM11.2 for SQL and Express
Module: AR
■ ■ ■
- Be sure to close Tax Forms.
- Take note of the Company ID from the Company Selection List.
- Access the Common Files Folder ► Data ► PRTAX folder.
- Rename the existing file for the Company ID in step 2.
- Access the Tax Forms function again; then, generate any report/tax forms.
■ ■ ■
- Access the Void Payment function to void the open credit applied to the wrong customer.
- When AccountMate asks you whether the amount was deposited to the bank, be sure to select ‘Yes’. This will create a negative receipt amount in the Record Bank Deposit function.
- Record an open credit transaction for the correct customer. Be mindful of the Receipt Date; this must be the same as the Void Date (and original Receipt Date) so that the positive and negative amount falls on the same day and period. In this way, the net result is a wash (i.e., $0.00).
- Access Record Bank Deposit to verify the transactions. You must see two entries for the same Receipt Date; one is a negative amount while the other one is a positive amount.
Subscription Information
If you or someone else in your office would like to receive NewsLine in your inbox each month for the latest AccountMate news and tips, please email newsletter@nexlan.com.





