Created a PL for 2024 and I see 2023 transactions in it. How can the 2023 transactions be eliminated for the 2024 report?
PL report set up
report result
Result detail when pressing circled item above and sorting by “transaction”
1 - View detail
1 - Edit detail
2 - view detail
2 - edit detail
Your profit & loss statement is on cash basis.
What is happening is that all your unpaid invoices from previous periods are added to the current period but since they haven’t been paid, they are again removed.
The figure is correct, just drilling-down on cash-basis is a bit confusing. You will notice that unpaid invoice doesn’t affect your rent total on cash-basis.
Thanks for the reply. Suggested ways to get a view with only filtered year transactions? Is it easy/is there risk in switching from Cash to Accrual while in this report?
Being able to see just the filtered year makes it easy to see missing invoices/months/payments.
There are more fundamental improvements I’m planning to do related to general ledger which will make drilling-down into cash-basis reports a lot more intuitive. For example, when drilling down into cash-basis reports, you will see Accrual-basis date and Cash basis date in separate columns which would make it more obvious why invoice from previous period shows up in another period etc.
is “Accrual-basis date and Cash basis date in separate columns” currently available or future?
The guide chat bot had this to say about accrual basis date column when I asked “add Accrual-basis date to profit and loss report”
“Bottom line: Manager doesn’t provide an “Accrual-basis date” column in the Profit and Loss report; you switch the entire report to Accrual basis and use invoice dates. For date-level detail, review invoices or build a custom report/export.”
This is the whole reply…
add Accrual-basis date to profit and loss report
Manager’s Profit and Loss report is driven by your chosen accounting basis:
Accrual basis: Income and expenses are recognized on invoice/bill dates (not payment dates).
Cash basis: Income and expenses are recognized on receipt/payment dates.
Because of this, there isn’t a separate “Accrual-basis date” column or filter you can add to the Profit and Loss report. The report itself switches between cash and accrual by how you run it.
How to get accrual-basis results:
Go to Reports > Profit and Loss.
Set Accounting method to Accrual basis.
Choose the date range and run the report.
If you need to see the underlying dates driving accruals, use supporting views:
Sales Invoices and Purchase Invoices tabs for invoice dates (recognition on accrual).
Cash transactions for cash basis reference.
Workarounds to analyze by dates:
Export relevant transactions (e.g., Sales Invoices list) and pivot in a spreadsheet by invoice date.
Use Custom Reports to list transactions with their dates from specific accounts (availability depends on your edition and permissions).
Bottom line: Manager doesn’t provide an “Accrual-basis date” column in the Profit and Loss report; you switch the entire report to Accrual basis and use invoice dates. For date-level detail, review invoices or build a custom report/export.
PS, cloned the PL report into accrual and it seems to provide the review info I need. Looking forward to the update so I can stay in cash. Thx for your help.
