- 221
- 268 467
myconsult
Malaysia
เข้าร่วมเมื่อ 6 เม.ย. 2020
Want to know more about accounting? You are in the right place!
The myconsult channel is focused on helping bookkeepers, students and SME business owners learn how to make full use of their accounting software to help them with their day to day operations.
This channel was created in 2019 with the idea to share the knowledge we have accumulated since 2003 from implementing solutions for both small and big enterprises.
Each week, we release tutorials on Accounting Guides to help you learn about SQL accounting & AutoCount. If this sounds like something that will help you out at work or in your studies then make sure to subscribe to the channel now!
If you have any questions or want to request a topic or tutorial just leave a comment on any of my videos and I will get back to you.
Thanks for watching, and welcome to myconsult channel!
The myconsult channel is focused on helping bookkeepers, students and SME business owners learn how to make full use of their accounting software to help them with their day to day operations.
This channel was created in 2019 with the idea to share the knowledge we have accumulated since 2003 from implementing solutions for both small and big enterprises.
Each week, we release tutorials on Accounting Guides to help you learn about SQL accounting & AutoCount. If this sounds like something that will help you out at work or in your studies then make sure to subscribe to the channel now!
If you have any questions or want to request a topic or tutorial just leave a comment on any of my videos and I will get back to you.
Thanks for watching, and welcome to myconsult channel!
Bacth validating and Cancelling Validated E Invoice
🌟 E-Invoice Batch Validation & Cancellation in AutoCount 🌟
With the implementation of E-Invoice in Malaysia, it’s crucial for companies to prepare before the deadline. Ensuring your E-Invoices are correctly validated and knowing how to handle errors are key to staying compliant.
In this video, we’ll guide AutoCount users through:
✅ The step-by-step process of batch validation for E-Invoices.
✅ How to cancel a validated E-Invoice if there’s a mistake.
💡 Stay ahead of the E-Invoice transition and simplify your invoicing processes with AutoCount!
🔔 Like, comment, and subscribe for more AutoCount tutorials and E-Invoice tips!
For more information visit our social media page :
myconsultsb/
_myconsult
#connectingthedots #myconsult #malaysianbusiness #sql #inventorymanagement #retailsolution #accountingfinance #accountingsoftware #accountingsolutions #outsourcedaccounting #kitajagakita #autocount #guide #training #access #users #myconsult #accounting #howto #autocount #finance #inventory #sales #purchases #quotation #invoice #howto #EInvoice #AutoCount #TaxCompliance #SimplifyYourBusiness #Automation #BatchValidation #BusinessSolutions #StayUpdated #GrowYourBusiness
With the implementation of E-Invoice in Malaysia, it’s crucial for companies to prepare before the deadline. Ensuring your E-Invoices are correctly validated and knowing how to handle errors are key to staying compliant.
In this video, we’ll guide AutoCount users through:
✅ The step-by-step process of batch validation for E-Invoices.
✅ How to cancel a validated E-Invoice if there’s a mistake.
💡 Stay ahead of the E-Invoice transition and simplify your invoicing processes with AutoCount!
🔔 Like, comment, and subscribe for more AutoCount tutorials and E-Invoice tips!
For more information visit our social media page :
myconsultsb/
_myconsult
#connectingthedots #myconsult #malaysianbusiness #sql #inventorymanagement #retailsolution #accountingfinance #accountingsoftware #accountingsolutions #outsourcedaccounting #kitajagakita #autocount #guide #training #access #users #myconsult #accounting #howto #autocount #finance #inventory #sales #purchases #quotation #invoice #howto #EInvoice #AutoCount #TaxCompliance #SimplifyYourBusiness #Automation #BatchValidation #BusinessSolutions #StayUpdated #GrowYourBusiness
มุมมอง: 12
วีดีโอ
SQL Accounting - Step-by-Step on How to Create a Consolidated E Invoice
มุมมอง 38128 วันที่ผ่านมา
🌟 How to Create Consolidated E-Invoices for Cash Sales in SQL Accounting 🌟 With Malaysia’s E-Invoice implementation just around the corner, businesses need to prepare to stay compliant. One crucial requirement is generating consolidated E-Invoices for cash sales invoices. In this video, we’ll guide you step-by-step on how to create a consolidated E-Invoice using SQL Accounting. Simplify the pro...
SQL Accounting E-Invoice - Updating your Customer TIN Information
มุมมอง 304หลายเดือนก่อน
🌟 Preparing for E-Invoice Implementation in Malaysia with SQL Accounting 🌟 With the introduction of E-Invoice in Malaysia, businesses need to gear up for compliance before the implementation date. One critical step is to obtain accurate tax information from your customers-a process that can be tedious and time-consuming. But with SQL Accounting, it’s a breeze! Simply enter the company name, and...
SQL Accounting E-Invoice - How to create an E-Invoice for Individuals
มุมมอง 247หลายเดือนก่อน
🌟 How to Create an E-Invoice for Individuals in SQL Accounting 🌟 In this video, we’ll guide you through the step-by-step process of creating an E-Invoice in SQL Accounting for customers who are individuals. For individual customers, generating a validated E-Invoice is simple. All you need to do is: 1️⃣ Obtain their MYKAD or passport number. 2️⃣ Set the TIN information to “General Public” in SQL...
AutoCount E-Invoice - Creating a Self-Billed E-Invoice
มุมมอง 784หลายเดือนก่อน
🌟 Understanding Self-Billed E-Invoice in AutoCount 🌟 In this video, we’ll dive into how AutoCount manages Self-Billed E-Invoices-a crucial requirement for businesses dealing with individuals who do not operate under a business or organization. When purchasing products or services from such individuals, it’s essential to generate a self-billed E-Invoice on their behalf. Why? Because without a va...
AutoCount E-Invoice - Creating a validated E-Invoice for Foreign Customers & Government Clients
มุมมอง 3302 หลายเดือนก่อน
Wondering how to validate an E-Invoice for overseas customers or government organizations in AutoCount? This video is here to help! As Malaysia rolls out E-Invoice requirements, we’re breaking down everything you need to know to validate E-Invoices seamlessly with AutoCount, whether your customers are international or part of a government agency. We’ll walk through the steps to ensure smooth co...
SQL Accounting E-Invoice - How to generate Self Billed E -Invoice for Foreign Supplier
มุมมอง 2.3K2 หลายเดือนก่อน
Are you ready for Malaysia's E-Invoice transition? In this video, we dive into how to generate a self-billed E-Invoice for foreign suppliers using SQL Accounting. As Malaysia moves into the E-Invoicing era, businesses need to adapt to meet compliance requirements, including generating self-billed invoices for transactions with overseas suppliers. We’ll guide you step-by-step through the process...
AutoCount E-Invoice - How to enter individual customer information to validate your Invoice
มุมมอง 4792 หลายเดือนก่อน
In this video, we'll guide you through the steps of managing individual customers in AutoCount, especially when issuing invoices. According to the E-Invoice guidelines, invoices to individuals require either a TIN and MYKAD number, TIN only, or MYKAD only. We'll show you two easy ways to handle this within AutoCount and ensure your E-Invoices are validated correctly. Whether you're invoicing co...
SQL Accounting - Step by step guide on linking your data file to LHDN E-Invoice portal
มุมมอง 8333 หลายเดือนก่อน
In this video, we walk you through the entire process of linking your SQL Accounting file to the LHDN E-Invoice portal. Whether you’re new to e-invoicing or already familiar with SQL Accounting, this step-by-step guide will help you smoothly connect your accounting system to the LHDN portal, ensuring compliance with Malaysia's latest e-invoice regulations. 🔗 What you'll learn in this video: Pre...
AutoCount - How do you generate a consolidated E-Invoice
มุมมอง 6963 หลายเดือนก่อน
In this video, we’ll walk you through the steps to easily generate a consolidated E-Invoice in AutoCount. With Malaysia's E-Invoice system rolling out, understanding how to manage your invoicing in compliance with the latest guidelines is essential. We'll show you how to streamline your invoicing process by consolidating multiple transactions into a single E-Invoice, ensuring you meet LHDN requ...
AutoCount - Step by step guide on setting up E-Invoice in AutoCount v2.2
มุมมอง 3K4 หลายเดือนก่อน
Learn how to set up your E-Invoice profile in AutoCount v2.2 in this comprehensive guide! We'll cover all the necessary steps to ensure your profile is configured correctly, helping you meet the latest E-Invoice requirements from IRB Malaysia. Whether you’re an experienced user or new to AutoCount, this video has everything you need to get started. 📋 Video Highlights: * Detailed setup of your E...
AutoCount - Step by step on setting up your E-invoice approval
มุมมอง 9174 หลายเดือนก่อน
In this video, we’ll walk you through the step-by-step process of setting up approval levels in AutoCount to ensure that your E-Invoices are only sent after being approved by an authorized user. With this feature, you can add an extra layer of control to your invoicing process, preventing E-Invoices from being automatically sent until they have been thoroughly reviewed and approved by someone w...
AutoCount - How do you update your stock information for E-Invoice compliance
มุมมอง 5805 หลายเดือนก่อน
In this step-by-step tutorial, we'll walk you through the essential updates you need to make in your AutoCount stock information to ensure seamless compliance with the LHDN E-Invoice guidelines. Following these steps will help you avoid any validation issues and ensure that your e-invoices are accepted without a hitch. Whether you're new to AutoCount or looking to fine-tune your setup, this gui...
AutoCount - Step by Step Guide on How to Setup Consolidated E-Invoice
มุมมอง 7215 หลายเดือนก่อน
In this step-by-step guide, we walk you through the process of setting up your AutoCount Accounting system to generate consolidated E-Invoices in compliance with the latest LHDN guideline announced on 30th July 2024. With the new relaxation period, companies now have a 6-month transition period from the date of E-Invoice implementation. During this time, businesses are required to generate only...
AutoCount - Step-by-step guide on how to import your customer information for E-Invoice
มุมมอง 1.3K5 หลายเดือนก่อน
AutoCount - Step-by-step guide on how to import your customer information for E-Invoice
AutoCount - Guide to update your customer information for E-Invoice
มุมมอง 8346 หลายเดือนก่อน
AutoCount - Guide to update your customer information for E-Invoice
AutoCount - How you can set-up the E-Invoice module for your company
มุมมอง 4K6 หลายเดือนก่อน
AutoCount - How you can set-up the E-Invoice module for your company
AutoCount - Step by Step guide to change your account code
มุมมอง 5877 หลายเดือนก่อน
AutoCount - Step by Step guide to change your account code
AutoCount - 3 easy ways to delete a transactions
มุมมอง 8877 หลายเดือนก่อน
AutoCount - 3 easy ways to delete a transactions
SQL Accounting - Step by Step guide on managing depreciation
มุมมอง 3748 หลายเดือนก่อน
SQL Accounting - Step by Step guide on managing depreciation
Step by step tutorial on managing fixed asset in SQL Accounting
มุมมอง 5058 หลายเดือนก่อน
Step by step tutorial on managing fixed asset in SQL Accounting
SQL Accounting - How do you create multiple delivery orders from a single sales order
มุมมอง 4478 หลายเดือนก่อน
SQL Accounting - How do you create multiple delivery orders from a single sales order
SQL Accounting - How you can bill with a service tax of 6% instead of 8% after 31/03/2024
มุมมอง 3428 หลายเดือนก่อน
SQL Accounting - How you can bill with a service tax of 6% instead of 8% after 31/03/2024
AutoCount - How to customise your system with your own drop down list
มุมมอง 4628 หลายเดือนก่อน
AutoCount - How to customise your system with your own drop down list
AutoCount - How to Prevent your Sales Agent from Accessing other Invoices
มุมมอง 3128 หลายเดือนก่อน
AutoCount - How to Prevent your Sales Agent from Accessing other Invoices
SQL Payroll - How to Manage your Leave
มุมมอง 7889 หลายเดือนก่อน
SQL Payroll - How to Manage your Leave
SQL Accounting - How to Set-up the User Access Rights
มุมมอง 6009 หลายเดือนก่อน
SQL Accounting - How to Set-up the User Access Rights
SQL Accounting - How can you convert a quotation into Delivery Order
มุมมอง 4319 หลายเดือนก่อน
SQL Accounting - How can you convert a quotation into Delivery Order
SQL Accounting - How can you set different pricing category
มุมมอง 2889 หลายเดือนก่อน
SQL Accounting - How can you set different pricing category
AutoCount - How to create a Debit Note for the additional 2% Service Tax
มุมมอง 4419 หลายเดือนก่อน
AutoCount - How to create a Debit Note for the additional 2% Service Tax
how to make self billed e invoice of rental ?
Stay tune as we will be releasing a new guide next week on this topic
How about the advance payment 30% for the foreign supplier invoice
Deposit payment don't need to issue E-invoice. According to the e-Invoice Specific Guideline (Version 2.1), Section 10.4.8: "In relation to the importation of goods, the Malaysian Purchaser should issue a self-billed e-Invoice latest by the end of the month following the month of customs clearance being obtained."
Hi wanted to ask u, if we do consolidated then the qr code at invoice how ya? Coz we submit monthly. Meaning after submit to ldhn then only all the invoice get the qr code? Meaning customer need to wait the invoice with qr code until we submit to lhdn?
After you do a consolidated E-Inovice, There will be a consolidated E-Invoice QR code. But customers would not get it cause it is a consolidated document not an individual E-Invoice. If your customer wants an E-Invoice, you would have to do an E-Invoice individually for that customer
Music too loud Sir.. 🙏
Thank you for the feedback! We will look into improving our future videos with your feedback
Hi I wish to know if customer make an advance payment (non refundable) and I need to open einvoice for this, how do I proceed to open this einvoice?
Hi! thank youf ro your question. You would need to create an E-Invoice as this is a non-refundable deposit. You can issue it via Sales Invoice screen.
is it possible to select price tag from item code but retaining description entered in sales order on invoice?
Hi! Yes that is possible
Hi to check whether the system will automatic backup all submitted e-invoice,how to call it out to keep a softcopy for audit purposes?
Hi! Thank you for your question. 1 of the way to extract an e-invoice would be to go to the MyInvois portal to retrieve it. In our system we will have the QR code information stored so you can scan it to get the information if required.
How about to create einvoice for B2G?
When you create your customer, make sure your TIN is selected for government. After that you would get your e-invoice validated as per normal.
E-Invoice
Monthly utilities bills (electricity, water and sewerage) are under landlord’s name, do we need to issue Self-billed invoice, if the landlord is not running business? Or if the landlord is running the business. Please advise. Thank you.
Yeah. If your landlord is not running a business, we would need to do a self billed E-Invoice
Hi, i wanted to ask u if i have purchase multiple item using petty cash, do i need to generate self invoive for each shop? Usually just credit 1 lumpsum pettycash and debit all the expenses.
@@reanr.a6010 if your supplier is generating einvoice then no, you do not have to create. If you are buying from individuals then yes
after transfer from location A to B, inventory of A will decreased and location B will increased. let said A is warehouse, B is production, how to decrease the inventory at location B or in what scenario to make the inventory at location decrease?
@@laihwaiwee3857 if you have the BOM module then you could produce the finish goods. If not then we would need to do a stock issue to reduce the inventory in location B when taken out for production
How to add barcode funtion
Thanks
#einvoice
Very Informative !
Hi Sir, wanted to ask u why the DO costing automatically goes to pnl? I wanted the pnl capture the invoice, not the DO, can autocount do that? I mean the DO wont affect the pnl. Thank you.
Hi, this is because the stock have been moved out from your inventory. What you can is try to untick the post the stock in your DO. Then when convert to invoice, make sure that is ticked. It should solve your problem
Einvoice sql accounting
Awesome knowledge
E-invoice
Hi, can you share how to create a new item such as a T-shirt with different sizes (exp s,m,l,xl). how to differentiate it in autocount with 1 itemcode. thanksss
Maybe what we can do is arrange an online meeting to discuss how to do it?
What if I click the post dn/cn adjustment, it shown please select one currecy?
I would recommend to call our office. Our technical team would be able to assist you. Our office number is 03-76241906/1907
why import detial / field been skip (K1, date.....)
We are waiting for the newer version from SQL where those fields will be included for validation purposes.
Thanks for the knowledge
So nice of you
Nice ! Clear guidance ❤
nice one!
Thank you! Cheers!
Nice ! Clear guidance ❤
Glad it was helpful!
this is not auto account we use in malaysia. you make us so confused
Hi. This is the latest version of AutoCount. Currently most likely you are using AutoCount v1.8/1.9. If you are using this version, we would recommend to upgrade to version 2.0 as it is E-Invoice compliant.
1) How to add additional annual leave to a staff who worked on Rest day and can claim back 0.5 days annual leave? 2) How to deduct staff leave if they have not applied in SQL but already on leave? 3) For a new confirmed staff who will be entitled to his Annual Leave, do the annual leave being calculated to him on the time we click on Leave Processor only or after we choose the Leave Group on his first day joining?
Thank you for your questions. 1. What I would suggest is that you create a replacement leave and open your leave processor and add it via that method. 2. You can apply the leave on behalf of the staff via the leave application screen 3. We would need to click the leave processor but do not press overwrite cause it will change all previous staff leave if you made changes. Then you manually put it in for the new staff that just joined.
If you have upgraded to AutoCount v2.2, we have released a new video on how you would set-up your AutoCount for the E-Invoice Era. Click the link here. th-cam.com/video/gwaNn860cEg/w-d-xo.html
How to find the deleted items ?
If there is transactions already, you would not be able to delete it however if there isn't in the browse screen you can highlight the item and then click the delte button
Where is the next video?
@@RayeHing thank you for your comment! Do let us know which part you are looking for and we will try to speed up to release that video
Hi…how do we post adjustment into fixed asset module?
Hi! What kind of adjustments are you looking at? Are you looking at amending the costing of the asset or the depreciation amount?
Hi.. i want to ask , why my sql system can’t send cust statement by email ? Hope can help
There would be some customization that we would need to do in the quotation level. can you send your inquiry via myconsult.com.my/contact-us/
Hi, I've just amended the design on the Report Design Center with added 'Your PO/No" on the top right header. The issue is the PO no just appeared on the first page but not on other pages. what can I do to make sure the PO no appears in every invoice pages?
Maybe you can contact our support team and they can see what went wrong?
Hi, regarding the B2C Myinvoice portal is found in LHDN ?
Hi Eugene, Yes this MyInvois portal is provided by LHDN
@@myconsult can you share the instructions for it ?
@@eugenechung1907 We will try to do a guide on how we can generate E-Invoice via myinvois portal soon
what is managing Quotation ?
Hi! Managing quotations shows how you can use AutoCount to create new quotations as well as create templates to simplify the quotation generation
hi can I know how this will impact small travel agency who sell products from other travel agency?
Based on our personal opinion, there will be 2 categories which you might be billing for. 1. Items/services with a mark up 2. Items/services without mark up For items with a mark up, you would need to create an e-invoice while if you do not mark up, you would not need to create an e-invoice. The E-Invoice implementation would change your process of creating an invoice to your clients and might require most documents to be prepared via an accounting or ERP system instead of a word/excel document.
How to set Saturday & Sunday - is Off Day
That is a good question. Actually SQL Payroll has a calendar where you can state that it is an off day
hello sir, can i ask, so customer must have autcount , then we can get their Tax information? or they can use other platform to update their Tax info.
The Tax Information is via a link which they can open via a web browser to fill up the information
How to run apl to windows ?
Hi with regards to this, I would need more information on what you are planning to do.
How to run apl to windows ?
First of all, you would need to purchase the API module. Then from there, AutoCount can provide the API guideline for your programmer.
How to run apl to windows ?
hihi, if i purchase in pcs, then i consignment also in pcs, but then billing is in package ( meaning 2pc, 4pc, 6pc ) so, how is work ?
Hi! You would need to first have the multi UOM module. Once that is enabled, you can create the different packaging sizes in the stock item. Once you bill based on pack of 2pc for example the system will automatically remove 2qty from your stock
Price?
Hi, which module are you looking at?
@@myconsult ERP software Sale, Purchase, Inventory, Accounts, Banking & Multi Currency
@@myconsult Sales, Purchases, Accounts, Inventory & Report's
@@Ahmed92500 It is RM2499 with 1 Company E-Invoice
Hi, what about audit adjustment for expenses ? if we don want to work backward ?
If it is for expenses, you can pass a journal entry as provided by your auditors.
how do i convert from 1 sales order to multiple DO?
You are able to do this if you have the module called Partial Delivery Module. If you need any assistance, we can help you check whether you have this module
Hi,may i know how this amount of BIK RM3999 apply to pcb deduction?
For BIK to appear on the EA Form, you would need to amend the EA form at the bottom of the table
what about 1 po multiple invoices?
Yes that is definitely possible. However you would require a module called partial delivery
i still stuck at chinese version after following your method. please assist
So Soo Lee, when you say stuck, does that mean you cannot change it back? Can you call our office during office hours (9am - 5:30pm). We will see how we can assist you.