An Adagio Accounting Newsletter
from AccSys Solutions

April 2021
BankRec 9.3A Arrives

If you use Adagio BankRec, you already know that BankRec is the easy way to track your bank account balances. Also, BankRec provides a centralized application to manage your cash position. Softrak recently updated this popular module, and below is a summary of these newly added features.

BankRec 9.3A adds features including enhanced backup options, improved Column Editor field selection, launch of 64-bit GridView and automatic refresh of Sample Data. BankRec 9.3A is compatible with Adagio DocStore so documents can be attached to transactions, batches and printed receipts, and then flow to other modules for review. It is easier to choose the correct field from tables with large numbers of fields in the Column Editor. You can now sort the list, filter the list using the data type you are searching for, and type in some text likely to identify the field. Use the Select the Type option on the Select Fields dialog to show fields of that type.

Batch entry has been updated with standard information, such as formatted customer addresses, receipts, Ledger accounting dates, batch optional fields and Ledger statistical units on distributions, all supported by Import batches.

Distribution codes now support taxable purchases for calculation tax and defining a tax recoverable percentage. Distribution Sets now allow you to distribute a single amount to multiple expense accounts based on a percentage.

Customer receipt batch entry now supports Payment Methods defined in Adagio Receivables for categorizing receipts and revealing credit card field information for credit card methods. This includes online credit cards using Adagio Payments.

Batch Entry Templates have been added in receipt, payment and bank transfer entry. Entry Templates can be defined separately by Security Group.

An archive batch system is available to store recurring transactions, using the same entry procedures as for active batches. Screen colors for Current and Archive batches may be chosen to help ensure you are editing the desired batch type.

Batch Status Inquiry has been updated with standard functionality such as the ability to Recover Batches and reprint the batch listings or posting journal reports.

Bank Reconciliation now allows splitting deposits into two transactions, for the purpose of reconciling a portion of the deposit instead of the entire deposit. Deposits can now be reversed in the same way as Payables vendor payments, to restore paid customer invoices. Vendor cash invoices now allow an option for reversing the invoice portion. A cut-off date hides all transactions with a more recent date.

NSF Receipt Processing for customer receipts has been removed from the Bank Inquiry function and is now available as a separate Maintenance function for NSF Receipts. Customer receipts can be searched for and NSF transactions can be created as part of a list and printed on an NSF List report. A posting journal report is available to print the NSFs processed.

You may choose to select multiple send methods when printing receipts, and can create forms in all selected methods for Print, Email, Fax and PDF, when you choose not to match the customer's preferred send method.

The Deposit Slip report now separates checks from cash in payment method groups and totals.

If you are on an upgrade plan with Softrak, you can download this update at www.softrak.com. Please don't hesitate to contact us if you need assistance with this installation. We are happy to help!
Adagio Technical Tips
Exporting Emails
Question: Is there a way to export all active customer emails into an Excel spreadsheet?

Answer: Yes. In Receivables, open your edit customer grid and double click on any of the column titles to pull up the column editor. Then add the email field you want (there are three different email fields) to the grid and use the Excel Direct button to export the list.


Multicurrency Open Payables

Question: When running an AP Open Payables Report (Summary or Detail) with Source and Home currency selected, there are columns called UEGL and REGL. What are those?

Answer: They are the unrealized and realized exchange gains/losses that occur with fluctuations in exchange rates. They are considered unrealized until the transactions are settled.

As an example:
  • $1000 USD @ 1.3 = $1300 CAD
  • At month end you revalue it at 1.28 = $1280. Now you have an unrealized gain of $20 (you will have to pay $20 fewer CAD to settle the account)
  • Then the vendor gives you a credit note for $100 USD @ 1.27. Now you have a realized gain of $3 plus an unrealized of $18.
  • You pay the balance owed at 1.27. Now you have an additional realized of $27 and no more unrealized.


Cloning A GL Department

Question: When I create a new department by copying an existing one, it appears the only options are to clone all accounts or none. Is there a way to toggle which accounts you want to clone?

Answer: When you copy a Department in Ledger, by default the entire list of accounts is selected. But you can Ctrl-click to de-select specific accounts from the grid, so you are not limited to all or none.


Custom Report Security

Question: Can you apply security to custom reports in any of the modules? We want only certain users to be able to see the report. I can’t seem to find a security setting to accomplish this.

Answer: Place the RPT in a Folder with the name of their Security Group under the Custom Reports Folder. Only members of the Group will see the report.

You can find more tips like this in the Softrak Technical Support Forum at www.softrak.com through the Client Portal. 
Surrey: 604.594.4344
Kelowna: 250.763.1732
Calgary: 403.663.6212
Regina: 306.586.4344
Winnipeg: 204.944.0302
Toll Free: 1.888.534.4344
Fax: 604.53434385