Forum Discussion

CMD's avatar
CMD
Contributing User
6 years ago

ACCOUNT RECEIVABLES RECONCILLIATION

How do i Ensure cash sale account is maintained at Zero balance
  • AliK607's avatar
    AliK607
    6 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)

AliK607's avatar
AliK607
MYOB Staff
6 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)

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.