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 add-on for Google Sheets.
How to create a P&L report
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.
Printing or Saving the Report
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.