accountant

Backup or Portable Company File? How to Decide

When you think about it, it’s pretty amazing that Intuit is able to pack the lion’s share of your financial data into one giant company file. It certainly makes it easier to separate from QuickBooks and move when necessary.

There are actually three options for saving and relocating that file. You know about backups, since you should be producing them religiously. You generate them so that if QuickBooks — or your computer itself — stops working or your file becomes corrupt, you can re-create the entire environment. Portable company files are more limited, and are best used when you want to save your file to a temporary location and/or email it to someone else.

You would only use an Accountant’s Copy, of course, when you want us to check your progress. We’ll work with you on setting this up.

Figure 1: Once you save and send off an Accountant’s Copy, you can’t work on transactions created before the dividing date.

The Critical Backup

We can’t emphasize this enough: Losing your financial data can be the beginning of the end of your company. You won’t know what you’re owed, so you’ll be unable to collect. You’ll miss vendor payments. Payroll will be impossible to reconstruct, and you won’t be able to submit payroll taxes. And how will you know what your income tax obligation is?

It can happen to you.

QuickBooks simplifies this process. Click File | Create Backupâ€¦ You’ll be asked whether you want to back up locally — to a network folder or thumb drive, for example â€“ or to the cloud, using Intuit Data Protect (fees apply). If you select the local preference, click onOptions to designate a location in this window:

Figure 2: Choose from options in this window to create a backup profile.

Click OK, then Next. QuickBooks will ask when you want to save your backup copy and offer scheduling options. When you’re done, click Finish.

Warning: If you’re using Intuit Sync Manager, there are special rules about copying the company file. Let us help you handle this safely.

Just the Facts

Portable company files are more compact than backup files, so they can be easily e-mailed as attachments or copied onto another computer. But they don’t contain everything that backups do. They lack, for example, letters, logos, attachments, images and templates. Don’t use this option if changes will be made, since they can’t be merged back into the file.

Be sure to create a current backup before you begin to move your file.

To save a portable company file, click on File | Create Copy (you can do this to copy any kind of file, actually). This window opens:

Figure 3: Click File | Create Copyâ€¦ to access any of QuickBooks’ three options.

Select Portable company file and click the Next button. In the following window, you’ll browse to a location for your file. QuickBooks will already have entered the name and will save your data in .qbm format. Click Save, then OK when QuickBooks tells you it must close and reopen your file first. Click OK again when you’re told that the file has been created.

Opening the File Elsewhere

When you’re ready to open the file at another location, click File | Open or Restore Companyâ€¦ In the window that opens, select Restore a portable file. The Open Portable Company File window opens; make sure that the file’s location is displayed in the Look in: field. Click Open. QuickBooks then asks where you want to restore the file.

The following step is critical. Rename your file unless you want to overwrite your current company file. You can add a date or some other identifying information like a version number.

Click Save. QuickBooks will convert your portable file to a standard company file with a.qbw extension.

QuickBooks makes it easy to create copies of your data, but an error here can threaten your company’s future. We can help ensure that that doesn’t happen.

Turn Over a New Cliche: Adopt Best Practices

Turn over a new leaf. Make a New Year’s Resolution. Make a fresh start. Get your ducks in a row. All familiar cliches, but their message is valid: At this time of year, you probably feel like renewing your commitment to running a more successful, productive business.

There are numerous ways to do this, but you might consider adopting the concept of best practices (if you haven’t already). Most industries have them, primarily larger businesses. Best practices are a set of operational guidelines that are expected to produce a favorable outcome. Run your business using these techniques or methods, and you’re likely to be more successful.

Accounting has best practices. While they’re not carved in stone, sticking with some tried-and-true, common-sense procedures will likely lead to increased efficiency. Perhaps adopting some or all of them will make a difference in your business. QuickBooks can help.

The Three I’s

Let’s look at the three stages you’ll encounter when you decide to apply best practices to your company.

Identify

What problems are you trying to solve? Where are your bottlenecks? Are collections a problem? Cash flow? Timely, accurate payroll? Have you seen a reduction in your customer base? Are your bills being paid late? Having trouble keeping up with inventory?

Bring your employees in on this process. They’re on the front lines, and will have insight into where your systems are breaking down. They’ll be pleased to be asked, and they may have ideas that will evolve into best practices.

Figure 1. When you’re formulating ideas that could evolve into best practices, use your best resource: your employees.

Implement

Turn your ideas into policies, and formalize them. Make a big deal out of introducing them to all staff related to accounting, and explain the rationale behind them. They’re intended to improve your company’s financial bottom line, which should translate into a positive outcome for everyone. Don’t turn your presentation into a critique of past performance; emphasize the constructive nature of the changes. Put it in writing, too.

Here are some examples of best practices that other businesses have implemented.

Invoice at the time of service/shipment, instead of once or twice monthly.
Set a specific time interval to deal with collections, like once a week. If you’re running QuickBooks 2011, you can use the Collections Center. Previous versions have numerous helpful reports, like A/R Aging Detail, Open Invoices, and Collections Report.

Figure 2. QuickBooks 2011 features the automated Collections Center.

Estimate your income tax obligation monthly, not just quarterly. When payments come due, there won’t be any major surprises.
Make sure everyone who works with accounting has a backup person who can fill in. Consider having us do the training.
If you don’t have a merchant account – which QuickBooks supports – get one, and encourage customers to pay in this fashion. Pay your bills the same way wherever possible. Use all of the technology that makes sense for you.
When it’s logistically possible, have employees who incur billable time use a timer. A few minutes lost here and there adds up. QuickBooks has a built-in timer; remote employees can use Time Tracker.

Figure 3. Have employees time billable activities whenever possible.

When was the last time you looked at your pricing structure? Are you building in enough profit? Evaluate your selling ratios on a schedule. Run inventory reports regularly.

See? It’s not rocket science. It’s a matter of emulating the practices of the most successful businesses. You might network with other companies to see how they handle this formalizing of processes. Talk to us, too.

Insure

Don’t leave it at that. Evaluate the effectiveness of the new best practices by scheduling follow-up meetings with employees. What’s working, and what isn’t? Do you need to tweak your methods?

This step is absolutely critical. You might want to appoint a compliance officer who follows up with individual employees and departments. If your business is small and informal, you could bring in lunch one day a month for follow-up – and for the development of new best practices.

Not just for mega-companies

You may already know something about best practices, but have always assumed that the concept was designed for big business. While it may be more of an imperative for large companies, even a sole proprietor with a bookkeeper can benefit. It’s really just a matter of putting the most effective work processes into place and maintaining them. Implementing best practices can be a good first step towards a more successful 2011. Call us if you have any questions.

Using the Add/Edit Multiple List Entries Feature

Data entry and modifications in QuickBooks can be tedious. Beginning with QuickBooks 2010 Pro Edition and above, that job got a lot easier. The Add/Edit Multiple List Entries tool does just what its name implies: It lets you add entries to your lists of customers, vendors, services, inventory parts, and non-inventory parts. It also makes changing one or several of them quick and easy.

Using this feature, you can:

See customized views of your list data
Enter missing information
Create new entries from duplicates of existing ones
Do a mass change of a whole column
Copy and paste records from Excel

There are myriad applications for this tool. You could use it, for example, when you’re changing Preferred Vendors for a group of items and you don’t want to have to edit each individual item record. Or when the area code for select customers or vendors has changed. You could use it if you’re adding an inventory item that’s just slightly different from another, or when your accountant tells you to change the name of an account.

Building the perfect view

To get started, click Lists | Add/Edit Multiple List Entries. In the screen that opens, click the arrow next to the List box and select the type of data you want to see, like Customers. Then select the group that you want displayed by dropping the View list down. Click the Customize Columns button. This window opens:

Figure 1: Make sure your columns are correct and in the right order.

The list on the left represents all possible column labels. To make the list on the right reflect what you want to see in your table, highlight the correct item and use the Add or Remove buttons and the Move Up or Move Down buttons. When you’re satisfied, click OK. The table will change to display those columns in that order.

TIP: You may have a lot of empty space between columns. To close those gaps, put your cursor on the faint vertical line that separates two column names. A cross-like symbol will appear. Drag it left or right until the columns are positioned well.

Let’s say that a customer commissions a new job. Since so much information will remain the same as in previous jobs, you can duplicate her record. Highlight the last entry in her list of jobs and right-click. Select Duplicate Row. The new entry will contain her default information, except the name will change to DUP [NAME OF PREVIOUS JOB]. Change that phrase to the name of the new job and click Save Changes if you’re done.

Figure 2: It’s easy to duplicate an entry’s information.

Mass changes

You may occasionally want to make the same change to a subset of records. Say a city’s zip code changed and you want to find the customers affected. You’d open the Customers list, click on the View arrow and select Custom Filter. Then:

In the Search list, choose from All, Active, etc.
In the For box, enter the common attribute, like the zip code.
Click on the arrow next to the in box, and tell QuickBooks where you want to search (address fields, all common fields, etc.).

Figure 3: You can search for a group of entries that share a common characteristic.

Click Go. QuickBooks will display a list of all of the matching entries.
Make your change to the entry at the top of the list, then right-click on it. You’ll see this menu:

Figure 4: The Copy Down command changes all entries in a column to match the top one.

When you select Copy Down, all of the entries duplicate the first one in the list.

Some housekeeping

Anything you change in these views, as long as you click Save Changes, will be reflected throughout QuickBooks, wherever that record appears. If you’ve made an error, like using a dollar sign, you’ll get a message telling you to fix it.

You can use Add/Edit Multiple List Entries in other ways. For example, it’s a good way to see how thorough your recordkeeping is. Take a look at your lists occasionally to spot missing data. Or say you were at a trade show and signed up new customers, but you didn’t have QuickBooks on your laptop so you entered them in Excel. Once you’ve made sure that your column names and order in Excel match those displayed in Add/Edit Multiple List Entries, you can just copy and paste the new customers in.

This feature is easy to use, but be cautious. We can help with complex modifications. Add/Edit Multiple List Entries is one of the ten best features QuickBooks has incorporated in recent years. It’s an easy way to get a birds’ eye view of your lists, and a great time-saver.

Backup or Portable Company File? How to Decide

The Critical Backup

Just the Facts

Opening the File Elsewhere