SQL Accounting – BEST Software For SMALL & MEDIUM Business

SQL Financial Accounting or SQL Accounting is designed to deliver business-critical functionality to large deployment of network environment. At the core of it lies a robust Client-Server architecture allows significant advantages in flexibility, reliability, performance and stability. Self-tuning features include cost-based query optimization and dynamic re-balancing of report structures enhances performance and provides a wide range of business reports. More important, SQL Financial Accounting is an Open Period solution that enables you to collect more data over a wider time frame for better decision-base analysis.

Selling Points

• Performance – Software Architecture designed for network environment, serving even up to 100 users in one network, with system speed maintain.
• Stability – In event of power, network or hardware failure, incomplete transactions are automatically ‘rolled back’.
• Data Integrity – Data never loss between linked modules when performing data posting action. Data integrity is always guaranteed.
• Speed of Data Access – The server utility only sends what is needed to the workstations (eg. Specific customer and date), whereas a file based (basic database) will send ALL invoices.

Built in features :

• Open Period, auto calculation of b/f figures to provide yearly comparative reports. (No year end)
• Budget, multi time intervals (monthly, quarterly, half-yearly and yearly)
• Export to external file format : Text file, MS Word, MS Excel, Lotus, Quattro pro, PDF, JPEG, HTML, XHTML & etc.)
• Unlimited level of Sub Account
• Simple drill down to source document.
• Copy & paste on document level and detail records.
• External file tracking (fax, email, letter & etc).
• Unlimited customer shipping / branch address.
• Post dated cheque report.
• SQL Power Search. (search anything anywhere)
• Built in Report Builder ( customise printing format ie. Invoice & etc ).

SQL Accounting Free Trial

We provide free trial before purchase. Click here to download the installer.

System Requirement:

• Operating System: Windows 10 and above (recommended with 64 bits windows).
• Processor: Intel i5 or above
• RAM: 4GB
• Internet / broadband connection for remote desktop

Add on Modules

Sales

• Profit Estimator – Detail of current on hand stock cost, enable you to profit and margin the sales.
• Advance Credit Control – Capable of Controlling not only credit limit but also Overdue Account, and user definable documents to lock with supervisor password option.
• Deposit – To keep track of Deposit Received before goods delivered. Invoice will show net payable amount.
• Partial Delivery – Multiple Delivery Tracking with Comprehensive Back Order Reports.
• Advance Price History – It will generate the listing of Price History (ie agent, area, customer & etc), analyze the Pricing Trend base on any time interval (daily, weekly, monthly, quarterly, half yearly and etc) in both tabular (high, low, average) & graphical format. It is a “must have” tools for a Sales Manager.
• Special Aging Format – ie 0-14, 15-21 days format in addition of 0-30, 30-60 format.
• Invoice –> Delivery Order – Especially for business to issue Invoice (for payment collection) before delivery (DO). It also provides Back Order Reports, status of quantity pending for delivery.
• E-Commerce – sync transaction from e-commerce platform such as shopee and lazada.
• Sales Order -> Purchase Order – directly transfer sales order items to purchase order
• Sales Price Assistant – It is a very helpful features when working on any sales document with setting on the number of last records to be shown and from which document types.
• Document Date, Posting Date – A supplier bill dated 25th Dec 2003 is received on 4th Jan 2004, but you want to charge it into 2004 account (year 2003 a/c is closed) and aging report follow back the original document date.

Purchase

• Landing Cost – Cost apportionment on Indirect Cost to charge into the Item Costing.
• Purchase Price Assistant – It is a very helpful features when working on any purchase document with setting on the number of last records to be shown and from which document types.

Stock

• Item Template – Setup the Product Package Combinations for easy billing and referring.
• Stock Category – Unlimited Level of Category Settings on stocks, and capable with any category combination in stock reports.
• Picking List – Stock Picking for Delivery with item quantity grouping by any parameter. (ie area, agent etc)
• Multi Location (Warehouse) – Multiple Location, Warehouse, Consignment & etc.
• Batch Number – help to trace goods and differentiate product costing
• Stock Status Estimator – Stock Status with Back Order Summary & Detail information.
• Serial Number – act as an unique identifier to an item.
• Alternative Item – act as a reference to look for the alternative item.
• Multiple Pricing – Unlimited level of selling price. you can set different pricing and discount rate base on Quantity, UOM (carton, box etc) and Customer.
• Stock Matrix – Item matrix combinations (ie, shirt with variety of color & sizes).
• Secondary UOM – For Industries with Double Unit of Measurement. (ie jewelry shops)
• Document Date, Posting Date – A supplier bill dated 25th Dec 2003 is received on 4th Jan 2004, but you want to charge it into 2004 account (year 2003 a/c is closed) and aging report follow back the original document date.

Production

• BOM – Capable of doing Item Assembly, Raw Material Planning & Wastage analysis
• Job Order – Plans the materials/components required based on the quantity ordered from Sales Order

Customize

• User Defined Script – User defined fields with ability to support VB & Pascal script for calculations.
• Sales Commission Script – calculate the commision rate based on the payment age.
• Recurring – Recurring profiles setting for transactions to be repeated at any time intervals (weekly, monthly, yearly & etc) with auto reminder.

Tools

• Project / Departmental – To handle Project or Departmental accounting.
• Multiple Document Number Set – Unlimited Sets of Running Number (ie invoice no. for local, export, inter-company sales etc.) Odd Financial Date – Abnormal Accounting Start & End Date ( ie 25th Jan till 24th Jan of the following year )
• Odd Accounting End Date –
• Cash Flow Forecast – It is particularly useful on Helping Top Management to Forecast on the Cash Flow requirement base on any time interval (daily, weekly, monthly, quarterly, half yearly and yearly) in both tabular & graphical format.
• Multi Currency – Keep track of Foreign Currency Customer and Supplier Account (Exchange gain/loss auto calculate & posting).
• Advance Currency – Maintain Foreign Currency Bank Account. & Foreign bank adjustment for adjustment on the carrying local value. Able to perform difference currency knock off (ie S$50 to knock of USD 20) with auto calculation on exchange gain/loss.
• Advance Drill Down – It is the Information Highway within the system linking all the reports tracing down to the source document level with simple mouse click.