ACCOUNT RECEIVABLES RECONCILLIATION
How do i Ensure cash sale account is maintained at Zero balance
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)