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.

PRSquire's avatar
PRSquire
Experienced Cover User

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.

     

     

     

    • Steven_M's avatar
      Steven_M
      Former Staff
      5 years ago

      Hi PRSquire 

       

      Have you tried taking a backup of the company file and deleting the payment before re-entering it? Does that impact the situation with that customer's balance?

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

        Thats that seem to do the trick. One question though. When I went to re-enter the payment I noticed that invoice 10071 had a status of order for $10 but if I clicked on this to view it there was nothing there.

        Could this have been the issue ?

        and why would it appear ?

         

        regards

         

        Phil

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.