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