Posting Expenses on basis of Accrual and Cash

Posting Expenses on basis of Accrual and Cash

Hi,
I trying to view P&L on the basis of Cash and Accrual, but unfortunately it does not show the desired result.

example
I have to pay $6000 in advance for Office rent of 6 months

I create bill for each month on different dates say 1 Jan,1 Feb and so on.
Make payment on 1 Jan for full $6000.

as per my assumption P&L on CASH basis should show expense of $6000 on 1 Jan (when cash was paid)
and on Accrual basis expense should be divided into 6month as per the bills. (expense realized when due).

but still on P&L it shows monthly on Accrual and Cash basis.
it shows different only if the payment is made at the end of period.

What i am looking for
- CASH BASIS REPORT: When advance is made for expense it should be shown in P&L on the date of payment(whole amount)
- ACCRUAL BASIS REPORT: Expense should be reported to P&L on the basis of date on Bill or Due date of Bill/Bills

Appreciate a prompt response.