TRAINING SERVICES
In-HOUSE TRAINING REGISTRATION
SQL ACCOUNTING
By joining this training, you will be able to master the following skills.
In-House Training
Date : Every Wednesday
Time : 9:30AM – 10:30AM
Location : Golden Traingle 2, Penang (View Map)
MANDATORY OUTLINE
- Setting the Company Profile and link SQL Acc with MyInvois Portal
- Set Financial Start Periods & System Conversion Date
- Maintain Chart of Account
- Maintain Customer (**Setting up mandated fields for E-Invoice)
- Maintain Supplier (**Setting up mandated fields for E-Invoice)
- Purchase
- Purchase Entry: Purchase Request, Purchase Order, Goods Received, Purchase Invoice (**Self-billed E-Invoice)
- Purchase Report: Purchase Document Listing, Outstanding Purchased Document Listing, Purchase Price History, Yearly Purchase Analysis
- Supplier Module: Supplier Invoice (**Check outstanding), Supplier Payment (**Knock off)
- Supplier Report: Supplier Statement
- Sales
- Sales Entry: Quotation, Sales Order (**Proforma Invoice), Delivery Order, Sales Invoice (**Individual E-Invoice), Cash Sales (**Consolidated E-Invoice)
- Sales Report: Sales Document Listing, Outstanding Sales Document Listing, Sales Price History, Yearly Sales Analysis
- Customer Module: Customer Invoice (**Check outstanding), Customer Payment (**Knock off)
- Customer Report: Customer Statement, Customer Aging Report, Customer Due Document
- General Ledger
- Cash Book Entry: Payment Voucher (**General Expenses), Official Receipt (**Other Income)
- Journal Entry (**Depreciation/Audit Adjustment)
- Bank Reconciliation
- GL Report: G/L Document Listing, Ledger Report, P&L Statement, Balance Sheet Statement, Trial Balance
- Backup database
OPTIONAL OUTLINE
- Maintain Opening Balance
- Debit Note & Credit Note (Sales/Customer & Purchase/Supplier)
- Deposit (Customer & Supplier)
- Refund (Customer & Supplier)
- Contra (Customer & Supplier)
- Maintain Document Number
- Maintain User (**Access Rights)
- Print Audit Trial
- Maintain Acceptable Transaction Date
- Analyse Data Integrity
- Multi Currency (**Billing)
- Advance Currency (**Foreign Bank Account, Maintain Payment Method) + Foreign Bank Adjustment
- SST
- Interbank GIRO (**Supplier)
GOOGLE REGISTRATION FORM
FAQ
TRAINING PREPARATION
What Should I Prepare for Online Training ?
- A Stable Internet Connection
- A Quiet Environment
- A Speaker / Earphone that can be heard clearly
- Your Laptop with SQL Software Installed
We will send out the Zoom meeting link a day before the training date. If you didn’t receive the email, remember to check “Spam” folder. If you need any asisstance, please do not hesitate to contact us.
What Should I Prepare for Inhouse Training ?
- Your Laptop with SQL Software Installed
Please arrive on time or 10 minutes earlier before training time to ensure smooth progress.
Where is the Location for Inhouse Training ?
35-5-03&3A, Golden Triangle 2 Commercial Square,
Jalan Dato Ismail Hashim, Relau,
11900 Bayan Lepas, Penang
Is the training a public class or a one-to-one session ?
The training is public class (which means there will be attendees from different companies)
However, we do offer one-to-one training. Please contact us if you are interested in the one-to-one training session.