Clearing Eftpos from Bank Feed
At the end of each day, the received eftpos payments are all combined by my bank and appear on the feed as one transaction. As the payments are already assigned to invoices from multiple customers, h...
Forum Discussion
Hi Flowtek15
When you record the Receive payments transactions tick the Undeposited Funds option:
In Prepare Bank Deposit tick all the Payment transactions included in the EFTPOS lump sum deposit. The Total Deposit Amount should be the same as the EFTPOS deposit amount:
If you look in the Bank Register you will see the Prepare Bank Deposit transaction for the lump sum amount:
Match the Prepare Bank Deposit transaction to the bank feed transaction in the Bank feeds window.
Please let me know if you need further help.
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.
Hi Tracey_H , Correct me if I'm wrong but won't this be adding a deposit? And therefore doubling the income of a sale?
Also when I select "Receive Payments", there is no check box for undeposited funds. I could setup a transaction rule so that all payments with the EFTPOS description are allocated to the undeposited funds account. However these funds have techncially already been deposited (when the customer paid via the eftpos machine), I just need to match the transactions or alternatively ignore/delete the deposit on the bank statement. Whichever clears it from the bank feed without creating issues.
As you can see below, I cannot select a customer for the transaction, as it covers multiple customers and multiple invoices. There is also no check box. And therefore I cannot receive the payment.
When there is only one Eftpos transaction for the day, MYOB is able to match the deposit on it's own to the correct, already paid, invoice. I'm just struggling to do this when the deposit covers more than one customer.
Sorry if I'm not explaining myself clearly.
Hi Flowtek15
You need to go to Sales>>Receive Payments to record the payment transactions, not select Receive payments from the Bank feeds window. You can then tick the Undeposited funds option, select the customer and record the payment.
When you record a sale transaction the journal posted credits the income account and debits the Trade debtors account. This is a sample sale transaction:
When you record the Receive payments transactions the Trade debtors account is credited and the account selected in the Deposit to Account field is debited. If you tick the Undeposited funds option this will be the Undeposited funds account:
When you record the Prepare bank deposit transaction the journal posted moves the amount from the Undeposited funds account to the Bank account.
The income account is only affected by the sale transaction.
The correct process for lump sum EFTPOS deposits is using Undeposited funds and Prepare Bank Deposit as explained previously. To recap that process:
- go to Sales>>Receive Payments>>tick Undeposited funds>>select the customer and record the payment
- go to Banking>>Prepare Bank Deposit>>tick the payments included in the lump sum EFTPOS deposit>>Record
- go to Bank feeds>>match the EFTPOS deposit to the Prepare bank deposit transaction
Please let me know if you need further help.
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.
