Quickbooks

Tips for Safeguarding Financial Records

With the 2012 hurricane season now under way and memories of tornadoes and other natural disasters fresh in our collective minds, now is the time for individuals and businesses to safeguard their tax records by taking a few simple steps.

Take Inventory. Gather all of your documents and make an inventory list. You may find everything in a single location, but more likely than not, youâ€™ll have to hunt around to find all of your documents. Don’t forget to check computer files, storage boxes, file cabinets, old and new computers and laptops, thumb drives, and external hard drives and backup disks.

Depending on how complex your finances are, you may opt for a single list or choose to make two separate lists. The first list might include items such as insurance policies, mortgages and deeds, car titles, wills, pension and retirement-plan documents, powers of attorney, medical directives, and so on. The second list might contain a list of less essential documents such as brokerage accounts, loans that have been paid off, end-of-year bank statements, and copies of old tax returns and supporting documentation.

Create a Backup Set of Records and Store Them Electronically. Keeping a backup set of records — including, for example, bank statements, tax returns, insurance policies, etc. — is easier than ever now that many financial institutions provide statements and documents electronically, and much financial information is available on the Internet.

Even if the original records are provided only on paper, they can be scanned and converted to a digital format. Once the documents are in electronic form, taxpayers can download them to a backup storage device, such as an external hard drive, or burn them onto a CD or DVD (don’t forget to label it).

You might also consider online backup, which is the only way to ensure that data is fully protected. With online backup, files are stored in another region of the country, so that if a hurricane or other natural disaster occurs, documents remain safe. Contact us if you need assistance with this.

Visually Document Valuables. Another step you can take to prepare for disaster is to photograph or videotape the contents of your home, especially items of higher value. Call us for more help compiling a room-by-room list of belongings.

A photographic or video record can help prove the fair market value of items for insurance and casualty loss claims. Store the photos or video with a friend or family member who lives outside the area, or as part of your online document backup.

Update Emergency Plans. Emergency plans should be reviewed annually. Personal and business situations change over time, as do preparedness needs. When employers hire new employees or when a company or organization changes functions, plans should be updated accordingly and employees should be informed of the changes.

Check on Fiduciary Bonds. Employers who use payroll service providers should ask the provider if it has a fiduciary bond in place. The bond could protect the employer in the event of default by the payroll service provider.

If disaster strikes, call us right away. We can help you get back copies of tax returns and all attachments, including your Form W-2. We’re here to help.

By Leon Clinton
July 11, 2012

Modifying Reports: Better Insight Into Past, Future

If you make one resolution about improving your accounting procedures in 2012, it should be this: Make extensive use of the tools that QuickBooks offers for report modification. Comprehensive, meticulously-shaped reports that flow out of your carefully-constructed records and transactions are your reward for pounding on the keys every day, conscientiously recording income and expenses.

QuickBooks supplies you with a wide variety of pre-formatted reports whose modification options can help you do focused, critical analysis of your financial data. The right set of numbers will help you understand your history and plan for the future more effectively.

Note: The reports discussed and pictured here shows only one possible set of customization options. There are many variations. We can answer your questions.

Check your preferences

When you created your company file in QuickBooks, you chose between reporting on a cash (income and expenses are recorded when money changes hands) or accrual (recorded when you invoice or receive a bill) basis. This affects summary reports, but not those that break out individual transactions or are simply lists.

If you want to change this, click Edit | Preferences | Reports & Graphs | Company Preferences and click the desired button:

Figure 1: You can establish a preference for your summary reports’ basis here.

You can set other preferences in this window that will affect your report output here, too, as you can see.

Altering the display

Open the Income by Customer Summary report (Reports | Company & Financial). Change the dates to reflect a range you’d like to see. Want the data displayed by different time increments — like week or quarter — instead of just the total? Click the arrow next to Columns and select Four week.

Figure 2: You can do some report display alterations from this toolbar; the options it offers vary by report.

By default, your report rows display alphabetically. If you want to view a column by total in ascending or descending order, select the column by hovering over the top number until the magnifying glass appears, and click on it. Click the arrow next to Sort by and choose Total, then click the AZ [down arrow] icon (in some reports, there will be other options here).

Additional options in this toolbar let you:

Memorize the report
Print, email or export it to Excel
Hide or Show the Header
Collapse or Expand the columns
Refresh the report if you’ve made changes that will alter data

More display options

Click Customize Report to open this window:

Figure 3: This window outlines your report’s content options.

Some of the options here duplicate what you saw in the toolbar. In addition, you can switch between Accrual and Cash for just this report, and add subcolumns in some. The latter is a complicated operation, one that you must understand well in order to glean any insight from it. We can help you with this.

Sometimes the subcolumns are generic, as shown in the screen above. In other reports, they’re very specific to that group of data.

Clicking on Revert takes you back to the default format, and Advancedopens additional options specific to the current report.

More customization = more insightful results = more informed financial choices

Transaction reports have many similarities and two major differences: You can change the column order by hovering your cursor over the column label until a hand appears. Click, hold and drag the column to the desired spot and let go. You can also add or delete columns by clicking Customize Report and checking or unchecking labels.

Figure 4: In transaction — or detail — reports, you can alter the column structure.

Learn the mechanics of report display modification well, and your company’s finances will come into much sharper focus, improving the wisdom of future choices. Up next month: filtering your reports for additional clarity.

If you have questions on this or any other QuickBooks feature, call or email us. We’re your partner and we’re here to make your business better.

QuickBooks Tips And Tricks: Make it Yours

No matter which version of QuickBooks you’re using, there are always ways to make your workday easier. As with any software, we tend to learn the features we need and not much more. But small changes in the way you operate can add up to significant time savings and more accurate files. If you jumped into QuickBooks without a thorough introduction, consider these tips.

Use the Open Window list

Spend some time in Preferences, and you’ll be surprised to learn that you have more flexibility than you knew. QuickBooks is designed to work for a tremendously wide variety of businesses, so it comes with some features activated but many dormant.

The Open Window list is a good example. Do you tire of closing windows to find a screen that you used several tasks ago? Make sure that you’re in one-window view (View | One Window), and then click View | Open Window List. Click on any entry to move to that page.

Make account assignment mandatory

QuickBooks lets you enter transactions without assigning them to accounts. So your Chart of Accounts has two accounts labeledUncategorized Income and Uncategorized Expenses that serve as repositories for these transactions. This means that when you run reports or prepare for taxes, you may have a hard time remembering the circumstances of those transactions and will find it difficult to assign them to accounts.

Do yourself a favor. Set up QuickBooks so that you must assign an account to every transaction. This will take extra time upfront, but not as much as if you try to recall the transaction three months from now. Go to Edit | Preferences | Accounting | Company Preferences and make sure that Require Accounts is checked. If you have questions on this, please call or email us.

Use the Account Prefill fields

Speaking of accounts, here’s a little time-saving tip. If you have vendors that are always assigned to the same account(s), you can establish this constant in the vendor record. Simply open the Edit Vendor window for a client and click the Account Prefill tab. Select the appropriate selection(s) from the drop-down lists. If a payment is sometimes split between multiple accounts, you’ll handle this division when you add transactions.

Use “Pending Sales”

Invoices, sales receipts and credit memos can be earmarked as “pending.” These sales do not show up in registers or reports (except for the Pending Sales report) and can’t be used for transactions where payment has already been applied. Create the transaction and click Edit | Mark [form name] As Pending. To finalize it, open the form and clickEdit | Mark [form name] As Final.

This action can be useful in multiple situations, including:

Backordered items
Draft approvals
Estimates
Time-tracking for jobs
Profit and loss reports that show the impact of pending sales (choose Either as the posting status [Non-posting or Posting]under Filters)

Be kind to your accountant: Set a closing date

Once we’ve worked with your QuickBooks file up to a certain date, entering, editing or deleting transactions prior to that date wreaks havoc with the balance of your books. To be safe, your administrator should password-protect the ability to do this, so that no one does this intentionally or unintentionally. Go to Edit | Preferences | Accounting | Company Preferences and enter a closing date and password. We will change the date each time we complete our work.

These are just a few examples of ways you can customize QuickBooks to make your workdays more productive and your record-keeping safer and more reflective of your business. We can help you further tailor the software to make it a better fit.