- Created by admin, last modified by BrianQ on Aug 29, 2017
https://help.myob.com/wiki/x/3Aic
ANSWER ID:9392
This page demonstrates how to use the Banking Export Groups to process merchant fee transactions when exporting information from RetailManager to your MYOB accounting software.
Most businesses get charged merchant fees when their customers use certain types of credit cards or charge cards. This situation can be dealt with in RetailManager and your MYOB accounting software by following these steps.
Setting up for merchant fees
Before recording merchant fees, your RetailManager and MYOB accounting software must first be set up with new accounts and Banking Export Groups.
Create the required accounts in your MYOB accounting software
- Go to the Accounts command centre and click Accounts List.
- Click the Asset tab.
- Click New.
- Select the Detail Account option.
- Select the Account Type of Bank.
- Give the new account a number and a name, for example 1-2354 Amex.
- Repeat steps 3 - 6 for each export banking account you want to create.
- Click OK.
- Click the Expense tab. This will allow you to create an expense account for the fees that you are charged.
- Click New.
- Enter an account number and name, for example Merchant Fees or similar.
- Click the Details tab.
- Assign this account a GST tax code.
- Click OK.
Create Banking Export Groups in RetailManager for the clearing accounts
Follow the steps outlined in the RetailManager User Guide to create export groups for your various payment types. In the below example, we have created export groups for Amex.
Dealing with merchant fees on credit/charge cards
With your software setup, you're ready to process merchant fee transactions when exporting from RetailManager to your MYOB accounting software. See below for details on that process.
When your Retail.txt file is imported, the money counted for Amex will be deposited into the clearing accounts you have created in your MYOB accounting software which you have linked in RetailManager. Cash, Cheque and other payment types will be deposited into your cash drawer, unless you have created banking groups for these payment types as well.
When this data is imported into your MYOB accounting software, the following General Journal entry will appear in the Transaction Journal.
As shown in the above example, an AMEX sale was deposited into the Amex account at $899.
When your Merchant sends you a monthly statement outlining what fees you have been charged, the following steps need to be processed in your MYOB accounting software.
- Go to the Banking command centre and click Spend Money.
- Take note of the balance and make sure that the Tax Inclusive option is selected.
- Select the Amex Clearing account from the drop down list in the top left hand corner.
- Skip all fields except for Amount. In our example, the amount is $899 with a merchant fee of $45 (found on your Amex statements).
- Enter a Memo for your own reference.
- Enter the number of the account you want to deposit the money into. We have specified our General Cheque Account (Bank Account).
- Enter the dollar amount excluding the merchant fees and leave the tax code as N-T. In our example, this amount is $854.
- On the next line, enter the number of the Merchant Fee account that you created previously.
- Enter the dollar amount of the fees that you were charged. In our example, this amount is $45.
- Record the transaction. The balance of the Amex account should revert to $0 when this transaction has been recorded. See our example below.