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
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.
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"
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
Match the fields to import by clicking on the Auto Match button
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)
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
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
Once found select the deposit and click on the Match & Approve button to reconcile the invoices to the cash in your account.
Your deposit is now reconciled and should appear like the below.