Forum Discussion

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

accrual v transaction

On a receivables reconciliation [Summary] I have a member who according to MYOB owes $10.01

Total Due0 - 3031 - 6061 - 9090+
$10.01$0.00$0.00$0.00$10.01

 

On the corresponding Card Transactions [Accrual]  report he owes 1 cent

ID No.SrcDateAccountDebitCredit
10071SJ10/09/20181-1400$190.49 
10174SJ27/04/20191-1400$55.00 
10360SJ5/04/20201-1400$55.00 
CR001008CR6/08/20201-1400 $44.99
CR001008CR6/08/20201-1400 $55.00
CR001008CR6/08/20202-1200 $10.00
CR001008CR6/08/20201-1400 $190.49
    $300.49$300.48

 

but when I do a find transaction report it shows a $10 CR listing as a credit and debit. showing the $10.01 

 

Find Transactions (Listing)  1/04/2018 - 16/08/2020
      
ID No.SrcDateAccountDebitCredit
10071SJ10/09/20181-1400$190.49 
10174SJ27/04/20191-1400$55.00 
10360SJ5/04/20201-1400$55.00 
CR001008CR6/08/20201-1400 $44.99
CR001008CR6/08/20201-1400 $55.00
CR001008CR6/08/20202-1200 $10.00
CR001008CR6/08/20201-1400 $190.49
CR001008CR6/08/20202-1200$10.00 
    $310.49$300.48

 

I know the member owes 1 cent but why is there a difference in MYOB.  As far as I know I havent recorded anything any differently.

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.

7 Replies

Replies have been turned off for this discussion
  • 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.

     

     

     

  • 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

  • Steven_M's avatar
    Steven_M
    Former Staff
    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.

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.