Forum Discussion

CMD's avatar
CMD
Contributing User
5 years ago
Solved

ACCOUNT RECEIVABLES RECONCILLIATION

How do i Ensure cash sale account is maintained at Zero balance


  • AliK607's avatar
    AliK607
    5 years ago

    Hello CMD ,

    Correct me if I'm wrong, but if 'Cash Sale' is a customer card set up within the MYOB system, You will need to make sure there are no open (/outstanding) invoices showing for that customer. Any outstanding invoices result in a positive balance for your accounts recievables.

    If you go into Sales > Sales register, you can filter by 'Cash sales' as your customer, then if you move the dates to the start of your company file to now, you should be able to see any open sales for this customer.

     

    Alternatively, you can run a (Reports > Sales > Customer >) 'Sales Customer Detail' report and filter it by open invoices for that customer. You will be able to run this report for multiple years at a time.


    (also make sure there is no unprocessed credit sitting in the credits/returns tab for this customer as this may result in a negative accounts recievable balance for this customer)

1 Reply

Sort By
Replies have been turned off for this discussion
  • AliK607's avatar
    AliK607
    MYOB Staff
    5 years ago

    Hello CMD ,

    Correct me if I'm wrong, but if 'Cash Sale' is a customer card set up within the MYOB system, You will need to make sure there are no open (/outstanding) invoices showing for that customer. Any outstanding invoices result in a positive balance for your accounts recievables.

    If you go into Sales > Sales register, you can filter by 'Cash sales' as your customer, then if you move the dates to the start of your company file to now, you should be able to see any open sales for this customer.

     

    Alternatively, you can run a (Reports > Sales > Customer >) 'Sales Customer Detail' report and filter it by open invoices for that customer. You will be able to run this report for multiple years at a time.


    (also make sure there is no unprocessed credit sitting in the credits/returns tab for this customer as this may result in a negative accounts recievable balance for this customer)