unpaid Bills / unpaid Invoice Report - Reporting error

Hi Doreen_P

I prefectly understood what you had replied.

But unfortunately in the MYOB Business Lite version, there is no date range to choose in the unpaid bills report but only a single date entry. Thus, my understanding is all bills entered which fall due outside the date of are due for payment after the date will display in that report. 

In the example I has forwarded, it show two balances on screen in the List of Bills screen window. Total Amount (The amount due as of 31/12/2023 $13,825.77) and Balance Due (Amount as of 15/03/2024 $7,067.14 the date you are viewing the report).

Now in the uppaid Bills report my chosen date is 31/12/2023, which should Brijlal balance due as at 15/03/2024 $7,067.14, whereas as the correct amount outstanding at 31/12/2023 is $13,825.77 not $7,067.14. 

Further when you compare this unpaid bills report to system Trial Balance report, it does not match. Example System TB report show Accounts Payable balance as $44,313.41, but the unpaid Bills report is showing outstanding as 31/12/2023 as $11,250.61. 

I did check for Bills entry Payment date for each supplier which is outstanding to the attached report. I lot of the suppliers are missing from the list. In the Create Bills report majority have been entered using the Terms as days due or specific dates. So if you compare the reports there is mismatch in information. I canot send my TB to my Accountant with non matching Supplier unpaid bill report.

I hope I had explained enough to show what is wrong in the report.

We do not use Purchase Order option since no inventory linked/active.

Regards

Minesh Bhagwan