Skip to main content
All CollectionsIntegrations & Add-OnsMYOB
MYOB Auto Reconciliation (AccountRight Live)
MYOB Auto Reconciliation (AccountRight Live)
Updated over a week ago

Ordermentum is able to simplify the reconciliation process by providing a MYOB compatible CSV to import.

In this article are the steps on how to bulk reconcile Ordermentum Payments with MYOB in just few simple steps.

KeyNotes:

  • The Auto Reconciliation will only work if you used Bank Feeds in MYOB

  • The user reconciling in MYOB must have access to the import/export function within MYOB

  • The file will have to be setup with a deposit account. We recommend using one of the clearing accounts and not the account the actual funds are deposited in to e.g. 1-1210

Screen_Shot_2021-03-24_at_8.13.44_pm.png

Steps

1. Ensure the Reconciliation feature is turned on

  • Under Settings> Integrations> Manage> Update Settings ensure the correct Bank Account is selected in the dropdown & Send payment reconciliation file? is switched on.

Screen_Shot_2021-07-21_at_1.37.24_pm.png

2. Receive MYOB Import File

  • Your MYOB reconciliation file will be attached to your remittance email

  • Download the file and save it in a location for to use in step 3.

3. Import file into MYOB

  • In MYOB got to File>Import Export Assistant

  • Import "Receive Payments"

Screen_Shot_2021-03-16_at_12.56.18_pm.png
  • Browse and select the file from Step 1.

  • You will be required to select the format for the file you are importing. Following the settings below

Screenshot 2023-11-16 at 11.35.05.png
  • Match the fields to import by clicking on the Auto Match button

Screen_Shot_2021-03-16_at_8.30.58_pm.png
  • After clicking Next you will be prompted to Import the file

Note: The importing of the file will close off all the invoices as paid OR if a credit has been applied in Ordermentum the net amount will be applied against the invoice.

4. Prepare Bank Deposit

  • The bank deposit is prepared to match the invoices that have been paid in Step 2 against the Bank Feed in your MYOB

  • In the MYOB Command Centre go to Banking>Prepare Bank Deposit

  • Select the Deposit Account the file above was allocated and the date the settlement was created in your account. You're looking for Ordermentum Settlement Reference e.g. OM23041008 number to match what you have in the Bank Feed (see screenshot below)

Picture_1.jpg
  • You will then need to select all the items in the Bank Deposit. Once all are selected the Total Deposit Amount: will be equal to the amount deposited in your Bank Feeds

bank_deposit_match.png
  • Once matched you can then Record the Bank Deposit

5. Match the Bank Deposit to the Bank Feed

  • Using the Bank Feeds click the Find button to search for the Bank Deposit created above

Screen_Shot_2021-03-16_at_9.23.26_pm.png
  • Once found select the deposit and click on the Match & Approve button to reconcile the invoices to the cash in your account.

Screen_Shot_2021-03-16_at_9.23.32_pm.png
  • Your deposit is now reconciled and should appear like the below.

Screen_Shot_2021-03-16_at_9.24.15_pm.png
Did this answer your question?