So here i am - I have 9 customers on Live accounts - Yes i know, not many. Two of them have now asked me to change from MYOB live accounts to another online cloud based software that will give corre...
Hi,
I'm having a similar problem with our accruals basis clients. The problem is that if any of the accruals basis clients received partial payments on their invoices, the amount is allocated to that account, but the invoice itself is not moved from accounts receivable to the sales balance until the full payment has been made. This caused problems as some of our clients have hundreds of invoices and having to go through every single one to find out when they were allocated across, those which were still considered 'outstanding' and those which were actually outstanding was painful and time consuming (especially when you have a bank deadline to meet in one case.)
Eg. A customer made a purchase for $1000. They paid $200 in the first month, $500 in the second month and the final $300 in the third month. The $1000 in accounts receivable was not transferred across to sales until the third month.
On a cash basis the accounts receivable should have been reduced by each payment made. Accruals basis the lot should have been transferred to sales either when the invoice was made, or when the first payment made.
Regards,
Sasha