Setting up Electronic Payments

Posted by Lynley on Jan 2 2009 with 0 Comments

Electronic Payments to suppliers can be easily made from MYOB accounting. It results in just one entry showing on your bank reconciliation window, representing the direct debit from your bank account to your multiple suppliers and saves lots of work paying your creditors and suppliers.

This feature also creates the file that your banking software will use to pay the suppliers. Here’s what to do:

1. Select Setup, Accounts list, Assets, Cheque Account, Payments tab. Enter your bank account details.

2. Enter the suppliers’ bank account info on their individual cards, under the Payment Details tab. You will need to click the box that says “I pay this supplier electronically”.

3. Record each of your Bill Payments to your suppliers, making sure you mark the box in the upper left corner of the screen that says “Group with Electronic Payments”.

4. Select Purchases, Prepare Electronic Payments, and click the Pay column beside each amount that will be paid as part of one direct debit batch. Click Process.

5. Save the MYOBDC file that is created (even if you’re not going to import it into your banking software.) This file can now be used by your banking software to transmit the payments to the suppliers.

Note: You can also make Electronic Payments to suppliers when you use “Spend Money” from the Banking command centre. These may be grouped in the same batch or their own batch.

Filed Under: MYOB accounting FAQ's

Home Office and MYOB

Posted by Lynley on Jan 2 2009 with 0 Comments

Home Office Percentages

Question: I am new to MYOB and have mastered it really well apart from the splits of home and business components e.g. power & phone for GST purposes. My Accountant installed the program with all codes etc but I seem to have a mental block on the home/business divisions.

Answer: There are a couple of ways to do this. Firstly, you could pay all your home bills in full with personal cheques, keep the bills in a file, and once a year do an entry to move the business % in to your books and account for the GST. Or alternatively you could pay the bills in full with business cheques, and do an entry at year end to move the personal part of this across to drawings, again moving the GST portion as well. Perhaps chat to your Accountant about this, as they will need to advise you on the percentage split for your situation as well.
Question: Automatic Percentage for Business/Personal

What is the best way to make personal use adjustments for GST purposes. I’d like to set it up so that transactions that are part business, part personal can have the personal use adjustment done automatically. Is this possible?

Answer:  None of the MYOB Accounting range do this split automatically (except MYOB Cashbook). We suggest you follow the procedure above.#adp01

Filed Under: MYOB accounting FAQ's

Importing data from Excel

Posted by Lynley on Jan 2 2009 with 0 Comments

Question: The system used to export-import csv files goes without a hitch, but lately I have been having problem with importing csv files to MYOB.

When I imported a csv file that has been edited in MsExcel, the system added quotes on some data field (customer name, item descriptions, etc). I tried specifying Excel on how to open the csv file (tab delimited=quotes, etc) but the quotes reappear when imported back to MYOB. In Excel the data looks fine.

Answer: A very common problem with any file type being imported to MYOB! In Excel use Search and Replace to replace all commas or other punctuation with a space (use space bar). Then import. It should come through cleanly this time.

NB: always backup before importing.#adp01

Filed Under: MYOB accounting FAQ's

Customer Discounts & Returns

Posted by Lynley on Jan 2 2009 with 0 Comments

Question:

1 We have different price levels for different customers. But it is not permanent, it changes all the time. For instance one shop had 10% discount on May but did not have it in June. What should I do?

2 Also, in purchase command centre in purchase register you can choose returns and debits. We as wholesales of shoes receive shoes back as they need to be credited because they are damaged or been send in wrong sizes. In the last case these shoes should go back to our inventory list, how to do that?

Answer:

1 MYOB does not know when to change price levels/discount levels. You can load the discount % on the Customer card under Selling Details, Volume Discount. The correct price level and discount should be reflected on every invoice provided you have setup correctly. If the discount varies month by month you need to alter it before invoicing. There is no work-around.

2 Enter a negative Item Purchase to send the stock back to the supplier. This takes it out of the stock file and creates a credit with that supplier. The credit must be settled against the invoice.#adp01

Filed Under: MYOB accounting FAQ's