Ringing Out 2016 in QuickBooks

2017 is just around the corner. Now’s the time to do your end-of-year QuickBooks tasks.

Since early January of this year, you’ve been faithfully creating new records, entering transactions, and recording payments. You’ve run basic reports. You’ve done your collection duties. You may have paid employees and submitted payroll taxes.

Now the end of the year is rapidly approaching. In the midst of holiday get-togethers, gift shopping, and perhaps preparing for travel, you probably have a list of work tasks that must be completed by December 31.

Is your annual QuickBooks wrap-up on that list? It should be. Here are some of the things we suggest you fit into your busy schedule sometime this month.

Create and send year-end statements.

QBC 1216 image 1_zpsug8f4wl3.jpg

As your customers wrap up 2016, too, it’s good to send statements to past-due accounts.

In an ideal world, all of the invoices that are currently due would be paid off by the end of the year. We all know that that’s not usually the reality. Two reports can help you here: the A/R Aging Summary and Open Invoices.

Give everyone a chance to clear their accounts before December 31 by sending statements. Click Statements on the Home page (or Customers | Create Statements) to open the window pictured above.

You have multiple options here that are fairly self-explanatory. The screen above is set up to create statements for all customers who have an open balance as of the date you select, but not for inactive customers or those with a zero balance or no account activity. That way, no one who’s paid in full to date will receive a statement. Of course, if you didn’t want statements created for anyone who’s less than 30 days past due, you’d click in the box in front of Include only transactions over and enter a “30” in the following field. Questions about all of this? Give us a call.

Tip: You can also find out who’s overdue by clicking on the Customers tab in the left vertical pane to open the Customer Information screen. Click on the down arrow to the right of the field just below Customers & Jobs. QuickBooks provides several filters for your list.

Reduce your inventory.

QBC 1216 image 2_zpsgjjxfwy6.jpg

Want to discount all or selected items in your inventory by the same percentage or amount? Open the Customers menu and click Change Item Prices. We can work with you on the whole item pricing process.

The week between Christmas and New Year’s Day might be a good time to sell excess inventory by having a sale. If you only sell a few products, you probably know what hasn’t sold well in 2016. If your stable of products is larger, you can run QuickBooks reports like Inventory Stock Status by Item and Sales by Item Detail to identify your slow-sellers and discount them. You may need to filter your reports to see the right data. Talk to us about customization options if you’re unsure of this.

Clean up your contact lists.

If you don’t maintain your customer and vendor lists, you’ll eventually start wasting time scrolling through them when you enter transactions. So this would be a good time to QBC 1216 image 3_zpseoaaqacx.jpgdesignate those contacts that you’ve not dealt with in 2016 as Inactive (you can delete their records entirely, but we advise against that). Simply open a Customer record, for example, and click the small pencil icon in the upper right to edit it. Click on the box in front of Customer is inactive.

Send holiday greetings to customers and vendors.

It’s getting a little late to send a holiday greeting/thanks-for-your-business note in December. Consider doing this in January (Best Wishes for a Successful 2017!) when your customers’ and vendors’ lives have slowed down a bit. You’re less likely to get lost in the crowd. If your lists are short enough, personalize these cards as much as possible. At least sign them by hand if you can.

Tip: You can print customer labels for your cards directly from QuickBooks. Open the File menu and then click Print Forms | Labels.

Run advanced reports.

Here’s where we come in. If we’re not already creating and analyzing QuickBooks’ advanced financial reports (found in the Accountant & Taxes submenu of Reports) monthly or quarterly, talk to us about it. They’re important, and they give you insight that you can’t get on your own. This is another activity that can spill into January.

We’d like to thank you for being a client this year, and to wish you a successful 2017!

Stock image courtesy of FreeDigitalPhotos.net

About Brenda J. McGivern, CPA

Brenda McGivern started her own certified public accounting and management consulting firm in October 2001. The full service CPA firm provides tax and accounting solutions to meet the needs of today's small business and individual. Brenda McGivern has become a trusted advisor and valuable resource her clients rely on for timely, accurate assistance when they need it. Before starting the firm, she worked as an accountant for three years at a local firm and prior to that five years at a large international CPA firm in Boston. She has performed the following tax services: federal, state and local tax planning, international tax planning, estate and succession planning, mergers and acquisitions, capital retention and IRS representation. She has also coordinated assurance engagements, such as financial statement audits, reviews and compilations from the planning phase through the reporting phase. She has prepared and reviewed regulatory filings for numerous regulatory agencies including the Security and Exchange Commission. Prior to these positions she was selected from over 2,000 candidates into an eight-person intensive financial management program at an international technology company. The program consisted of graduate level classroom study and two six-month rotational assignments in financial operations. She graduated cum laude from the University of Massachusetts at Amherst and holds a Bachelors Degree in Business Administration with a concentration in accounting. McGivern also holds a license in Massachusetts as a Certified Public Accountant and is a member of the American Society of Certified Public Accountants and the Massachusetts Society of Certified Public Accountants. She resides in Stoughton, Massachusetts with her husband Brian, and their sons Sean, Ryan and Conor and their dog, Davis.
This entry was posted in Business, business help, Business Owner, customer, customer service, Filing Taxes, Financial Planning, guide, Inventory, New Business, Operational Accounting, Operations, quickbooks, quickbooks help, QuickBooks Tips, record keeping, sales, save money, save on taxes, stock, Supply, Tax, tax advice, Uncategorized and tagged , , , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s