New Business Direction LLCGreetings!
QuickBooks is easy to use, intuitive and flexible. But it is not an accounting manual or class or tutorial. If your business is exceptionally uncomplicated, you might get by without knowing a lot about the principles of bookkeeping.
Still, it helps to understand the basics. Here’s a look at some terms and phrases you should understand.
2. Accounts Payable (A/P). Everything that you owe to vendors, contractors, consultants, etc. is tracked in this account.
3. Accounts Receivable (A/R). This account tracks income that hasn’t been realized yet, like outstanding invoices.
4-5. Accrual Basis. This is one of two basic accounting methods. Using it, you record income as it is invoiced, not when it’s actually received, and you record expenses like bills when you receive them. Using the other method, Cash Basis, you would report income when you receive it and expenses when you pay the bills.
6-7 Asset. What physical items do you own that have value? This could be cash, office equipment and real estate. In QuickBooks you’ll be managing two types. Current Assets are generally used within 12 months (or you could convert them to cash in that length of time). Fixed Assets refers to belongings like vehicles, furniture and land, property that you probably won’t use up in a year and which usually depreciates in value. Depreciation is very complex; you may need our help with that.
8. Average Cost. This is the inventory costing method that programs like QuickBooks Pro and Premier use to calculate the value of your stock.
10-12. Double-Entry Accounting.This is the system that QuickBooks uses – that all legitimate small business accounting software uses. Every transaction must show where the funds came from and where they went. Each has a Credit (decreases asset and expense accounts) and Debit (decreases liability and income accounts) which must balance out (other types of accounts can be affected).13. Equity.This refers to your company’s net worth. It’s the difference between your assets and liabilities.
14. General Journal. QuickBooks handles this in the background, so it’s unlikely you’ll ever be exposed to it. We sometimes have to create General Journal Entries, transactions required for various reasons (errors, depreciation, etc.) that contain debits and credits. Please leave that to us.
15. Item Receipt. You’ll create these when you receive inventory from a vendor without a bill.
16. Job. QuickBooks often associates customers with multi-part projects that you’ve taken on, like a kitchen remodel.
17. Net income. This is your revenue minus expenses.
18. Non-Inventory Part. When you purchase an item but don’t sell it or you buy something and resell it immediately to a customer, this is what it’s called. It’s merchandise that isn’t stored by you for future sales.
19. Payroll Liabilities Account. QuickBooks tracks federal, state and local withholding taxes, as well as Social Security and Medicare obligations, that you’ve deducted from employees’ paychecks and will remit to the appropriate agencies.
20. Post.You won’t run into this term in QuickBooks. It simply refers to recording a transaction within one of your accounts.
21. Reconcile. QuickBooks helps you with this. It’s the process of making sure your records and those of your financial institutions agree.
22. Sales Receipt.This is how you record a sale when payment is made in full during the transaction.
23. Statement. You’ll generally use invoices to bill customers in QuickBooks, but you can also send statements, which contain transaction information for a given date range.
24. Trial Balance. This standard financial report tells you whether your debits and credits are in balance. Should you run this report and find a problem, let us know right away.
25. Vendor. With the exception of employees, QuickBooks uses this term to refer to anyone who you pay as a part of your business operations.
These are just a few of the terms you should recognize and understand. We hope you’ll contact us when you need help understanding how the accounting process fits into your workflow.
Greetings,
Knowing your vital signs, and especially when they are out of whack, is good for your health. In the same way, knowing your business’s vital signs, and especially when they are out of whack, is good for the financial health of your business.
If you’ve been in business a while, you might already know the “vitals” you like to track. Here are some common ones for a small or new business:
- Checking account balance(s)
- Cash flow requirements for bills and payroll
- Revenue for the month and year-to-date
- Sales by customer so you can see the top five to ten largest customers
As time goes on and your business grows, you may want to add some of the following:
- Revenue for the month and year-to-date compared to last year
- Net income for the month and year-to-date compared to last year
- Days Sales Outstanding which is a measure of how long it takes to collect on an invoice from a client
- Revenue by service or product line in a pie chart
What about these important metrics?
- Best and worst selling products
- Tracking promotion codes and coupon results
- Work in progress or backlog
- Number of days to fill an order
These are just a handful of the many options there are when it comes to measuring the results of your business, and it would be difficult for us to list all of them here. The point is to decide proactively what you would like to track on a monthly basis. Then you can set up the process it takes to get those numbers delivered to you in the format you prefer.
Once you decide on the numbers you need to run your business, you’ll be able to take your “vitals” whenever you want. You can take this to the next level with one more idea: exception reporting.
It’s great to glance at your numbers periodically, but there can be a lot of data to wade through. How about getting a report that tells you only when the numbers go out of range? This is called exception reporting, and requires that you set ranges for each measure you want to follow. If the measure stays within range, you do not have to be alerted. However, if it falls out of range, then you can get a report to tell you what’s going on so you can take the right business action.Exception reporting is not all that common in small business, but it should be. It can save a busy owner a lot of time.
By determining the vitals you want to watch for your business and putting a process in place to monitor that information, you will be helping your business stay healthy. If we can help, please reach out and let us know. The doctor is IN.
Phone: (603) 356-2914 | Fax: (603) 356-2915
Greetings!
When your goods come rolling in, be sure to document them correctly.
You’re probably happy to see couriers delivering inventory items you’ve ordered since it means you can ship to customers, but recording the new stock means yet another repetitive task.
QuickBooks’ tools can help with this, but you need to be sure you’re using the right forms. There are two different ones that you’ll use, depending on whether or not you’ve received a bill.
Bill in Hand
Either way, you’ll get started by opening the Vendors menu (or clicking the arrow next to Receive Inventory on the home page). If you do have a bill, select Receive Items and Enter Bill (Receive Inventory with Bill on the home page). The Enter Bills screen opens; select your vendor from the drop-down list. If you had entered a purchase order, you’ll see something like this:
Now the PO item information has been entered in the window. Check the form for accuracy, then save it.
Of course, if there was no purchase order, you’ll enter the information about the items you received (descriptions, prices, etc.) in the Enter Bills screen.
If you receive items without a bill, you still need to document the shipment. Open the Vendors menu and select Receive Items (or click the arrow next to the Receive Inventory icon on the home page and select Receive Inventory without Bill).
The Create Item Receipts window opens. Select the vendor by clicking the down arrow next to that field. If a message about existing purchase orders for that vendor appears, click Yes or No, and either select the appropriate POs or enter the information about what you received.
If the items were already earmarked for a specific customer on the purchase order, the Customer column will have an entry in it, and there will be a check mark in the Billable column. If there was no purchase order and you’re entering the information, you can complete those two fields manually
Figure 2: If a purchase order was already assigned to a customer and is billable, that information should appear in this windowEnter a reference number if you’d like. The Memo field should already be filled in with Received items (bill to follow), and the Bill Received box should not be checked.Warning: Be sure that the Items tab is highlighted when you’re recording physical inventory. If there are related costs like freight charges or sales tax, click the Expenses tab and enter them there.
When the bill comes in for merchandise that you’ve already recorded on an Item Receipt, you’ll use this procedure to pay it:
* Click Vendors | Enter Bill for Received Items, which opens the Select Item Receipt window.
* Select the vendor, then the correct Item Receipt.
Note: If the bill corresponds to more than one Item Receipt, you’ll need to convert each into a bill separately. You can create a new bill if some items received were not accounted for on Item Receipts.
* Click the box next to Use the item receipt date for the bill date if you want to match it to the inventory availability date.
* Click OK. The Enter Bills screen opens, which can be processed like you’d handle any bill.
Though it may seem like extra work, this last procedure is important, since it prevents you from recording the same inventory items twice.
It’s easy to get tangled up on these procedures. We hope you’ll consult us when you begin implementing inventory management in QuickBooks, or when you’re taking on a new task there. It’s a lot easier to prevent errors than to go back and fix them.
This article of QuickBooks Tips and Tricks was based on the 2013 version of QuickBooks.
Cash flow improvement is a hot issue for small businesses; in many businesses, it seems like there is never enough cash when you need it. The last thing a business owner wants is to reduce their cash balance unnecessarily. To help you preserve or increase your cash, here are five cash management leaks to avoid.
1. Bloated Bank Fees
Some banks are more business-friendly than others. We recommend you assess the fees you are currently being charged to see if you can discontinue any unnecessary services.
- Could you maintain a cash balance to avoid monthly fees?
- Are you being charged online banking fees and bill pay fees, and are these still necessary?
- Are you being charged for a high volume of transactions or cash drawer services, and are these competitive with other banks?
Banks, including national brands, that have not kept up with technology and have not automated a significant amount of their transactions are inefficient and must charge higher fees to cover their processing costs. If your accounts are located at one of these costlier banks, you do have a choice.
2. Overtaxed
Are you sure that you are paying the lowest amount of taxes you legally owe? There are several places to look to make sure you have not overpaid taxes anywhere in your business or personally:
Payroll taxes- Sales and use tax
- Franchise taxes
- State and local income taxes
- Property taxes
- Federal income taxes
- Taxes that are specific to your industry
In preparing income taxes, a few of the easiest items to overlook include carryovers from prior years and new deductions you become eligible for. If you received a large refund this year, congratulations, but that means you gave Uncle Sam an interest-free loan on your money. You can do better next year by estimating your tax payments and paying only what’s due.
3. The Check Is in the Mail 
Customers who take too long to pay you are big cash drains in your business. Consider changing your terms, asking for deposits, or becoming more aggressive with collections to bring your DSO (days sales outstanding) down. When you do, you’ll get an instant, permanent cash flow improvement.
4. Sweat the Small Stuff
You may have an eagle eye on your largest bank account, but what about your other cash stashes? PayPal, petty cash, and business savings accounts are among the places that may not get daily scrutiny. Make sure those accounts are properly reconciled and have the proper controls in place so funds don’t go missing.
5. It’s in Your Interest
A nice problem to have is when your bank balances get too large and you don’t need the money immediately. Make 
sure that money is still working hard for you by putting the excess in an interest-bearing account. It’s not much these days, but every little bit helps.
Make a Dash to the Cash
If we can help you plug any of these cash leaks in your business, please don’t hesitate to reach out and let us know.
Not using progress invoices? Maybe you should be.
Greetings!
The U.S. economy may be picking up, but your customers are probably still being very careful with expenditures. If your company’s finances will allow it, you can help them out on sizable jobs by using progress invoicing, also known as partial billing or progress billing.
You could, of course, simply create invoices for smaller chunks of the job as they come. A smarter way is to build estimates for the entire job or sequential phases so your customer can see the big picture. You can still use progress invoicing to start collecting funds one segment at a time.
How to Proceed
First, be sure you have progress invoicing turned on. Go to Edit | Preferences | Jobs & Estimates | Company Preferences and make sure the Yes button is filled in next to the questions about estimates and progress invoicing.
Now create your estimate (these instructions are for QuickBooks Premier 2013; your steps may vary slightly). Go to Customers | Create Estimates. When you’ve entered all of the items you want to include in this phase of your project, click the Create Invoice button. This window will open:
By clicking one of these buttons, you can bill the customer 100 percent of what’s due on the invoice or just a percentage. But let’s say you and your customer have agreed that payment will be due in pre-defined stages, so click the third button and select one or more of the line items. Click OK. QuickBooks will display a new window that lets you select items and/or percentages of amounts due.
In our example here, we’re going to invoice the customer for two items, the blueprints and floor plans. So we selected the button next to Show Quantity and Rate and entered the full estimated quantity for each item in the QTY columns (if you chose Show Percentage, new columns would appear). It would look like this:
Click OK. QuickBooks will return to your progress invoice, which you can save and print or email to your customer. Your original estimate will remain unchanged.
Tip: If you don’t want any of the zero amounts to appear on the progress invoice, go to Edit | Preferences | Jobs & Estimates | Company Preferences and make sure there’s a check mark in the box next to Don’t print items that have zero amount.
Following Up
When you want to bill for another set of items on this estimate, simply repeat these steps.
Here’s an easy way to determine how much (if any) of the estimate has been invoiced. Go to the Customer Center and select the customer. Click the arrow next to the Show field and select Estimates. Any estimate that has a zero in the OPEN BALANCE column has been completely billed.
QuickBooks provides a report that tells you where you are with all of your progress invoices. Go to Reports | Jobs, Time & Mileage | Job Progress Invoices vs. Estimates. Your report will include the progress invoice you just created:
More Options
What if you determine that you won’t have one or more of the items on the estimate? QuickBooks lets you quickly generate a purchase order. With your estimate open, click Create Purchase Order to select the item(s) needed and generate the form. You can also click Create Sales Order if one is necessary.
Estimates provide a useful way to fine-tune your bookkeeping and inform your customers about impending costs. They can also be confusing if you don’t keep up with them. We can help you determine when they’re a good idea and how to keep them organized. QuickBooks provides good tools here, but they require some administrative control.
This article of QuickBooks Tips and Tricks was based on the 2013 version of QuickBooks.
It’s generally a good idea to keep overhead costs low so that your business profits will be higher. This is especially true with items that are easily commoditized and fairly standardized, such as utilities and rent. But there are times when increasing expenses pays off nicely, and here are five areas to consider so you can reap the rewards.
1. Training
Whether it’s for you or your staff, good training can pay back for years to come. Learning new skills, no matter what our crafts are, will keep our businesses from becoming stagnant. Implementing what we learn will help us grow.
You might get training to increase the mastery of your chosen profession. You might also want to consider general business skills, including technology, marketing, finance, and leadership. Just about everyone can benefit from learning more about project management, communications, and negotiations, to name a few more.
You might also want to consider “human performance” skills such as public speaking. Whatever you choose, training is always a great investment that pays back big dividends.
2. T
ools
Without the right tools, the same task can take double the time. It’s a great idea to provide your employees with the most powerful computers and software on the market. The cost of labor outweighs the costs of the computers, so it makes sense to load employees up with the best tools you can. An employee with a slow computer, through no fault of their own, is not giving you their best, and that will cost money in lost productivity.
The same thing goes for owners. You can spend your time fighting with a machine or getting a ton of work done. I’m pretty sure the latter is more profitable.
3. Accounting
The most successful companies we work with invest in accounting services in five areas: accounting technology, accurate bookkeeping, thorough reporting, tax minimization, and professional consulting. When we see business owners cutting corners in any of these areas, it usually costs them more money in the long run to clean up the problems that result.
An up-to-date accounting system minimizes maintenance and troubleshooting costs. Making sure the bookkeeping and reconciliations are done properly is essential for compliance reporting and decision-making. A robust set of reports allows a business owner to make smart decisions about running their business, and minimizing taxes helps you keep more of what you make.
Since accountants see thousands of financial reports in their careers, they have developed an eye for opportunities that a business owner may not see. Bringing an outside perspective into your business is a good investment that can help you discover great opportunities in your business.
4. Marketing
Whatever you do in your business, you are helping others. You are sharing a skill you have that your clients either don’t have or don’t choose to do for themselves. Being a best-kept secret doesn’t help you share your gifts and talents.
Marketing can help you get the word out to people who need your services but might not know about you. Developing great marketing materials will help you communicate what you do as well as receive fair compensation for what you do. It almost always makes sense to invest in this area of your business.
5. Employee Perks and Benefits
Keeping employees passionate about your vision and motivated to be productive is a continuing task. One way to do that is to provide employee benefits and perks that make it attractive for employees to work for you.
There are many ways to invest in your employees. Good health insurance, personal time off, extra vacation time, education reimbursement, flex time, and working from home are just a few of the many options you can choose from to enhance employees’ working environments.
Measuring the Payoff
We can help you measure your return in any of these areas; as always, please let us know how we can help.
Depending on your location, you’re probably starting to see early signs of spring. The nicer 
weather and signs of new life seem to make people want to spruce up their surroundings.
Now would be a good time, too, to clean up your accounting environment. Some of your screens may be unnecessarily cluttered. And your QuickBooks® company file probably needs attention, too.
So here are some suggestions for streamlining QuickBooks®. You’ll have a tidier workspace, and you’ll save time and frustration.
Make a Clean Start
Intuit did a great job of giving QuickBooks’ home page a fresher, more “open” look in its 2013 versions. But does everything really need to be there? Could you simplify it a bit? There are several things you can do, including:
- Minimize icons. That pretty graphical process map on the home page is great for quick access to frequently-used actions. Some of them must remain there if they’re related to activities you do (i.e., Invoices has to stay if you use Estimates), but you can remove some of the ones you don’t use. Go to Preferences | Desktop View | Company Preferences. You’ll see this:
Figure 1: You can turn off some of the feature icons on your home page.
Some of the options have been grayed out because they support other processes. To remove an active feature icon like Inventory, click on it. In the window that opens, uncheck the box next to Inventory and purchase orders are active (you can also modify options here).
Figure 2: Clicking the checkbox next to Inventory and purchase orders are active grays out the other options and removed related feature icons from the home page.
To reduce the number of feature icons even more, go to the Finance Charge, Jobs & Estimates, Payroll & Employees, Sales & Customers, Sales Tax and Time & Expenses. QuickBooks® removes the related icons and reroutes the process map on the home page.
More Time-Saving Tweaks
- Don’t allow multiple windows to open in your work area. Tired of seeing all of those overlapping open windows on your desktop? Open the View menu and select One Window. All of your open windows remain active in the background. To return to one of them, open the Window menu and select the one you want to move to the front (Window | Close All returns you to a blank work area).
Figure 3: Your Icon bar can be your fastest route to often needed screens – if you modify it to only contain the functions you use, in order of importance. You can also change the labels to make them more meaningful to you.
- Trim down your icon bar. Seems like a minimal change, but it’s one of those things that can add unnecessary moments of frustration throughout the day (“Where’s the Calendar!“). Click View | Customize Icon Bar.
- Customize columns in Lists. You probably work in QuickBooks’ Lists often, but are you spending too much time tracking down the right information? Customize their columns so your registers contain only what you usually need (and add additional ones if it’s helpful). Open a list, right-click anywhere within it and select Customize Columns to modify the display (resize column widths by placing your cursor on the vertical set of dots between labels and dragging).
Figure 4: When you customize your columns in Lists, you’ll find what you’re looking for faster.
- Hide inactive names and items. Highlight an item, right-click and select Make Item Inactive. Open the Item menu in the lower left and click Hide Inactive Items (this action won’t delete them). This should be done with Customers, Vendors, Employees and Items to keep them manageable.
Internal Cleaning
These may all seem like cosmetic changes, but you will save time and frustration over the long run. The most critical spring cleaning task is company file analysis and maintenance. We can handle this for you. QuickBooks® can slow down and start generating error messages when the data file becomes unwieldy. Preventing file corruption before it crashes your system is a lot faster and less expensive than a reconstruction project.
This article of QuickBooks Tips and Tricks was based on the 2013 version of QuickBooks.
What is Cloud Computing? 
By now, we’ve all heard about the subject of Cloud Computing. Working in the Cloud simply means that you are accessing servers, software and technology via the internet.
It’s something that most of us are already using on a daily basis when we access our bank accounts and pay our credit card bills online; or when we use Facebook and other social media websites.
That’s the infamous Cloud – you access it with a browser from any computer or mobile device with an internet connection and you log in to use applications that you do not own and that are stored elsewhere to retrieve your data.
Hosting QuickBooks®
Many businesses are looking for an online solution for their QuickBooks® software but are hesitant to move to QuickBooks® Online because it does not have the full functionality of the Desktop versions of the software that we’ve all become familiar with.
A great option for those who want to move to the cloud but don’t want to change everything all at once is to have their licensed QuickBooks® Desktop software hosted by an Intuit Authorized Hosting Provider.
The average cost of hosting is approximately $50/month/user for basic setup and storage space, plus the cost of the software. The following is a list of certified secure data centers with proven reliable up-times:
Many of these providers are also licensed to rent QuickBooks® licenses for currently supported versions of the software which is quite cost-effective.
Benefits 
The hosting service provider installs and manages the QuickBooks® software and the company data files on their cloud-based servers. They install the software, update it and maintain it and provide system maintenance, redundant servers, improved security, virus protection and managed data backups.
It’s the full version of your licensed QuickBooks® software hosted on a secure server that users can access anytime, anywhere – remotely and simultaneously with proper licensing. There’s no data conversion and no retraining of users because it’s the same software that they have already been using.
There is no more dealing with Accountant’s Copies and Transfer Files at year end for your tax preparer, as access can be provided to outside professionals to seamlessly share data and collaborate with the business.
You are not required to upgrade to the newest version of the software each year in order to use hosted services, as long as the version is still supported by QuickBooks®, you do not have to upgrade.
If you aren’t satisfied with the hosting service, you can move to a different hosting vendor or you can move back to your desktop – you’re not tied in – it’s your data and your software.
Challenges
There are a number of areas of the QuickBooks® application which are designed directly in conflict with the concept of a hosted, shared application service model, making QuickBooks® hosting a fairly complicated business.
Installing the correct application licensing levels and multiple editions of the product, allowing individual user settings for printers and forms, and even providing multi-user access are areas where some service providers fall short.
In addition, not all hosting service providers support additional third party applications that integrate with the QuickBooks® software and there may be issues with hardware integration, e.g. scanners, bar code readers and so forth.The biggest drawback of all – no internet, no access.
Conclusion
Hosting QuickBooks® can be a great solution for many businesses. It is best to spend some time in advance choosing the right hosting provider; one that best fits your business needs. If you need help, please call us.
This article of QuickBooks Tips and Tricks was based on the 2013 version of QuickBooks.
We hope you’ll be ringing out a successful financial year at month’s end. Here’s what you should know about preparing for a new year.
End of the year: QuickBooks has been hard at work for the past 11+ months, recording and tracking and storing all of that financial data that you’ve entered so faithfully.
But when you turn the calendar page and make a new start January 1, your accounting software could use some closure on the year that’s just passed. Here are some actions you can take to ring out the old and ring in the new. There’s more you can do (we can help you with the advanced activities) but we’ll just hit the highlights here.
- Reconcile, reconcile, reconcile. Yes, we know it’s not one of your favorite chores, but we really like to see all bank and credit card accounts reconciled by the end of the year if at all possible. Void all checks necessary and enter missing transactions.
Figure 1: You can make yourself crazy looking for a nickel when you’re reconciling, but it’s a critical function.
- Make accrual adjustments. This is complicated, and it only applies if you accrue payroll and liabilities or prepay expenses that are then carried as assets. We’ll need to create journal entries for you.
- Close your books. This is totally optional. It depends on whether you want to lock 2012 data to everyone except those who have the password and permissions. If you don’t close them, you’ll have easier access to last year’s transaction details. Regardless of what you choose, QuickBooks® will automatically make some year-end adjustments.
- Do a physical inventory. Then compare this with what QuickBooks® says. Reports | Inventory | Physical Inventory Worksheet.
Figure 2: It’s good to match up your physical inventory count with QuickBooks® occasionally, and the end of the year is as good a time as any.
- Check W-2 and 1099 data. You can’t create these forms, of course, until after your final 2012 payroll, but you can get a head start. Ask employees to verify their names, addresses and Social Security numbers for accuracy. Also, make sure that your EIN and SEIN are correct, as well as the company address.
- Clean up, back up. We can monitor the health of your QuickBooks® data file anytime. But year-end is a good time to scrutinize your software’s performance. Has it slowed down, started crashing or returning error messages? We can troubleshoot to find the problem and clean it up. We’re sure you’ve been backing up your file faithfully, but archive all of 2012 and store it in a very safe offsite location – or use Intuit Data Protect for online storage.
Figure 3: Frequent backups are critical, but you should be sure to have a copy of your entire 2012 data file stored somewhere safe.
- Double-check tax liabilities. If you’re handling your own payroll, look back to see whether all of your payments and filings have been completed.
Thanks for another year
Again, these are suggestions. QuickBooks® does not require you to do any of them. There’s more you can do, and you will need assistance with some of these. So let’s set up a December or early January meeting to get you started right in 2013.
We want to take this opportunity to thank you for letting us serve your company in 2012. We certainly appreciate your business, and we’re happy to do what we can to help your business prosper.
This article of QuickBooks Tips and Tricks was based on the 2013 version of QuickBooks.
QuickBooks® provides an Audit Trail feature that allows you to see every change that is made to each transaction in the file.
Each time you edit, void or delete a transaction, QuickBooks® posts the previous condition of the transaction to this report. As a result, QuickBooks® retains both the old data and the new data for the transaction.
In QuickBooks® 2005 and prior, this feature was optional and was available to be turned on and/or off in the Accounting: Company Preferences window. It also caused QuickBooks® to run much slower, especially in a multi-user environment and caused the data file to grow faster.
In QuickBooks® 2006 and beyond, the Audit Trail is always on and there is a much more powerful database that supports much larger files and allows you to track information on the Audit Trail without significant loss of performance.
To view the Audit Trail report, select the Reports menu, select Accountant & Taxes and then select Audit Trail.
As the consultant/accountant, it is best to create a user name for yourself so that QuickBooks® will tag all of your entries and edits with your name. After you work on the client’s data, export the Audit Trail report to Excel and save the details in your files. This allows you to refer back to the work you do at any time in the future.
The Audit Trail tracks transaction data only. It does not track changes to transactions that do not impact their accounting integrity. Specifically, it does not track edits to list items, edits to memorized reports, changes to memorized transaction or edits to user access privileges.
The Audit Trail allows you to determine which transactions the user changed or deleted, which user entered the change or deletion and when the user made the change or deletion. It does NOT tell you why.
Any information about the transaction that has been changed is highlighted in Bold Italic type in the report. If there are multiple versions of a transaction, the earliest version will have no highlighting, but subsequent versions will highlight each value that differs from the previous version’s value in that field by displaying the value in bold italics. If a line item was added to the transaction, that entire line of the report will be highlighted.
If the Audit Trail Report displays “Unknown User” under the Last modified by column, the user has been deleted.
The Num column displays the user-specified number for each modified or deleted transaction. This field will be blank if a transaction is ready for printing and has not yet been assigned a transaction number.
The State column identifies whether you are looking at the most recent version of a transaction (the Latest) or an earlier version of the same transaction (a Prior). Transactions may have multiple Prior entries listed, but only one Latest.
This Status (Latest or Prior) is automatically assigned by QuickBooks as transactions are added, deleted, or modified. To view the most current version of the transaction, double-click any field in the Latest entry in the report.
By default, the Audit Trail report is sorted by the user who created or last modified the transaction, the transaction type, and the date the transaction was created or last modified.
To make this report easier to use, you may want to filter it. It is feasible to do this from within QuickBooks® by choosing a different date range from the drop-down list. This presents limited results and may not provide the information you need. For best results, you can Export the Audit Trail report to Excel and use the Find command to locate the specific information.
As always, if you have questions or would like more information about the QuickBooks® Audit Trail or any other QuickBooks® feature, please call us, we would be happy to help.
This article of QuickBooks Tips and Tricks was based on the 2012 version of QuickBooks.
