unpaid Bills / unpaid Invoice Report - Reporting error

Bula

Is there a report that shows invoices outstanding as at a particular date yet not overdue for payment. Like a Age Summary / Detail report.

Hi, Minesh

Thanks for your post.

It seems there might be confusion regarding the values displayed in the list of bills window and the unpaid bills report, particularly when comparing them with different date ranges. To clarify:

• List of Bills Window: This window typically displays a list of all bills within a specified date range, regardless of whether they have been paid or remain unpaid. It provides a comprehensive overview of all bills entered into the system within the selected timeframe.
• Unpaid Bills Report: On the other hand, the unpaid bills report specifically focuses on bills that have not been paid within the specified date range. It filters out bills that have been paid during this period and presents only those that are outstanding.

Regarding your other concern about Age Summary report, you may check the Receivables report.

If this does not answer the question, feel free to add more details to your query.

Best regards,

Doreen

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

Hi Minesh,

Please confirm which report has the correct figures. In addition to that, The Unpaid Bills report will show invoices that have been created and gone to a Supplier Card. It will also display bills up to the selected date and should agree with the Accounts Payable account on the Balance Sheet. If your reports are different, we'd recommend going to Reporting > Exceptions dashboard and running the Payables reconciliation exceptions report to check for any exceptions. The Help Article, Checking your records, has detailed information on what can cause the payables to be out of balance.

Feel free to post again anytime if you require further assistance. 
 
If my response has answered your inquiry, please click "Accept as Solution" to assist other users in finding this information.

Best regards,

Doreen

Hi Doreen_P

Thank you for your response.

After reviewing your recommedation below, I did try that report, but the problem is I am not still able to find List of Suppliers / Customers outstanding at that particular date is not available in the report, except a total variance amount (if Any). 

Than upon find this variance then how can be correct? Which customer/supplier to correct.