Account Keeping Plus – Administration, Bookkeeping, Compliance News & Tips MYOB Reckon Quickbooks Xero Software TrainingSmall Business

Making Business Books and Accounting Come Alive! MYOB Reckon Xero

MYOB – How to Reconcile Suppliers V19 and Earlier

Leave a comment


MYOB – How to Reconcile Suppliers V19 and Earlier

MYOB – How to Reconcile Suppliers V19 and Earlier

Client – Requested us to help reconcile the supplier records in their MYOB

HowI find it good to use a couple of windows to see the full picture of the transactions and payments. To do that you need to tick the Restore Down at the top Right Hand Side (RHS) so you are able to see multiple windows at a time and move them beside each other.

  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. The bank should be reconciled for payments you have made up to date, if possible.
  3. 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).
  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.

Need help? Not sure? Call for FREE 30min advice / Strategy session today!

Call 0407 361 596 Aust and also get FREE “Avoid these GST mistakes” – There’s 18 that the Tax Office see regularly – Get them right!

Advertisements

Author: accountkeepingplus

Administration, bookkeeping and compliance for small business, and Self-Managed Super Funds (SMSF) Training, trouble-shooting, or we can do the books and payroll for you! Self Managed Superannuation Fund Service Provider, Free support MYOB Certified Consultant, Reckon/QuickBooks Professional Partner.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s