Features of SQL Account
|
| Basically, SQL Accounting consists of six core modules which are GL, Customer, Supplier, Stock, Sales, and Purchase. Spend some time to review the following list of features available to you when using our SQL Accounting and judge for yourself. |
| |
|
|
| |
General Ledger
|
| Accounts are display in tree like format. SQL Accounting allows you to maintain foreign currency account, asset account, manufacturing account with ease. |
 |
|
|
|
| |
| The SQL Accounting provide a user-friendly screen for you to maintain payment voucher and official receipt with ease. |
|
|
|
|
| |
| SQL Accounting includes journal entry, allowing you to maintain journals (e.g: purchase 2 automobiles from a car dealer) for your company. |
|
|
|
|
| |
| This feature enables you to maintain local carrying value of foreign bank balance. |
|
|
|
|
| |
| Similiar with maintain account, here the accounts are also display in tree like format, you can easily to maintain the opening balance (local DR, local CR) for each account. |
|
|
|
|
| |
| With SQL Accounting, we introduce this feature to allows you to recon the bank transactions from each bank accounts with simple mouse clicks. |
|
|
|
|
| |
| SQL Accounting provide this feature enables you easily to maintain the closing stock value of each month. |
|
|
|
|
| |
| A very user-friendly and interactive screen allows you to maintain monthly, quarterly, half yearly, or yearly budget for each account. |
|
|
|
|
| |
 |
Reports |
|
|
| The SQL Accounting provide a wide range of reports such as G/L document listing, journal of transaction listing, transaction summary listing, ledger report, trial balance, receipt and payment report, profit and loss statement, and balance sheet statement. |
|
|
 |
Unique |
|
|
| Compare to others accounting software, SQL Accounting provides the opportunties for user to maintain different project/ department accounts to suit their business needs. Beside, SQL Accounting has embedded with the features of odd financial date, it is use for those company with accounting start period which is not start from the begining of the month to end of the month (e.g: 22 Aug 2004 to 31 Aug 2004). |
|
|
|
Customer
|
| The SQL Accounting provide a user-friendly and flexible screen for you to easily maintain your customers. |
|
|
|
|
| |
| This feature enables you to easily to maintain the overall customer invoice entry from sales module, at the same time SQL Accounting will display the payment history for each customer invoice, if the payment had been make for the particular customer invoice. |
|
|
|
|
| |
| With little input, you can easily to maintain the customer payment and dispatch your official receipt to customer. In addition, SQL Accounting has support for partial payment, post date payment and pay by knock off. |
|
|
|
|
| |
| You can now easily to maintain the overall credit note from sales module, while at the same time SQL Accounting will display a list of invoice/ debit note knock off, if found. |
|
|
|
|
| |
| A complete list of debit note from sales module provide the opportunities for you maintain the overall debit note, similiar with customer invoice, the SQL Accounting will display the payment history for each debit note, if the payment had been make for the particular debit note. |
|
|
|
|
| |
| Need to knock off payments and refund credits for customers? SQL Accounting has support for this feature. |
|
|
|
|
| |
| SQL Accounting include this powerful features, allowing you to match a customer invoice against the supplier bill. Beside, SQL Accounting have embeded with a set of contra control number, allow for different currency (e.g: customer invoice with amount USD100 contra with supplier bill with amount of S$200), auto calculate and posting on forex gain/ loss. |
|
|
|
|
| |
|
Reports |
|
|
| The SQL Accounting support a wide range of reports such as customer document listing, customer balance report, due document listing, aging report, customer statement, customer post dated cheque listing, customer analysis by document, and customer sales and collection analysis. Each of these reports have been proved work well with multi currency. |
|
|
|
Unique |
|
|
| Compare to others accounting software, SQL Accounting able to support special aging (e.g: 0-7, 0-9 days and etc.) during generate customer aging report. In addition, SQL Accounting has embedded with features of advance credit control. With this advance credit control, you can set the credit limit and overdue limit for each customer. |
|
|
|
Supplier
|
| With SQL Accounting, a very user-friendly and interactive screen allows you to easily to maintain your suppliers. |
|
|
|
|
| |
| This feature enables you to easily to maintain the overall supplier invoice entry from purchase module, and at the same time, SQL Accounting will display the payment history for each supplier invoice, if you have make the payment for particular supplier invoice. |
|
|
|
|
| |
| With little input, you can easily to maintain the supplier payment. Beside, SQL Accounting has support for partial payment, post dated payment and pay by knock off. |
|
|
|
|
| |
| Similiar with customer debit note, supplier debit note contains a complete list of debit note from purchase module. SQL Accounting will display the payment history for each invoice, if payment is found. |
|
|
|
|
| |
| A complete list of debit note from sales module provide the opportunities for you maintain the overall debit note, similiar with customer invoice, the SQL Accounting will display the payment history for each debit note, if the payment had been make for the particular debit note. |
|
|
|
|
| |
| Need to knock of payments and refunds credits from suppliers? SQL Accounting has support for the feature. |
|
|
|
|
| |
| This feature allowing you to match a supplier invoice against the customer invoice. Beside, SQL Accounting have embeded with a set of contra control number, allow for different currency (e.g: supplier invoice with amount USD2000 contra with customer invoice with amount of S$900), auto calculate and posting on forex gain/ loss. |
|
|
|
|
| |
|
Reports |
|
|
| SQL Accounting has support for a wide range of reports such as supplier document listing, supplier balance sheet, supplier due document, supplier aging report, supplier statement, supplier post dated cheque listing, supplier analysis by document and supplier purchase and payment analysis. Each of these report has proved and work well with multi currency. |
|
|
|
Unique |
|
|
| Compare to others accounting software, SQL Accounting able to support special aging (e.g: 0-7, 0-9 days and etc.) during generate supplier aging report. In addition, SQL Accounting has embedded with features of advance credit control. With this advance credit control, you can set the credit limit and overdue limit for each supplier. |
|
|
|
Sales
|
| SQL Accounting provide this feature to enables you to easily to maintain the quotation as requests from your customer. |
|
|
|
|
| |
| A very user-friendly and interactive screen allows you to easily to maintain the sales order for your customer. To help simplify your work, to create or edit the sales order, you can right click on your mouse button and choose transfer from quotation. |
|
|
|
|
| |
| Similiar with sales order, SQL Accounting enables you to easily to maintain the delivery order for your customer, you can create or edit the sales order by simply right click on your mouse button and choose transfer from quotation or transfer from sales order. |
|
|
|
|
| |
| With this feature, you can easily to maintain the invoice with little input. In this feature, you can create or edit the invoice by right click on your mouse button and choose either transfer from quotation, transfer from sales order or transfer from delivery order. |
|
|
|
|
| |
| A very user-friendly and flexible interface allows you to maintain the cash sales as easier than your expectation. |
|
|
|
|
| |
| With SQL Accounting, we provide you a very flexible and user-friendly screen to allow you to maintain the debit note for sales with ease. |
|
|
|
|
| |
| Here, you can maintain the credit note with user-friendly interface. To help simplified your work, to create or edit the credit note, you can right click on your mouse button and choose either transfer from sales invoice or transfer from cash sales. |
|
|
|
|
| |
| Compare to others accounting software, SQL Accounting has include this features to allow you to maintain the cancelled note for sales order. To create or edit the cancelled note with ease, you can right click on your mouse button, and choose transfer from sales order. |
|
|
|
|
| |
|
Reports |
|
|
| Support wide range of reports such as sales document listing, outsanding sales document listing, sales picking list, customer price history, profit and loss by document, sales analysis by document and yearly sales analysis. |
|
|
|
Unique |
|
|
| In contrast with others accounting software, SQL Accounting has support for partial delivery in maintaining quotations, sales order, delivery order and invoice. In addition, SQL Accounting has provide the available stock balance in maintaining quotations, sales order, delivery order, invoice, cash sales, credit note and debit note. SQL Accounting also has support for sales price history, which means it allows you to check the particular sales history for particular company under particular item code. |
|
|
|
Purchase
|
| Similiar with quotation in sales module, SQL Accounting include this feature to enable you to easily to maintain the purchase request for particular supplier. |
|
|
|
|
| |
| Here, we provide you a very flexible and user-friendly interface, so that you can easily to maintain the your purchase order for particular supplier. |
|
|
|
|
| |
| You can easily to maintain the goods received note for your company. To help simplified your work, SQL Accounting allow you to create or edit the good received note by right click on your mouse button and choose either transfer from purchase request or transfer from purchase order. |
|
|
|
|
| |
| This feature that allows you to maintain the purchase invoice with ease. Here, you can create or edit the invoice by right click on your mouse button and choose either to transfer from purchase request, transfer from purchase order or tranfer from goods received. |
|
|
|
|
| |
| SQL Accounting provide you a very user-frendly and easy to use interface allows you to maintain the cash purchase. |
|
|
|
|
| |
| With this feature, a very flexible and interactive interface allows you to maintain the purchase debit note for your company with ease. |
|
|
|
|
| |
| Others accounting software cannot handle and maintaining the purchase returned? You will have no worry with SQL Accounting, you can maintain the purchase returned from particular complete purchase invoice or from particular item under particular purchase invoice or from particular cash purchase. |
|
|
|
|
| |
| Need to cancel the particular purchase order or need to cancel the particular purchase item from particular purchase order? SQL Accounting has provide this feature and has been proved extremely work well. |
|
|
|
|
| |
|
Reports |
|
|
| SQL Accounting has support wide range of reports such as purchase document listing, outsanding purchase document, supplier price history, purchase analysis by document and yearly purchase analysis. |
|
|
|
Unique |
|
|
| With SQL Accounting, it has support for partial delivery in maintaining purchase request, purchase order, purchase invoice and goods received. Beside, SQL Accounting has provide available stock balance in maintaing purchase request, purchase order, purchase invoice, purchase debit note, goods received, purchase returned and purchase cancel note. SQL Accounting has support for purchase price history, which means it allows you to check the your company purchase history for particular supplier under particular supplied item. |
|
|
|
Stock
|
| This feature allows you to easily to maintain the stock group information for you business. |
|
|
|
|
| |
| You can maintain the stock items information for your company via this feature. Beside, this feature able to support multi-warehouse, multi-UOM, different customer price, different supplier price, price tag, alternative stock item, bar code and costing. Beside able to switch costing, SQL Accounting has support for standard, FIFO and weighted average of costing. |
|
|
|
|
| |
| This is the feature which allows you to maintain the stock category information for particular stock item. For instance, a stock category template name handphone will consists of a list of handphone category such as SAMSUNG, NOKIA, MOTOROLA and etc. |
|
|
|
|
| |
| Maintain Stock Category Template |
|
| It is a feature to help you to group the related stock category under one common template. |
|
|
|
|
| |
| SQL Accounting enable you to maintain the stock price tag for your business via this feature. |
|
|
|
|
| |
| With this feature, SQL Accounting enables you to group the related stock items under once common template. It is a shortcut to allows you to append all the relate items at once under a common template. For instance, a item template name prepaid card consists of a list of prepaid cards (e.g. Maxis Prepaid RM100, Maxis Prepaid RM60, Celcom Prepaid RM100, Celcom Prepaid RM50, etc) information. |
|
|
|
|
| |
| SQL Accounting has support this feature to allows you to maintain the stock location (warehouses) details of your company. |
|
|
|
|
| |
| We enable you to easily to maintain the stock received for your company internal use purpose. For instance, the director place back the stock items after he has no longer used. |
|
|
|
|
| |
| This feature enable you to maintain the stock issue for your company internal use. For instance, the director may take particular stock items for own used purpose. |
|
|
|
|
| |
| Here, SQL Accounting has support this feature where it enables you to transfer a particular stock items from one location (warehouse) to another location (warehouse) of your company. |
|
|
|
|
| |
| SQL Accounting include this feature to enables you to maintain/ adjust the stock level in different branches within your company. |
|
|
|
|
| |
| This feature has include stock item assemble, stock item disassemble, and various type of reports such as BOM listing, BOM material usage, BOM planner and BOM wastage report. |
|
|
|
|
| |
|
Reports |
|
|
| SQL Accounting has support a wide range of reports include stock document listing, stock reorder advice, stock physical worksheet, stock card, stock month end balanace, stock aging and stock analysis by document. |
|
|
|
Unique |
|
|
| Compare to others accounting software, SQL Accounting include real time post, costing calculation is date sensitive - you can back date transaction, costing calculation interwarehouse transfer, extremely accurate in costing calculation, and multi-generate interwarehouse transfer in costing calculation. |
|
|
|
Miscellaneous
|
| SQL Accounting has include command navigator to help you to easily to access different modules and its features. Support customisable commands and linkage to external programs. |
|
|
|
|
| |
| In SQL Accounting, data entry operation buttons (New, Edit, Delete, Save, Cancel, Detail/Browse, Close) are locate on the right. SQL Accounting has support XML Copy/ Paste. Simply means, when you copy any record from SQL Accounting modules and paste it inside any text document, the text document will contains the record in XML format. Beside, SQL Accounting has embedded with standard entry screen for the purpose of shorten the learning curve if you are the first time user. SQL Accounting has include lookup of any fields in data entry screen. |
|
|
|
|
| |
| Able to perform grouping, sorting, filtering, summarize, field chooser, and export to excel via SQL Accounting. |
|
|
|
|
| |
| Include logon, change password, backup database, restore database, maintain user, and user rights assignment. You can maintain the detail of user access right in SQL Accounting via user rights assignment or during creation of new user account. There are several security types available such as access right, form mode, document number set, report, report default printer. Each of this security types can be further divide into sub-security types. For instance, the access right, it is further divide into by user, by access right, and access right vs user. |
|
|
|
|
| |
| There are two types of search, specific vs power search. Specific search include stock item search, account inquiry, cash flow inquiry, cash flow forecast, customer pricing inquiry and supplier pricing inquiry. With power search, you can find whatever records by specify the condition with some keywords, characters, numbers or symbols. |
|
|
|
|
| |
| It is the information highway within the system linking all the reports tracing down to the source document level with simple mouse click. |
|
|
|
|
| |
| This feature allows you to maintain and customize the default reports layout to suit your own needs. |
|
|
|
|
| |
| With little input, SQL Accounting is able to show you with a complete details of audit trail. This feature enable you to determine who has manipulate the records in all period of time and under which modules, what are the original value and what are the new value (after change). |
|
|
|
|
| |
|
Reports |
|
|
| SQL Accounting support more than 1000 reports combination, JIT sorting/ filtering, customizable and scriptable reports and can export to others format such as Excel, Word, PDF and etc. |
|
|
|
Unique |
|
|
| SQL Accounting has include this feature to allows you to print bar code. Plug-in your barcode scanner, and you can use it immediately. |
|
|
|
|