Setting up businesses in Tiller

Hello - I have 2 businesses. I just painstakingly reconciled 2020 in my quickbooks accounts for both.

I would like to close out both quickbooks accounts and move both my businesses to Tiller. I found 2 articles - SB Comprehensive Guide and Business dashboard

I currently have all of my personal accounts in 1 google sheet. While my business accounts are with the same bank as my personal, I am not pulling the business data into my personal sheet.

I could not determine from either article if its best for me to add the dashboard and business accounts to the existing sheet or create a new sheet? Should each business have its own sheet?

I also do not see from the articles listed how I might be able to have business and personal mixed into 1 sheet.

The businesses have different categories from each other and also have different categories from my personal file.

Would love some guidance here. I am sure there is probably an “it depends” to this question.

What I will say is that Tiller has relieved an immense amount of time and stress by having all of my personal accounts in 1 place. I used quicken for years, but I could never get my retirement accounts from 2 of the 4 places into them. Now I have everything in tiller. WOW!

I would have no issue with 3 sheets 1) Personal 2) Bus 1 3) Bus 2

It would be an improvement.

Thanks for the help.

1 Like

Great questions, @abilityto.

Personally, I would (and do) have separate sheets for business and personal accounts. You can unify your feeds under a single Tiller Money subscription, but I’d recommend creating discrete spreadsheets and only linking the accounts that are relevant into each one.

Regarding your TWO businesses, unless there are overlaps (e.g. credit card payments) or efficiencies in putting them together, I’d recommend creating a discrete spreadsheet for each— especially if the Categories are different. The Business Dashboard, for example, will only work well with a single instance installed in the spreadsheet (making it difficult to manage two businesses.

Hope this helps.
Randy

1 Like

@abilityto

Funny you ask. I spent the last month or so doing this very thing. I have them all in one sheet, as I only had one sheet available.

I have personal, Schedule C, Schedule E#1, and Schedule E#2. I got historical data from many many sources so I have complete data for at least all of 2019 and 2020. You will not be able to use the Business Dashboard if you go this route but in no way was this a deal breaker.

Each Schedule E has, lets say, 10 units. I am tracking everything by unit. You will need some pivot tables and sheet manipulation to organize and combine things together in a meaningful way.

So, it can be done, but would require an experienced user.

Thanks,

Blake