Articles Blog
MYOB – How to Reconcile Your Suppliers
- Details
-
Published on Friday, 23 December 2016 15:59
Client - requested us to help reconcile the supplier records in their MYOB to get a true picture of what they owe.
How – I find it good to have a couple of windows open to see the full picture of the transactions and payments. To do that you need to tick the Restore Down in MYOB at the top Right Hand Side (RHS) so you are able to see multiple windows at a time and move them beside each other. Now here’s what to do -
1. MANUALLY RECONCILE all the papers you have - the supplier invoices to their statements ( assuming they send them to you, say monthly, or request an up to date statement or account that they have of what you owe them). It is good to staple the invoices behind the statement (which is a nice summary of the month). Have the past 3 months or as far back as you need or are unsure of.
2. ARE ALL PURCHASES & PAYMENTS IN? - To see your purchases payments, click on Find Transactions at the bottom of the Purchase Command Centre (or Ctrl+Y) on the Card tab, search and select your supplier, choose your dates. This gives purchases (Cr column) and payments (Dr column).
3. The bank should be reconciled for payments you have made up to date, if possible, and allocated to the correct bill you paid.
4. RECONCILE - Now compare, working in date order that all purchases (there are 2 lines – one is the GST amount, the other ex GST) and payments and see if they match your records, and those of the supplier. This can take time
5. Enter or correct what is not right.
6. RECONCILE the recent months - The final window to use (most useful for the last 2-3 months) – is the Purchases Command Centre, in the lower RHS, click the word Analysis and the Analyse Payables should open with all suppliers summarized. Click the white arrow to the left of the supplier name you are working on. This shows all purchases you still owe. It is also grouped by month (or day/period set in Preferences) – you should be able to see the totals at the bottom and compare each month to the monthly statements from your supplier – if some invoices are paid, they will not show in the list here (you can select the dates for the month at point 2 above in the Purchase Register and see all invoices and the closed ones will be the paid ones).
7. FINAL – once you are happy all purchases and payments are in, the Analyse Payments window should have dating period totals and final total that matches (less your payments they haven’t recorded yet on the last statement) the latest supplier statement. Tick the total to show you have reconciled, or print the Analyse Payable window if you need to put with that with the supplier statement.
Get Your FREE “Avoid these GST mistakes”
There are 18 that the Tax Office see regularly – Get them right!
This email address is being protected from spambots. You need JavaScript enabled to view it.
Need help? Not sure? Call for FREE 30min advice / strategy session today!
Call 0407 361 596 Aust
Search for info you need in the box towards the top right, Call for FREE 30min advice 0407 361 596 or click for the list of our articles.
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
