SQL Account Feature - Top

Fast. Stable. Feature loaded.

SQL Accounting software 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.

SQL Accounting Features

General Ledger. It's easy to manage and track your company's accounting records.

What's unique? Create and manage accounting records by project or department so you can easily keep track and analyze your company's performance. It also supports odd financial date (e.g: 22 Aug 2011 to 31 Aug 2011) so you can get started from any period you wish.

Want more? Discover more about General Ledger module below.

Purchase Request
Let them know you mean business. Similar to Sales Quotation, a professional Purchase Request can be easily created for you to ask for a good purchase deal.

Purchase Order
Found a good price? Place an order or transfer it from Purchase Request. Key in a deposit if you have too. And let the system handle the rest. It's so easy.

Goods Received
You can easily create a Goods Received note upon receiving goods by from scratch or document transfer. It also has Landing Cost that can be distributed to your purchased items. All this helps keep the stock updated real-time.

Purchase Invoice
Similar to Sales Invoice, Purchase Invoice can be easily created from scratch or using the time saving document transfer.

Cash Purchase
A very user-friendly and flexible interface that allows you to maintain Cash Purchase.

Purchase Debit Note
Similar to Sales Debit Note, you can create a Purchase Debit Note for special instances where you need a business-to-business transaction or an extension of credit.

Purchase Return
Similar to Sales Credit Note, Purchase Return can be used to correct mistakes or any circumstance that needs adjustment to goods received or invoice.

Purchase Cancelled Note
Need to cancel the whole Purchase Order or particular item from a Purchase Order? SQL Account provides this feature that just works.

Need a report? SQL Accounting provide a comprehensive range of financial 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.

Customer. Keep your customers in touch.

What's unique? SQL Accounting supports special aging (e.g: 0-7, 0-9 days and etc.) apart from the standard aging, all built-in. It also features Advance Credit Control, a feature that lets you set credit limit and overdue limit for each customer.

Want more? Discover more about Customer module below.

Maintain Customer
Maintain your customers easily with a user-friendly and flexible interface.

Customer Invoice
Create customer invoice and track it's payment history all on the same screen.

Customer Payment
Make a payment and dispatch an official receipt lighting fast. It also supports partial payment, custom payment post date and pay by a simply knock off.

Customer Credit Note
You can now easily create Customer Credit Note and edit Sales Credit Note all from the same screen. Here it displays a list of invoice or debit note to be knocked off.

Customer Debit Note
Just like Customer Credit Note you can create Customer Debit Note and edit Sales Debit Note all from the same screen. You can also see the payment history for each debit note.

Customer Refund
Need to knock off payments and refund credits for customers? SQL Account has support for this feature.

Customer Contra
This is a nice feature that allows you to match a customer's invoice against a supplier's bill. It also allows for different currencies (e.g: USD100 customer invoice contra with a S$200 supplier bill), auto calculation and Forex gain/loss.

Need a report? Customer module has 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 to work well with multi-currency.

Supplier. Manage and keep your supply chain in check.

What's unique? Similar to Customer module, the Supplier module also supports special aging (e.g: 0-7, 0-9 days and etc.) apart from the standard aging, all built-in. It also features Advance Credit Control, a feature that lets you set credit limit and overdue limit for each supplier.

Want more? Discover more about Supplier module below.

Maintain Supplier
Maintain your suppliers easily with a user-friendly and flexible interface.

Supplier Invoice
Create supplier invoice and track it's payment history all on the same screen.

Supplier Payment
Make a payment and dispatch an official receipt lighting fast. It also supports partial payment, custom payment post date and pay by a simply knock off.

Supplier Debit Note
Just like Supplier Credit Note you can create Supplier Debit Note and edit Purchase Debit Note all from the same screen. You can also see the payment history for each debit note.

Supplier Credit Note
You can now easily create Supplier Credit Note and edit Purchase Return all from the same screen. Here it displays a list of invoice or debit note to be knocked off.

Supplier Refund
Need to knock off payments and refund credits for supplier? SQL Account has support for this feature.

Supplier Contra
This is a nice feature that allows you to match a supplier's invoice against a customer's bill. It also allows for different currencies (e.g: USD2000 supplier invoice contra with a S$900 customer bill), auto calculation and Forex gain/loss.

Need a report? Similar to Customer module, the Supplier module has support for a wide range of reports such as Supplier Document Listing, Supplier Balance Report, Due Document Listing, Aging Report, Supplier Statement, Supplier Post Dated Cheque Listing, Supplier Analysis by Document, and Supplier Sales and Collection Analysis. Each of these reports have been proved to work well with multi-currency.

Stock. Helps you take control of your inventory effortlessly.

What's unique? A real time posting engine. Date sensitive costing calculation so you can back date transactions. Costing calculation inter-warehouse transfer. Extreme accuracy in costing calculation, and multi-generate inter-warehouse transfer in costing calculation.

Want more? Discover more about Stock module below.

Maintain Stock Group
Creates a list of stock group to help organize your stock items. It also gives you a convenient option where you can preset your sales and purchase posting account.

Maintain Stock Item
Creates stock item with information such as multiple warehouse and UOM, different customer & supplier price, price tag, alternative stock code, bar code and costing. You can also switch between standard, FIFO and weighted average costing.

Maintain Stock Category
Creates stock category for your stock items. For instance, a stock category template named handphone will consists of a list of brands such as SAMSUNG, NOKIA, MOTOROLA and etc.

Maintain Stock Category Template
Group related stock categories under one common template.

Maintain Stock Price Tag
This helps you define different pricing level for each Price Tag.

Maintain Item Template
This enables you to group related stock items under once common template. It serves as a shortcut to allows you to append items quickly.

Maintain Location
Creates a list of stock location (warehouses) and it's details.

Stock Received
Easily maintain stock received for company's internal use.

Stock Issue
Similar to Stock Received, the Stock Issue allows you to dispatch item for company's internal use.

Stock Transfer
Transfer a particular stock item from one location (warehouse) to another location (warehouse).

Stock Adjustment
Adjust the stock level by your locations.

Bill of Material Item Assembly
Stock Item Assembly, Stock Item Disassembly and various type of reports such as BOM Listing, BOM Material Usage, BOM Planner and BOM wastage report are all part of Bill of Material component intended for manufacturing company.

Bill of Material Item Disassembly

Bill of Material Document Listing

Bill of Material Usage

Bill of Material Planner

Bill of Material Wastage Report

Need a report? Stock Document Listing, Stock Reorder Advice, Stock Physical Worksheet, Stock Card, Stock Month End Balance, Stock Aging and Stock Analysis by Document all from the Stock Module.

More time. For Sales.

What's unique? SQL Accounting supports partial delivery through out Sales module documents. In addition, SQL Accounting also provides an assistant screen which show the available stock balance and sales price history when you are creating any Sales document. Now, you can check sales history for any particular item that you are selling.

Want more? Discover more about Sales module below.

Quotation
Turn that first impression into a deal. SQL Account provides you a fast and easy way to create attractive quotation for your customers. And you can also estimate your profit with just a mouse click.

Sales Order
Need to keep track of orders? Just like Quotation it's easy to create and track your sales orders. You can even make a deposit all in one screen.

Delivery Order
Time to delivery orders? Just transfer it from Quotation or Sales Order in a few clicks, print document and you are ready for delivery. A prompt customer service translates to good customer satisfaction.

Invoice
Get paid. Track orders that are not billed, easily transfer them to your invoice, and send it via email. It is a real time saver.

Cash Sales
A very user-friendly and flexible interface that allows you to maintain cash sales. This is perfect for simple of the shelf sales transaction and point-of-sales system integration.

Debit Note
You can create a Debit Note for special instances where you need a business-to-business transaction or an extension of credit.

Credit Note
Returned goods? Special discounts? Or a simple billing mistake can be easily corrected with Credit Note.

Cancelled Note
SQL Account includes a unique feature that allows you to maintain a Cancelled Note for Sales Order.

Need a report? A truly great sales tool won't be complete without a wide range of sales reports such as Sales Document Listing, Outstanding Sales Document Listing, Sales Picking List, Customer Price History, Profit and Loss by Document, Sales Analysis by Document and Yearly Sales Analysis.

Purchase. Be cost effective.

What's unique? Similar to Sales module, the Purchase module supports partial delivery through out its documents. It also provides an assistant screen which show stock balance and purchase price history when you are creating any purchase document. Thus, you can check purchase history for any particular item before buying.

Want more? Discover more about Purchase module below.

Purchase Request
Let them know you mean business. Similar to Sales Quotation, a professional Purchase Request can be easily created for you to ask for a good purchase deal.

Purchase Order
Found a good price? Place an order or transfer it from Purchase Request. Key in a deposit if you have too. And let the system handle the rest. It's so easy.

Goods Received
You can easily create a Goods Received note upon receiving goods by from scratch or document transfer. It also has Landing Cost that can be distributed to your purchased items. All this helps keep the stock updated real-time.

Purchase Invoice
Similar to Sales Invoice, Purchase Invoice can be easily created from scratch or using the time saving document transfer.

Cash Purchase
A very user-friendly and flexible interface that allows you to maintain Cash Purchase.

Purchase Debit Note
Similar to Sales Debit Note, you can create a Purchase Debit Note for special instances where you need a business-to-business transaction or an extension of credit.

Purchase Return
Similar to Sales Credit Note, Purchase Return can be used to correct mistakes or any circumstance that needs adjustment to goods received or invoice.

Purchase Cancelled Note
Need to cancel the whole Purchase Order or particular item from a Purchase Order? SQL Account provides this feature that just works.

Need a report? Similar to Sales module it offers a wide range of reports such as Purchase Document Listing, Outstanding Purchase Document, Supplier Price History, Purchase Analysis by Document and Yearly Purchase Analysis.

There's so much more. You'll just need to experience it.

Experience more. SQL Accounting is more than just a tool for you to enter financial record. It has an ecosystem of powerful component such as security, flexible user access control, 24x7 data backup, information search and inquiry, command navigator, customizable grid and reports, document drill down, DIY field and scripts and so much more.

Want to know more? Discover more about the ecosystem below.

Main Screen
On the front you'll be greeted with a nice functional menu that helps you easily access different modules and its features quickly.

Entry Screen
The data entry operation buttons (New, Edit, Delete, Save, Cancel, Detail/Browse, Close) are consistent through out the SQL Account. It also has XML Copy/ Paste support.

Grid
A powerful Grid component to help you perform task like grouping, sorting, filtering, field customization, grid export to excel and etc. You will love this if Excel is your thing.

Maintain User
We take security seriously and this function lets you create a user name, password and configure access rights.

Access Right
The Access Rights configuration screen as you can see is very detailed and comprehensive.

User Rights Assignment
If you need more control, User Rights Assignment lets you control Access Rights, Form Mode, Document Number Set and etc. by the users you have created.

Account Inquiry
This component gives you fast access to account records that can be filtered by a specific date range and project.

Cash Flow Inquiry
With just a few clicks you can track the movement of your money by date.

Cash Flow Forecast
There is also a handy tool that lets you forecast the expected balance based on your cash flow and display it in summary, detailed or by visual graph presentation view.

Customer Pricing Inquiry
Another great Sales tool that gives you the ability to check Price History, Stock Status, Aging, and etc. by your stock item and customer.

Supplier Pricing Inquiry
Similar to Customer Pricing Inquiry this tool that gives you the ability to check Price History, Stock Status, Aging, and etc. by your stock item and supplier.

Stock Item Search
If you have a large stock item database this tool helps you call out search with a simple F9 shortcut key press.

SQL Power Search Engine
The name says it all and its truly a powerful search tool to help you track down any data that you have input.

Drill Down
If you wonder how a purchase report figure amounts to a value. All you need to do is double click that amount and the system will link to the another report by tracing down the source document.

Reports
SQL Account have more than 500 reports built-in that are highly customizable and can be exported to other format such as Excel, Words, PDF and etc.

Report Designer
This feature allows you to design or customize existing report to suit your needs.

Audit Trail
With little input, SQL Account is able to show you a detailed audit trail. This feature lets you track user's data input by a specific date range and modules.

System Requirement.

Recommended Hardware:
PC with a 233MHz Intel or AMD processor and above.
Intel Pentium MMX or faster processor and 64MB of RAM is required (128MB recommended).
Screen resolution of 800x600 or greater.
256-color (8-bit) color monitor or greater video card is required.
Broadband Internet connection to use the SQL Remote Desktop

Supported O/S:
Windows 98 and above

Supported Database:
Oracle
InterBase
Firebird Server
Microsoft SQL

© 2017 by Syntax Technologies Sdn Bhd Terms Of Use Privacy Statement