Bookkeepers and Business Owners! – Training you – Solving Problems – Or We do your books for you!

Bookkeeping – Train, Troubleshoot or we do the books for you! MYOB Reckon Xero & Set Up


MYOB – Track Departments, Offices, Properties, Models with Categories

The Categories feature in your software gives you a powerful new way to track and report on transactions.  By setting up Categories, you can now record and track transaction information using your own criteria, such as lines of business, divisions or departments.  Unlike the jobs function, Categories can be used to track and report on virtually all transactions, not just income and expenses.

Set Up: (> means click)

> Set Up > Preferences > System tab, tick: Turn on Category Tracking, and choose whether Required or not > OK

myob category set up

myob category set up

Create Categories:

>Lists > Categories > New > Category ID – give a code name, > tab > OK > Close

Transaction screens (some don’t such as Pay Bills etc) will now have a box lower in the screen where you can assign a category.

myob category in a transaction

myob category in a transaction

Use reports under the Accounts tab in Index to Reports – scroll down to the Categories Group. Try the Activity Summary or Detail reports that give per account. You can filter for selected accounts only or the full Balance Sheet and Profit and Loss. You can also select the Profit & Loss and Balance Sheet Category Reports too.

Note you can filter by Categories in the Sales (and Purchase) Item Detail & Summary reports – filter by category or add a column for the categories used.

Further info at the MYOB support note: Categories


Leave a comment

Occupational Health for Employers – watch Jan 2012

Employers take note – responsibilities for OHS come into the spotlight as significant changes to Occupational Health and Safety Laws come into effect across Australia from 1 January 2012.

The new reforms are part of a “harmonised” system – rather than a national one. Each state has its own legislation in line with the agreed model Work Health and Safety (WHS) Act, but there are variations. By providing wider coverage to reflect contemporary work relationships and an increasingly mobile workforce the reforms apply not only to employees, but also to contractors and their employees, subcontractors, labour hire workers, apprentices and volunteers.

The new reforms bring tougher penalties and “officers” of companies (which include directors) will need to exercise due diligence to ensure compliance with OHS laws. There’s also a wider range of enforcement mechanisms for OHS regulators, and a national compliance and enforcement policy will be developed to ensure a consistent regulatory approach across all jurisdictions.

As an employer, it’s important that you review your OHS policies. Ensure that your policies embrace the new reforms and your employees understand the policies and the consequences for breach. Undertaking an audit of your Work Health & Safety compliance will help minimise your business risk and provide a checklist to remedy any non-compliance.

For More See

National Codes of Practice

Occupational health and safety

Safe Work Australia


What are YOUR worksafe issues?

Leave a comment

Quickbooks – Bill Clients from Progressive Quote/Estimates

After a client accepts a quote/estimate, you can bill your clients in stages. Follow these steps (> means click) –

First turn on “Progress an Invoice” as follows >Edit > Preferences >Company tab, >Another Standard Invoice Design: Progress Invoice >Save/OK

>Customer Centre >Estimate and create invoice (if you are a professional service, at the top RHS change to Proposal form

Once accepted and stage 1 is ready to invoice >Invoice type the Customer/job name, wait a screen appears with Avaialble Estimates, choose the one you want >OK

In the Create Progress Screen, choose: whether you want entire, percent or selected items >OK

Specify amounts for the items >choose:  quantity and rate +/or:  show % >OK

Check the invoice

Add more items if required

Subsequent invoices will accrue the previous invoiced amount(s)

Leave a comment

MYOB – End of Year Payroll Process – should report match General Ledger before start a new payroll year?

Client asked – I have doubts before i go ahead and start a new payroll year…

1) what will happen if Payroll activity statement matches with payroll register but does not match with general ledger or P and loss account?

 2) we have paid PAYG withholding up to May 2011 but i didn’t pay June PAYG withholding because our BAS is due in July.

 Can i process payment summaries and start a new payroll year or do I need to reconcile first all the accounts then go further?

Answer – Yes your General Ledger should match/or final balance reconcile to your payroll Activity and Payroll Register BEFORE you roll over. Subtract the difference and try to see if a transaction has gone to the wages or PAYG Liability or Super Liability, and shouldn’t be there. Check if all payments of PAYG (via BAS/ or Instalment Activity Payments) and super are there correctly.

Wages expense account should match your Gross Wages in the Activity Report, full year.

PAYG balance at year end should be the net after the last PAYG payment eg if PAYG paid via last BAS last Qtr (ie to the end of March) then the April to June PAYG should be the balance at Year End of the PAYG Liability account. In your case only the June amount, as you have paid up until May. (And entered the payment to the Liability account).

Same for Super Liability, year end balance should be what is not paid.

It is OK to have part paid the PAYG, before you rollover the payroll year, the account will still have the records and the balance due is paid in July.

So ensure ALL BAS are entered and PAYG allocated to the Liability account and super payments allocated to the Super Liability account.

When all reconciles, THEN process payment summaries, THEN a BACKUP should be made and labeled YE11 Payroll. Then you have a correct and reconciled payroll year.

THEN you can rollover the payroll year.