Forum Discussion

PRSquire's avatar
PRSquire
Experienced Cover User
5 years ago

accrual v transaction

On a receivables reconciliation [Summary] I have a member who according to MYOB owes $10.01 Total Due 0 - 30 31 - 60 61 - 90 90+ $10.01 $0.00 $0.00 $0.00 $10.01   On the correspon...
Reports
Sales
  • Steven_M's avatar
    Steven_M
    5 years ago

    Hi PRSquire 

     

    The Recieve Payments window will show both open invoices and orders (and closed transactions if the option is enabled).

     

    When you record an order no accounts are affected and thus the Find Transactions window will not show anything until that order is converted into an invoice. A user can make a payment on an order, however, it is placed into a deposit situation where the payment is placed into holding until the invoice is converted to an invoice.

     

    Looking at the original screenshots you have provided, it looks like that deposit transaction hasn't quick carried across for one reason or another and thus leaving a difference. Deleting that transaction and redoing should bring across the transaction as intended. However, do let us know if you are still encountering that situation after re-doing that payment so we can investigate further.

Steven_M's avatar
Steven_M
Former Staff
5 years ago

Hi PRSquire 

 

If you run the Reports>>Sales>>Receiveables>>Receivables Reconciliation [Detail] report, this will list the individual transactions that are outstanding for that customer.

 

However, having a guess looking at the other values I would have it a guess that the $10 was paid through a deposit based transaction that has caused some problems within the system. My recommendation would be to review that transaction history to ensure that you do have the Transfer from Deposit transactions (should be two listed) - open the invoice, select the History button (right-hand side of the Edit Sales window).


If you still require assistance, we would need to see a copy of the Receivables Reconciliation [Detail] report, a screenshot of the associated transaction for that customer and one Find Transactions for that individual sale transaction to be investigated further. Also, getting the actual list balance on the card would be ideal.

  • PRSquire's avatar
    PRSquire
    Experienced Cover User
    5 years ago

    I've produced a recievables reconciliation detail report showing the $10.01 owing

    Receivables Reconciliation [Detail]
    As of 25/08/2020
            
    ID No.DateTotal Due0 - 3031 - 6061 - 9090+ 
            
    103605/04/2020$10.01$0.00$0.00$0.00$10.01 
     Total:$10.01$0.00$0.00$0.00$10.01 
     Grand Total:$10.01$0.00$0.00$0.00$10.01 
     Ageing Percent: $0.00$0.00$0.00$1.00 
     Receivables Account:$1,050.12     
     Out of Balance Amount:($1,040.11)     
            
            

     

    as you can see if I Print from the Find transaction screen the card transactions is 1 cent out

    Card Transactions [Accrual]
    1/08/2018 To 25/08/2020
            
     ID No.SrcDateMemoAccountDebitCredit
     10071SJ10/09/2018Sale;  Colin1-1400$190.49 
     10174SJ27/04/2019Sale;  Colin1-1400$55.00 
     10360SJ5/04/2020Sale;  Colin1-1400$55.00 
     CR001008CR6/08/2020Payment; , Colin1-1400 $44.99
     CR001008CR6/08/2020Payment; , Colin1-1400 $55.00
     CR001008CR6/08/2020Payment; , Colin2-1200 $10.00
     CR001008CR6/08/2020Payment; , Colin1-1400 $190.49
          $300.49$300.48

    but if you look at the screen grab of the Find Transaction screen it show a $10.01 difference

     

    now if I look for invoice 10027 in find transaction it shows 2 invoices as you can see from the screen grab inv 10071 - Colin H

     

    If I click on the lower 10027 it brings up a completely different account 

     

    I must admit I'm confused

    • Steven_M's avatar
      Steven_M
      Former Staff
      5 years ago

      Hi PRSquire 


      According to the Receivable Reconciliation [Detial] report that $10.00 amount is coming from Invoice # 10360. So we can investigate further getting the Find transactions/history for that transaction would be required. 

      • PRSquire's avatar
        PRSquire
        Experienced Cover User
        5 years ago

        Thanks Steven

        Find Transaction 10360.jpg shows inv 10360. It details a payment of CR001008

        Transaction details.jpg expands CR001008 

         

        There are 3 invoices 10071 $190.49 ; 10174 $55 ; 10360 $55; Total $300.49

        The customer paid $300.48

         

        It shows a $10 payment as both a credit and a debit. This seems to be where the issue lies. No other payment as been shown this way.

         

         

         

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.