Purchases on bank statement not in myob

Question

Hi All,

I have approx 75k worth of personal purchases for the last 22 months on the company bank account that are obviously not in myob for me to match up and reconcile. Is there any easy way to enter these into myob, or do i need to sit down for the next 400 hours and enter every seperate item into a purchase in myob then check it off??

help please

Tracey_H · Answer

Hi @Flyin

How bank feeds works is the bank transactions are brought into your file from your bank and appear on the left side of the Bank feeds window. The AccountRight transactions are on the right side of that window, when you approve a match the AccountRight transaction is automatically ticked in the Reconcile accounts window.

If you have bank rules set up the software will automatically create the AccountRight transaction and match those transactions in the Bank feeds window. Once approved the AccountRight transaction is ticked in the Reconcile accounts window.

From your screenshot it looks like you've got bank rules set up which have created the transactions starting with 1 and are ticked in the Reconcile accounts window. It looks like the transactions you've manually entered start with 3. I'm basing that assumption on the transaction memo. It looks like the 3 transactions are manually entered memo descriptions and the 1 transactions are the bank descriptions.

If that's the case, you'll need to delete the 3xxx transactions by clicking on the blue zoom arrow to open the transaction, then click on Edit>>Delete or you can right click on the open transaction and select Delete.

Going forward, I'd recommend not manually entering each Spend money transaction. Use the Bank feeds window to match and approve the bank transactions with the AccountRight transactions. If there isn't a matching AccountRight transaction you can create one from the Bank feeds window by clicking on New>>Spend money.

Your other option would be to delete the bank feed rules. Then in the Bank feeds window record the AccountRight transaction by clicking on New>>Spend money.

Please let me know how you go with this.

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Flyin · Answer

Flyin · Answer

Thank you. I have been entering every transaction into the myob spend money screen manually, or if its an un entered invoice, i have entered those. Now when i look at the transaction journal, there seems to be a double up of the same transactions and is putting me out of balance. is this normal for it to look like a double up and will recify once reconciled, or because it is coming through as a bank feed it is automatically allocting them? im confused.