Google Sheets

Profit and Loss Report for Google Sheets

Easily generate a profit and loss report in your Tiller-powered Google spreadsheets.

About the Profit and Loss Report for Google Sheets

One of the most fundamental business reports for bookkeeping and accounting is a profit and loss statement (P&L Report).

How the Profit and Loss Report Works

  • Open the Extensions menu at the top of your Google Sheet.
  • Choose Tiller Community Solutions > Reports > 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  Your P&L Report

Each time you generate a P&L Report, a new tab will appear at the bottom. Feel free to print the report, )either a physical copy or to a PDF). Delete the report tab (by right-clicking the tab) from your Tiller spreadsheet if you no longer need it after the original report generation.

Support & Documentation

Tiller Community Solutions FAQ

Is this template free?

This is a free template built by a member of the Tiller Community. While it’s free for anyone to use, it’s designed for Google Sheets automated by Tiller. Additionally, it’s recommended for use within the Foundation Template.

What is Tiller?

Tiller is the only automated personal finance service for Google Sheets and Excel. Tiller automatically tracks your daily spending, income, and balances in your spreadsheets, so you can see all your finances in one place with full control of how you manage your money. Learn more →

What is the Tiller Community Solutions Add-on?

The Tiller Community Solutions add-on is an easy way to install dozens of free, prebuilt sheets for tracking your budgets, debt payoff goals, net worth, savings, and more. It also includes several helpful spreadsheet utilities and CSV importers.

Does this template have any dependencies or special requirements?

This template for Google Sheets works best when installed in Tiller’s Foundation Template.

Have questions about this template?

Visit the Tiller Community with any questions about this template.

Tiller Community Solutions

Browse free budgeting and personal finance templates made by the Tiller Community for spreadsheets powered by Tiller Money Feeds