Simple Business Help Docs
4 weeks ago

Simple Business Help Docs

Simple Business Google Spreadsheet

Getting Started With The Tiller Simple Business Spreadsheet

Learn how to get easy, clear, and organized business finances with Tiller.

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.

Watch the getting started video or review the written steps below. 

1. 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. 

Read more about easy categories for business. 

2. 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.

For quick and automated categorizing

Set up AutoCat, our category automation tool or quickly categorize by hand in the Transactions sheet. 

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

Learn more about setting up AutoCat for automating your business category workflows. 

3. 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.

Optional Steps

The below steps are optional depending on whether or not you need to reconcile transactions and statements and generate the specific reports that are available in the Tiller add-on business tools. 

4. Stay organized with everything in one place

Seamlessly keep your business finances organized and current by using the transaction and statement reconcile features. 

  • With transaction reconciliation you can see projected cash flow by adding in checks and payments before they’ve cleared. 
  • Your data stays organized when you use the Statements sheet to track your transactions against your account statements. 

Learn more about the Tiller Simple Business reconcile features.

5. Easily generate business critical reports

Reporting is key for your business finances. With the Tiller add-on business features you can quickly generate a profit and loss statement as well as line item detail category reports. These reports make understanding your business financials and sharing key information with your accountant a breeze.

Easy Categories for Business Finances

Learn how to easily get started with Categories in the Tiller Simple Business Spreadsheet

The Categories sheet in the Tiller Simple Business template comes preloaded with common business categories and groups. These are meant to inspire and get you started. 

You can completely wipe this sheet and start over, overwrite some you don’t need, or add more to the bottom of the list. All categories need 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 sort by the Description column. 

Automate Your Business Category Workflow with AutoCat

Learn how to increase your business expense tracking productivity with AutoCat.

Once you’ve refined your Categories sheet to meet your business’ unique financial situation, you can 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 Simple Business Spreadsheet
  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

Learn more about AutoCat and how to build a ruleset.