SQL ACCOUNTING

SQL Financial 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 ).

Free Trial

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

System Requirement:

  • Operating System: Win7, Win8.
  • Processor: Intel or AMD processor
  • RAM: 4GB
  • Internet / broadband connection for remote desktop

Add on Modules
  • Basic 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.
  • Project / Departmental – To handle Project or Departmental accounting.
  • Recurring – Recurring profiles setting for transactions to be repeated at any time intervals (weekly, monthly, yearly & etc) with auto reminder.
  • Advance Credit Control – Capable of Controlling not only credit limit but also Overdue Account, and user definable documents to lock with supervisor password option.
  • Special Aging Format – ie 0-14, 15-21 days format in addition of 0-30, 30-60 format.
  • 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.
  • 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 )
  • Deposit – To keep track of Deposit Received before goods delivered. Invoice will show net payable amount.
  • Multiple Pricing – Unlimited level of selling price. you can set different pricing and discount rate base on Quantity, UOM (carton, box etc) and Customer.
  • Picking List – Stock Picking for Delivery with item quantity grouping by any parameter. (ie area, agent etc)
  • 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.
  • Sales, Purchase Price Assistant – It is a very helpful features when working on any sales/purchase document with setting on the number of last records to be shown and from which document types.
  • Stock Status Assistant – Stock Status with Back Order Summary & Detail information.
  • Profit Estimator – Detail of current on hand stock cost, enable your
  • Maintain Font Style – Feel free to assign the font Color, font Type, bold, underline to give your business documents a new look.
  • Item Template – Setup the Product Package Combinations for easy billing and referring.
  • Landing Cost – Cost apportionment on Indirect Cost to charge into the Item Costing.
  • Partial Delivery– Multiple Delivery Tracking with Comprehensive Back Order Reports.
  • User Defined Script– User defined fields with ability to support VB & Pascal script for calculations.
  • Invoice –> DO – Especially for business to issue Invoice (for payment collection) before delivery (DO). It also provides Back Order Reports, status of quantity pending for delivery.
  • Job Order – Plans the materials/components required based on the quantity ordered from Sales Order
  • Multi Location (Warehouse) – Multiple Location, Warehouse, Consignment & etc.
  • Stock Matrix – Item matrix combinations (ie, shirt with variety of color & sizes).
  • Stock Category – Unlimited Level of Category Settings on stocks, and capable with any category combination in stock reports.
  • BOM – Capable of doing Item Assembly, Raw Material Planning & Wastage analysis
  • Secondary UOM – For Industries with Double Unit of Measurement. (ie jewelry shops)
  • 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.
  • 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.