GL transaction report doesn't match P&L on Cash Basis

Using 19.12.14

I have a set of books which includes Sales Invoices. I use cash basis. My year-end P&L doesn’t match my year-end GL transaction report because of the basis. Example: I create a sales invoice dated 31-Dec-2019 for which I will get paid in 2020. When I run a cash basis P&L, this invoice is not reflected (as it should not be). But when I run a GL transaction report (to provide transaction details to my accountant) it includes these transactions.

Is there another way I can produce a GL transaction report which only includes the transactions that were included on a cash basis P&L?

First of all @cfischer69 Please update to the new version.

Cash bases accounting will not report what you haven’t paid or received in cash.

The transaction above will never appear in a cash bases report. To capture all the unpaid invoices in a report, change the basis to accruals.

I understand. That’s precisely what I want. That is what the P&L report does now which is correct. The problem I am having is with a GL Transaction report. It does show transactions that should not be included when reporting on cash basis.

GL transactions report doesn’t give options to select bases does it?

Understand that cash basis in Manager means cash basis reporting. The underlying transactions were still entered, so they still show in the General Ledger Transactions report. That report is not intended to match the main financial statements, only list transactions.

@Tut got it. Can you think of any way to get a details report that does obey basis? My accountant doesn’t want to install Manager to look at my books which was my initial suggestion. I suppose I can take the GL transaction report,import to Excel and manipulate it there.

I can’t think of a way. The underlying issue is that differentiation between accrual and cash is programmed into the reports, not the database. Any sort of custom report won’t make the distinction.

Take a note of those “unpaid” transactions, delete them, create the GL Transactions report and then re-create the transactions. Hopefully there aren’t to many.

PS: you can always make a backup before re-entry so you have a permanent report match file.