Wednesday, August 30, 2017

Convert your On-Premise MYOB Premier into OnCloud

How to access MYOB Premier remotely

How do we turn our MYOB Premier software with 3 user into cloud platform so that you can access even when you are out of office, anywhere, anytime?

Let me assume you currently share MYOB from one of your computer via folder sharing service with 2 other users in your same network. In order to share out to internet, you can either use one of the least utilised PC or QNAP NAS

Why QNAP NAS? QNAP NAS has a virtualisation function whereby you can install Microsoft OS into the NAS and access the NAS like a computer via remote desktop connection. After setting up the NAS, you should purchase Microsoft Windows 10 Professional (recommended) and preferably with additional RAM. You can then purchase terminal service software with 3 user license from us, we will set up the rest for you. Next subscribe to dynamic DNS service from dyndns.org which will allow you to do re-direction of IP for you by just remembering your URL, for example yourcompany.dyndns.org. This would cost you about USD60/yr but would at least save you SGD100 yearly (but having static IP broadband connection). Once you have that settled, you will have to configure the dynamic DNS on either your NAS or router, and have to do port forwarding configuration on your router.

With this setup, you can access to your office via internet using remote desktop connection client on laptop, PC or mobile devices from home or anyway, and anytime as below:

Remote Desktop Application

Remote screen with MYOB in background
IT solution can be simple and affordable.

Call us for more information.

William Tan

Monday, August 28, 2017

IT Setup for SMEs of about 5 employees (Part 4-1)

IT Setup for SMEs (Selecting Accounting and Sales Solutions)


We are active advocate of accounting solutions (including MYOB, Moneyworks and Xero) as most of the time we want control over our business. And the most important control is in the area of finance. However, many businesses believe that their focus is in sales, and finance should be left to accountants who will be engaged for year end for statutory tax reporting purposes. This also means most SME bosses will know real results of their business at the end of the year. What then can you do if you find your results are bad at the end of the year?


Fortunately the new era accounting solutions has evolved into simple operations software. Instead of you keying in MS Excel or MS Word to generate your invoice or purchase orders, you are using accounting software to enter those as it will help you remember customer and supplier details and simplify your administrative task. 

What are the selection criteria when you look for a business solution that solves your accounting and sales problems? Some of the important considerations when choosing such solutions include:


  1. Easy of use - try out to see if you understand by just clicking around
  2. Specific needs - inventory with multi-warehouse, multi-currency trading, serial number tracking, project costing and departmental costing etc
  3. On-premise or On-cloud - choose to pay once or subscribe monthly
  4. Future extension - allow integration with other solutions
We do have articles written for you with regards to On-premise or On-cloud and also comparison between MYOB and Moneyworks which will help you understand the differences.

Below are top 5 simple reasons we have gathered from our customers on why they are looking for accounting solutions:
  1. We want to know at any point of time (not just year-end or month-end) our cash and performance position to make important and on-going strategic business decisions
  2. We want to track our projects to know if each project is profitable
  3. We need to track our profit and loss every month so that we will not be late to be notified
  4. Our business has grown and is hard to track via Excel formulas
  5. Our existing accounting software cannot track batch or serial number, but is statutory requirements in our trade (common among pharmaceutical and mobile phone trade)
We should start planning to reinvest and/or re-align our business with relevant software solutions that will bring us to the next level in this digital age.

We hope this helps simplify your thoughts on considering accounting and sales solutions.

For further clarifications and assistance, please feel free to contact us now.


William Tan

Thursday, August 17, 2017

Moneyworks Hack - Landing Cost Calculation


Many will want to know our product's real cost to calculate the product profit margin accurately. For that to happen, you will need to include landing cost, however we know it is quite troublesome to spread our freight cost to each item's pricing.

We may need to calculate every item cost as a fraction to the total and spread the freight cost to the purchase price. This is massive exercise and tedious, and we secretly hope the accounting software we are using can automate this function.

We are fascinated by MoneyWorks scripting capability and that helps us with this special mundane task.

Here is the video I have created so that you can see how easy it can be automated:


This video is based on MoneyWorks GOLD feature.

Should you have any questions, do feel free to comment or contact us for further clarifications.

We definitely hope this article simplify and speed up some of your work.


William Tan
Advanced Micro Control Pte Ltd
Tel: +65 6347 7000
email: sales@amc.com.sg

Monday, August 7, 2017

IT Setup for SMEs of about 5 employees (Part 3)

IT Setup for SMEs of about 5 employees (Business Phone System)

Telephone has been and will remain important communication tools among businesses. So naturally, we have to start looking at phone system setup.

We shall look at 3 options for phone systems to consider:

Option 1: Traditional PABX (or key phone systems)

Most common brands used in Singapore should be Panasonic or NEC.

Pros: Reliable and should last many years

Cons:

  • Limited to system configuration eg Panasonic KXTA824 basic system is limited to 3 incoming/outgoing physical line and 8 extension, but purchase option to scale up
  • Limited to physical location for your extension
  • Limited features like interactive voice response, voice mail and phone recording is not available
  • Have to purchase proprietary phone, and require experience engineer to program
  • Have to run physical phone cabling
Option 2: IP PBX (VoIP Systems)



Getting popular as technology and internet bandwidth advances. SMEs can consider Grandstream for a low end start.

Pros:
  • Expandable up to 30 extension without add-on
  • Can self manage to configure without engineer
  • Not limited to physical location (can bring hone the phones)
  • More features including voice mail, phone recording and interactive voice response
  • Can purchase any brand of SIP phone or use software application like x-lite or gwave
  • Can use a single network cable for both phone and PC/laptop
Cons: Not as reliable, if internet or network is down, all phone will be down

Option 3: Hosted IP PBX (bizphone)

Option 3 will have the same pros and cons as option 2 except you do not need to invest in PBX. Just purchase SIP phone or use software to run your phone by subscribing to a reliable provider will do.


Compare phone solutions
Above table is a quick summary, but not comprehensive enough to cover all brands and solutions. However, it should be generic enough for a quick glance of the 3 solutions highlighted.

Should you have any questions, do feel free to comment or contact us for further clarifications.

We definitely hope this article helps simplify the understanding for SMEs to make sound choices.


William Tan
Advanced Micro Control Pte Ltd
Tel: +65 6347 7000
email: sales@amc.com.sg


Friday, August 4, 2017

IT Setup for SMEs of about 5 employees (Part 2)

IT Setup for SMEs of about 5 employees (Email & Web Hosting)

Email and Web hosting is the next essential thing to work on when you start up a business. Web and email hosting becomes essential because all corporate image starts from a nice website and easily remembered domain. Gone are the days of yellow pages advertising and greenbook advertising whereby most customers will flip directories to search for your service or products.

Domain selection determines how your customer look at you and therefore how your position your company is important. Names can be the services, brand or company. 

Domain name has 2 parts: 
  • Part 1: Name: You can name your domain by companyname (eg asiahawk.com for Asia Hawk Pte Ltd), brandname (eg myob.com.sg for MYOB accounting software but company is Asian Business Software Solutions Pte Ltd), or servicename (eg. bookkeeper.asia for Bookkeepers-On-Wheels LLP). 
  • Part 2: TLD: Top level domain which is after the name represents your market or industry. Most commonly used is .com (International market), .net (internet businesses), .com.sg (Singapore businesses), .sg (also Singapore businesses), .asia (Asia market). 
So you will need to select based on 2 simple conditions:
  1. Easy to remember and communicate to your customer (eg. amc.com.sg instead of advancedmicrocontrol.com.sg)
  2. TLD extension that tells customer we are dealing in which region (eg amc.sg which only deals with local market and bookkeepers.asia which handles Asia market)
Hosting of email and website is the next thing you have to consider carefully. Hosting can be very affordable on international or US service provider as the have the economy of scale to provide a very low cost service. Looking at Bluehost pricing, you will not know how to compare to Simplehost pricing which is much more expensive. However, it is important to know that Simplehost has a local number which you can call in the event of emergency compared to calling US number which you would likely avoid due to operation hours and IDD charges. Do note that both would have some differences especially coming from the point of storage and quality of hosting.

With affordable hosting, some of you might need local service provider to assist you as these hosting service may not provide you with on-site services or getting it done for you. Services to setup email accounts and configuring on your laptop, PC or mobile devices would be available by service company like ours (Advanced Micro Control Pte Ltd), however web design may need to look for web design company to assist you.

Please feel free to contact us for assistance or clarifications.


We seek to help making IT simple for SMEs.

William Tan
Advanced Micro Control Pte Ltd
Tel: +65 6347 7000
email: sales@amc.com.sg

Monday, July 24, 2017

IT Setup for SMEs of about 5 employees

IT Setup for SMEs of about 5 to 10 employees

Let's discuss on how an SMEs of about 5 to 10 employees leverage on IT technology in their operations. We are talking about either an engineering, trading and services industry who serve other businesses (Business-to-business operations).

We are going to look into 5 key areas:

  1. Internet and IT infrastructure
  2. Email and Web Hosting
  3. Telephone Setup
  4. Software for business operations
    1. Accounting and Sales
    2. HR management
  5. Future possible expansion
We will break these 5 areas into 5 emails for easier discussion as our intention is to Simplify IT for you.

Starting from Internet and IT Infrastructure:

IT infrastructure is a jargon for bigger companies and normally would include a server room, server rack, cable management etc. However for an SMEs, we can consider simple setup with the following requirements:
  • Connectivity: Running category 5e or 6 network cables (easily available and is about $95 to $120 per point) for connectivity. Alternatively, you can consider going for wireless, however, nothing is as stable as cable.
  • Router: Usually provided by Internet Service Provider (Starhub, Singtel, M1 etc) when you sign up with a contractual plan of 24 months.
  • Internet Plan: You can subscribe to a fibre plan typically below $100 for 30Mbps and above. Do compare with Singtel, Starhub and other smaller players (like MyRepublic) for best deals if available, but do not compromise on stability and reliability.
  • Network Switch: You can go for 100 Mbps switch or 1 Gbps switch with either 8-port or 16 Port with POE (Power-Over-Ethernet) to compliment your telephony equipment and wireless Access Point for mobile devices.
  • File Server: You can consider NAS which you will need to learn how to maintain or administer or get SMESUITE which covers the services to administer and maintain it for you.
  • Backup: Buying a NAS with RAID is not equivalent to backup. You need a separate harddisk with similar capacity to backup your NAS. However if you choose to go for SMESUITE, all backup are taken care of.
  • Printer: Multi-function laser printer which acts as laster printer, scanner and fax should be good enough for most us. However, avoid copiers unless there is necessity to do mass printing. Attempt to discourage physical print copy if possible as not only it cost more to print physical paper with expensive ink, but also take up storage. 
Simple example of network setup

* Note: You may subscribe to Dropbox or equivalent of cloud storage (monthly subscription applies).

Please feel free to contact us for assistance or clarifications.

We seek to help making IT simple for SMEs.

William Tan
Advanced Micro Control Pte Ltd
Tel: +65 6347 7000
email: sales@amc.com.sg

Thursday, July 6, 2017

Moneyworks Professional Payment Voucher

Moneyworks Professional Payment Voucher

You might have seen or received bank's payment voucher with detachable cheque for you to tear out and bank in, while payment voucher is for your filing and reference. Banks do sell them for about S$1 per cheque.

Sample payment voucher with attached cheque
This desired format does have benefits:

  • Automation in cheque printing without having separate cheque writer
  • Professional and error free as all handwriting is eliminated
  • Alignment of address ease you from writing on envelop
  • Faster in processing payment without repeat writing in envelopment, voucher and cheque
However, to buy from bank at $1 per cheque, is not really practical for cost conscious SMEs.

If you are using Moneyworks, we are prepared to share this simple hack. All you need to is get your printing company to cut some slots and with perforated line for tearing as shown in the youtube video:


This method may cost you a fraction of the cost charge by bank and your free cheques (for some corporate bank account) can still be presented in a very professional way!

Want more information? Contact us at:

William Tan
tel: +65 63477000