Creating a Profit & Loss Report

Overview

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

  1. Open the Add-ons menu at the top of your Google Sheet.
  2. Choose Tiller Labs > Tools > Create a report > Profit & Loss
  3. Configure the report to meet your needs.
  4. 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.

It would be awesome if there was a total column on the right summing up all the monthly columns. Blake

I haven’t documented the local template functionality of the reports, @Blake, but you may be able to implement this on your own. When you first run a report, the scripts download a report “template” and hide it in your spreadsheet. (You can unhide it just like any other sheet.) There is a block where the data will populate (that you can’t modify), but you can add/modify the header, footer, and sides of the block. With a little creativity on placing the calculating cell and specifying range (and possibly dividing to account for sum rows) this could be a local mod to the report template that persists for future report executions.

Hope this all makes sense.
Randy