A21 Clarity SQL Features and Benefits - Singapore ERP Accounting Software

Designed for small to mid-sized companies, A21 CLARITY-SQL takes care of minute details that matters most to them, especially productivity, efficiency and bottom line. A21 CLARITY-SQL benefits translate into real competitive edge for you.

SYSTEM

USER FRIENDLY INTERFACE
A21 CLARITY-SQL is user friendly. Our extensive study of available systems & user preferences result in a system that performs immediately for you. No accounting or computer jargon; just a powerful accounting in plain English.

REAL TIME & ONLINE SYSTEM
Batch processing systems are outdated. With A21 CLARITY-SQL, cross validations and updating for all accounting entries are real time. Management can get instant accounting information with A21 CLARITY-SQL.

SECURITY RIGHTS
Every A21 CLARITY-SQL user can be assigned a personalized entry screen for access to modules right down to add, modify and delete option. Every employee can now be a A21 CLARITY-SQL user.
ROBUST & RELIABLE DATABASE
A21 CLARITY-SQL uses MS SQL Server database at the backend. Supporting up to 4 terabytes of database and multiple-CPU within a computer, it gives you unprecedented robustness and scalability unlike flat file databases like DBF, MDB, TXT files etc. Scalability that any growing company would want to know their financial system can provide.

ONLINE PRINTING
A21 CLARITY-SQL provides options to send either all source documents & reports to the screen, printer or PDF format. Each transaction can have up to 4 different print formats to choose from. Historical documents can also be selected for reprinting; giving you the most flexible print output system available!

OUTPUTS REPORTS TO ACROBAT PDF FORMAT
Save the trees! - convert your monthly print-outs into PDF files and store these on the server for browsing. Acrobat PDF file is the most popular document formats to send electronically. Being non-editable, it is a good way to send purchase orders, statement of accounts and order confirmations etc by email. Save tons of money using electronic transmission over conventional mails.

MODULAR – BUY ONLY WHAT YOU NEED!
A21 CLARITY-SQL is sold by modules. Buy only what you need. Upgrade any time you need any add-on modules. Price is kept affordable and implementation simpler.

MAINTENANCE SERVICE IS AVAILABLE
It is optional, but available. We have a team of specialist as well as accounting partners who can support A21 CLARITY-SQL. When you buy A21 CLARITY-SQL, you are in good hands.

OPERATIONS

MULTIPLE COMPANIES
A21 CLARITY-SQL supports unlimited account books, limited only by hard disk space per license. CLARITY if used within a group of companies will prove to be an extremely cost-effective solution.

E-BUSINESS SUPPORT
A21 CLARITY-SQL support e-business for companies wanting a piece of the Internet action. With A21 CLARITY-SQL, we build the bridge for a transparent integration for you. From the e-world to the real world, A21 CLARITY-SQL supports your business operations.

CONCURRENT MULTI-USERS
A21 CLARITY-SQL makes real-time network accounting with many users working simultaneously possible. Users can perform similar entries concurrently like sales invoicing, ensuring a high throughput of data entries, minimizing backlogs.

UNLIMITED ACCOUNTING PERIODS
A21 CLARITY-SQL supports unlimited number of accounting periods. Transactions may be entered into A21 CLARITY-SQL for as long as you need the history. Auto carry-over of GL balances ensure financial reports are correct anytime specified.

DEPARTMENTAL ACCOUNTING
At all source documents, user-defined sub-ledger codes can be entered to provide departmental reports. All financial reports i.e. Trial Balance, Balance Sheet and Profit & Loss Statements are reportable by department. The possibilities are endless.

MS-OFFICE LINKS
A21 CLARITY-SQL links with Microsoft Office applications (MS-Word, MS-Excel etc). Financial reports in A21 CLARITY-SQL that need to be analyzed in different variations can be sent to MS Excel or Word or convert to PDF to email your reports. You have complete reporting flexibility.

ADVANCE DIAGNOSTICS
A21 CLARITY-SQL comes with a suite of powerful diagnostics to handle the integrity of data. If transactions are done in accordance to acceptable accounting principle, and such aberrations still occur, our diagnostic will capture & list all the erroneous transactions.

REMOTE NETWORKING SUPPORT
A21 CLARITY-SQL can operate over a wide area network and via Internet connectivity using terminal server architecture. Branches or subsidiaries can use a 512kbps Internet connection to operate the system. Choose A21 CLARITY-SQL, a system that can grow with you.

ACCOUNTING

UNLIMITED FOREIGN CURRENCY BANKS
Being multi-currency, A21 CLARITY-SQL has option for unlimited bank accounts in any currencies. Perform reconciliation, unrealized revaluations and pay or receive in any currencies from these banks. No need to be stifled – open a foreign currency bank a/c now!

SUPPORTS GST / VAT
A21 CLARITY-SQL's GST rates are stored in tables; just modify the percentages when rates change. Sales & purchase bills auto-update your GST, pickup the tax amounts and prints the standard GST Form-5 report and supporting schedules. Stop camping out in your office every quarter when it is due for tax submission.

MULTIPLE CURRENCY TRANSACTIONS
A21 CLARITY-SQL supports unlimited number of currencies to transact in. Realized transactions with exchange gain/loss are automatically posted to the general ledger. Multiple currencies can be transacted with a single customer code. Daily exchange rate table stores historical rates for accurate references. Unprecedented flexibility when you handle international business.

POWERFUL DRILL DOWN SCREENS
This powerful feature allows you to view your Trial balance and GL from any date to any date, and to drill down to the transaction you wish to verify, and finally down to the source document level. No need to waste time to cross check hard copies to audit/verify transactions.

EASY BANK RECONCILIATION
A21 CLARITY-SQL uses a point-&-click method for reconciliation; match realized cheques against your bank statements; sort transactions by cheque numbers, date, and reference numbers etc for ease of reconciling. Spend minutes to do what used to take hours!

RECURRING TRANSACTIONS
A21 CLARITY-SQL lets you enter recurring journal transactions like rental, salary vouchers etc in an easy and flexible way. Recur payment voucher feature makes your repetitive work very simple. Instant productivity gain!

CASH / BANK QUERY ENGINE
Select any bank and view onscreen transactions from/to any dates. Search for transaction by narration, cheque number and zoom in to your transaction. A great tool to manage your bank balances.

INVOICING

UNLIMITED LINE ITEMS
Unlimited number of item line per transaction. Combine stock & service items. At every item line, enter unlimited lines of additional descriptions. Pre-set in the item master or do a free text entry. Whether you need short details or elaborate descriptions or create a 1 or 100 pages invoice, A21 CLARITY-SQL empowers you to bill clients anyway you need to!

SUPPORT TAX-INCLUDED OR ADD-TAX PRICE
Whether you sell with a tax-included or before-tax price, A21 CLARITY-SQL gives you a choice that can be set at customer level. Set up customer with the default tax rate for auto-pickup. And you can still change it in the transaction screen. Selling price with tax handling is now made burden free for users.

MULTIPLE SALES DELIVERY ORDERS
A21 CLARITY-SQL allows you the choice to assign unlimited number of delivery orders into 1 sales invoice or to choose on 1-to-1 relation. Improve operational efficiency in companies where delivery volumes are high.

MULTIPLE SHIP-TO LOCATIONS
A21 CLARITY-SQL allows unlimited ship-to locations and addresses per customer. You may analyse the sales to various locations of that customer too. No need to remember location details when billing. Let A21 CLARITY-SQL do the job.

MULTIPLE PRICING SCHEMES
If you sell a range of products to a broad base of customers, this feature is indispensable. Different customers can be assigned a product selling price and you don't have to remember any one of them. At the point of billing, the price will be auto-pickup when a product is selected for that customer.

MULTIPLE ITEM LEVEL DISCOUNTS
A21 CLARITY-SQL allows multiple levels of discounts per item e.g. discount of 20% + 5% for volume purchase + 3% for cash discount to be assigned at the point of billing. This provides companies a convenient way to build a discount pricing structure.

CREDIT CONTROL
Credit control is an important part of the business cycle. At sales or purchasing, A21 CLARITY-SQL auto-checks for credit limits of the customer or vendor and responds with a block, warn or ignore option. With this feature, you have effective control over risks of bad debt.

SPECIFIC USER CONTROLS
In CLARITY, the administrator can set specific user to transact only with their own customer records; they cannot edit documents or call for reports on sales that do not belong to them. Or set a user with the right to access all records. Prevent sales person conflicts with this restriction.

MULTIPLE PURCHASE DOCUMENT SELECTION
A21 CLARITY-SQL allows you the choice to assign multiple purchase orders to 1 goods received note or a supplier invoice. Or choose it based on 1 to 1 relation. If your supplier delivers 5 of your purchase orders over 5 GRN and sent 1 invoice to you, A21 CLARITY-SQL is designed to handle such complex transactions in a simple manner for you.

POWERFUL SALES ANALYSIS REPORTS
A21 CLARITY-SQL presents powerful MIS reports in detailed & summary formats. Reports can be taken as on any date or from- to any date, showing transactions by sales reps, products, customers, categories, brands, territories etc. A21 CLARITY-SQL serves as a decision support system in management planning.

PURCHASE ANALYSIS REPORTS
Which product was purchased from which suppliers and what volume was made for the period? Reports, detailed or summary on purchases shows transactions by buyers, products, vendors etc. Plan and get the best terms from your vendors if you know your buying trends.

BLACKLISTING CUSTOMER OR SUPPLIER
Allow you to blacklist delinquent accounts or suppliers who do not deliver quality products. Create the history or when they were blacklisted, which transaction will not be allowed. With multiple sales persons handling a large number of accounts, this feature prevents bypasses through a different sales person.

PROFIT ESTIMATOR
A21 CLARITY-SQL has option for you to view the profit attributed to every order or invoice generated as you enter. See the profit amount & margin change. A great tool to help sell confidently and optimize profits for you.

PURCHASE HISTORY
Empower yourself to negotiate with your vendors with a complete view of quantities, cost and all the vendors you have purchased a product from in the past is just one key stroke away. Newly employees can use this information to find the right vendor and price for the products you need to meet customer demand.

INVENTORY

RETURN MERCHANDISE CONTROL
In many systems, merchandise return control is done separately from the accounting system. A21 CLARITY-SQL handles it transparently via a single document where stocks are replenished to the warehouse, a sale is reversed, and the cost of sales deducted and the customer get a credit note. No duplication of work and up-to-date stock balances.

CALCULATES LANDED COST
Freight, insurance, handling charges and custom duties/excise etc can now be included as a cost into the product itself. A21 CLARITY-SQL posts direct into the stock ledger and the GL and you can take a report of the Landed Costs. A21 CLARITY-SQL apportions excise duties, update landed costs and delivers accurate sales profit analyses.

ONLINE STOCK CARD
Online stock card works just like a conventional one. And you can see it from any day to any date. With A21 CLARITY-SQL, using true multiple location system, your stock movement report can also be taken by individual locations. What used to take storekeepers hours are now fully automated within A21 CLARITY-SQL.
MULTIPLE WAREHOUSES
A21 CLARITY-SQL offers true multiple warehouses. Maintain a central accounting database with multiple branches. Transfer stocks between different warehouses and analyses sales pattern. Track consignment sales using the unlimited warehouse that A21 CLARITY-SQL supports. See your stock status on screen or take your stock valuation by warehouses. Be in full control of your stocks now.

MULTIPLE UOMS
A21 CLARITY-SQL allows transactions to be performed in units of measure different from stocking units. Stocks, e.g. motor oil, can be purchased in drums and sold in bottles or liters. Buy ropes in roll and sell in meters. Provides flexibility to sell what customers want without compromising accuracy in stock control.

GENERATE SHIPPING LABELS
A21 CLARITY-SQL assists warehouse dispatch of goods per delivery order or invoice by generating package labels. With these packages are properly tagged; reduce expensive wrongful deliveries that will eat into profit margins.

STOCK KIT ASSEMBLIES
A21 CLARITY-SQL allows the use of a BOM (bill of material) to generate assemblies. Kit any assembly to sell and even assign production overheads to the final cost of product. Auto-calculates your bill of material and let you know how many assemblies can be created. This option allows you to easily convert child parts into finished goods.

PRODUCT COMPATIBILITY MATRIX
A21 CLARITY-SQL comes with option to let you specify alternative codes for every product in your system. In case the item is out of stock, A21 CLARITY-SQL offers stock balances in compatible codes. Avoid over-stocking. Move products faster and your improve cash flow.

STOCK STATUS QUERY ENGINE
Query & find, search engine style, any item you want. View stock on hand, sales & purchase order status. Drill down item to warehouse balances, customer and supplier prices. Improve customer service level & productivity, where all information is a mouse-click away.

PRODUCT GRAPHICS
You can add a graphic file (JPG or GIF format) to your product master and link it to your documents like invoices etc. View it when you query the product if not sure. No need waste time referring to wrong items when it is available at a click.

SERIALIZED STOCKS
You have option to create a serialized stock; where at point of stock receipt and issue you can manage the serial numbers for these stocks. If you have expensive stocks, serialize & track these now for better control.

BATCH/LOT TRACKING OF STOCKS
You also have option to create a lot item stock; at point of stock receipt and issue you can manage the batch numbers for these stocks. If you need production batch numbers or expiry date tracking for better control, A21 CLARITY-SQL is the choice.

STOCK DISPATCH MANAGER
A21 CLARITY-SQL has option for tracking which of your D/O and invoices are barcode scanned and issued “out on delivery”. It also manages cash sales to ensure money is collected. If you have many deliveries, chances are you lose track of which are completed and returned. Be in control – know which is out and which is back now.

AND..