Quickbooks

Is Your QuickBooks company file ready for 2022? Three things you can do to put things in order.

Don’t forget about QuickBooks while you’re catching up on 2021 and looking ahead to 2022. You probably don’t want to put one more item on your to-do list, but any steps you take now to ready the software for the new year will pay off. Once you start entering transactions and placing orders and welcoming new customers, it will help tremendously to have a clean slate.

Here are some suggestions for completing as much of the work you started in 2021 as you can.

Run four critical reports

Bills can slip through without being paid in December because there’s so much going on. This applies to both you and your customers. You need to catch up on what’s owed to you and what you owe. So generate these four reports in QuickBooks:

• A/R Aging Detail. Which of your customers are in arrears with their payments to you? How much do they owe you, and when should the money have come in?
• Open Invoices. Which invoices have not yet been paid? There will be some duplication with A/R Aging Detail, but this report isolates only unpaid transactions.
• A/P Aging Detail. Are you caught up with the money you owe other individuals and companies? This report will tell you.
• Unpaid Bill Details. Like Open Invoices, this report sets apart only the bills that have unpaid balances.

Create statements for past-due customers

You’ll have to decide how hard you want to lean on customers who are late paying your bills when it’s so early in the year. Certainly, if some customers are more than 60 days late (30 days if they have sizable balances), you may want to make a phone call or at least send a personalized email asking them to fulfill their obligations.

But you can also send statements. These documents provide details of financial activity between you and your customers for a given period of time. Open the Customers menu and click Create Statements. Look over all of the options in the window that opens and indicate your preferences. If customers don’t respond to your statements within 10 days, then it may be time for a phone call.

Take a hard look at your inventory

It may have been a while since you did this, but it’s really important to do it regularly – especially if you had a busy holiday season. The best way to start on this is to open the Vendors menu, scroll down and hover over Vendor Activities, and click Inventory Center.

If you don’t have a lot of inventory, you could just highlight each entry under Active Inventory, Assembly over to the left. The window that opens on the right side of the screen holds an enormous amount of detail about each item. But if you sell a lot of different kinds of items, that will take too much time. In that case, you might run one or more of the reports linked from this screen. Even the QuickReport can be helpful.

Tip: If you need to adjust the quantity you have on hand, click the down arrow next to Manage Transactions in the lower left and select Adjust Quantity/Value on Hand. You might consult with us if you’re running into this problem, and we can go over inventory issues with you.

Set Up Online Financial Connections

January is also a good time to be thinking about how you can better use QuickBooks in 2022. We tend to learn how to use the tools we need and not explore any further when we’re using any kind of software. QuickBooks is such a massive program that that’s understandable.

But there are two tools that can have tremendous impact on your daily workflow, your ability to get paid faster by customers, and your understanding of where you stand financially every day. They are:

• Online Banking. Did you know that you can connect QuickBooks to many financial institutions and import your cleared transactions every day? That’s what the Bank Feeds Center is all about. If you sign up for this service, you won’t have to wait until your monthly statement comes to see what transactions have gone through.
• Online Payments. If you’re only accepting checks as payment from your customers, you’re probably getting paid more slowly than you might. Sign up for QuickBooks Desktop Payments, and you’ll be able to process credit cards, eChecks, and ACH payments.

There are always more things to learn about the applications we use every day. Here are some tips for expanding your use of QuickBooks Online.

We tend to fall into the same old patterns once we’ve learned how to make a computer application work for us. We learn the features we need and rarely venture beyond those unless we find we need the software or website to do more.

QuickBooks Online is no exception. It makes its capabilities known through an understandable system of menus and icons, labeled columns and fields, and links. But do we really see what else it can do? Expanding your knowledge about what QuickBooks Online can do may help you shave some time off your accounting tasks and better manage the forms, transactions, and reports that you work with every day. Here are some tips.

Edit lines in transactions. Have you ever been almost done with a transaction and realize you need to make some changes farther up in the list of line items? Don’t delete the transaction and start over. QuickBooks Online comes with simple editing tools, including:

• Delete a line. Click the trash can icon to the right of the line.
• Reorder lines. Click the icon to the left of the line, hold it, and guide it to the new position. This is tricky. You may have to work with it a bit.
• Clear all lines and Add lines. Click the buttons below your line items, to the left.

Explore the More menu. Saved transactions in QuickBooks Online have a link at the bottom of the screen labeled More, as pictured above. Click it, and you can Copy the transaction or Void or Delete it. You can also view the Transaction journal, which displays the behind-the-scenes accounting work, and see an Audit history, which lists any actions taken on the transaction.

Create new tabs. Do you ever wish you could display more than one screen simultaneously so you can flip back and forth between them? You can. Right click on any link in QuickBooks Online, like Sales | Customers, and select Open link in new tab.

Use keyboard shortcuts. Not everyone is a fan of these, mostly because they can’t remember them. Hold down these three keys together to see a list: Ctrl+Alt+?. Some common ones include those for invoices (Ctrl+Alt+i) and for expenses (Ctrl+Alt+x).

Modify your sales forms. Do you need more flexibility than what’s offered in your sales forms? It may be there. Click the gear icon in the upper right and select Account and settings under Your Company. Click the Sales tab. In the section labeled Sales form content, notice that you can add fields for Shipping, Discounts, and Deposits by clicking on their on/off switches. You can also add Custom fields and Custom transaction numbers.

Add attachments. Sometimes it’s helpful to have a copy of a source document when you enter a transaction. To attach a receipt to an expense, for example, look in the lower left corner of the transaction. Click Attachments and browse your system folders to find the file, then double click on it.

Record expenses made with credit cards. Who doesn’t use credit cards for expenses sometimes? You can track these purchases in QuickBooks Online, as pictured above. Click the gear icon in the upper right and select Chart of Accounts under Your Company, then click New in the upper right. Select Credit Card from the drop-down list under Account Type. Enter Owner Purchase in the Name field and then Save and Close. When you create an expense, select Owner Purchase as the Payment account.

Previous Transaction Button. Are you trying to find a transaction that you entered recently but don’t want to do a full-on search? With a transaction of the same type open, click the clock icon in the top left corner. A list of Recent Expenses will drop down. Click on the one you want.

Whether you’re new to QuickBooks Online or you’ve been using it for years, there’s always more to explore. We’d be happy to help you expand your use of QuickBooks Online by introducing you to new features, building on what you’re already doing on the site to improve your overall financial management. Call us to schedule some time.

If you have one or more people besides yourself using QuickBooks Online, you’ll need to know how to set up their accounts.

Your QuickBooks Online file contains a great deal of very sensitive information, like customers’ credit card numbers and employees’ Social Security numbers – data you don’t want to have fall into the wrong hands. You obviously trust your employees or you wouldn’t have hired them, but when it comes to security, you should implement all the safeguards you can.

QuickBooks Online can help you stay safe by limiting the access that other users have to your company file. Here’s how it works.

To get started, click the gear icon in the upper right and select Manage users. You should be listed there, of course, as the Master Administrator. Click Add user. The screen that opens will ask you what type of user you’re adding. There are four of them:

• Standard user. You can assign full or limited access to standard users, but they won’t have administrator privileges.
• Company admin. At this level, the user can see and do everything.
• Reports only. These individuals have access to all reports except those that contain payroll or contact information.
• Time tracking only. You’d assign this type to employees who only need to enter their own timesheets.

 

The first two count toward your user limit, but the second two do not. Make your selection and click Next. We’ll select standard user for this example.

On the screen that opens, you’ll be assigning actual access rights, telling QuickBooks Online what the user’s restrictions are. You can choose All (with or without payroll access), None (allows some activities), or Limited. Select Limited, then click in the box in front of Customer to create a check mark. You’ll see the list of specific actions that that individual can take (like creating invoices, sales receipts, and statements) and the screens that they can see (customer registers and reports, tax rates and agency settings, etc.).

There’s also a list of what they can’t do, including printing checks, viewing bank registers, and preparing a sales tax return.

Click in the box in front of Customer again to uncheck it and select Vendor. You’ll see a similar list here of what your new user can and can’t do, only its activities relate to your accounts payable.

Click Next If the user will be entering his own her own timesheets in QuickBooks Online, click the button in front of Yes, then select the correct name from the drop-down list. Click Next. Answer the user settings questions on the next screen and click Next. Enter the user’s name and email address (user ID), then click Save. QuickBooks Online will return you to the Manage Users screen, where you’ll see that your new user has been added to the list. The individual you just invited will receive an email invitation to set up an account, with instructions on how to do so.

Other Security Tips

There are other ways you can keep all of your company’s data safe. Here are some suggestions to consider if your business has returned to its offices.

• Always update your operating system and applications when prompted. These often contain security patches in addition to bug fixes and new features.
• Keep backups out of reach of others. Cloud backups are best, but if you use a local device, don’t leave it out in the open.
• Log out of QuickBooks Online when you’re not at your desk.
• Shred anything you print from QuickBooks Online or store it in a locked drawer.
• Protect your networks. Discourage excessive web browsing by employees. Don’t allow extraneous app downloading on company equipment and ask employees not to use company mobile devices on public networks. Consider network monitoring software if you can’t afford managed IT.

We follow security best practices in our own offices, and we hope you’ll do the same. Applying safeguards proactively will help prevent data theft that can be nearly impossible to recover from.

Intuit employs industry-standard security practices to keep your data safe, too, and it handles all backup and upgrades. Often, those updates include new features, like the recent addition of transaction “tags.” Let us know if you need our help with these or with any other element of QuickBooks Online.

SOCIAL MEDIA POSTS

Are you taking on a new employee who will use QuickBooks Online? The site has a specialized setup process for this.

Did you know that you can create and use tags now in QuickBooks Online? We can show you how it’s done.

Are you concerned about the security of your QuickBooks data? Ask us how you can best protect it.

Are you considering using QuickBooks Online in 2021? We’d be happy to help you set it up for your business and learn to use it.

New year, new challenges, and the potential for new successes. Here are five ways you can improve your financial management in 2021.

A painful year is drawing to a close. We’ll still be dealing with COVID-19 and a struggling economy in early 2021, but there’s hope on the horizon. There’s a lot you can’t control about the difficulties facing our country, but you can take control of your corner of it, especially in terms of how you manage your finances.

If you’re already using QuickBooks Online, you know how it’s solved the paperwork confusion of the past. But are you taking advantage of all of its capabilities? As you turn your digital calendar to January, consider expanding your use of the website to set yourself up for success in the new year. Here are five features to explore if you haven’t already.

Practice Proactive Reconciliation

QuickBooks Online’s Banking screen display registers for the bank and credit card transactions that have been posted by your banks. Do you review these frequently? It’s easy, and it’s important. It will save time when you do your monthly reconciliations with your bank statements. Hover over Transactions in the toolbar and select Banking. You can see some of your transaction management options in the image below.

When your statement comes and you’re ready to reconcile, you can use QuickBooks Online’s tools that take you step by step through the process. Hover over Accounting in the toolbar and select Reconcile. Let us know if you need help with reconciliation or with managing downloaded transactions.

Start Accepting Online Payments

This is probably the #1 way to encourage customers to pay you faster. When you set up a merchant account through QuickBooks Payments, you’re be able to accept credit cards, debit cards, and ACH bank transfers. Your invoices will include a Pay Now button and will contain the information your customers need to pay electronically. Their funds will go into your bank account.

There are other ways they can pay you directly. You can take their card numbers over the phone. You can also get a free card reader from Intuit and swipe their cards on your mobile device. And you can set up recurring payments that will occur automatically. There are no base fees – you just pay per transaction.

Set Weekly and Monthly Report Schedules

You may just run reports in QuickBooks Online as you need them. Some reports, though, should be created every week at a minimum, like Accounts receivable aging (detail or summary), Accounts Payable Aging, Open invoices, and Unpaid Bills. There are many others, but you need to keep a close watch on what you owe and who owes you.

It’s important to run some other reports on a monthly (or, sometimes, quarterly) basis, including Balance Sheet, Profit and Loss, and Statement of Cash Flows. Rather than just providing snapshots of where you stand with money coming in and going out, they give you a more comprehensive view of your finances that can help you make better business decisions. They’re complex and often difficult to analyze, though, which is why QuickBooks Online categorizes them as For my accountant. We can create and interpret these for you.

Expand QuickBooks Online’s Features by Using Apps

QuickBooks Online is generic enough that it can be used by a wide variety of small businesses. But that flexibility may mean that it’s not quite robust enough in one area or another, like inventory management or time tracking. There are hundreds of apps that you can integrate with QuickBooks Online to fill in the gaps. Some are free. Click on Apps in the toolbar. Again, we’re available to help if you need assistance.

Evaluate the Cost-effectiveness of Your Vendors

It’s easy to stick with the same old suppliers because it’s a hassle to change. But so many companies are hurting because of the pandemic that you may find you can get what you need for less. To go over your whole list, hover over Expenses in the toolbar and click on Vendors. You might clean up your list while you’re at it. Click the down arrow at the end of each row and select Make inactive if you haven’t ordered from specific suppliers over the last year.

As we said earlier, we’re available to meet with you and explain any of the concepts discussed here in more depth. It’s still a hard time for so many small businesses, and we want to be of help wherever we can.

SOCIAL MEDIA POSTS

Don’t have a budget set for your business? QuickBooks Online has tools that can simplify the process of creating one.

When you’re creating a budget, it’s helpful to distinguish between essential and non-essential expenses. QuickBooks Online has tools that can help you, including budgeting for necessities first.

When was the last time you shopped for new suppliers? Now is a good time to see if you could save some money and help with your budget. QuickBooks Online has many tools that can help both you and your business budget.

Did you know QuickBooks Online allows you to use existing income and expense data to create a budget? Here is how this is done.

…and how QuickBooks Online can help you with the mechanics.

If you already have a budget, it’s probably been difficult for you to stick with it for the last several months. Unless you provide products and/or services that have been in great demand since the COVID-19 pandemic took hold, you’ve had to adjust your budget significantly.

Better days are ahead, though, and now is a good time to start doing some planning for 2021. While there are still likely to be uncertainties next year, creating a budget will give you a starting point. A budget increases your awareness of all of your projected income and expenses, which may make it less likely that you’ll find yourself constantly running short on funds.

Here are some ways you can make your budgeting process more effective and realistic.

Use what you already know. Unless you’re starting a brand-new business, you already have the best resource possible: a record of your past income and expenses. Use this as the basis for your projections.

Be aware of your sales cycle. Even if you’re not a seasonal business, you’ve probably learned that some months or quarters are better than others. Budget conservatively for the slower months.

Distinguish between essential and non-essential expenses. Enter your budget items for the bills and other expenses that must be covered before you add optional categories.

You can use data from a previous year to create a new budget in QuickBooks Online.

Keep it simple. Don’t budget down to the last paper clip. You risk budget burnout, and your reports will be unwieldy.

Build in some backup funding. Just as you’re supposed to have an emergency fund in your personal life, try to create one for your business.

Make your employees part of the process. You shouldn’t be secretive about the expense element of your budget. Try to get input from staff in areas where they have knowledge.

Overestimate your expenses, a little. This can help prevent “borrowing” from one budget category to make up for a shortfall in another.

Consider using excess funds to pay down debt. Debt costs you money. The sooner you pay it off, the sooner you can use those payments for some non-essential items.

Look for areas where you can change vendors. As you’re creating your budget think carefully about each supplier of products and services. Can you find less costly alternatives?

Revisit your budget frequently. You should evaluate your progress at least once a month. In fact, you could even start by budgeting for only a couple of months at a time. You’ll learn a lot about your spending and sales patterns that you can use for future periods.

How QuickBooks Online Can Help

QuickBooks Online offers built-in tools to help you create a budget. Click the gear icon in the upper right corner and select Budgeting under Tools. Click Add budget. At the top of the screen, give your budget a Name and select the Fiscal Year it should cover from the drop-down list by that field. Choose an Interval (monthly, quarterly, or yearly) and indicate whether you want to Pre-fill data from an existing year.

QuickBooks Online supplies a budget template that already contains commonly used small business items.

The final field is labeled Subdivide by, which is optional. You can set up budgets that only include selected Customers or Classes, for example. Select the desired divider in that field, then choose who or what you want included in the next. Click Next or Create Budget in the lower right corner (depending on whether you used pre-filled data) to open your budget template. If you subdivided the budget, you’ll see a field marked View budget for. Click the down arrow and select from the options listed there.

To create your budget, you simply enter numbers in the small boxes supplied. Columns are divided by months or quarters, depending on what you specified, and rows are labeled with budget items (Advertising, Gross Receipts, Legal & Professional Fees, etc.). You simply enter numbers in the boxes that apply. When you click in a box, a small arrow appears pointing right. Click on this, and your number will automatically appear in the rest of that row’s boxes. When you’re done, click Save in the lower right. You can edit your budget at any time.

QuickBooks Online provides two related reports. Budget Overview displays all of the data in your budget(s). Budget vs. Actuals shows you how you’re adhering to your budget.

We know creating a budget can be challenging, but it’s so important – especially right now. We’d be happy to look at your company’s financial situation and see how QuickBooks’ budgeting tools—and its other accounting features—can help you get a better understanding of your finances.

SOCIAL MEDIA POSTS

Don’t have a budget set for your business? QuickBooks Online has tools that can simplify the process of creating one.

When you’re creating a budget, it’s helpful to distinguish between essential and non-essential expenses. QuickBooks Online has tools that can help you, including budgeting for necessities first.

When was the last time you shopped for new suppliers? Now is a good time to see if you could save some money and help with your budget. QuickBooks Online has many tools that can help both you and your business budget.

Did you know QuickBooks Online allows you to use existing income and expense data to create a budget? Here is how this is done.

Taking on your company’s payroll with QuickBooks Online? Knowing what you’re up against ahead of time will make your setup tasks much easier.

 

Payroll is probably the most complex element of small business accounting. Not only are you directly responsible to your employees, but you also have to make sure you’re handling everything related to benefits and payroll taxes correctly.

Whether you’re switching from a manual system to QuickBooks Online, or you’ve just hired your first employee, you’ll soon discover that the site can make your payroll-related tasks much more organized and accurate – speeding up the process tremendously.

But before you start getting ready for your first payroll run, you have a lot of setup work to be done. Be sure to leave yourself time before those first paychecks are expected.

 

Our Purpose Here

We’ll provide some step-by-step instruction, but initially, we just want you to see what information you’ll need to have available and how QuickBooks Online handles it. This is not meant to be a payroll setup tutorial.

 

Building a Backbone

There’s no particular order set in stone for your payroll preparation tasks, although you will need to provide some background information about your company and its policies before you can start creating employee records.

QuickBooks Online doesn’t walk you through the steps required. It does though display a page with links to all of the data you’ll have to enter. Click the gear icon in the upper right, and then click Payroll Settings. You’ll see this screen:

QuickBooks Online’s Payroll Settings screen displays links to the pages where you’ll manage your setup tasks.

You would have entered information about your Contact Information and Work Locations (under the Business Information heading) when you first signed on to QuickBooks Online. At the same time, you would have been exposed to the Chart of Accounts, which already has accounts designated for payroll. You can see them by clicking Preferences | Accounting, but please do not customize these. If modifications are needed, we’ll do them for you.

 

Payroll Policies

How often will you pay your employees? Go up to the Payroll heading in the upper left and click on Pay Schedules. Click Create and open the drop-down list next to Pay Period to select the frequency desired. Then enter the date for the first payroll you’ll run in QuickBooks Online and the end date for the period that it covers. Click the box below if you want this to be the default setting for all employees. Then click OK to return to the previous page.

Open the Vacation and Sick Leave Policies window. If you don’t yet have accrual rules for these paid days off, let us help you here. It’s complicated. When you’re done, click the back arrow to return to the Pay Policies window and select Deductions/Contributions. Are you offering benefits like health insurance? You’ll need to have your paperwork and information handy before you start completing this section.

Before you can pay employees, you’ll need to have entered information about the benefits you offer so you can withhold dollars for them.

Click the plus sign (+) in front of Add a New Deduction/Contribution and complete the fields here, then click OK. You’ll assign these deductions to employees on their individual records in QuickBooks Online. If there are any Employee Garnishments needed (like child support), click the down arrow next to Add Garnishment for and select the worker from the list. You’ll provide details for these in the window that opens. This information was most likely provided to you by the agency requesting it. When you’re done, click OK.

 

Taxes and More

If you’re new to payroll and have never dealt with payroll taxes before, you’re going to need our help getting this complicated element set up correctly. Even if you have, we’d recommend that you let us work with you. QuickBooks Online does a good job of providing guidance here, but failure to submit payroll taxes (or pay them incorrectly) can lead to penalties and fines – or worse.

There are other setup tasks you’ll need to complete, like:

• Connecting your payroll bank account to QuickBooks Online.
• Creating employee records.
• Setting payroll production preferences.

Setup is by far the most challenging part of processing payroll in QuickBooks Online. Once that’s done, you’ll just be entering hours and making modifications. Please do connect with us if you’re planning to take this on, and we’ll make sure you get a good start.

Social media posts

• Are you using a payroll service or doing payroll manually? Consider letting QuickBooks Online taking over this task.
• QuickBooks Online contains links to your payroll setup tasks, but it doesn’t walk you through the process. Let us.
• Hiring your first employee? Talk to us about managing your payroll in QuickBooks Online.
• Are you offering vacation and sick time leave to your employees for the first time? We can help you set up accrual rules.

Your time is valuable and accounting software is not your specialty. That’s why we provide training, oversight, and ongoing support. Call us at 661-323-1514 and ask for Ken to discuss your specific needs.