Job Profit & Loss - Cash Basis

[Flinders]

I am running a Job Profit & Loss reports - this is obviosuly on an accrual basis.

Is there a way this can be run on a cash basis like a normal P&L? 

Further to this after speaking to MYOB there isnt a CASH job report.

Can I do a custom payables reports showing paid date and job number? I am trying to show what supplier invoices were paid in a certain month for a certain job and compare this to the job income..  I have checked and am unable to find this. thank you 

[Komal_S]

Hi @Flinders 

There is no direct report in the software that would return these results. An alternative would be producing two reports and sending them to Excel, to combine the results, the first being the Purchases [Supplier Detail] report (Reports>>Purchases>>Supplier). You will need to add in the Job no and due date fields to that report.

For the Paid date, you would be looking into the Supplier Payments History report (Reports >>Purchases >>Supplier payments). You would need to cross-reference the PO NO. on that report with that of the  Purchases [Supplier Detail] report to get the payment date. 

Please feel free to post should you have further queries.