Learn about QuickBooks and Turbo Tax here
Optimize your QB data before importing to TT with these ten tips.
If you want to use QB and Turbo Tax, there are some important steps you need to do before filing the tax return. Take care of these steps to ensure that your tax returns are as accurate as possible.
1. Reconcile Accounts. All Balance Sheet accounts in the Chart of Accounts (COA) that can be reconciled should be. Here is a list of some of them:
In order to reconcile them, you will need all statements going back to the last time they were reconciled, or the inception of the account.
Here's help to reconcile statements in QuickBooks?
2. Examine Customer and Vendor Balances. Run aging reports for each of these and see if there are any unapplied credits or payments. Apply them if needed. Follow this path for customers:
Reports > Customers & Receivables > A/R Aging Detail
Reports > Vendors & Payables > A/P Aging Detail
3. Tax-Line Mapping. QuickBooks and Turbo Tax are a natural combination. This step is what enables you to use the two programs together. Here's how:
4. Suspense Account Clean Up. Before using QuickBooks and Turbo Tax, the Suspense account must have a zero balance.
Sometimes QB users use an account called, "Suspense." Using an account like this helps people keep their register balances accurate without needing to assign what the transaction was for. This is fine, as long as the transactions get assigned as some point. They need to be assigned before financial data can be imported to Turbo Tax.
This is because there is no corresponding tax line for "Suspense." If transactions remain in a Suspense account, they will get assigned to a tax line during the tax line mapping process. The transactions will be incorrectly reported if this happens. Make sure it doesn't and go through the Suspense account, assigning transactions correctly until it has a zero balance.
5. Create and Review Income Tax reports. These reports give you a good picture of your tax situation. Follow this path to run them:
Get help with QuickBooks here
Get it Now ~ Free Ebook
"7 Time Slashing Strategies for QuickBooks"
Available for immediate download
6. 1099 Preparation. This isn't a QuickBooks and Turbo Tax issue, but still applies since it's for a similiar time of year. Get it set up the right way:
Since most QuickBooks users will only use Box 7:Nonemployee Compensation, this is probably the only 1099 Category you need to make an entry for.
Run 1099 reports to make sure the data is correct:
Reports > Vendors > 1099 Summary
If you see a column called "Uncategorized," this means that the vendor was marked as a 1099 vendor in the vendor setup screen, but the account his payment posted to is not selected in the Preferences instructions above. Go to the vendor bill, determine which account his payment posted to, and go back to the 1099 preferences and add that account as shown above.
Print your 1099s and give them to your vendors by January 31. Print the 1096 and mail it by February 28.
7. Close the Books. If you don’t close the books on a regular basis, close them once the tax return has been prepared. You will need Admin access to do this. Here’s how:
8. Purchase a Turbo Tax desktop version. Be sure to purchase the right version of Turbo Tax.
9. Consider the potential disadvantages of doing your own taxes. It's true that many people can do their own taxes just fine. But many others cannot. Even though QuickBooks and Turbo Tax go together smoothly, I've seen too many incorrect returns in my practice to say, "Everybody can do it!" Be sure you are one of the ones who really can. An honest self-assessment is important!
10. Get another set of eyes. If you decide to prepare your own return, consider having a tax professional look it over before you file. The small fee may help you sleep better at night. Click here if you want me to review your income tax return before filing.
I hope you enjoyed this article about QuickBooks and Turbo Tax.
Get all 4 eBooks
for only $19.97!
These four eBooks cost almost $40 when you buy them separately.
Download all 4 now for
Click here to:
You're going to LOVE them, I promise!
... or you can learn more here: