CLARITY-SQL Features & Benefits
Designed for small to mid-sized companies (SMEs), 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.
USER FRIENDLY INTERFACE
Our extensive study of available systems & user preferences result
in a system that performs immediately for you. No accounting or computer jargons; just a powerful accounting
system 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
employee can now be a A21 CLARITY-SQL user with a personalized
entry screen for access to modules right down to add, modify and
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.
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 ADOBE PDF FORMAT
Save the trees! Convert your monthly print-outs into PDF files
and store these on the server for browsing.
Adobe 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 and time 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
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
CLARITY-SQL supports unlimited account books, limited only by hard
disk space per license. Used within a group of
companies, A21 Clarity-SQL will prove to be an extremely cost-effective solution.
CLARITY-SQL supports 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
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,
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.
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.
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.
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.
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
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
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
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!
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
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
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 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
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
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
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.
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.
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
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
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.
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.
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.
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
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.
OUR CUSTOMER SPEAKS…
We create great software but we let our customers say it to you:
“GREAT SOFTWARE… KEEP IT UP”. We want you to be the next
customer we have using this great product.