cancel
Showing results for 
Search instead for 
Did you mean: 
Miiiki
Level 2

How to start/set up QBO for my existing business?

I started my business in July 2017 and have been using Excel for bookkeeping. I'd like to start using QBO from Jan 2021.  My question is how to set up QBO for my existing business. I file taxes on Schedule C every year.

 

[Bank feeds]
1. How far back transactions do I have to enter to QBO?
All the way back to July 2017 when I started or going back to the beginning of this year(Jan 2020)? Or fresh start in Jan 2021? I can download the transactions files from some banks up to 25 months and others up to 18 months.
*I filed taxes in 2017,2018 and 2019 by using information on my excel books.

 

2. How do I determine Opening balance amount?
If I go back to the beginning of this year, is Opening Balance the balance of the bank account on Dec 31 2019?

 

[Asset]
3. In 2018 I bought some equipment that I still use when I provide my service to my customers. They last more than 1 year but I deducted the costs as an expense on Schedule C in 2018 as they were less than $2500/invoice. How do I record this equipment to show in Balance Sheet if I started to record transactions from 2020?


[Company setting]
4. Categories- Track classes,Track locations(department), Multi-Currency
I provide 2 different types of services. Let's call them A and B. Majority income is from A which is a service in person and I receive payments in USD.  B is a service provided online and I receive payments in my foreign bank account in foreign currency. I started this online service in 2020 due to Covid and I am expecting the online service income will be growing next year.

Should I use class and locations(department) ?

Should I turn on multi currency ? - I saw a YouTube video that recommended not to turn it on and use class to track foreign transactions instead. 

 

Hope my questions make sense.  Thank you in advance!

 

2 Comments 2
JamesDuanT
Moderator

How to start/set up QBO for my existing business?

Every questions you have make sense and they are essentials when setting up your company. Let's address them one at a time, Miiiki.

 

Your business started last July 2017 and let's make sure you have an active QuickBooks Online subscription. This would allow us to address your concerns as we go through one of them.

 

When you connect your bank account, QuickBooks Online can only download 90-days worth of bank transactions. Some banks allow more than that. If you need more of these bank transactions to be downloaded, we can use a CSV file and import it to QuickBooks Online. You can use these links so you can successfully do the import process:

Once you have imported the bank transactions, you can categorize them. That includes the tax payments you've made on the previous years.

 

For your second question, you are correct. You can set the Opening Balance on December 31, 2019 if you want to start setting up the account within this year. Here are some links that you can use for reference:

In QuickBooks Online, we can set up the depreciation of an asset. Here's also a link that will serve as your guide: Depreciate assets in QuickBooks Online.

Though that is how we set up depreciation in QuickBooks Online, we'd still recommend consulting your accountant. They know what's best option based on your company setup.

 

Now, let's address how you can track your income. Based on the details you've provided, using the Class Tracking feature would your best option. You can either assign these classes per transaction or per line item. Here are link about it: 

Lastly, we only turn on the multicurrency if you want to track and receive transactions with foreign currencies. Wit this, you'll be able to track specific transactions with their respective currencies. To know about it, here's a general link about multicurrency: About Multicurrency.

This article has multiple articles relating to multicurrency and everything you want to know about the feature. Before you turn it on, you can also reach out to your accountant. They might be able to guide you whether this option is best for you or not.

 

As you go through everything that I've mentioned above, keep in mind that we're here always ready to help you more. Let us know how this goes so we know where we can start.

 

 

Miiiki
Level 2

How to start/set up QBO for my existing business?

Thank you so much for your quick response!! really appreciate it. 

For my question #1, as you mentioned I am aware that the bank feed feature can download only limited periods and also I can download csv/qbo files from my banks but this way also has limits. ( 18 months or 25 months back depending on the banks).  That was not my question.

 

My question was more like " How do I determine how far back I want to/should go to start QBO? " rather than how to use the bank feed feature. 

Is there any standards/guidelines to determine it in accounting world? What are the factors to decide how far back to go?   Or can I just pick whatever periods I like? 

 

For example:  Let's start from the beginning of 2020 because my taxes are already done in 2017, 2018 and 2019.   Is it a good reason to pick 2020?  

 

Or,  I should go back to 2017 because that's the year when I started my business ?

 

Please advise.  Thank you in advance!!

 


Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us