Report for when invoice are due

[Mckinlay]

Hello, 

I am wanting a report that shows what invoices are due by or on a certain date. The unpaid bills feature doesn't appear to be able to exclude what is not yet due. Eg. If I have bills due before the end of the month I want to be able to print a report that shows what is due each week. Unpaid bills shows everything that is yet ot be paid...

thanks, 

[Melisa_D]

Hi @Mckinlay, 

Thanks for your post. Unfortunately the unpaid bills report doesn't have that option, however you could try running the Supplier purchases report which allows you to select a date range and filter by open bills, this will give you a list of the open bills along with the due date. More information on the type of purchase reports we have available currently in MYOB Business is available on this help article Purchases reports. 

Do let me know if you have any further questions. 

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

[Mckinlay]

Thanks Melisssa. 

You mentioned this will give me a list of the open bills along with the due date. But I do not appear to have the due date in my report? Can you assit in more detail please? 

many thanks. 

[Melisa_D]

Hi @Mckinlay, 

Sorry for the delay in my response. When you've opened the report please select the customise button, this will give you a drop down list (select columns to display) of columns that can be be added to the report. Once selected please click apply and refresh the report. 

[Mckinlay]

I just dont know what I am doing wrong!! Please see the attached screen shot where is says that the due date is part of the report but if i for example selected report date from 1/5/22 to 9/5/22 it stil shows invoices that are not due until the 30/5/22.

it's driving me mad!

Thanks Melisa. 

[Melisa_D]

Hi @Mckinlay, 

The report will show all bills between that date range, the due dates can still fall out of that date range. The date range entered only reflects on showing the bills in that period.