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. 

The Tiller add-on for Google Sheets is pre-installed in the Tiller Simple Business Spreadsheet template.

Generating a P&L report 

  1. Open the Add-ons menu at the top of your Google Sheet.
  2. Choose Tiller > Business > Generate Reports.
  3. Choose the P&L Report radio option in the sidebar that appears.
  4. Choose Select Report.
  5. Configure the desired account(s) and time range settings for the report.
  6. 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.

Did this answer your question?