One of the most fundamental business reports for bookkeeping and accounting is a profit and loss statement (P&L Report). You can easily generate one with the Business features in the Tiller Labs add-on for Google Sheets.
You’ll need the Tiller Labs add-on for Google Sheets to generate a P&L report
- Open the Add-ons menu at the top of your Google Sheet.
- Choose Tiller Labs > Tools > Create a report > Profit & Loss
- Configure the report to meet your needs.
- Click Create Report.
A new, readily-printable tab will appear along the bottom of your Google Sheet with the sheet name “P&L Report” containing a report per your configuration settings.
Each time you generate a P&L Report, a new tab will appear along the bottom. Feel free to print the report, either a physical copy or to a PDF, and then delete the report tab (by right clicking the tab) from your Tiller spreadsheet if you no longer need it after the original report generation.
If you have a question or need help first search the community to see if someone has already asked and if not click here to quickly post a question about this report in the Google Sheets category.
Be sure to customize the title of your post with keywords about the issue or question so others can easily find the Q&A in search.