Detailed P&L report

1

Hi all, I met with a bookkeeper last week who asked me for a detailed Profit & Loss report. She said that I should be able to create a report that lists every transaction that took place per account.

image
image240×817 14.9 KB

For example, my Meals and Entertainment account should display the expense category and then list every payment I’ve categorized under Meals. I’ve tried messing around in custom reports but that’s over my head at the moment. Is there another built-in report that would display this for me?

Thank you for any help you can share!

2

Hello @cohete,

That would be Reports > General Ledger Transactions

1 Like
3

Send them the general ledger it will detail everything they want to see, you dont need to add many things in your P&L

1 Like
4

You can use Copy to Clipboard and delete the rows from the first appearance of a Balance Sheet Account until the end of the report.

You can do this because the report is sorted to show Profit and Loss Statement Accounts first and Balance Sheet Accounts last.

Alternatively, you can create an Advanced Query on Summary > Transactions with the following filter:

Where:
    Profit and Loss Statement Account is not empty
1 Like
5

General Ledger Transaction will do it. Just fill in description and date range as required. If you want all transactions leave Account Field blank. Dump to pdf or “Copy to Clipboard” and paste into Excel Spreadsheet.