QuickBooks - Why Export Reports into Excel?

December 30th, 2007 darlees Posted in Quickbooks No Comments »

Sometimes people want to export QuickBooks reports into Excel. There’re at least four reasons for this:

1. Consolidation Reporting. By example, there may be a parent entity that owns sub entities. There is more. The parent entity may want to see a single financial statement for itself along with all it is entities. Exporting into Excel makes this much easier than doing it manually.

2. Creating Graphs & Charts in Excel. Some times a visual presentation of numbers is easier to understand. Exporting QuickBooks reports into Excel makes it a breeze to create colorful charts & graphs.

3. Computing Totals on a QuickReport. While in the Chart of Accounts, or any of the lists, we can easily run a QuickReport. Just select the appropriate name (Auto Expenses, for example), right click, & select QuickReport. Adjust the date range, as needed. QB shows all entries for this name, both the debit entries & the credit entries.

However, QB doesn’t give a total for the entries, & sometimes it is useful to know the total. You may need to modify the report to show only the entries you want (click the Modify Report button to do this). Then, once it contains the information you need, export the report to Excel, & use the =sum feature to add the column.

4. Improving the Reports’ Appearance. There’re probably many reasons for this. Here are two:

a. The QB reports may need some cosmetic improvements in order to show them to people who have some financial power - if you’re approaching a bank for a loan, for example, you may want the balance sheet & P&L to look different. (Not the numbers, of course! Just the layout & appearance.)

b. Some times accountants, bookkeepers, managers, or CPAs do not like the appearance of the QB reports, & they export the reports into Excel to improve their look.

Final Thoughts

I see a trend here:

  • Exporting because it is useful for financial or other business reasons, vs
  • Exporting for strictly cosmetic reasons

My suggestion is this: If the time spent modifying reports in Excel is a good use of company resources, then do it… If it is only cosmetic, then don’t. All companies have limited resources, & these must be used wisely.

About the Author: Jennifer A. Thieme is a Certified QuickBooks ProAdvisor who loves to help people with QuickBooks. So… She brings completely unique insight, clear instructions, & over ten years of experience to all of her QuickBooks articles. Owner of Solid Rock Accounting Services, Jennifer’s clients enjoy these same benefits on a personal & regular basis. You can too - visit http://www.jenniferthieme.com & contact Jennifer today.

AddThis Social Bookmark Button

Credit Card Q&A In QuickBooks

December 16th, 2007 darlees Posted in Quickbooks No Comments »

Sometimes new users of QuickBooks have questions about how credit card work in the software. Here are some help-ful bites of information about this subject.

Aren’t Credit Cards Expense Accounts?

No. In the Chart of Accounts, liability accounts represent amounts of money owed to others. Credit cards are liability accounts, because every time we use our credit cards, we owe money to the credit card company. One nice feature of QuickBooks is that it allows us to set up a special type of account for credit cards, called, not surprisingly, “Credit Card.”

But make no mistake: this type of account is a liability, & not an expense. And so… So far so good. When you buy something with a credit card, you’re paying for it with borrowed money, & the money is borrowed from the credit card company. This is why credit cards are considered liability accounts.

So When Are Expenses Recorded?

When using the credit card, the expense is recorded in the Record Credit Card Charges screen, in the lower ½ of the screen, in the Expenses tab. Let us say you went to Office Depot & bought some computer paper with your credit card. Two things happened when you did this:

1. You incurred an expense for Office Supplies
2. You went into debt to the credit card company

When using the Enter Credit Card Charges screen, both of these events are recorded on a single screen.

How Does This Relate to Double Entry Accounting?

This above transaction is an excellent example of double entry accounting. Remember this & it will often help you a lot in QuickBooks: every transaction in QuickBooks is double entry - it records two events with a single transaction. If you grasp this, & understand what those two events are in each screen, it will save you a lot of time & trouble in the long run.

Credit Card Users, Credit Card Accounts. . . How to Set Up in QuickBooks?

Even if you have multiple credit card users for a primary account, my suggestion is to have a single account set up in QuickBooks for all users. An alternative is to set up sub-accounts under a parent account, one sub-account for each credit card user. But I think the single account will be easier to manage.

The only reason to set up sub accounts is for some internal, management reason - do you really need to track the separate liability balances & expenses by credit card user? How useful will that information be? The extra work to keep track of it this way needs to be offset by the usefulness of the information.

Keep in mind, too, that three separate payments will need to be paid for each of the separate sub-accounts - this will ensure that the liability balances in QB will stay correct. My suggestion is to keep life simple & only use a single credit card liability account in this situation.

About the Author: Jennifer A. Thieme is a Certified QuickBooks ProAdvisor who loves to write about QuickBooks issues. So… She brings completely unique insight, clear instructions, & over ten years of experience to all of her QuickBooks articles. Owner of Solid Rock Accounting Services, Jennifer’s clients enjoy these same benefits on a personal & regular basis. You can too - visit http://www.jenniferthieme.com & contact Jennifer today.

AddThis Social Bookmark Button

How to Pay Sales Tax in QuickBooks - The Right Way & The Wrong Way

December 2nd, 2007 darlees Posted in Quickbooks No Comments »

The Sales Tax function in QuickBooks is a separate module from the rest of the program, even though it does not seem like it… Because it’s a separate module, sales tax payments should be made according to how the module works.

The Wrong Way

The unsuspecting QuickBooks user computes the sales tax return. Then, he/she generates a regular check in QuickBooks (a regular check is always designated CHK in the register). Perhaps this check is even correctly posted to the Sales Tax Liability account. Regardless of which account it’s posted to, using a regular check to pay sales taxes isn’t how QuickBooks was designed. Unfortunately, QuickBooks allows this transaction to occur.

The Right Way

1. Compute the sales tax return. Then, adjust the QuickBooks tax payment for rounding differences, if necessary.

In California, the BOE-401 requires every line to be rounded to the nearest dollar. This will create a small difference in the amount of sales tax owed on the return, verses the amount of sales tax owed according to QuickBooks.

In order to adjust for the difference, & if you’re certain you’re ready to record the payment in QuickBooks, from the Vendors menu select Sales Tax. Then select Pay Sales Tax. Click the button that says Adjust. Make the Adjustment Date the same as the final day of the tax reporting period. Put an Entry Number if you wish. In the Sales Tax Vendor box, select the sales tax reporting agency. For the Adjustment Account, select an expense account called Sales Tax Adjustments (create it if you do not already have one). Then, select the appropriate circle, depending if you’re increasing or reducing the amount of sales tax to pay in QuickBooks. Fill in the correct amount of the adjustment. Record a memo if you wish. Click Ok.

2. Generate a Tax Payment check.

At the Pay Sales Tax window, click the taxes you’re paying, as well as the adjustment you just made. Make sure the all of the other information is correct, particularly the Pay Sales Tax Through box - this must have the same date as the final reporting date on the sales tax return. Save the transaction.

The check you just generated appears now in the check register ® that you selected in the Pay Sales Tax window. Go & look for it there. You’ll see it as a completely unique type: TAXPMT, rather than CHK or BILLPMT.

Final Thoughts

Here’s why QuickBooks users should pay sales tax utilizing the correct method:

  • QuickBooks generates Tax Payment checks (TAXPMT) rather than regular checks.
  • QuickBooks users can perform specific searches for these types of checks.
  • QuickBooks can compute the tax amount - this can then be used as a guide to make certain the sales tax return was prepared correctly.

About the Author: Jennifer A. Thieme is a Registered Tax Preparer & a Certified QuickBooks ProAdvisor who enjoys writing about tax & accounting issues. So… She brings completely unique insight, clear instructions, & over ten years experience to all of her business articles. Owner of Solid Rock Accounting Services, Jennifer’s clients enjoy these same benefits on a personal & regular basis. You can too - visit http://www.jenniferthieme.com & contact Jennifer today.

AddThis Social Bookmark Button

QuickBooks - When is a Sole Proprietor Ready For It?

November 18th, 2007 darlees Posted in Quickbooks No Comments »

Do you need QuickBooks at this time? Are you feeling swayed by the advertisements about how easy it will make things?

QuickBooks is a full-blown double-entry accounting system. Even though Intuit has done an excellent job making double-entry accounting accessible to many people, it still requires a certain amount of specialized knowledge to use the program effectively.

Brand new, solo, sole proprietors generally only need a few things in their day-to-day business accounting:

1. Accurate Bank Balances. Managing & reconciling the check register ® should be as easy as possible. Printing vendor checks is nice, but optional.
2. How Much Revenue? Tracking revenue for tax purposes is an absolute must.
3. Expenses Tracking. Keeping track of all expenses in their proper categories is also an absolute must for tax purposes.

Quicken can do all of these things, more easily & less expensively than QuickBooks. So… So can Excel or even a paper based system.

I’m not a big fan of switching people over to QuickBooks unless their financial situation changes. You might be ready for QuickBooks if:

4. Employees. Perhaps you have grown to the point of needing to hire people. Great! But you also might need a new accounting system to help you with all of the payroll reporting & payment requirements.
5. Inventory. Perhaps your inventory has grown to the point where you would be better off tracking it via software. QuickBooks can assist you with this.
6. Change of Entity. You may even have grown to the point where you should change from a sole proprietor to some other type, such as an S-Corp. If so, then you really need to be easily able to generate a balance sheet for tax purposes. QuickBooks can do that for you…
7. Accounts Receivable. You may send a lot of customer invoices each week or month. QuickBooks can keep track of these for you in a very organized & easy to understand way.
8. Lots of Business Debt. If you have many loan balances, keeping track of them in QuickBooks is easy.
9. Job Costing. You perform work on a job-by-job basis. Maybe it is time to track revenue & expenses for each job - this way, you can determine if you’re making money on each job, & which jobs are more profitable than others. QuickBooks does this.

If more than one of these applies to you, it may be time to make the switch.

Final Thoughts

Switching to QuickBooks means better reports & better tracking of financial data. For this, you may need professional help - you may need to hire somebody to do the bookkeeping and/or help with the setup. So switching accounting systems will cost more than just the price of the software. Before you switch, make certain that the additional data is worth the additional expense. If some of the above variables have come into play, it probably is.

About the Author: Jennifer A. Thieme is a Certified QuickBooks ProAdvisor who loves to help people with QuickBooks. So… She brings completely unique insight, clear instructions, & over ten years of experience to all of her QuickBooks articles. Owner of Solid Rock Accounting Services, Jennifer’s clients enjoy these same benefits on a personal & regular basis. You can too - visit http://www.jenniferthieme.com & contact Jennifer today.

AddThis Social Bookmark Button

Quick Tour Through QuickBooks

November 4th, 2007 darlees Posted in Quickbooks No Comments »

QuickBooks is accounting software targeted at assisting small businesses in organizing their financial bookkeeping. It’s developed by Intuit? & was first released in 1992. It’s currently the #1 selling accounting software package for small businesses.

Uses can include:

  • Expense tracking
  • Invoice preparation
  • Financial Statement preparation
  • Inventory tracking

Competitive products include:

  • Simply Accounting By Sage?
  • Peachtree? by Sage
  • Microsoft? Office Accounting Professional

There are 4 flavors of QuickBooks currently offered:

  • QuickBooks SimpleStart-
    • Print checks, pay bills, track sales & expenses
    • Create estimates & invoices
    • Accept credit cards
  • QuickBooks Pro- All QuickBooks SimpleStart functionality, plus:
    • Payroll capabilities
    • Interoperability with Microsoft? Office
    • Inventory tracking
    • Download capabilities for credit card & bank transactions
  • QuickBooks Premier- All QuickBooks Pro functionality, plus:
    • Business planning & forecasting tools
    • Advanced pricing capabilities
    • Advanced cost tracking tools
  • Enterprise Solutions- All QuickBooks Premier functionality, plus:
    • Multiple user capabilities (up to 20 concurrent)
    • Increased capacity for inventory tracking
    • Advanced reporting tools (including financial statement templates)
    • Employee Organizer tool

There are also some targeted functionality products that allow businesses to use QuickBooks as a complement to less feature-rich accounting software:

  • QuickBooks Payroll (including Basic, Standard, Enhanced, Assisted, Online, & Direct Deposit variations)
  • QuickBooks Point of Sale (including Basic, Pro, Pro Multi-Store, Merchant Service, & Gift Card Service variations/add-ons)
  • Customer Manager
  • Invoice Manager
  • Credit Card Processing
  • Other various transaction & remote services

Additionally, Intuit released an on line service called QuickBooks Online Edition in 2001, which has gradually matured into a best-in-class accounting service for small businesses.

There are many other help-ful on line resources for finding out more about QuickBooks & what it can do to improve your business. So… Some of these include:

  • QuickBooks’ Support site on quickbooks.com
  • QuickBooks Support Forum (also found on QuickBooks’ website)
  • Jennifer Thieme’s Expert QuickBooks Articles on Ezine Articles (http://ezinearticles.com/?expert=Jennifer_A._Thieme)

Finding the best accounting software for your business can be a challenge. If you would like more information on how you can “make technology your #1 employee”, go straight to the TeknoCoach website ( http://www.teknocoach.com ) & check out our solutions & services.

Chris Smith is a pioneer in applying “coaching” principles to technology planning for small & medium-sized enterprises. He is founder & owner of TeknoCoach?, a company which is committed to helping small businesses “make Technology their #1 employee”.

If you have:

  • a need for website improvement
  • a need for a business continuity/disaster recovery planning
  • a need for employee training on technology
  • a need for some specialized research on technology solutions

then you really need to go straight to the TeknoCoach website (http://www.teknocoach.com) to find out what TeknoCoach can do for you.

AddThis Social Bookmark Button

How To Void A Check From A Closed Period In QuickBooks

October 22nd, 2007 darlees Posted in Quickbooks No Comments »

Sometimes a check from a closed accounting period doesn’t get cashed. Here’s how to handle it, without altering the closed period.

Understand the Void Check Function

When we use the Void Check function, QuickBooks zeros the amount of the check, & also zeros the amount that was used in the lower ½ of the screen. Usually, this is some type of expense. By example, it could be office supplies, auto expenses, or some other type of expense.

If we void a check from a closed period, we alter the closed period. We increase the amount of cash showing on the books, & we increase the amount of profit (if the check was for an expense). Altering closed periods isn’t a good practice & should always be avoided, unless your accountant directs you otherwise.

Don’t Void - Make a Reversing Entry Instead

Remember the old days, when we kept paper check registers? Do you remember what you did when you needed to void a check? You had one of two choices:

  • You could cross off the voided check, & readjust the running balance in your register ®
  • You could make a reversing entry on today’s date, to “wipe out” the effect of the voided check. This entry looked like a deposit in your register, & did not alter the running balance.

Here’s how to do the latter in QuickBooks:

1. Take Good Notes. Go to the check you want to void. Make a note of the payee, amount, date, number, & expense account. Make a notation on the memo line that explains why you needed to reverse the check, such as: “Check lost in mail. Reversed on MM/DD/YYYY.” MM/DD/YYYY is today’s date, or whichever date in the current period you want to use.

2. Make a Deposit. Go to the Make Deposits screen. Make sure the correct bank acount is chosen, the same one as the check. Enter the appropriate date in the current period. In the top Memo line, enter a notation like this: “Reversal of Ck# 1234 - check lost in mail.”

In the Received From field, enter the payee. In the Account field, enter the expense account used in the original transaction. In the Memo line, enter the same thing as the top memo line. In the Check #, enter the check number. Enter the payment type as Check. Enter the amount. OK. Save the transaction.

If you go straight to the bank account register, you’ll see this as a deposit, & your bank balance will be higher than it was before you made the entry.

Reconcile Your Problem Away

Next time you reconcile this bank account, you’ll see both entries - the original entry on the left side of the screen, the reversing entry on the right. Be sure to select them both to be reconciled. They will offset each other & not effect the reconciliation.

Why Not Use the General Journal?

Some people might suggest to use a General Journal Entry in this situation, but I think it is better to use the Make Deposits screen. This screen allows you to enter the check number in it is own field.

This is important. In the future, somebody might need to search for this check number. When this happens, both entries will show in the search results, the original & the reversal. Using the General Journal will not produce the same results in a search for this check number.

Final Thoughts

These instructions are for straightforward check entries, the type that are designated CHK in the check register. They do not necessarily apply if the check was a bill payment check (designated BILLPMT in the register), a payroll check (designated PAYCHK in the register), or some type of tax payment check (designated LIABCHK or TAXPMT in the register). If you really need to void or reverse one of these, or a payroll check that was not generated by QuickBooks, please consult with a QuickBooks or accounting professional.

About the Author: Jennifer A. Thieme is a Certified QuickBooks ProAdvisor who loves to write about QuickBooks issues. So… She brings completely unique insight, clear instructions, & over ten years of experience to all of her QuickBooks articles. Owner of Solid Rock Accounting Services, Jennifer’s clients enjoy these same benefits on a personal & regular basis. You can too - visit http://www.jenniferthieme.com & contact Jennifer today.

AddThis Social Bookmark Button

How to Tell if You’ve Outgrown Quicken

October 8th, 2007 darlees Posted in Quickbooks No Comments »

Think you have maybe outgrown Quicken as a small-business accounting solution? Maybe, maybe not. OK. Small-business accounting systems (including Quicken) are supposed to do three things:

1. Measure your profits & cash flow so that you can prudently manage your business.

2. Track the assets & liabilities of the business so that you know what you own & what you owe.

3. Generate the business forms that you use to transact business.

As long you keep these three accounting system tasks in mind, you will find it easy to tell when you have outgrown Quicken & should move up to a more full-featured small-business accounting system.

Symptom #1: You want to use accrual-basis accounting

Quicken measures income & expenses using either cash-based accounting or very simple accrual-based accounting. If you want to do sophisticated accrual-based accounting rather than cash-based accounting, you can not use Quicken. You will need a more full-featured accounting system, such as QuickBooks from Intuit or Peachtree Accounting for Windows.

Symptom #2: You need detailed records of more than just cash

To keep detailed records of assetsbesidescash & your investments, you also need to use a small-business accounting system. By example, if you buy & sell inventory items & want to track those items, you need an accounting system that includes inventory management features. (Most small-business accounting packages provide these features.) If you own a lot of depreciable assets & want to track them, you need an accounting system that includes a true fixed-assets module that easily handles depreciation. (This is a less common feature, by the way.) If you want point-of-sale accounting, or other special features, you also need to upgrade to a more powerful accounting system.

Symptom #3: You need business forms other than checks

One other issue is business forms. Quicken produces check forms & Quicken Home & Business produces invoices & customer statements, but you may need to produce other business forms, such as purchase orders. If you want to automate production of these other forms with an accounting system rather than prepare them manually, you really need to upgrade to a more powerful system.

Before you jump to another accounting system: Two Caveats to Consider

Before you purchase a new accounting system to take care of the tasks I have just described, there’re a couple of things to keep in mind. First, no accounting system is perfect. I have seen more than one business waste enormous amounts of time, energy, & money pursuing the perfect accounting system. If you have a system that works reasonably well, lets you gauge the performance of your business, & in general does most of the things you need it to do, you may create more problems than you solve by converting to a more complicated new system.

If Quicken works reasonably well & presents you with only a handful of minor problems & irritations, I had suggest you stick with Quicken.

Also, the more powerful small-business accounting systems generally require you (or some one who works for you) to know a lot more about accounting than you really need to know to operate Quicken. When you get right down to it, all you really need to know to operate Quicken is how to use a checkbook & enter payments & deposits into a check register. In comparison, to use a full-featured small-business accounting system, you (or your employee) should know how to perform double-entry bookkeeping, understand the tricks & techniques used in accrual-based accounting (accruals, deferrals, reversing journal entries, & so on), & be easily able to read & use the financial information contained in a standard set of accrual-based financial statements (income statements, balance sheets, & cash flow statements). Note that the cash flow statement produced by an accrual-based accounting system will not look anything like the Cash Flow report produced by Quicken.

About the author: CPA Stephen L. Nelson wrote the bestselling book on Quicken & QuickBooks as well as the downloadable do-it-yourself guides at Incorporating a business, Limited liability company formation, Subchapter S corporation setups.

AddThis Social Bookmark Button

Sales Tax Items And Sales Tax Codes In QuickBooks

September 24th, 2007 darlees Posted in Quickbooks No Comments »

Are you confused about Sales Tax Items & Sales Tax Codes in QuickBooks? I was too! It took me forever to finally figure out what they actually did, how to get the sales tax liability report to look right, & where they showed up on that report. After reading the QuickBooks help, & reading tons of articles online, I still had no clear answer. But I finally figured out how to set things up in a way that makes sense to me - I hope it makes sense to you too.

We’re going to discuss the proper setup of sales tax items & codes; proper setup of customers for sales tax reporting; the difference between sales tax items & sales tax codes; using sales tax codes; & running sales tax reports in QuickBooks.

Proper Setup of Sales Tax Items & Sales Tax Codes

These guidelines assume that you have no Sales Tax Items or Sales Tax Codes set up yet in QuickBooks. However, many of you reading this already do. If this is the case, just go through your lists & see if your items & codes are set up like these. IMPORTANT: I strongly suggest that you do not change anything in your QuickBooks file until you read this entire article & understand it!

First, determine how many sales tax agencies & rates you really need to report. You’ll need to set up your Sales Tax Items depending on this information. If you’re unsure, contact a local accountant.

Here’s how to set up the Items & Codes:

From the Items List, press Control-N. Select Sales Tax Item. Enter a name for the sales tax - something simple is fine, something that makes sense to you… Enter a more detailed description on the next line. Enter the tax rate, & select the state reporting agency where the tax will be remitted.

Then, set up a non-taxable Sales Tax Item. From the Items List, press Control-N. Select Sales Tax Item. Item name should be Non-Taxable Sales. Enter a brief description, & 0.00% for the rate. Even though this is non-taxable, select the main tax agency you use.

Next, setup your sales tax codes. It will be help-ful to have your sales tax return in front of you to do this. By example, for California, on BOE-401-A page two, there is a list of all of the reasons sales may be non-taxable. Here are some of them:

Resale
Food
Labor
Sales to the U.S. government
Out of state sales

From the Lists menu, select Sales Tax Code list. Then press Control-N. Enter a three-character code & description for each. By example, for non-taxable labor, you can use a three-character code of LBR, & a description of, “Labor Sales - non-taxable.” Do this for all of the reasons that sales are non-taxable. Make sure the Non-taxable circle is selected.

For taxable sales, set up a Sales Tax Code called TAX. Write a brief description. Make sure the Taxable circle is selected.

Proper Setup of Customers for Sales Tax Reporting

It’s important that the customers are set up correctly, because when invoices are generated, they will default to the setup you use here.

Go to the customer list, pick a customer you want to examine, right click, & select Edit Customer:Job. Click the Additional Info tab. In the bottom left area you’ll see Sales Tax Information.

First, select the Tax Item box. If this customer lives out of state or is otherwise non-taxable, select the Non Taxable sales tax item you established above. If the customer lives in-state or is otherwise taxable, select the Taxable sales tax item you established above.

Next, select the Tax Code box. If the customer is out of state & non-taxable, select the code, “OOS.” If the customer is the U.S. government, select the tax code you established for these types of sales. If the customer is in state, select the code, “TAX.” Generally, you’ll only need to use these codes in these screens for all customers.

Any time you generate an invoice for your customers, QuickBooks will default to the sales tax items & codes you established in the Edit Customer:Job screen.

Understand the Difference Between Sales Tax Items & Sales Tax Codes

The Sales Tax Item tells QuickBooks how much sales tax to computer for a given sale. On invoices, they’re located just above & to the left of the Total. Sales Tax Items are pretty straightforward to understand & use.

The Sales Tax code tells QuickBooks why the customer or sale was taxable or non taxable. They are located along the right side of the invoice screen. Also in the invoice screen, in the grey area above the Memo line, you’ll also see a box that says Customer Tax Code. This defaults to the Tax Code you established above for each customer.

Sales Tax Codes are important, because the California sales tax return BOE-401-A requires that non-taxable sales be itemized. If the codes are setup & used correctly in QuickBooks, the reports will show this itemization.

Using Sales Tax Codes

As a general rule, anytime you have an out-of-state customer, you’ll use the Non Taxable Sales Tax Item, & the OOS Sales Tax Code. My recommendation is that even if there is non taxable labor or non taxable shipping on the invoice, do not change the codes, still use OOS.

For taxable customers, use the Taxable Sales Tax Item on their invoices. However, you may need to use different Sales Tax Codes on different lines. By example, you may sell some products to a customer, but on the same invoice you may have non-taxable shipping or labor. You’ll need to make certain the SHP or LBR codes show up correctly, & that the TAX code shows correctly along the right side of the invoice. This will compute sales tax only for your products, & not for your shipping and/or labor.

Running Sales Tax Reports in QuickBooks

If you have taken the time to get everything set up correctly, you efforts will pay off when it is time to run sales tax reports!

From the Vendors menu, select Sales Tax, then Sales Tax Liability. Make certain of the date range, that it matches the date range of your sales tax return.

You will see many columns, most notably Total Sales, Non-Taxable Sales, & Taxable Sales. Notice that the Sales Tax Items are listed down the left side, underneath the state agency. Also notice that the Sales Tax Codes do not appear on this report.

In order to see the Sales Tax Codes (remember, these are the reasons why sales are taxable or non-taxable), go straight to the Non-Taxable Sales column, & find the amount that intersects with the Non Taxable sales row. Double click. This report will show all of the amounts used for the Sales Tax Codes for Non Taxable sales. Use this information to help you prepare your sales tax return (for California, this information should appear on BOE-401-A, page 2).

The Sales Tax Liability Report can be often used to finish the rest of the sales tax return.

Final Thoughts

Sales tax collection & reporting is very complex, & varies considerably even from city to city in some cases. There is more. These guidelines are intended to be general in nature, giving a broad over view of the sales tax process in QuickBooks. If you need more help, please refer to a professional who can assist you make certain everything is set up according to your completely unique location & needs. If you wish, you can experiment with the ideas here in a Sample Company File, which was loaded onto your computer when you loaded QuickBooks.

About the Author: Jennifer A. Thieme is a Registered Tax Preparer & a Certified QuickBooks ProAdvisor who enjoys writing about tax & accounting issues. So… She brings completely unique insight, clear instructions, & over ten years experience to all of her business articles. Owner of Solid Rock Accounting Services, Jennifer’s clients enjoy these same benefits on a personal & regular basis. You can too - visit http://www.jenniferthieme.com & contact Jennifer today.

AddThis Social Bookmark Button