SQL Account - Your Ideal Business Software

SQL Account is suitable for both small businesses and large organization in both on-premise and online accounting software. choose what’s best for the workflow of your accountant and bookkeepers.

SQL Account - your Ideal Business Software

Check out why more than 250,000 companies trusted SQL Account.

SQL Account enhances workplace performance, reduces human error, and maximizes profits through our stable, dependable, and developed software functionalities.
Our system's wide range of functions includes data collection and analysis, accurate reporting formats, inventory maintenance, and SST processing.
When you choose SQL Accounting software, you will also receive an abundance of online resources to support your journey in using this system. Regardless if it’s an on-premise or cloud accounting software, SQL Account is the best. If that's not enough, we conduct unlimited hands-on free accounting software training in our HQ.

SQL Account Features

General Ledger

It’s easy to manage and track your company’s accounting records

Customer

Keep your customers in touch

Supplier

Manage and keep your supply chain in check

Sales

More time. For Sales.

Purchase

Be cost effective.

Stock

Helps take control of your inventory effortlessly

Whatsapp Integration with All Document

Step it up by using Whatsapp to send your business documents! SQL Account is the first accounting software integrated with Whatsapp feature, now you can send Quotation, Invoice, Statement of account and many more documents to your clients via Whatsapp with a few simple clicks.

Flexible Unlimited User Defined Fields

SQL Account is the best accounting software can cater from small business to large organisation. SQL Account has user defined fields that can be easily altered and customized. With user defined fields, you can create the perfect document that suit your business size and workflow.

Click “Learn More” to see SQL special industries.

Salesman Commission Reports

SQL Account supports a variety of commission calculation. We calculate partial-payment commission, profit-margin based commission, and we also support multiple commission rates based on stock groups and agents.

Advance security

SQL Accounting provides the best options when it comes to data privacy. You can have double layer access control on what they can do on SQL Accounting. For example, users whom you granted them access right in cash book entry for recording expenses transactions, but you also wish to “hide of” transactions with sensitive keyword , like ‘Director fees’ or ‘bonus’ etc from them.

By assigning advance security transactions exclusions to your users, you can ensure data confidentiality which only uniquely found in SQL accounting .

Unlimited monthly free training and Responsive support team

No worries if you are unfamiliar with our system! We provide free accounting software training every month. Contact us to find out more! Our technical support team is fully trained and equipped to assist you via phone, email, and remote access.

Learn more about SQL Account

SQL Account Releases

SQL Account 5.2021.914.806

Released on August 23, 2021

Release Notes

Database upgrade to version 184
Feature #5820: ST_ITEM_ALT table upgrade AltCode from 30 to 35 characters (for E-Commerce Purpose)
Add Email column to SY_USER table
Add support of CTOS full report
Add Daily Job Order Qty Listing (Group Sorted by Date) format
#5876: PD document load remark1, remark2, description2 and description3 from item master if item BOM detail is empty
Add Sales Invoice 8 (SST 2)-Aging format

SQL Account 5.2021.913.805

Released on August 13, 2021

Release Notes

Add Shopee 3 format
Fix bug: Lazada order couldn't post when has voucher and all products are returned
Fix bug: Lazada order is posted when has either invoice or credit note
Fix bug: Lazada payment will not post order with 0 released amount
Fix bug: Lazada payment unable to delete IV due to already knockoff by CN
Fix bug: Shopee order print amount for coin and vouchers have no decimal
Adjust: Shopee payment show message to sync all invoice before posting
Fixed Stock Assembly Cost/Unit not same as on Screen
#5925: DIY OnOpen Script failed when GL Ledger report form unable to trigger Apply button click and SL Invoice Detail unable to find UDF grid column

SQL Account 5.2021.912.804

Released on August 9, 2021

Release Notes

Adjust: Lazada order post to IV detail, update original qty at S/U Qty
Adjust: Lazada payment posting
Adjust: Lazada Order to append seller id when have duplicate order id
Adjust: Shopee order posting quotation and credit note to update unit price of stock item from invoice
Adjust: Shopee order to display "Credit Note" on column Invoice if posted to credit note
Adjust: Shopee payment allow post only when all orders are posted
Fix bug: eCommerce chinese characters not properly display
Fix bug: Lazada payment past order date
Adjust: eCommerce post IV, Cancel is needed to show correct error message
Adjust: Lazada product fetching limit to 5
Adjust Lazada Account: store seller id
Adjust eCommerce order must match customer code when verifying
Fix bug: Lazada payment does not show error message after posting
Adjust: Lazada order able to post as cancelled order
Adjust Lazada payment only allow to post payment when all orders posted to IV/CN
Adjust: eCommerce order posting to tick tax inclusive if has tax set
Adjust: eCommerce order post order time in 24 hour to DocRef1, tracking no to DocRef2
Fix bug: Lazada order only cancel partial item qty
Adjust: eCommerce order posting to include shipping carrier name
Fix bug: eCommerce credit note is not past order
Fix bug: Shopee order same item should combine to 1
#5921: AR/AP Deposit Refund - Add Company Name and Gain/Loss summary
#5920: AR/AP Deposit Refund - the exchange rate should allow to edit if same foreign currency in both customer and payment method
Fixed Preview error & Reduce Column Usage on FR3 Export to excel for GST Bad Debt Relief - Purchase-Adj-InputTax & OutputTax format
Fixed Preview error & Reduce Column Usage on FR3 Export to excel for GST Bad Debt Relief - Sales-Part C17 & C18 format
Bug #5916: SL/PH Documents detail when change itemcode to another, the tax code will be incorrect even both itemcode set to same Tariff
Bug #5918: Fix incorrect label name in supplier deposit
Bug #5915: Maintain GL Account should block to add sub account if parent account has transactions in GL Budget
Bug #5898: Maintain Stock Item delete invalid Stock Category records upon save
Bug #5902: Year End GL Opening Balance's Retained Earning didn't include GL Stock Value amount if the Project only has GL Stock Value but doesn't have transaction in ledger
Bug #5917: Unable to edit invoice detail record description when the detail record has SV tax code after process SST as draft
Bug #5914: AR/AP Deposit Refund Loss/Gain calculation incorrect for last deposit refund with multiple refund
Bug #5913: AR/AP Deposit Refund Loss/Gain calculation incorrect for last deposit refund with a payment knock off (foreign currency)
Fixed Cust Local - Due Document Listing - Outstanding Service Tax Grand Total TaxDue amount not correct when more then 1 page
Bug #5887: AR/AP Invoice Fast Entry if insert multiple invoices only the first invoice has audit trail posting, others invoices no audit trails
Add Check Different Between Ledger vs Aging report
Bug #5904: SST-02 Report tax code SVA from Sales Credit Note change back from item 13c to 13a (revert commit cac511a1)
Fixed Sales Invoice 11 shown double detail information
Reduce Column usage on FR3 Export to excel for Purchase Order format
Reduce Column usage on FR3 Export to excel for Purchase Cancel Note format
Reduce Column usage on FR3 Export to excel for Cash Purchase format
Reduce Column usage on FR3 Export to excel for Purchase DN format
Reduce Column usage on FR3 Export to excel for Purchase Request format
Reduce Column usage on FR3 Export to excel for Purchase Return format
Reduce Column usage on FR3 Export to excel for Sales Cancel Note format
Bug #5906: Job Order & Stock Assembly if tick Cancelled should remove "transfer from" relation
Bug #5891: Customer Balance Report apply with 1 year data show not responding
Enable Batch Email for Sales DN Format
Enable WhatsApp template for Sales CN Format
Enable Batch Email for Customer Credit Note Format
Enable Batch Email for Customer Debit Note Format
Bug #5905: DIY Script - Ledger Unable to find the component for Account lookup
Enable Batch Email for Customer Invoice Format
Bug #5901: GL Opening Balance preview report prompt access violation error

SQL Account 5.2021.911.803

Released on July 17, 2021

Release Notes

Adjust: eCommerce order posting should overwrite tax to empty
Fix bug: Woocommerce product fetching not complete
Fix bug: Lazada payment did not post seller balance adjustment
Adjust: Shopee order able to post BOM item
Adjust Shopee order able to post status cancelled
Adjust eCommerce order posting for shipping fee
Adjust Shopee product to show all products at form show
Fix bug: Lazada payment able to post reversal marketing fee
Fix bug: Lazada payment statement has trailing spaces
Fix bug: eCommerce post invoice should overwrite the default value of disc
Adjust eCommerce order selection
Adjust Lazada order able to post "To Ship" to quotation
Adjust eCommerce payment to not default select first account
Adjust Lazada, Shopee order to show posting order count
Bug #5896: SL/PH Order should prompt dialog if user key in deposit amount but payment method is blank
Feature #5895: Maintain Stock Item - BOM should enable when have BOM or eCommerce Module
Feature #5861: Maintain Stock Item BOM grid Location field should memorize last value
Bug #5864: View | Stock Available Balance Stock Card section rename "Available Qty" to "Qty After SO" and "Future Qty" to "Available Qty"
Feature #5872: Add feature auto calculate bank gain/loss
Add SST Listing 3-DTR format
Bug #5892: Advance Credit Control - Unable to Save Cash Sales if only Set Suspend in IV
Fixed GST Detail 3 - GST F5-(SG) missing Box 8
#5873: Point Listing add Customer Code filtering
Feature #5874: Point Browse Screen should enable Filter Row by default
#5886: Label missing after change label caption in DIY script
Reduce Column Usage on FR3 Export to excel for GL Bank Reconciliation Report
Fixed GST Detail 3 - GST F5-(SG) Total of Boxes (1) + (2) +(3) & (6) not correctly sum
Bug #5888: GL Cash Flow Statement Report prompt temp table key violation error when click apply
Adjust Lazada payment posting for marketing fee
Adjust Lazada order change all status contain 3PL to "SHIPPED"
Adjust Shopee payment showing incorrect error message
Adjust Shopee order to include courier in shipping fee description
Fix bug: Shopee product should show empty status when no action
Fixed SST-02 (2020) F16 not included the DTR amount
#5877: Apply Sales Picking List Prompt Index error
Enable Batch email for FR3 Sales CN
Feature #5843: SL/PH CN prompt dialog for auto knock-off transfered invoices/cash sales/cash purchase
Adjust Lazada payment able to post reversal item
Adjust eCommerce change "Expire Date" to "Session Expire"
Adjust eCommerce order able to persist selection
Feature eCommerce able to post past order to customer credit note
Fix bug: Lazada payment did not post CN
Fix bug: Woocommerce order incorrect item price when has discount
Adjust eCommerce order to post credit note with FromDocKey, FromDtlKey and FromDocType
Adjust Shopee payment posting to replace commission, service and transaction fee
Adjust Shopee order posting to separate commission, service and transaction fee
Adjust Lazada verify customer payment doc no with cheque no
Adjust Lazada able to replace order
Adjust eCommerce order will post item id to remark2
Fix bug: Shopee did not match item id with stock item code
Fix bug: Woocommerce order did not post voucher
Adjust Shopee order to able to filter by date
Fix bug: Shopee past invoice not found when knockoff payment
Fix bug: eCommerce couldn't replace order when IV knocked off with CN
Fix bug: Shopee refund posting adjustment
Adjust Shopee order will not post customer refund to knockoff credit note
Fix bug: Shopee did not fetch all return orders
Adjust Lazada payment transaction no from DocRef4 to description
Adjust Lazada payment able to post presales order
Adjust Lazada order and payment able handle lost or damaged orders
Fix bug: eCommerce showing incorrect payment no
Fix bug: Shopee return order fetching incomplete
Fix bug: Woocommerce order shipping fee should be positive due to buyer pay
Fix bug: Lazada payment statement commission not displayed
Bug #5697: Unable to edit customer invoice contains SV tax code even though without payment knockoff
Bug #5870: AR/AP Debit Note incorrect document type when post audit trail
Increase Calculation or O/s Amt decimal point to 8 for all Sales & Purchase Outstanding report with amt
Fix bug #5836: Error when stock take share folder contain non JSON files
Add Stock-Assembly Listing (Unit Cost) format
Add Cost/Unit for Stock Assembly Report
Add GL.Auto.BankRecon.HBMBMY
Bug #5730: AR/AP Deposit Refund add Project & Payment Project fields
Bug #5826: Supplier knock-off detail show duplicate invoice when perform undo data. AR/AP PM, CN, Refund & Contra should hide undo command from grid context menu
Bug #5868: Stock Month End balance - Update GL Stock Value should not allow to update if user do not have access right to edit Maintain Stock Value
Bug #5866: Year End if GL Budget has transaction, run Year End will prompt violation of Primary key error
Fixed Customer Debit Note Export PDF Error
Fixed Customer Credit Note Export PDF error
Fixed Sales Order 3 (Sales Disc) batch print shown incorrectly
#5853: Change current Shortcut CTRL+T to CTRL+Shift+T
#5858: Memory Leaking When using ReportObject in DIY Script
Fixed Sales Point Listing & Statement preview error
Add GL Ledger-Forex Gain Loss Report
Bug #5862: Account Inquiry Invoice full knock-off but still show outstanding in if select date range
Fixed Shopee Report format - Spelling error
Reduce Column Usage on FR3 Export to excel for Purchase Local - Goods Received Listing (Tax 1)
Fixed Purchase Local - Goods Received Listing (Tax 1) should be in Listing
Fixed Stock Transfer (With Cost) UnitCost not match with onscreen value
Remove Sales invoice 2, Sales invoice 4, Sales Invoice 8 (SST) Subtotal & Sales Invoice 9 format
Add Sales Invoice 10, 11 & 12 format

SQL Account 5.2021.908.802

Released on May 29, 2021

Release Notes

#5847: Customer Balance Report's Current Balance should show PM outstanding instead of 0 when Future Refund knockoff PM (within date range)
Fixed GL Payment Voucher - RTM format Currency Rate 1 should hide
Fixed GL Bank Reconciliation Report - Clear Transaction not include Opening Balance Information
Fix Woocommerce did not fetch product's variations
Fix Shopee order couldn't be posted when shipping fee charged more than item price
Feature: Lazada setting add "Claims" item group
Adjust: Lazada payment to use statement description as SQL description
Feature: Lazada payment will create customer refund to knock off
Feature: Lazada payment will amend invoice detail
Feature: Shopee order able to replace sales invoice
Feature: Shopee payment able to post past invoice
Fix Shopee order did not include seller coin cash back as voucher
Fix Shopee order post to Sales Quotation incorrect detail
Fix Shopee order incorrect discount amount
Fix Shopee, Lazada order refund should post only returned item
Fix Shopee order couldn't be posted when escrow amount is less than 0
Fix Lazada order will prompt error when no orders within the selected period
Fix eCommerce address filled up wrongly in invoice
Fix AutoBankRecon matched to wrong record
#5846: GL Bank Deposit Search Form missing Mark & Clear All, Mark & Clear Selected in grid context menu
#5833: Sales Profit Estimator's Total Sales Rounding issue

SQL Account - Your Ideal Business Software

SQL Account - your Ideal Business Software

Check out why more than 250,000 companies trusted SQL Account.