If your customers can pay you via PayPal, this article shows you how to set up MYOB to record these transactions.
PayPal transactions are much the same as other transactions which involve a merchant fee. In other words, the merchant (in this case PayPal) takes a percentage share of the transaction for providing the credit facilities. In our example, a $100 sale is received through PayPal, from which $2 is paid to PayPal, resulting in a net sale of $98. You will need to record both transactions in MYOB, in other words a customer receipt of $98 and a merchant charge of $2.
There are a few things to set up to handle these transactions, but once you're set up it's east to record your PayPal sales and account for the fees.
Task 1: Create a PayPal bank account
A PayPal bank account is required, against which you can record PayPal sales. This account will show you the balance owed to you by PayPal (or the balance you owe PayPal). It can be used like a normal bank account for making payments from or recording transfers to other accounts. Unfortunately at this stage, the PayPal account can't be set up with bank feeds.
Go to the Accounting menu and choose Chart of accounts.
Click Create account.
Leave the Account category set to Detail account.
For the Account type, choose Bank.
For the Parent header, choose the header account under which this new account will sit. If you're unsure which to choose, check with your accounting advisor.
Enter a Account number that suits your account list.
For the Account name, enter "PayPal Bank" or similar.
Choose the applicable Tax code. If you're unsure which to choose, check with your accounting advisor. Here's our example:
Click Save.
Task 2: Create a PayPal clearing account
This account is required to temporarily hold the PayPal fees before being cleared to an expense account.
Go to the Accounting menu and choose Chart of accounts.
Click Create account.
Leave the Account category set to Detail account.
For the Account type, choose Bank.
For the Parent header, choose the header account under which this new account will sit. If you're unsure which to choose, check with your accounting advisor.
Enter a Account number that suits your account list.
For the Account name, enter "PayPal Clearing" or similar.
Choose the applicable Tax code. If you're unsure which to choose, check with your accounting advisor. Here's our example:
Click Save.
Task 4: [Optional] Create a supplier card for the PayPal fees
When you record the PayPal fees using a spend money transaction, it's a good idea to allocate the transaction to a contact. Here's how to create a contact for PayPal.
Go to the Contacts menu and choose Create contact.
For the Contact type, select Supplier.
For the Designation, select Company.
In the Company name field, enter "PayPal" or similar.
Enter a Contact ID—this is a unique alphanumeric code to identify this supplier, such as SUP0001.
Click Save.
Task 5: Record the sale
Record the sale for the customer as you normally would (need a refresher?). In our example below, a sale for $100 has been recorded for a customer who is paying through PayPal.
Task 6: Receive the payment
When payment for the sale is received it comprises the net payment you will receive for the sale, plus the PayPal fees. In our example the total sale is $100 which comprises a net sale value of $98 plus a $2 PayPal fee. This is recorded using a customer payment for the full amount to the PayPal clearing account, and then a receive money transaction for $98 to the PayPal account from the clearing account.
To record the payment for the sale
Go to the Sales menu and choose Create invoice payment.
In the Customer field, choose the applicable customer. The list of invoices open against that customer appears.
In the Deposit into field, choose the PayPal Clearing account you created earlier.
Enter a Description for the payment.
In the Amount received column, enter the full amount the customer paid (including fees). Here's our example:
Click Save.
To record the receive money transaction
Go to the Banking menu and choose Receive money.
In the Bank account field, choose the PayPal Bank account you created earlier.
In the Contact field, choose the customer.
Enter a Description of transaction.
Select whether the amounts are Tax inclusive or Tax exclusive.
In the Account column, choose the PayPal Clearing account.
In the Amount field, enter the sale amount minus the PayPal fee.
Choose the applicable Tax code. If unsure, check with your accounting advisor or the ATO. Here's our example:
When you're done, click Record.
Task 7: Record the PayPal fees
You can now record the PayPal fees using a spend money transaction. This will clear the money from the PayPal Clearing account and allocate it to your PayPal Expense account.
Go to the Banking menu and choose Spend money.
In the Bank account field, choose your PayPal clearing account.
[Optional] In the Contact field, choose the PayPal contact.
Enter a Description of transaction.
Choose whether the transaction amounts are Tax inclusive or Tax exclusive.
In the Account column, choose the PayPal merchant fee expense account.
In the Amount column, enter the PayPal fee.
Choose the applicable Tax code. If unsure, check with your accounting advisor or the ATO. Here's our example:
Click Record.
FAQs
Can I set up a bank feed on my PayPal account?
Currently you can't set up a bank feed directly from a PayPal account. But there are a few ways PayPal payments can be managed. One way is to link your PayPal account to a bank or credit card account. If you have a bank feed set up for that bank or credit card account, then all transactions, including the PayPal ones, will show in that bank feed.
For more information about PayPal payment methods, see the PayPal website.