Blog

Setting a Company File To Open In Multi-User Mode

quickbooks-logo-2Have a company file that you want to automatically open in multi-user mode each time you fire up Quickbooks? While you can always open files manually in multi-user mode, Quickbooks comes with the option to set choose multi-user mode as default. Toggling on this option will automatically open the respective company file in multi-user mode; thus, saving you time and energy. If this is something you are interested in doing, keep reading to learn more about setting a company file to open in multi-user model.

Note: by default, Quickbooks opens company files in single-user model. This is done to ensure the security of sensitive data. Of course, there are a number of instances where multi-user mode is preferred. In just a few minutes, you can modify the default settings of your Quickbooks account to automatically open company files in multi-user mode.

After logging into your Quickbooks account, select the ‘File’ option from the main menu, followed by ‘Open or Restore a Company File.’ Choose ‘Open a Company File’ from the available options and click ‘Next.’ You will now see a list of all your company files. Scroll through the available options until you find the one that you want Quickbooks to automatically open in multi-user mode. Highlight the respective company file, and at the bottom of the screen you’ll see a box labeled ‘Open in Multi User Mode.’ Click this box followed by the ‘Open’ option. Congratulations, you’ve just set your company file to automatically open in multi-user mode each time you launch Quickbooks! You’re no longer forced to go through the task of manually opening your company file in multi-user mode each time there are multiple people working on it.

Opening a Company File Manually In Multi-User Mode

Since we’re on the subject, let’s go over the steps of opening a company file manually in multi-user mode. The process is pretty much the same as choosing Quickbooks to automatically open company files in multi-user mode; select the ‘File’ option from the main menu, followed by ‘Open or Restore a Company File.’ The difference, however, is that you’ll now want to choose the option to open a company .QBW. From here, you can select the appropriate file and whether to open it in single-user or multi-user mode.

Choosing to open company files in multi-user mode allows multiple people to work on the same file. Whether your business is small, medium or large, you may find yourself in need of this option. Thankfully, Quickbooks makes toggling between single and multi-user modes a breeze.

How Turn an Estimate Into an Invoice?

reciept-1-300x225Many business owners will find themselves in need of converting an estimate into an actual invoice for their Quickbooks account. After sending a price estimate to a customer for a product or service, they will either accept or deny the quote. If they deny the estimate, there’s no additional steps necessary on your part. If they accept the estimate, however, you’ll need to convert it into an invoice; otherwise, it won’t factor into your Quickbooks account properly. Keep reading to learn the basic steps of converting an estimate into an invoice.

Step #1) Locate The Estimate

The first step in converting an estimate into an invoice is to locate the estimate in your Quickbooks account. With your Quickbooks account open, click the ‘Customer Center’ tab on the main menu. It’s important to note that you must have the estimates feature turned on in order to locate past and current estimates. You can refer to this guide located at Intuit.com for more information how to toggle on and off the estimate feature.

After selecting the ‘Customer Center’ from the main menu, click the ‘Customers and Jobs’ tab. You should now see a list of all the respective customers and clients associated with your Quickbooks account. Scroll through them until you find the client connected to the estimate. Click on the client and locate the estimate.

Step #2) Creating The Invoice

The second step is to create the invoice. Assuming you followed the steps previously mentioned, you should see a button titled ‘Create Invoice’ above the client details box. Click this button and adjust the invoice as needed. This option allows you to manually enter in the desired amount for the customer’s invoice. As long as the customer accepted your previous estimate, you should be able to use this same number. If they countered with another number, though, you’ll have to use it instead.

Please note that Quickbooks users with ‘Progress Invoicing’ turned on will have to enter additional information during this step. Progress Invoicing is a slightly more complicated and time-consuming option which allows for greater transparency, so there are a  couple extra dialogs and options to choose from when creating a customer’s invoice.

Step #3) Save & Exit

As with any major change or update in your Quickbooks account, double check the changes to your invoice before clicking save. You can always go back and modify invoices later, but taking a minute to double check them before saving will ensure your account is properly balanced and accurate.

How To Change Account Type

paycheck-void-1-480x321So, you just realized that you’re using the wrong account type when recording transactions in Quickbooks. Now what should you do? The good news is that Quickbooks makes it easy to switch out different account types. And even if you initially used the wrong one, you can go back and correct the mistake in just a few simple steps. Taking the time to fix these errors now will ensure your accounting goes smoothly and without any discrepancies.

Note: there are certainly restrictions placed on changing account types. These restrictions are in place to maintain the integrity of Quickbooks. See the list below for a brief outline of account-changing restrictions.

  • Accounts receivable and accounts payable are not changeable.
  • If the account type was automatically created by Quickbooks, you cannot change it.
  • Subaccounts can’t be changed; however, a simple fix to this problem is to drag them to a new location.
  • Accounts can only be changed one at a time.

Another Note: always back up your Quickbooks data before changing account types. While this typically won’t cause any issues with your Quickbooks data, it’s always a good idea to have a full backup in the event of data corruption. Some users may not want to spend the additional time and energy to create a full backup before changing their account types, but doing so will give you the peace of mind knowing that your data is 100% secure and protected from failure.

Changing Account Types

To change account types, fire up your Quickbooks and visit the “Chart of Accounts” section and select the account you wish to change. If you look down at the bottom of this screen, you’ll see a list of available options for changing your account types. The first option available is “Options.” Click this button and choose “Edit Account” from the drop-down menu. After doing this, proceed to the next step listed below.

After selecting the “Edit Account” option, you’ll be able to specify the type of account used in your Quickbooks. Click “Account,” followed by the appropriate ‘type’ of account you wish to use. Double check this option to ensure it’s the desired account type and select “Next.” Quickbooks will now associate the Chart of Accounts with this new account type. Even if you previously entered an item under a different account type, you can easily go back and adjust it using this method.

What Is a QBM File?

usb-flash-1Have you come across Quickbooks files with a QBM extension? Regardless of which Quickbooks version you are using, QBM files are oftentimes used to move data safely and efficiently. Unfortunately, many inexperienced Quickbooks users overlook this key feature, resorting to full backups instead. While backing up all of your Quickbooks data is one alternative method for temporarily moving it, using QBM files is easier and takes less time. To learn more about QBM files and how they work, keep reading.

QBM Files 101: The Basics

First and foremost, it’s important to understand what exactly QBM files are used for, as many people confuse them with full-size backups. While they both backups and QBM files are used to transfer Quickbooks data, there are major differences between the two that shouldn’t go unnoticed. Backup files are significantly larger in size, containing logos, images, letterheads, templates and more. On the other hand, QBM files are a stripped-down version of a backup, containing the core data without transaction logs and other unnecessary files.

Because they are smaller than full-size backups, QBM files can be transferred to USB flash drives or other portable storage devices. One of the issues some Quickbooks users face is trying to move their full-size backup files over to portable storage device. The enormous size of these files is oftentimes more than standard USB flash drives are capable of holding. Thankfully, this isn’t a problem with QBM files, as their stripped-down design takes up a fraction of the space as a full-sized backup.

Note: only users with administrative access can create a QBM file. If you’re looking to create one, make sure you are logged in as the administrator. This is necessary to ensure the security and privacy of sensitive Quickbooks data.

How To Create a QBM File

Creating a QBM file is a fairly easy and straightforward process that should only take a couple of minutes to complete. While you are logged in as the administrator, click on “File,” followed by “Create Copy.” Scroll through the available options and choose “Portable Company File.”

One of the great things about creating a QBM file is that you can save it directly to a USB flash drive, hard drive, or portable storage device. After selecting the option to save your copy as a “Portable Company File,” choose the destination of your file and click continue. When the process is complete, your new QBM file will be located in the specified destination.

How To Identify and Fix Quickbooks Errors

codeOne of the many reasons why Quickbooks is the leading business accounting software in the world is because it’s such a powerful, versatile and easy tool to use. Whether you run a small or large business, you can easily perform all of your transaction and accounting tasks with Quickbooks. And while the chance of this happening is rare, some users may experience an error message from time to time. It’s downright frustrating when you spend hours working on your account only to discover an error message popped up on your screen. The good news, however, is that errors in Quickbooks are fairly easy to identify and fix more.

Error With ‘qbregistration.dat‘ File

Have you noticed an error message in your Quickbooks account associated with a particular file named qbregistration.dat? This is one of the most common Quickbooks-related errors, but the message alone doesn’t provide much information as to what’s causing it or how to fix it. qbregistration.dat is a registration file found within the core files of Quickbooks. Most users experience this message when they initially load Quickbooks. The loading screen appears and transitions into an error message rather than the home screen.

So, how do you fix the dreaded qbregistration.dat error? Assuming you are using either Windows Vista, Windows 7 or Windows 8, Intuit recommends users first attempt to fix this error by toggling the account control settings. Please refer to this ‘how to’ article published by Intuit for specific instructions on toggling the account control settings. After performing this operation, restart your computer and attempt to run Quickbooks. If toggling the account control setting worked, Quickbooks should fire back up without displaying the error message. If it didn’t work, you’ll need to completely remove and reinstall Quickbooks. Assuming your data is backed up either locally or on the cloud, your files should remain intact.

MSXML Errors

Another common type of error in Quickbooks is related to MSXML. This problem actually goes hand in hand with the previously mentioned error, as they are both associated with the registration files. If MSXML isn’t installed on your computer, or if it’s damaged, you may experience this message. The easiest way to fix it is by download and running the MSXML repair tool here. If this doesn’t work, remove and reinstall MSXML on your computer. As long as MSXML is operating correctly, you shouldn’t experience this error message.

How To Use The Rebuild Data Tool

tools-2Quickbooks is the world’s most popular business accounting software, and for good reason; it’s versatile, packed with features, offers an easy-to-use interface, and it can handle accounting tasks of all sizes. However, some users may experience certain error messages when using Quickbooks. In the rare event that you notice an error message on your screen, you should run the ‘rebuild data tool’ to resolve the issue. In this post, we’re going to walk you through the steps to using this tool.

When To Use The Rebuild Data Tool

It’s important to note that the rebuild data tool isn’t designed for all types of errors and problems. Beginners oftentimes use it as a ‘catch-all’ fix for their Quickbooks-related problems, but this typically doesn’t work. See below for a list of instances when using the rebuild data tool would prove useful:

  • Error message displayed on screen advising you to run the rebuild date tool.
  • Damaged data error message displayed on screen.
  • Troubleshooting your problem through the built-in knowledge base suggests you run the rebuild data tool.
  • Quickbooks customer support agent advises you to run the rebuild data tool.
  • Forms containing errors or coding problems.
  • Reports containing errors or coding problems.

Before Running The Rebuild Data Tool…

It’s imperative that you back up all of your Quickbooks data before running the rebuild data tool. Nine out of ten times the tool will run perfectly fine without  any issues arising; however, some users may experience data loss from using the tool. And if your data isn’t backed up beforehand, you could find yourself starting back at square one. It only takes a few minutes to back up your Quickbooks data to either a disk or the cloud, so make sure you do this before running the rebuild data tool.

Running The Rebuild Data Tool

It’s recommended that you run the rebuild data tool on your local workstation and not over your network. You can view Intuit’s step-by-step walkthrough located here, but the process is pretty self-explanatory. With the tool installed, run it on your computer and it will automatically search and fix various errors. Depending on the size of your account along with the speed of your machine, the rebuild data tool may take anywhere from 15 minutes to several hours to complete (sometimes even longer). Under no circumstances, however, should you exit the program early, as this may cause corrupt data.

Quickbooks Web Connector 101

internet-sign-1-480x360Quickbooks Web Connector is a versatile tool which allows web-based Windows programs to exchange data with Quickbooks. When used correctly Web Connector can drastically improve your accounting tasks by performing some operations automatically. With that said, this tool isn’t for everyone. Depending on the structure of your business, you may or may not need to use Quickbooks Web Connector. If you’re interested in learning more about this tool and what it does, keep reading.

Should I Use Web Connector?

Web Connector is a completely free tool that comes with Windows versions of Quickbooks. You can download the tool by clicking here. Once the download has finished, run the exe file to install it on your computer. As previously stated, however, Quickbooks Web Connector isn’t for everyone. If your business relies strictly on local and/or brick-and-mortar sales, then you probably won’t need to Quickbooks Web Connector. Local businesses can perform all of their accounting tasks manually by entering the transaction information directly into their account.

On the other hand, businesses in the e-commerce field will certainly find Quickbooks Web Connector to be a versatile and useful tool. Web Connector operates by opening lines of communication between Windows operating systems and Quickbooks. If you run an e-commerce website, Web Connector can automatically record transaction when a customer makes a purchase. This is incredibly useful since you are no longer forced to log into your account and make changes each time a purchase is made. With Web Connector set up and running, it will handle tasks such as this for you.

Advantages

The advantages of using Quickbooks Web Connector are pretty clear — it handles some web-based transactions by recording them into your account.  In turn, this saves you both time and energy since you don’t have to worry about recording transactions made through your website. And since Web Connector is a free-to-use tool, you don’t have to worry about coughing up extra money to install it. Just click on the link mentioned above to download Web Connector directly to your computer. As long as you have an active Quickbooks account, you can run Web Connector to link your account with your computer.

Disadvantages

The only real disadvantage associated with Web Connector is its somewhat complicated setup. New users may run into problems trying to run the program. If you’re having problems with Web Connector, don’t be afraid to reach out to a professional for help.

 

Quickbooks Enterprise: Essential Tips and Tricks

enterprise-1Enterprise is the most versatile and flexible version of Quickbooks available, offering a wide range of features along with improvements from other versions. If you own a medium-to-large sized business, this is hands down the most effective type of account software. With that said, trying to make your way around the system can be confusing for first-time users. In order to effectively perform accounting work in Quickbooks Enterprise, you’ll need to familiarize yourself with some basic tips and tricks.

Why Choose Quickbooks Enterprise?

First and foremost, let’s go over some of the benefits of choosing Quickbooks Enterprise. The truth is that some businesses don’t need all of the features offered with this ‘higher-end’ version of Quickbooks. If you run a small-sized business, Quickbooks Simple Start, Essentials or Plus will likely meet all of your needs while saving you some money in the process. However, larger businesses with more clients and transaction require a more complex system of accounting, in which case Quickbooks Enterprise is the right choice.

Here’s a short list of some of the many benefits of choosing Quickbooks Enterprise:

  • Scales from 1-30 users
  • Ability to track hundreds of thousands of customers, transactions, items and more
  • Fully customizable reporting tool
  • Managed hosting service
  • Choose from a wide variety of exclusive add-ons which are only available for Quickbooks Enterprise
  • Purchase comes with a full one-year service plan

Learn The Shortcuts

I can’t stress enough the importance of learning the keyboard shortcuts in Quickbooks Enterprise. Like all versions of Quickbooks, Enterprise incorporates a wide variety of shortcuts designed to save the user time. While there’s no rule stating that you must use them, keyboard shortcuts will certainly make your life easier while saving you time in the process. You can read through some of our previous blog posts here at myvao.com for more information about shortcuts, but they are basically designed with the “Ctrl” key along with a specific letter. For instance, “Ctrl+I” instantly creates a new invoice, while “Ctrl+F” opens the Find window.

Reconcile, Reconcile, Reconcile!

Of course, you’ll want reconcile your Quickbooks Enterprise accounts on a regular basis to eliminate any potential accounting discrepancies. No matter how hard you try to prevent it, errors are bound to occur, especially in large-scale accounting projects tied to Quickbooks Enterprise. The good news is that users can easily identify and fix discreteness through the reconciliation process, which is a built-in feature in Quickbooks Enterprise.

Steps To Setting Up an Itemized Expense

old one dollarQuickbooks is designed to make business accounting a breeze. Whether you run a small, medium or large-sized business, this versatile software allows anyone to perform their own accounting work. Of course, this is why it’s the world’s #1 business account software. Once you are familiar with its interface and features, you’ll be able to seemingly perform transactions, reconciliations, customer invoices and much more. However, first-time Quickbooks users may run into some hurdles as they attempt to perform basic task like setting up an itemized expense. In this post, we’re going to walk you through the steps to setting up an itemized expense in Quickbooks.

Step #1) Access Quickbooks

The first step in setting up an itemized expense is to log into your Quickbooks account and access the home screen. If you have multiple accounts, make sure you signed in under the account connected to the expense; otherwise, it will create an erroneous entry in the alternative account. From the home screen of the appropriate account, select “Chart of Accounts” from the Company menu. Depending on the particular version of Quickbooks you are using, this should be located in the top right corner of the home screen.

Step #2) Chart of Accounts

After selecting “Chart of Accounts,” click on “Accounts” followed by “New.”  Next, click on the button labeled “Expense” followed by “Continue” to add the entry to your account. This will begin the setup process of adding the new itemized expense to your Quickbooks account. Quickbooks gives you the option of naming your expense anything you’d like. If the itemized expense is for a Los Angeles business trip, then perhaps you could label it “LA Business Trip.” It’s recommended that you choose a name which relates to the type of expense, as this will help you better identify it in the future. Finish the setup process by selecting “Save & Close” and the expense will be added to your account.

Step #3) Adding Debits

With the expense now added to your Quickbooks account, you can now select this new expense anytime you enter a debit from the check register. If a certain debit falls under this category, be sure to choose it from the check register. There’s no limit on how many transactions/debits you can add to an expense. With that said, it’s usually best to keep them to a minimum in order to better organize your transactions.

Quickbooks Tips and Tricks For Beginners

quickbooks-2Quickbooks is hands down the most versatile accounting software in the world. Whether you run a small, large or medium-sized business, Quickbooks is able to perform all of your accounting needs accurately and effectively. However, it’s enormous amount of features creates a slight learning curve for first-time users. If you’re new to Quickbooks, you may run into some hurdles initially. To help you make the most of your Quickbooks accounting software, we’ve compiled a list of some important tips and tricks for beginners. While you may already know some of these tricks, chances are there are others that will surprise you.

Increase Font Size

Is the default font size too small for you to efficiently read? Adjusting it is kind of tricky, especially if you’ve never done it before, but it should only take a minute or two to accomplish. To either increase or reduce the font size of your Quickbooks software, open up the QBW.INI file located in your Quickbooks folder. Its exact location varies depending on the particular version you are using, but you can search for it using the “find” command on your computer. Once the file is located, open it with Notepad and edit the “Font Size” to your preferred amount. Go to “File” and click “Save and Close.” Voila, Quickbooks will not display text in the appropriate size specified in this file.

Use Shortcuts

If you aren’t taking advantage of shortcuts in Quickbooks, you’re missing out on one of the easiest ways to improve your accounting efficiency. There are literally dozens of keyboard command shortcuts available for Quickbooks, all of which are excellent for bypassing certain areas. For instance, you “Ctrl+I” instantly opens a new invoice window, while “Ctrl+R” opens the register menu. Familiarize yourself with all of the Quickbooks shortcuts to improve your efficiency. You read through some of our previous blog posts for more information on how to use shortcuts.

Reconciliations

You should try to get into the habit of reconciling your Quickbooks account on a regular basis. I guess you could say this process is similar to balancing a checkbook. You’ll go through all of the transactions to ensure each and every one matches up appropriately. If there’s a transaction off, you’ll need to find out what’s causing the discrepancy. Allowing errors to dilute your Quickbooks account can lead to disastrous consequences, so make sure you are reconciling your account on a regular basis.

LAYOUT

SAMPLE COLOR

Please read our documentation file to know how to change colors as you want

BACKGROUND COLOR

BACKGROUND TEXTURE