Tiller Labs Simple Business Comprehensive Guide

Quick Start Guide

The Tiller Simple Business spreadsheet immediately provides insights on your business inflows and outflows as well as the current balances for all accounts linked to the spreadsheet. Gain even more clarity around your business finances by following these recommended steps.

1. Install the Business tools

With the Tiller add-on you can install the Tiller Simple Business Spreadsheet’s features in an existing Tiller spreadsheet.

  1. Install the Tiller add-on and give it permission to run using the Google Account you use with Tiller.
  2. Open the Tiller spreadsheet where you want to install and use the business features.
  3. Open the add-ons menu at the top of the Google Sheet.
  4. Choose Tiller > Business > Start
  5. The add-on will install the Dashboard, Statements, and Setup sheets as well as add some columns to the Transactions sheet.
  6. You can now access the Add Transaction and Reconcile features from the add-ons menu under Tiller > Business.

Note : to install the Tiller add-on click on “Free” in the upper right of the Add-on store listing via the link above. A blank Google Sheet will open and you’ll be prompted to authorize the Tiller add-on.

2. Refine your categories

The Tiller Simple Business Spreadsheet comes loaded with vetted business categories, but you can refine these to meet your unique business workflows. How does your business spend and earn money each month?

Overwrite or delete any example groups and categories you don’t need. Start by filling in the Group, Category, and Type. Categories must be unique and all categories must have a group and type assigned.

Start out by reviewing your Transactions sheet to help you refine your Categories list. A useful way to quickly see your most common merchants and transactions is to sortby the Description column.

3. Check in on your automated transactions

Tiller automatically adds transactions from linked financial accounts to your Transactions sheet each day. Tiller can pull up to 90 days worth of data for most institutions.

Use these tips if you need to add more historical data.

Categorizing your transaction data brings the Dashboard to life and fuels the data for your business reporting such as a profit and loss statement.

Automate your category workflows with AutoCat

Set up AutoCat to help you save time categorizing your transactions.

This is a great way to quickly categorize historical data when you’re first starting out with your Tiller Simple Business Spreadsheet, but it’s completely optional.

If you’d rather categorize each transaction one by one, you can do that, and it’s pretty quick and easy too.

How to Install AutoCat in your Simple Business Spreadsheet:

  1. Open your Tiller-powered Google Sheet
  2. Open the add-ons menu at the top of the Google Sheet
  3. Choose Tiller > Tiller Tools > AutoCat > Start
  4. Click “Create” in the sidebar that appears
  5. Start building your ruleset

Build a ruleset for your most common merchants and recurring transactions. Then turn on the Auto Run feature and AutoCat will automatically categorize those transactions for you as they come into your Transactions sheet.

To turn on the Automatic Run feature:

  1. Install AutoCat
  2. Open the add-ons menu at the top of the Google Sheet
  3. Choose Tiller > Tiller Tools > AutoCat > Run Automatically

4. Quickly gain insights

Once you’ve categorized your transaction data your insights are ready. Check in on your dashboard to quickly see a breakdown of your income vs expense for a selected time period, zero in on spending or earning for a specific category, pinpoint your cash flow, and understand spending and income breakdown by group.

Learn more about insights on the Tiller Simple Business Dashboard.

Understanding the Simple Business Dashboard

The Tiller Simple Business dashboard allows you to quickly gain insights on how your business is performing. Understand your cash flow, income vs expense, income by category group, and expenses by category group all based on a customizable time ranges with readily-available presets.

The dashboard also gives you an at a glance account balance information as well as income vs expense reporting.

Insights in the Dashboard Sidebar

Uncategorized Transactions Alert

The left sidebar of the dashboard gives a few indicators and helpful information. If you have uncategorized transactions for the period selected below cash flow calculation you’ll see a red bar indicating how many transactions, and their amount sum, are waiting to be categorized. Categorizing transactions is key to an accurate financial picture.

Income and Expense

The income and expense chart shows you your income vs expense totals over the selected time period.

Configure the time period below the cash flow calculation. You won’t see any data here until you categorize transactions that occurred during the selected time period.

Cash Flow

The cash flow calculation is your income minus your expenses based on the time range selected below the cash flow amount. It’s the numeric difference between the two graphed income and expense values above it.

Current Balances List

The Current Balance list in the sidebar shows you the current balance for accounts you’re tracking in the Accounts Sheet. It is pulling data from the Accounts sheet and the Transactions sheet.

There are two balances shown: Tiller and Bank. The Tiller balance is calculated based on the latest balance history entry for the account and any uncleared transactions you may have manually entered that are waiting to be reconciled. The Bank balance is the last available balance for the account from the Accounts sheet.

Read more about manually entering and reconciling transactions to better visualize cash flow.

Dashboard Charts and Reports

The main area of the Dashboard includes several easy to use and customizable reporting charts.

Inflows vs. Outflows (top left)

Upon immediately opening the Tiller Simple Business Spreadsheet, this chart compares inflows vs. outflows on a month-by-month basis for All Transactions over your selected time range.

This is the default filter setting that is only looking at the sign of the transaction amount. If you switch the filter setting to “Categorized Income & Expenses” you will only see data once you have categorized some transactions that occurred during the selected time range.

How to use it:

  1. Configure the time range using the dropdown option below the chart to change the data set that’s graphed in the chart. If you choose “custom”, editable start and end date options will appear.
  2. Configure the filter by choosing All Transactions, which only looks at the amount data, or Categorized Income & Expenses, which charts the data based on how you’ve categorized it (income and expense only) on the Transactions sheet.

Category Focus (top right)

The Category Focus chart is a powerful tool for zooming in on certain financial aspects of your business. As with the Income vs. Expense chart, you can choose either a time range preset or specify a “Custom” time range. Category Focus includes a powerful filtering capability to show month by month transactions filtered by:

  • By “All”, “All Categorized” or “All Uncategorized”: these options are useful for cashflow analysis and also to see how many transactions have not yet been categorized.
  • By Income: show any single income category.
  • By Expense: show any single expense category.

Income By Category Group (bottom left)

The Income By Category Group pie chart shows you where your income is coming from within the selected time range. This chart really comes alive if you have income from multiple sources (clients, stores, etc) and you leverage category groups to organize key income categories.

How to use it:

  1. Refine the income categories for your business on the Categories sheet.
  2. Organize income categories into groups like “Investments”, “Revenue”, “Acquisition” on the Categories sheet.
  3. Categorize income transactions.
  4. Configure the time range using the dropdown option below the chart on the Dashboard to update the data that’s included in the chart.
  5. The Total $ field in the upper right shows the total value of the income pie within the selected time range.

Expense By Category Group (bottom right)

The Expense by Category Group chart is useful understanding your relative spend across key expense category groups for the selected time range.

How to use it:

  1. Refine the expense categories for your business on the Categories sheet.
  2. Organize expense categories into groups like “Overhead”, “Payroll”, “Professional Services”, “Travel” on the Categories sheet.
  3. Categorize expense transactions.
  4. Configure the time range using the dropdown option below the chart on the Dashboard to update the data that’s included in the chart.
  5. The Total $ field in the upper right shows the total value of the expense pie within the selected time range.

Generating Reports

The Tiller Simple Business template offers two key financial reports: a Profit and Loss Statement (P&L) and a Category Report. These can be generated from the Business menu under Generate Reports in the Tiller add-on for Google Sheets.

Add-ons > Tiller > Business > Generate Reports

About the Reports

These reports are static reports that create a new tab each time they are generated. They’re easily exported to a PDF or printed as a hard copy. You can delete the tab for the report once you’ve printed or saved it to another location.

Note : If you change the data that’s feeding the report, such as re-categorizing transactions, you’ll need to generate a new version of the report.

If there are other reports you’d like to see possible with these features email support@tillerhq.com and let us know.

Generating a P&L report

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.

  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.

Generating a Category report

A category report is great if you need to see a breakdown of business expenses for a specific category. The Category Report details line item transactions across the selected period grouped by the transaction description.

  1. Make sure you have categorized transactions within the desired reporting period.
  2. Open the Add-ons menu at the top of your Tiller spreadsheet.
  3. Choose Tiller > Business > Generate Report.
  4. Choose the Category Report radio option in the sidebar that appears.
  5. Choose Select Report.
  6. Select a category to report on.
  7. Choose the desired time range settings for the report.
  8. Optionally, enter any range filters for the amount field.
  9. Click Create Report.

A new, readily-printable tab will appear along the bottom of your Google Sheet with the sheet name “Cat Report” containing a report per your configuration settings.

Printing or Saving the Category Report

Each time you generate a Category 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 from your Tiller spreadsheet if you no longer need it after the original report generation.

Reconcile manual scheduled transactions

Tiller keeps all your business financial data in one place for you by automatically pulling in transactions and balances into your Google Sheet. The Tiller Simple Business Spreadsheet goes a step further by allowing you to manually add transactions through our add-on, flag them for reconciliation, and then later reconcile and merge them when Tiller brings in the match. It also offers workflows for balancing your bank statement to your transactions list.

These are optional steps that you may or may not need or use depending on your business’ workflows and reporting needs.

Manually adding scheduled transactions

As part of effectively managing your business finances you may need to add a transaction before it has posted at your bank. For example, you might want to capture a check paid to a vendor, an invoice submitted to a client, or a bill that you paid electronically. Logging a transaction when you make it, rather than waiting for it to post at the bank, captures future liabilities and helps manage cash flow.

You may also need to manually add transactions for accounts that aren’t automated by Tiller.

Watch this how to video or read on below:

How to do it:

  1. Open the Add-ons menu at the top of your Google Sheet.
  2. Choose Tiller > Business > Add Transaction.
  3. Fill in the Add a Transaction screen with relevant data including the transaction date, description, amount, and category.
  4. Enter the amount as an absolute value (no + or -).
  5. Leave the check box next to “flag for reconciliation” checked if you need to reconcile the match when Tiller brings it in automatically. Uncheck this box if you’re adding a transaction manually for an unlinked account.
  6. If you are finished adding transactions, click the Add button. If you would like to add more transactions, click the Add + 1 button to continue adding manual transactions.

Manually added transactions that are flagged for reconciliation will be highlighted in yellow on your Transactions sheet until they are matched to a transaction from your bank feed.

Note : manually added transactions for unlinked/non-automated accounts do not update the manually tracked account’s balance on the Accounts/Balance History sheets. You must also manually update and save the account balance on the Account sheet for unlinked/non-automated accounts.

How to reconcile manually added transactions

If you’ve manually added an uncleared transaction flagged for reconciliation, like a check you wrote to pay a vendor, when Tiller brings that transaction in automatically, you’ll want to reconcile it with the match. The manually added transaction will remain yellow on your Transactions sheet until you reconcile it.

Watch this how to video or read on below:

How to do it:

  1. Open the Add-ons menu at the top of your Google Sheet.
  2. Choose Tiller > Business > Reconcile Transactions.
  3. The Reconcile Transaction(s) dialog window will appear.
  4. At the top of the window, you will see the manually added transaction that has a match.
  5. Lower in the window, you will see a list of potential matches, the ones Tiller automatically brought in, (based on exact amount and account).
  6. If you see the match in the lower table, click on it and click the Match button. The Tiller add-on will then merge the two records. If you don’t see the match in the lower table you can skip the transaction to move to the next one that has a match in the list.
  7. Once you have matched all the manual transactions to their automatic counterparts the dialog will disappear.

How to turn on the reconcile auto trigger

The Tiller add-on can alert you when a potential match for a manually added transaction flagged for reconciliation is added to your sheet when you turn on the Auto Reconcile trigger.

The trigger will present a dialog when you open your Tiller spreadsheet if there are new transactions that match transactions waiting to be reconciled, and ask you if you want to reconcile them.

How to do it:

  1. Open the Add-ons menu at the top of your Google Sheet.
  2. Choose Tiller > Business > Reconcile Auto Trigger

Reconcile bank statements

Another key to keeping your business finances in sync is verifying that all the transactions that appear on your bank statement are also available in your Tiller transactions sheet. Statements reconciling helps flag checks that haven’t been cashed yet, unexpected charges, and human & machine errors and is a common business financial workflow.

  1. Open the Statements sheet in your Tiller Simple Business spreadsheet.
  2. Enter the statement end date into column D. You can find this on your actual bank statement.
  3. Choose the account to which the statement corresponds from the dropdown in Column E.
  4. The Statements sheet will automatically generate a statement name (Column C) that consists of the statement end date plus the last four digits of the account that corresponds to the statement. If you’d like to use a different statement name feel free to clear the statement name data and enter your own name. (Don’t be afraid to clear out the formula!)
  5. Enter the Starting balance. This should also be available on your actual statement.
  6. Enter the amount of deposits from your bank statement.
  7. Enter the amount of withdrawals from your bank statement without the - sign.
  8. The ending balance will be calculated for you.
  9. Open your Transactions sheet and apply the statement name to all transactions for that account that occurred during the statement period in the Statement column. Keep in mind that Tiller may bring in transactions that will be dated outside the statement start or end date that should be included in the statement. Review your statement against the transaction description and amounts.
  10. Check the Statements sheet to verify that the Deposits and Withdrawals under Tiller Transactions show a green “matched” status. If they don’t you know there is an error somewhere or a transaction for the statement hasn’t been pulled into Tiller yet.

Add custom branding

Use the setup sheet to swap out the logo, address, and business name to customize your sheet.

  1. Unhide a hidden sheet called “Setup” by clicking the four horizontal lines next to the plus sign in the lower left of the sheet
  2. Overwrite the example business details about your business into the fields such as name and address. (Hint: press the option/alt key + enter to move to the second line in the address cell).
  3. Add the direct URL of your logos per the descriptions in cells D9 through D12 using =image("") with your direct URL in between the quotation marks. (e.g. =image(“https://storage.googleapis.com/assets.templates.tillermoney.com/tiller-template-nacho.jpg”)

Note: If no logo URLs are added, Tiller’s logo will be used throughout the template.

Generating a Direct URL for your Logo

The Tiller Simple Business sheet uses the Google sheets built in formula “=image()” to display your logo in the spreadsheet. This function requires a direct link to an image file for it to work properly.

To get a direct URL to your image you can upload your image to a free service such as Photobucket or get the URL from your website where the logo might already be stored.

The url must end in a valid photo file format such at .png, .jpg. or .gif.

When using Photobucket, you can create a new free account, drag and drop your logo image into Photobucket, then click on the image. You will get a screen that looks similar to this:

Double click on the “Direct” URL and copy the link, this will give you a direct URL to the .png or .jpg file.

Insert this link into the Setup sheet in either Cell D9, D10, D11, D12 depending of the type of logo (Wide or Square, on dark background or on light background) and your logo will then display on the other sheets in the template.

Track business receipts

The Transactions sheet contains a column called “Receipt”. Use this column to pair transaction line items with attachments stored in the could. When URLs are placed inside Sheets cells, they can be clicked for instant access to cloud content— like a detailed record of a purchase.

  1. Create a folder on your Google Drive for “Receipts”. Each time you make a purchase take a picture of the receipt, or save it to PDF, and then save it to this folder on your Google Drive.
  2. Paste the URL of the receipt image in your “Receipts” folder into the Receipts column on the Transactions sheet.