Forum Discussion

simonk2's avatar
simonk2
3 months ago

Bank feed-split single deposit to reconcile 2 x invoices

We recently processed 2 x credit card transactions on the same day. One was $357.62 and the other $786.06. These both appeared on the bank feed as a single transaction of $1143.68. My question is h...
  • simonk2's avatar
    simonk2
    3 months ago

    Thanks for your response, it pointed us in the right direction.

    The Tall Emu/MYOB CRM allows a deposit invoice to be generated and places it in the Deposit TE account. When the goods are actually shipped and a sales invoice is generated the deposit amount is credited against the invoiced amount hence the NIL balance as you described.

    What we did was a "receive money" for this client against the Deposit TE account which then allowed us to find and allocate the transaction.

    Thanks for your help.

Freman's avatar
Freman
Trusted Partner
3 months ago

Yikes... a paragraph was missing from my OG post.....

 

Your 2nd picture is showing an invoice with NIL balance to pay with items totalling 786.06 (inc GST) cancelled out by the Deposit TE line. There is nothing outstanding on this invoice so my guess is (unless there is something funky going on with the setup of the 'Deposit TE' item) there should be another transaction showing $786.06 was expected to be deposited (probably payment against a single line invoice with 1 unit of  'Deposit TE' $786.06) . --> This one and the $357.62  are the ones that should be heading to the undeposited funds account to be stitched together with the 'Prepare Bank Deposit' process. 

  • simonk2's avatar
    simonk2
    3 months ago

    Thanks for your response, it pointed us in the right direction.

    The Tall Emu/MYOB CRM allows a deposit invoice to be generated and places it in the Deposit TE account. When the goods are actually shipped and a sales invoice is generated the deposit amount is credited against the invoiced amount hence the NIL balance as you described.

    What we did was a "receive money" for this client against the Deposit TE account which then allowed us to find and allocate the transaction.

    Thanks for your help.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.