Showing posts with label Setup. Show all posts
Showing posts with label Setup. Show all posts

Setup Accounts List & Familiarization/Customization

When setting up Company Files, you would have opted for a preset Accounts List or built your own.

Now we want to familiarize ourselves with or customize the Accounts List. To get to the Accounts List, load MYOB, open a company file and thus get to the Command Centre where you see the Accounts tab. Click on Accounts and a cascading list appears. Click Accounts List and the Accounts List is displayed (Note that you can also get to the Accounts List by clicking LIST in the Menu Bar and selecting ACCOUNTS):

MYOB Accounts List
MYOB Company Accounts List

You will initially be in the ALL ACCOUNTS tab in the Accounts List Window resulting in the whole list of accounts to be displayed as shown in the screenshot above. Note that there are altogether 9 tabs in the Accounts List window:
All Accounts | Asset | Liabilit | Equity | Income | Cost of Sales | Expense | Other Income | Other Expenses

By clicking the appropriate tab the Accounts List will be filtered to show only accounts belonging to that tab. For example, you click on the INCOME tab. All the accounts belonging to the Income category will appear:

MYOB Accounts List filtered according to category
MYOB Accounts List filtered according to category

Note that those accounts are all placed at different levels, Level 1, Level 2, Level 3, Level 4
Example
1-0000 Level 1
1-1000 Level 2
1-1100 Level 3
1-1110 Level 4

The account can either be a Header account or a Detailed account
Bold: header account
not bold: Detailed

You can see the Profile and edit the account by clicking the arrow to the left
You can also delete the account by clicking the arrow then in the Menu bar at the top, click
Edit > Delete Account

At the bottom, there will be 4 tabs:
Help F1 | Print | New | Budgets

If you want to create a new Account or recreate one you deleted earlier by clicking the NEW tab.
Reporting: generate a sub-total
Details: see linked accounts. If linked to many other accounts, difficult to delete

Edit Accounts window—Profile view

The Edit Accounts window allows you to add new accounts and make changes to existing accounts in your accounts list.

In the Profile view, you can choose whether the account is a header or detail account, select the type of account (asset, liability, equity, income, etc.), and assign it a unique number and name.

Field Descriptions

Account Number and Name

This field appears only when you edit an existing account or enter an account number for a new account; when you first open this window to enter a new account, this field is blank.
This field displays the number and name of the account.

Current Balance

This field displays the current balance of this account. If this is a header account, this field displays the sum of all the detail accounts assigned to it.
If this is an asset, liability or equity account, the amount shown here is the value of the account. If this is an income, expense, cost of sales, other income or other expense account, the amount shown here is the total of all activity with the account since the beginning of the current financial year.
If this is a detail account and you want to view more information about the account balance, click the zoom arrow. The Find Transactions window will appear, listing the transactions that make up the current balance.
If you’re viewing the equity account named Current Year Earnings, the current balance displayed is your company’s year-to-date profit or loss amount.

Inactive Account

Select this option if you want to deactivate the account—for example, if you rarely use the account or you don't want it to appear in selection lists. If you make the account inactive, existing transactions are not affected and you can still enter new transactions for the account by manually selecting it in an account field.

Only detail accounts can be marked as inactive.

When you print the Accounts List [Summary] report or Accounts List [Detail] report, you have the option to omit inactive accounts.

Header or Detail Account

Specify the account as a Header Account or a Detail Account.

Header: Header accounts are used as titles of groups of accounts. They are used only for grouping accounts of a similar purpose and appear in this list for display and organisational purposes only. You can not create a budget for a header account.

Detail: Detail accounts are the Premier accounts that have transactions assigned to them. Each one is assigned to the header account that appears directly above it in the list. Detail accounts appear in plain type, and header accounts appear in bold type.

Account Classification

If you’re viewing an existing account’s information, the account’s classification appears here and is view-only. If you’re creating a new account, this field is blank until you select the Account Type; then the classification that corresponds to the selected type appears.

Account Type
If you’re viewing an existing account’s information, the account’s type appears here. If the account is a detail asset or liability account, all the account types for its classification appear in a list. You can change the type to another in the list.

Account Number

Account prefixes are not editable, but you can change the other four digits in an account number, provided the account number you choose is not already in use.
Any four digits except 0000 can be used in the account number. If you enter fewer than four digits, zeros will be added to the end of the number. When you enter an account number, the number will be automatically placed in the accounts list list in numerical order.

Account Name


Enter up to 30 characters to describe this account.

Opening Balance

Enter the balance of this account as of the first day of your conversion month. If an amount already appears in this field, you may have already entered an opening balance for this account in the Easy Setup Assistant or the Account Opening Balances window.

New

Click create a new account.

Budgets

Click to open the Prepare Budgets window where you can create monthly budgets for Detail accounts.

OK

Click to save your changes and close the window








MYOB: Setup: Tax Codes

To setup or access the Tax Code list, go to the menu bar at the top and click LISTS

Drop down menu will have the following choices
Accounts | Cards | Items | Jobs | Categories | Tax Codes | Recurring Transactions | Custom List & Field Names | Custom Lists | Sales & Purchases Information | Identifier

Click TAX CODES and the Tax Codes window revealing the whole Tax Code List pre-loaded by MYOB as per Royal Malaysian Customs.

MYOB Tax Codes Lists as per Royal Malaysian Customs

I have copied the whole list for your reference at MYOB Tax Codes List. It is accurate as of 3rd December 2014.

If you click on the arrow on the left of any code, a TAX CODE INFORMATION window will open showing various properties of that tax code (See screenshot below). Here various properties of that tax code will be display including what accounts the tax code is linked to. In this window too you can edit the tax code properties if you have information from the Royal Malaysian Customs and you know what you are doing or you didn't subscribe to MYOB 1 year support, you can edit it yourself if Royal Malaysian Custom make changes. Otherwise leave it alone and let MYOB update it for you.

For example, you click the arrow to the left of SR (Standard Rated Supplies), the properties window for SR will pop up:

MYOB Malaysian Custom Tax Code Information






Delete tax codes and import new tax code list

In preparing to use MYOB for doing your accounts and helping you to manage GST related tasks, you may have imported your company file from your accountant. It may already have a Tax Code List with the old tax codes. You may get a file from MYOB to import into your company file to add all the GST tax codes matching those from the Customs. If you try to first delete the old tax code list, you may not succeed because some of the tax codes may already be linked to some accounts.

Instead of deleting the whole list, open that old tax code list and delete tax codes one by one instead. Click on the arrow to the right of a tax code to open the Tax Code Information, click EDIT at the top horizontal menu bar, then click DELETE TAX CODE. You will be informed if that tax code cannot be deleted becausee it is used for same transaction already in which case just leave it alone. Just delete all the tax codes that can be deleted.

If you do not yet have a suitable tax list file to import after the above is done, MYOB would have provided a trial company file, clearwtr.myo. Open this file and at the top horizontal menu bar, select LISTS:

Menu bar > Lists > Tax Codes

After opening the tax code list, go to the top horizontal menu, select FILE

Menu bar > File > Export Data > Tax Code List

Save the file as Non-consolidated Codes in a folder from which you can remember to import from. Now to import this file into your company file.

With the company file open, go to the top horizontal menu bar, select IMPORT DATA

Menu bar > Import Data > Tax Code List > Non-consolidated Data > Select the exported file from folder > Match All > Import

MYOB: How to create new Customer/Supplier/Employee/Personal

Step 1: Open MYOB > Command Center > Card Files > Card list

CREATE

On clicking Card List, the Card List Window will open. There will be 5 tabs at the top:
All Cards | Customer | Supplier | Employee | Personal


MYOB Card List
MYOB Card List

Say, you want to add New Customer. Click
Customer > New > In the Name field, enter Name, example Customer A > Click OK
New Customer will be listed in the Customer window. Now to add details, click EDIT
Now you can enter the details like Card ID, Location, Address, Phone, Email etc., click OK, done.

MYOB edit customer details
MYOB edit customer details
Card ID is optional, but will make things easier. As to the Card ID, I would suggest you have a system such as C001 for fist customer, C002 for second and so on.

SEARCH

In the card list, you can also search for particular supplier/customer etc. If you have already created some customers, suppliers, etc. clicking ALL CARDS will reveal all that you have created. If long list, you can also search by criteria. In the SEARCH BY, there is a drop down menu will pop up revealing:

First Name | Last Name/Co. Name | Card ID | Phone Number | Email | Address | City | State | Postcode | Country

Clicking on "All Cards" will enable you to search all cards by 
First Name | Last Name/Co. Name | Card ID | Phone Number | Email | Address | City | State | Postcode | Country





MYOB Accounts List Choices

With MYOB you can either create your own Accounting List, import, or select from lists preloaded by MYOB according to these choices
Agriculture | Manufacturing | Retail | Service | Others | All

Selecting All will reveal a long list of business as follows (use ctrl+F to quickly find):
Advertising Agency
Advocate & Solicitor
Agricultural Business
Air Conditioning Contractor
Architect
Art Gallery
Associations & Clubs
Audio-Visual Equipment Rental
Bakery Banquet Facility
Beauty Salon
Bicycle Dealer
Boat Dealer
Book Store
Bridal Shop
Building Contractor
Cafe
Car Dealership
Cemetery
Chiropractor
Cleaning Service
Clinic
Clothing - Retail
Computer Dealer
Computer Consultant
Computer Service Bureau
Construction Company
Consulting Firm
Copy Centre
Craft Business
Dance Studio
Day Care Center
Decorator
Delicatessen
Dental Surgery
Designer
Developer
Distributor
D.I.Y Shop
Dry Cleaner
Educational Fund Tracking
Educational Institution
Electrical Contractor
Entertainer
xercise Equipment Dealer
Farm
Financial Services F
itness Center
Florist
Food Service
Formal Wear Rental & Sales
Freelance Writer
Funeral Palour
Furniture Dealer
Garden Centre/Nursery
Gift Shop
Graphic Artist
Gymnasium
Hairdresser
Hardware Store
Health Club
Health Food Store
Heating Contractor
Hobby Shop
Home Appliance Dealer
Home Business
Home Product Sales
Instructional Lessons
Insurance Agency
IT Consultant
Jewellery Store
Landscape
Legal Firm
Limousine Service
Liquor Store
Manufacturing
Mechanic
Medical Office
Motel/Hotel
Moving & Storage Company
Night Club
on-Profit Organisation
Optician/Optometrist
Partnership, Other
Pest Control Service
Pet Shop
Pharmacy
Photographer
Printer P
roperty Management
Publishing Company
Real Estate Agency
Religious Organisation
Restaurant
Retail Business, Other
Shoe Store
Sole Proprietorship
Sporting Goods Dealer
Travel Agency
Veterinarian
Video Store
Web Designer
Wholesale Business

MYOB Setup - Create new company file

Here is how to create a new company file. Open MYOB. This will open the MYOB Welcome window.


Click the CREATE tab, and the MYOB File Assistant window/wizard will open


The Introduction screen will first and will tell you that to create a company file, just tell MYOB about your company, answer a few questions about accounting year, choose accounting list.

You can click NEXT to continue or click on the grayed out options on the left (at any time you want to edit, just click the relevant tab):
Company Information
Accounting Information
Accounts List
Company File
Conclusion

Company Information: you must enter the MYOB serial number, Business Registration Number (required) and the rest like Company Name, GST Number, Phone Number, Fax Number, Email Address are optional.
Account Information:
Current Financial Year,
Last Month of Financial Year,
Conversion Month (beginning month of a Financial Year),
Number of Accounting Periods: 12 or 13. If you choose 13 Accounting Periods, MYOB will add an extra column for you to do adjustments, but the number of months remain 12 months.

Accounting List: You can Start with MYOB provided list, Import, Build Own List. Whichever selected, it is possible to add or delete later. Selecting MYOB List and Clicking NEXT will allow you to choose your Industrial Classification (Agriculture, Manufacturing, Retail, Service, Others, All).

Clicking any of the first 6 will reveal all the items preloaded by MYOB for that particular industry. If you select ALL, there will be a further drop down menu to select a long list of business ranging from Advertising Business to Wholesale Business.

To view the wholes list of businesses you can select for ALL to to MYOB Accounting List Choices.

From Help
Company file setup
…The last month of your financial year. This is the month in which your financial year ends. For most businesses the last month is June. * Your conversion month. This is the earliest month for which you…

Related Products: Chart Of Accounts List | Chart Of Accounts Set Up | Change Conversion Month

Setting up MYOB accounting software mid-year
…balances will be reported at the date of your conversion month. Task 4 [Optional] - Assign opening balances to historical months If you need to obtain monthly Profit & Loss and Balance Sheet reports, rather…

Related Products: Setting Up Company File | Payroll Opening Balances | Historical Balancing

Networking 101: Where to go, tools to use and why you should care | MYOB Blog
There's an old adage: It's not what you know €”it's who you know. But when we are starting out in business, our networks are often limited, consisting of former colleagues, friends and family. And while these people will help get you on your way, very few of us can rely entirely on them for business success. That's where networking comes in.

Related Products: Mobile App

Glossary of accounting terms
…accrued depreciation account. Contra accounts can also be used as suspense accounts. Conversion Month - The month in which you start entering transactions in MYOB. Cost: Item - The cost of an inventory…

Related Products: Retained Earnings | Current Year Earnings | Cost Of Sales

3 ways to simplify your payroll process this month | MYOB Blog
The big race to provide your employees their PAYG Payment Summaries is about to begin. Here are three ways you can simply your payroll process this month to ensure you provide the PAYG Payment Summaries to your employees by the 14 July deadline and the PAYG Payment Summary Statement to the tax office by 14 August.

Related Products: Reconcile Payroll | Month End Reports | Payg Payment Summary

Entering pre-conversion deposits
…10:02 AM How do I enter pre-conversion deposits? It is common for businesses to receive a partial payment as a deposit against an order placed by a customer. Conversely, orders placed with a supplier…

Related Products: Conversion Date | Supplier Deposits | Sales Deposit

Setting up MYOB accounting software mid-year
…balances will be reported at the date of your conversion month. Task 4 [Optional] - Assign opening balances to historical months If you need to obtain monthly Profit & Loss and Balance Sheet reports, rather…

Related Products: Change Conversion Month | Set Up Payroll Mid Year | Allowances Set Up

Consignment stock - as consignee
…a computer software store. You hold a number of lines on a consignment basis. At the end of each month you notify the consignor of consignment sales. The consignor then invoices you for the stock sold…

Related Products: Consignment Stock Gst | Consignment | Sales Commissions

Setting up MYOB accounting software mid-year
…balances will be reported at the date of your conversion month. Task 4 [Optional] - Assign opening balances to historical months If you need to obtain monthly Profit & Loss and Balance Sheet reports, rather…

Related Products: Set Up Payroll Mid Year | Trade Creditors List | Accounting Basics

Hello? Is this my insurance company? Is anyone there? | MYOB Blog
…- One Resolution. Without breaking your spirit, dear reader, by going into the details of my two-month long baptism of fire in Crisis Negotiation, let me tell you that if I was the writer of that tagline…

Related Products: Commission | Not Responding | Insurance Claim

Receivables reconciliation out of balance
…Account Opening Balances you will see the following window. The amounts shown here relate to the conversion month or time at which you began using this particular company file to track your balances and transactions…

Related Products: Out Of Balance Receivables | Trade Debtors | Receivables Reconciliation

Setting up MYOB accounting software mid-year
…balances will be reported at the date of your conversion month. Task 4 [Optional] - Assign opening balances to historical months If you need to obtain monthly Profit & Loss and Balance Sheet reports, rather…

Related Products: Balance Sheet | Entering Opening Balances | Opening Balances

MYOB Accounting software - first step

The very first step for MYOB Accounting is always to open the Command Center. Once that is opened, at the top will be a menu bar. In the menu bar, there are
File | Edit | Lists | Command Centres | Setup | Reports | Windows | Help

Normally, once open, it will show the Command Centres tabs. There will be 6 tabs (for MYOB Accounting, more for other MYOB versions:

Accounts | Banking | Sales | Purchases | Inventory | Card File

Depending on which tab you clicked, there will be a cascading menu in the center which you can click depending on what you want to do.

The at the bottom, there will be more options:

To do list | Find Transactions | Reports | Analysis
At each option, there will be a down arrow which you can click to reveal more options.

Screenshot:

MYOB Command Centers
MYOB Command Centers

Search This Blog