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 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.

  • 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.

  • 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

      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

        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.