Import Fixed Asset Listing into SQL Accounting Software Fixed Asset Module
Import Fixed Asset Listing into SQL Accounting Software Fixed Asset Module
February 13, 2023
Ask Bryan Cheong
Ask Bryan a question
Customer Invoice vs Sales Invoice, which one to use?
Customer Invoice vs Sales Invoice, which one to use?
February 13, 2023
SST-Account for Pending Service Tax over 12 months
Service Tax required to be accounted if on the day following period of 12 month when any whole or part of the payment is not received from the date of the invoice for the taxable service provided. Step By Step Guide on how to handle in SQL Accounting Software.
January 30, 2023
Ask Bryan Cheong – SQL Accounting Software – Fixed Assets Module
固定资产折旧(Assets Depreciation)在会计方面，扮演着非常重要的角色。一般上，公司只能用Excel去处理然后再输入进会计系统，这是一个繁琐而会且计员工很容易犯错。这里有一项对于SQL会计软件用户的好消息，大家一直期待的SQL 固定资产折旧模块 (SQL Fixed Assets Module) 终于推出了。它包含Opening, 折旧计算以及报告。让我们看看它如何运作。
Fixed Assets Depreciation plays an important role in every company accounting process. But companies normally can only use Excel to manage it and re-key back to the accounting system. This is tedious and account staff can easily make mistakes. Good News to all SQL Accounting System users, the long-waited SQL Fixed Assets Module has finally launched. It includes, Fixed Assets Opening, Depreciation Calculation, and Reports. Let’s check out how it works.
October 31, 2022
Ask Bryan Cheong – SQL Accounting Software – Supplier Customer Item Code
当你的供应商或顾客是一间大机构，他们要求你以他们的货品编号和货品名称来进行交易，是很普遍的现象。例如你向可口可乐公司采购或销售给AEON,他们可能就会要求你以他们的货品编号交易，以减轻在他们输入系统时需要更改或转换货品编号的负担。让我们看看SQL会计软件里的供应商与顾客货品编号如何帮助你。
When your supplier or customer is a big organisation, it is normal that they will request you to transact with them according to their Item Code or Item Description instead of using your own. Example, if you send purchase order to Coca-Cola manufacturer, or sell Coca-Cola to AEON, they may request you transact using their item code to ease their burden without need to translate/convert your item code during entry into their system. So, let see how SQL Accounting System Customer/Supplier Item Code work for you.
October 28, 2022
Ask Bryan Cheong – SQL Accounting System – Learning Costing Method – Understand why you are making loss when doing sales
有时候，你可能听到别人抱怨他们不明白为何他们所销售的东西赚幅是100%,并没有计算来价成本，又或就算卖价高过买价也会亏钱。这是因为成本计算法(Costing Method)。任何销售物品的商家，必须了解如何通过不同的成本计算法去算出单件货品的成本与价值，以使到你能选择运用哪一种适合你的成本计算法并能准确的设定售价以达到你要的销售净利率(Profit Margin)。一起学习为成本计算法吧!
Sometimes, you may hear people complaining they do not understand why the profit margin of their product is 100% and not factor in the stock cost, or why they still make loss even the selling price seems higher that the purchase cost. This is because incorrect Stock Cost and Stock Value. For any business that are selling product, you need to understand how is the cost and value of each item is generated by using different costing method, so that you can decide on which method that best suit you. By then, you are able to set the item price by using accurate item cost, which ultimately achieve the profit margin that you want. Let’s learn Costing method!
October 20, 2022
Ask Bryan Cheong – SQL Accounting Software – Recurring Invoice and Charging Late Payment Interest Module
对于每个月都需要重复开几百张，甚至几千张相同数额发票或需征收逾期付款利息的公司特别是物业管理公司，确实是一件繁杂和累人的工作。通过SQL会计软件的重复发票和逾期付款利息功能，一定大大地减轻你的负担。让我们看看它是如何运作吧。
For companies especially Property Management companies that need to generate hundreds or even thousands of Invoices every month with the same amount or need to charge late payment interest on overdue amount, it definitely a lengthy and tiring hassle job. With SQL Accounting System Recurring Invoice and Charging Late Payment Interest Module. It will be definitely be a great relieve for you. Let’s check out how it works.
October 12, 2022
Ask Bryan Cheong – SQL Accounting Software – Disable Editing For Certain Parts In Transaction
When your company have multi user to update SQL Accounting System, by default, you can enable a specific user whether can edit a certain transaction such as Delivery Order or Invoice. But you can not specify, which section or fields of the transaction can be edited and which cannot be edited. By using the Enable Editing customisation, now it’s very convenience for you to set the Editing Right to one more level for each user. Let’s check it out.
August 12, 2022
Customer Pay Your Invoice via Online Bank Transfer FPX / eWallet / Credit Card / Buy Now Pay Later(Mini Installment) By Click on SQL Invoice You WhatsApp or eMailed-FREE SQL v819 Fuction+FREE iPAY88 Registration
现金流永远是一项所有生意人需要注意的课题。除了提高销售，老板也应该想办法令你的顾客更快的付钱，而令付款更简易就是一个解决方案。通过SQL会计软件的iPayment，你的顾客可以通过信用卡，网上银行转账, 电子钱包甚至先买后付(迷你3个月分期付款)方式付钱给你，他们只需点击你从SQL会计软件直接WhatsApp或电邮给他们的的发票或Statement即可。让我们看看如何操作吧。
Cash Flow is always one of the main concerns for every business. Beside of making more sales, business owner should also think of ways to make customer pay you faster, and one of trick is to make payment easier. With SQL Accounting System iPayment, customer can now pay you via Credit Card, Online Banking Transfer FPX, eWlallet or even Buy Now Pay Later(Mini Installment) by clicking the Invoice or Statement you WhatsApp or email to them directly from SQL Accounting System. Let’s check this out.
July 20, 2022
GST Sales/Purchase Deferred Tax Journal Adjustment After 2018
马来西亚消费税在2018年已经终结。但有些商家在当时因为客户欠款超过6个月而做了Bad Debt Relief, 在2018年后收到顾客付款，那么商家就需要把消费税部分以Bad Debt Recover还回给关税局。让我们看看如何做出这项更动。
Malaysia GST Era ended in 2018. However, for some companies that have claim Bad Debt Relief by claim back the GST Amount because customer overdue for more than 6 months. If they have recover the debt after 2018, the company should pay back the GST Amount to KASTAM as Bad Debt Recover. Let see how you can do the adjustment for the balance of GST Sales / Purchase Deferred Tax (Bad Debt Relief) AFTER 29 December 2018.
July 19, 2022