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.

Whether you sell products or services, you may need to create estimates in QuickBooks Online. Here’s how it’s done.

It would be nice if you could just instantly invoice every sale. But sometimes your customers need to know what a particular purchase will cost before they make the decision to buy. So you need to know how to create an estimate. If the sale goes through, you’ll of course want to send an invoice.

QuickBooks Online automates this entire process. It even helps you track the progress of your estimates by providing a special report. Here’s how it works.

Just Like An Invoice – Almost

The process of creating an estimate in QuickBooks Online is almost identical to creating an invoice. You click the New button in the upper left and select Estimate.

When the form opens, you’ll notice one difference right away. Directly below the Customer field, you’ll see the word Pending next to a small down arrow. Click it to see what your options are here. You’ll be able to update its status later. Select a Customer to get started. If this is a new customer, click + Add New and enter at least the name. If you want to build a more complete profile at this point, click Details and complete the fields in the window that opens. To send a carbon copy or blind copy of the estimate to someone else, click the Cc/Bcc link.

Next to the Estimate date, there’s a field for Expiration date. Enter that and continue on to add the products and/or services that will be included, just as you would on an invoice. If you’re generating an estimate for a new product or service, click + Add new in the drop-down list. A panel will slide out from the right that allows you to create one.

You’ll see more options for your estimate at the bottom of the page. You can add a message in the message box (or leave the default message if there is one). You can also Customize it, Make recurring, or Print or Preview it. When you’re satisfied, Save it, and send it to the customer.

Updating the Status

Your estimate will not be considered a transaction until you accept it. To do this, click the Sales link in the toolbar, then All Sales. Find your estimate in the list by looking in the Type column. Click the down arow next to Create invoice to see your other options there. You’ll see that you can Print or Send it or save a Copy.

Click Update status. In the window that opens, click the down arow next to Pending. From the list that drops down, select Accepted. You can also mark it Closed or Rejected. If you choose any of the last three options, another window opens that allows you to enter the name of the individual who authorized the action and the date it was done.

Click Create invoice if your estimate was accepted. You’ll have three options here. You can invoice your customer for:

• The estimate total.
• A percentage of each line item.
• A custom amount for each line.

After you’ve made your selection, click Create invoice to open the form with the amounts filled in based on your preference. Complete anything that’s unfinished but do not change any of the product or service line items. Save it, and your invoice is ready to go. You can always check the status of your estimates by running the Estimates by Customer report.

Creating and tracking estimates is as easy as working with invoices. You may run into difficulties, though, if you need to do anything beyond that point with estimates, such as modifying it and re-submitting them. We’re here to answer any questions you might have about this. It’s important that you get your estimates and their subsequent invoices exactly right, so you don’t lose money or sales. Let us know if you want to go over these concepts.

 Call us at 479-242-1236 now and find out how you can leverage QuickBooks to precisely track your finances or request your complimentary consultation online.

Sometimes, you have to spend money on your customers. Make sure you’re billing them for it.

Usually, money flows from your customers to your business. But there may be times when you have to purchase items for a job whose costs will eventually be reimbursed. Or you, or an employee, might spend time providing services for customers and get paid for those hours by your company before you receive payment from the responsible party. If you’re a sole proprietor with no payroll and no reserves, of course, you just have to wait to be paid for your work.

In the first two cases, you’re spending money upfront that will eventually be paid back. In all three cases, QuickBooks Online calls these billable expenses and billable time, and it does a good job of tracking these transactions – much better than if you were scribbling notes on a receipt or a paper timecard.

Obviously, you want to be paid for these expenditures as soon as possible to minimize their impact on your own cash flow. So QuickBooks Online “reminds” you that they need to be billed when you create an invoice for a customer. It also offers reports that help you track unbilled time and expenses. Here’s a look at how it works.

Tracking Billable Time

It’s easy to create a billable time activity. Click +New, then Single time activity. Fill in the blanks and select items from drop-down lists until you’ve completed a form. The critical section of this screen is pictured below:

In this example, the employee will receive $50/hour for the work done (Cost rate). Because the Service being provided will be billed back to the customer, you click in the box in front of Billable to create a checkmark. You’re charging the customer $65/hour (a $15/hour markup), so you enter that number in the Billable field. You don’t have to worry about remembering that. QuickBooks Online, as it does with all of your other company information, retains that and makes it available to you.

Tracking Expenses

You probably already know how to record expenses in QuickBooks Online. You can either click the +New button and then Expense, or you can click the Expenses link in the toolbar and the New transaction | Expense. Just as you did in recording time activities, you complete the fields and place a checkmark in the Billable column and select the Customer/Project from the drop-down list.

Once you’ve saved a billable expense, it will appear in the table on the Expense Transactions page. To display is again, click View/Edit at the end of the corresponding row. The transaction will open, and you’ll notice that there’s a small View link in the Billable column. Click it, and you’ll see this:

In this example, there’s been no markup applied to the transaction. If you want to add markup costs to all billable expenses, click the gear icon in the upper right and go to Account and settings | Expenses. Click the pencil icon to the far right of the Bills and expenses block of options. Click the box in front of Markup with a default rate of to create a checkmark and enter a percentage. All of your billable expenses will now include a markup of that percentage.

Invoicing Time and Expenses

The next time you invoice a customer who has outstanding time and expenses, QuickBooks Online will remind you that they’re pending. Open an invoice form and select a customer who you know has billables. The right vertical pane will contain a box containing information like this:

Click Open if you want to see the original expense record. Clicking Add will, of course, include that transaction on the invoice.

QuickBooks Online offers another way to see your pending billables. Click the Reports link in the toolbar and scroll down to the Who owes you section. You’ll see two related reports here: Unbilled charges and Unbilled time.

We want you to make sure that you’re getting reimbursed for all of the time and expenses you incur on behalf of your clients. So please let us know if you have further questions on this topic or if you have other QuickBooks Online issues.

SOCIAL MEDIA POSTS

Do you ever spend money on behalf of your customers? QuickBooks Online calls these billable expenses, and it can track them. Here’s how.

If you provide services for customers, you’ll have to invoice those hours as billable time. Did you know you can record this activity in QuickBooks Online? Here’s how.

Did you know when you invoice customers with outstanding time and expense charges, QuickBooks Online reminds you about them? Find out more here.

Confused about which customers owe you for billable time and expenses? QuickBooks Online provides specific reports for that. Find out more here.

ValueMetrik CFO offers QuickBooks support as part of our package of accounting services for small and midsized businesses. Call us at 479-242-1236 now and find out how you can leverage QuickBooks to precisely track your finances or request your complimentary consultation online.