Archive for the ‘MYOB’ Category

h1

Generate BAS data using a MYOB (v19) report

October 22, 2019

This post is for me, in case anything gets messed up in the future, like it did today. I use MYOB AccountRight Plus v19, so if you use a different version, this may not work for you.

What happened

I went to generate my quarterly BAS using the BASLink method I’ve used since I started using MYOB. But instead of getting all the fields filled with figures, I got nothing. Blank fields everywhere. Something wasn’t right. After panicking a bit (being late with a tax office payment is not my idea of a good time!), I remembered that I got a new computer back in August. Aha! I bet something didn’t link as it should. Now all this is just a few short sentences, but it was about an hour of time, and about 10 years off my life!

What I did

I emailed my accountant to see if she could help, and while I was waiting for a response, I hunted out old backup files looking for the *.bas files for the BASLink setup. I found them but nothing I did worked—I still got blank fields in my BAS. Then I found this web page, which gave me the clue I’d been looking for: https://help.myob.com/wiki/display/ar/BASlink+FAQs

I’d been looking for a way to link the setup files via MYOB itself, but you have to do it via BASLink, which means running BASLink, ignoring all the blank fields and going to File > Setup & Links WITHIN the BASLink program. Once I’d correctly linked the old files, everything worked, and I breathed a very large sigh of relief.

An alternative

Meantime, my accountant got back to me just as I’d solved the problem telling me that there’s another way to generate the BAS data via standard MYOB reports, so here are those steps if I ever need them in the future:

  1. Go to Reports > GST/Sales Tax.
  2. Select the GST [Summary – Cash] report.
  3. Click Customise and set the dates for the quarter.
  4. While in the Customise window, also select the tax codes to report (in my case, just GST).
  5. Click Display. This gives you the totals that go into the various fields on the BAS:
    • Sale value = G1
    • Purchase value = G11
    • Tax collected = 1A
    • Tax paid = 1B
  6. What it doesn’t give is the PAYG tax information, so for that go to Reports > Payroll.
  7. Select the Activity Summary report under Employees.
  8. Click Customise and set the dates for the quarter, if not already set.
  9. Leave Employees set to All.
  10. Click Display. This gives you the totals that go into the various fields on the BAS:
    • Wages = W1
    • Taxes = W2, W5, and 4.

 

h1

My notes about single touch payroll

June 5, 2019

These notes are for me only. I just needed somewhere to document my process so I don’t have to remember it every month. Oh, and with 27 steps (!!!), this is NOT a ‘single touch’ process, despite what the ATO would lead you to believe!!!!

  1. Open MYOB 19 and do payroll as per normal.
  2. Note the amount, the pay date range, and the date payment was made.
  3. Close MYOB.
  4. Go to online banking and make the payment as per normal.
  5. Open Namich STP Creator.
  6. Select user name and enter password.
  7. Click Permanent Data Set.
  8. If the dataset doesn’t load, click Browse 1 and select the company data set if not already populated (default location: C:\Users\<username>\Documents\STP_Creator).
  9. If asked, select user, enter password, then click OK.
  10. Click Load Data from MYOB File.
  11. Select ADMINISTRATOR user ID for MYOB and enter password (or skip if no password). Click OK.
  12. Click Save and Close Screen to return to the main STP Creator window.
  13. Click Assemble YTD Data. Check the data is correct, then click Save to return to the main STP Creator window.
  14. Click Assemble W1 and W2 Data.
  15. Enter the pay date range and the date payment was made (see step 2 above), then click OK.
  16. Check the totals match the amount paid via MYOB (step 2 above). Click Save.
  17. Click Assemble Lodgement Data.
  18. Do a final check of the data, then click Lodge. NOTE: If this is the last pay run of the year, click Final Indicator BEFORE clicking Lodge.
  19. Check the declaration box.
  20. Click Sign In.
  21. On the Single Touch log in screen, enter the email address and password for Single Touch, then click Sign-in.
  22. Click Send Code to send a two-factor authentication code to my mobile phone.
  23. When the code arrives, type it into the verification code box. DO NOT press Enter or any other key.
  24. If you get a Server Busy error message (likely), click Retry.
  25. Once you get the message that you’re successfully signed in, click Send.
  26. The status should change to Success and you should get a couple of emails from Single Touch letting you know that a new STP event was generated, and that the data was successfully submitted to and accepted by the ATO.
  27. Click Close on all open STP Creator windows, then close STP Creator.

See also:

h1

MYOB: Dealing with PayPal payments and merchant fees

January 9, 2019

This is for me, because I’m bound to forget what to do the next time someone pays me via PayPal and I have to account for the PayPal fee incurred.

Follow Steps 7 and 8 in this support note from MYOB: http://help.myob.com/wiki/display/supae/PayPal+payments+from+customers

In case that webpage ever goes missing, here are those steps:

Step 7: Receive Payment

When payment for the sale is received it comprises the net payment you will receive for the sale, plus the PayPal fees. In our example the total sale was $100, which comprises a net sale value of $98 plus a $2 PayPal fee.

This is recorded as two separate Receive Payment transactions:

  • one payment for $98 which is allocated to the PayPal Bank Account
  • one payment for $2 (the PayPal fee) which is allocated to the PayPal Clearing Account.

To record the payment for the sale

  1. Go to the Sales command centre and click Receive Payments. The Receive Payments window appears.
  2. In the Deposit to Account field at the top, select the PayPal Bank Account.
  3. In the Customer field, select the customer to whom you made the sale. The customer’s open invoices will be displayed.
  4. In the Amount Received field, enter the net sale amount, in other words the total sale amount minus the PayPal fees. In this case it would be $98.
  5. Click in the Amount Applied column for the customer sale. The amount will be automatically applied. See our example below.
  6. Click Record.

 

To record the PayPal fees

  1. Go to the Sales command centre and click Receive Payments. The Receive Payments window appears.
  2. In the Deposit to Account field at the top, select the PayPal Clearing Account.
  3. In the Customer field, select the customer to whom you made the sale. The customer’s open invoices will be displayed.
  4. In the Amount Received field, enter the amount of the PayPal fees. In this case it would be $2.
  5. [Optional – see Task 1 above] In the Payment Method field, select PayPal.
  6. Click in the Amount Applied column and the amount will be automatically applied. See our example below.
  7. Click Record. The $2 will be allocated to the PayPal Clearing Account and this will be cleared out in the next task.

Step 8: Clear the PayPal Clearing Account

The final task is to clear the PayPal fees from the PayPal Clearing Account to your Merchant Fees expense account. To do this:

  1. Go to the Banking command centre and click Bank Register. The Bank Register window appears.
  2. In the Account field, select the PayPal Clearing Account. The payment made to this account in the previous task will be listed.
  3. Click to highlight the PayPal payment.
  4. In the bottom section of the widow in the Type field, select Spend Money.
  5. In the Card field, select the PayPal supplier card.
  6. In the Amount field, enter the amount of the PayPal fees – in this example that would be $2.
  7. In the Account field, select the Merchant Fees account created in Task 4 above.
  8. In the Tax/GST field, select the relevant tax/GST code.
  9. Click Record. See our example below.

*********
My next step is to find out how I can add an automatic percentage fee to an invoice to account for the PayPal fee (and BPay fee, if I ever get it). It doesn’t look like this will be easy to do…

h1

MYOB v2011: Registry entries

May 22, 2012

I think I’ve found a reason why MYOB v2011 is SO DAMNED SLOW…

I had installed it on my Windows XP machine back in December 2011, but didn’t get to do more with it than test it on the sample company files. After the debacle with the release, I decided to continue using v19.6.

Anyhow, I’ve retired that Windows XP PC, and this weekend I used Revo Uninstaller to uninstall a heap of programs from that machine. Most of the software I uninstalled had fewer than 10 Registry entries, with only a few pieces of software having more than 100. Google Desktop had a tad under 400 Registry entries left after uninstallation. And most pieces of software I uninstalled left very few files after the removal of the software — typically fewer than 20 files, if any.

Not MYOB v2011. After uninstalling MYOB v2011, Revo Uninstaller reported that there were still 1762 Registry entries lurking! 1762!! And after I deleted those via Revo’s interface, it reported another 2163 MYOB-related files that weren’t uninstalled. NONE of these files were my data files; many were individual Help files, graphics files, DLLs, etc.

Unbelievable. No wonder the application is so darned slow if there are 1762 Registry entries left over AFTER uninstallation — makes you wonder how many are installed in the first place.

h1

MYOB: They’ve got Australian businesses caught between a rock and a hard place

April 11, 2012

I am NOT happy with MYOB.

As a small (one-person) business who charges by the time I spend on client work, I need accounting software that can deal with hourly rate time billing and calculate the GST, can accurately calculate my BAS at the end of each quarter, and that can load the updated tax tables from the Australian Government after July 1 each year.

MYOB seems to be the only software in the Australian marketplace that can do all this automatically. And as it’s also used by my accountant, I’m pretty much locked in to the MYOB world. While it’s never been the prettiest software or the most intuitive to work with, it has worked, and I haven’t begrudged paying the annual ‘Cover’ fee (i.e. subscription) on top of the initial amount I paid for the software (the ‘Cover’ subscription gets me [annual] software updates and those all-important updates to the Australian Tax Office’s tax tables).

But now MYOB have really upset their user base. Firstly, they put out new release of their software in late in 2011, which didn’t work in a timely manner (slow as a wet week would be polite), and have released THREE service packs since then. And still the MYOB forums are full of bookkeepers, accountants, and small business users howling at the slowness of the software, and advising anyone who can to go back to V19.6. Needless to say, after my fruitless experience over Christmas trying to install and activate the new version and reading hundreds of forum posts berating MYOB for a really crappy software version and for losing those small business people hundreds — if not thousands — of dollars in revenue and enormous amounts of lost time, I’ve stuck with v19.6. The forums haven’t died down in the past few months either — MYOB is taking a HUGE hit to its reputation from its user base on this release. Even the CEO has come on to the forums to try to calm things down, but that hasn’t worked either — the software is still buggy and slow, according to the most recent forum posts.

And now to add insult to injury, I got my ‘Cover’ (annual subscription) renewal in the mail the other day, and the annual subs have jumped from around $400–$500 a year (see below for my past invoices) to $714.00!!

Subscription amounts for the past four years

From 2008 to 2009, there was a $20 increase (less than 5% increase) on the previous year’s subs. From 2009 to 2010, there was also a $20 increase (also less than 5% increase). From 2010 to 2011, there was a $34.05 increase on the previous year’s subs (about a 7% increase), and from 2011 to 2012, there’s a $220.95 increase to $714.00! That’s a 31% increase on last year’s subs! That’s out and out highway robbery.

The CPI in Australia from Dec 2010 to Dec 2011 was averaging around 3% (http://www.abs.gov.au/ausstats/abs@.nsf/mf/6401.0) so the less than 5% increase, and even perhaps the 7% increase are not too far off that mark. But more than 30%??? That’s just taking advantage of the fact that their Australian small business customers have very little alternative software available to them for managing their business finances and taxes.

A crappy product and a price increase of 30%? How to lose your customer base really quickly. I’m sick of them and their dodgy business practices (who releases a major software version without testing it first? and then ups the subscription amount by some 30% for a crappy product that no-one wants to use?).

If anyone has any suggestions of software alternatives to MYOB, I’d be happy to hear them. However, the alternatives MUST be able to do hourly time billing, calculate the GST and BAS, provide annual tax tables from the Australian Tax Office, and be at a price point suitable for a one-person business. So anything designed for the US, UK etc. is out. Oh, and the alternative has to be able to import my existing MYOB files (accounts, card files, etc.) and let me customise my invoices. And my accountant needs to be able to work with the files come tax time.

Update April 2013: Just got my renewal from MYOB for this coming year: $780!! A $66 increase from last year’s subs, which is another 8.5% increase. The 2012 CPI for Australia was 2.2%…

h1

MYOB AccountRight 2011: Upgrade issues

December 27, 2011

Bottom line: I can’t use the new version of MYOB!

I held off upgrading my business accounting package (MYOB) until the Christmas break. I wanted to have time to do the upgrade (MYOB suggested 1 hour outside normal work hours), and time to learn about some of the new features. I’m glad I held off — within a few days of releasing their v2011, they had released a service pack (SP) for it, addressing ‘issues’ presumably related to the upgrade process and things that just didn’t work once your MYOB files were upgraded.

So, come Boxing Day (December 26), I was relaxed enough to do the upgrade and had set aside half a day for it. I read through the Release Notes (yes, people actually read these!), which included the steps for the upgrade and what to do both before and after. I backed up my two MYOB files, installed v2011 and then the SP, as instructed. I upgraded my two MYOB files. All this took about 45 minutes or so.

And then I came to a screeching halt.

One thing that MYOB does when you do an upgrade (and about every 6 months thereafter) is activate and/or confirm your files and your installation of the software are legitimate. I don’t have an issue with that… as long as it works! But it didn’t work for me. And nor did a few other things.

Fortunately, I made a backup and didn’t uninstall v19, so I can continue to use that until MYOB open their customer support lines on Wednesday 28 December.

Here are my issues with this upgrade:

  • I can’t confirm either of my MYOB data files via the internet. Without confirmation, I CAN’T USE MY OWN DATA. I have a legitimate installation of MYOB and pay almost $500 a year for their upgrade/support, yet I can’t access my own stuff and I can’t contact them as they’ve closed their support lines only a short time after releasing this new software. I understand that their staff need a Christmas break too, but even a skeleton staff would help — there must be many businesses that take advantage of the holidays to upgrade their business software. Also, there’s no ‘grace period’. Even Microsoft allow you to use their Office products for several days/instances before you must activate.
  • I can’t confirm via phone either as the phone # and serial # is not displayed, as documented in the Release Notes. I just get a blank screen with a title.
  • I couldn’t choose a network location for my library folder. I got error messages no matter what I put in for the network path. For example, I tried these \\<servername>, \\<servername>\myob (yes, that folder exists and is shared), and the IP address of my server, all as instructed. None worked, so I ended up choosing the default My Library.
  • When I selected My Library, there’s no indication of the file path for the installation of your MYOB files and no option to change the location! What other software does this?? I only discovered the file path by doing a Windows search; the path in Windows XP is the Documents and Settings\All Users\Documents\MYOB… folder. (see this Support Note for the locations for other operating systems: http://myobaustralia.custhelp.com/cgi-bin/myobaustralia.cfg/php/enduser/std_adp.php?p_faqid=33728&p_sid=JdhaHxMk&p_lva=33830) One user on the Forum said it most eloquently: “Libraries. Fixed location does not work for me and others. I want to keep my data where I want it. Remember it is my data, not yours. Makes backing up all my data simple.”

Other issues documented in the Release Notes are of concern:

  • Many existing features in v19 and earlier are not yet available in v2011. I don’t use any of these listed in the screen shot below, but if I did, I’d be mightily annoyed with MYOB that they seem to have released a half-baked product. Perhaps they were under pressure to get it out before the end of the year. Personally, I’d rather they waited and got it right and did the proper testing before releasing software that LOSES features people have come to rely on.
  • All your custom reports are gone. Phhttt. Gone. Just like that. And you can’t get them back or convert them — you have to set them up again. Platitudes like ‘…making this task a lot easier’ are worthless if you’re the poor bunny who relies on custom reports and has to set them all up again. I don’t have many — perhaps 6, only 1 of which I use regularly — but I’m still not happy that there’s no conversion option for these and that I’ll have to spend time setting them up again.
  • User accounts become inactive and you are forced to assign users to roles. They sell the package I use to small businesses only and sell it as a single user system. Often the only person using MYOB is also the owner of the business. One user. So why is MYOB forcing these small businesses to use roles? That seems like overkill. Sure, I can understand it for their medium to large business and enterprise packages, where many people can be using the same MYOB file. But not for the single person small businesses.
  • Any images you’ve used in your previous MYOB installations have to be relocated to a new folder and they CANNOT BE MORE THAN 200 KB is size! 200 KB? What year are we in — 1992??? What a ridiculous restriction. And there’s no explanation as to why, either.

Other potential issues reported on the MYOB Support Forum:

  • It’s dog slow (I can’t confirm this as I can’t get into my files, but it’s a common thread on the forum; many users have reverted to using v19)

For all sorts of other issues, see the MYOB Support Forum topics on the November 2011 upgrade: http://community.myob.com/t5/AccountRight-November-2011/bd-p/AccountRighNovember2011Upgrade

I don’t think I’ll be trusting my business and personal accounts to the latest version of MYOB for some time… It’s WAY too buggy. I wonder if I can send them an invoice for the 6+ hours I’ve wasted today on their forums and trying to get their software to work.

Update: I decided to open the sample file in the latest version of MYOB, and did some quick speed tests against the same sample file in v19. Here are my results:

  • Open Mary Jones’ card: v2011 – 10+ seconds; v19 – less than 1 second. (I re-opened it in the new version two or three times in case there was caching going on — each time it took more than 10 seconds to open)
  • Open the Spend Money window: v2011 – 7 seconds; v19 – less than 1 second
  • Enter a different date on the Spend Money window: Can’t overwrite existing and use periods as dividers in v2011, as you’ve been able to do in ALL previous versions of MYOB. You have to use ‘/’ separators or choose a date from the drop-down calendar. For those who do a LOT of data entry, this will frustrate the hell out of them.
  • Entering time billing information takes forever…
  • Generating an invoice: v2011 – 10+ seconds; v19 – 2 seconds
  • Processing payroll: v2011 – 30+ seconds; v19 – less than 5 seconds

The program is definitely MUCH prettier. But its functionality and performance leave a LOT to be desired. Pretty NEVER trumps performance, in my book.

Update 27 December 2011: It took nearly 5 minutes to get my Desktop displayed after booting up and logging on this morning. I recall seeing something about slow boot times as a result of installing MYOB AccountRight 2011 in the forums yesterday, so will restart my computer again to see if that was a one-off. If it wasn’t, I’ll try a system restore back to where I was before I installed MYOB…. The restart was at normal speed, so I’ll hold off on that system restore.

[Links last checked December 2011]

h1

MYOB: Find previous General Journal entries

July 19, 2011

This post is for me, because I can never remember how to find the list of Journal Entries I had to make as a result of receiving the Adjusting Journal from my accountant. This is a process I only do once a year, and if I need to check the entries later, I spend ages trying to find the right report.

So, for my own benefit, here’s where that report is in MYOB:

Reports > Accounts > Transaction Journals > General Journal

MYOB Adjusting Journal report

MYOB Adjusting Journal report

And to enter the Adjusting Journal entries from the accountant once they’ve completed the tax return etc., go to Accounts command center > Record Journal Entry. Make sure the date is set to 30 June of the just-finished tax year (you might need to unlock the security period first — Setup > Preferences > Security), and make sure all tax codes are N-T otherwise the adjusting journal won’t balance.