QuickBooks

There are many ways to encourage delinquent customers to pay. QuickBooks Online’s statements may be effective for you.

After the year-plus you’ve just experienced, the last thing your small business needs is customers who are behind on their payments to you. You may have been giving them a break because you know that they’re struggling, too, but things have been looking up for many companies in the past few months. It’s time for you to be more proactive about calling in your debts.

There are numerous ways you can accomplish this. One of the best is to send statements in QuickBooks Online, which are detailed reminder forms that contain multiple transactions. These can be especially helpful if you’ve sent multiple invoices with no response. There are three different types you can send, depending on your needs. Here’s how you create them.

Before You Start

QuickBooks Online offers a couple of options for formatting your statements. To see these, click the gear icon in the upper right corner and select Your Company | Account and Settings. Click the Sales tab and scroll down to the Statements section. Click the pencil icon over to the far right to make any changes needed. You can:

• List each transaction as a single line or include all of the detail lines.
• Display an aging table at the bottom of each statement.

Click the buttons to specify your preference and then click Save and Done.

 

Three Statement Types

You can choose from among three different types of statements in QuickBooks Online: Balance Forward includes invoices with outstanding balances for a specified range of dates. Open Item statements contain information about all unpaid (open) invoices from the last 365 days. And Transaction Statements show every transaction in a date range that you specify. We’ll describe how to create them so you can decide which makes the most sense for a particular situation.

One Way to Create Statements

Like it does for many other actions, QuickBooks Online offers two ways to create statements. The first is easier. Click the New button in the upper left and select Statement (under Other). Click the down arrow in the field under Statement Type to see the three options there.

If you select Balance Forward, you’ll need to define three criteria (there will be similar options for the other two types):<.p>

• Statement Date
• Customer Balance Status (Open, Overdue, or All)
• Start Date and End Date

When you’re satisfied with your statement parameters, click Apply. QuickBooks Online will display a list of the transactions that meet your criteria, along with the number of them that will be generated. Each row in the list will display the recipient’s name, email address, and balance. In the upper right corner, you’ll see the number of statements again and the total balance these customers represent.

If you want to exclude any of these customers, click in the box in front of each to unselect them and delete the checkmark. When you’re satisfied with your list, click Save, Save and send, or Save and close. If you click Save and send, a window will open containing a preview of your statements. Thumbnails of each will appear in the left pane. Click on any to see their previews. When you’re ready, you can download, print, or send them.

If you click Save or Save and close, you’ll still be able to see the statements you’ve just generated. Click the Sales tab in the toolbar, then All Sales. Click the down arrow next to Filter and open the drop-down list under Type. Select Statements, and your list will appear. You can print or send one by selecting the correct option in the Action column. If you want to dispatch multiple statements, click in the box in front of each, and then click the down arrow next to Batch actions.

Another Method

There’s an alternate way to create statements. Click the Sales tab in the toolbar, then Customers. Select any or all of the customers in the list, then click the down arrow next to Batch actions and select Create statements. QuickBooks Online will open the Create Statements window again so you can select the type and process your statements like you did using the previous method.

We don’t expect that you’ll have much trouble working with statements, though you may want to consult with us on when they’re appropriate. We can also suggest other ways to bring your accounts receivable up to date. As always, we’re available to help you maximize and streamline your use of QuickBooks Online. Keeping your financial books current and organized is one way to ensure that you don’t fall too far behind with customer payments.

SOCIAL MEDIA POSTS

Are too many of your customers behind in their payments to you? Consider sending statements in QBO. We can show you how.

QuickBooks Online supports statements, reminder forms you can send to customers whose payments are past due.

Don’t know how many customers are past due on their payments to you? Run QuickBooks Online’s A/R Aging reports.

There are two ways to create three different types of statements in QuickBooks Online. We can help you sort it out.

Send us an e-mail or call us today at 901-685-9411 to discuss your QuickBooks accounting needs with an experienced CPA. Or, request a free 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.

Send us an e-mail or call us today at 901-685-9411 to discuss your QuickBooks accounting needs with an experienced CPA. Or, request a free consultation online.

…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.

Send us an e-mail or call us today at 901-685-9411 to discuss your business needs with an experienced CPA. Or, request a free consultation online.

The most important thing you need to know about sales tax is that administering it correctly can be challenging.

If you sold only one type of product to customers in one city, collecting and paying sales tax would be easy. But most businesses have a wider reach than that.

QuickBooks Online offers tools that allow you to set up sales tax rates and include sales tax on sales forms. Further, it calculates how much you must pay to state and local taxing agencies.

This is one of the most complicated areas in QuickBooks Online because you may have to deal with numerous taxing agencies. If you’re not already working with sales taxes, we strongly recommend you let us help you get everything set up correctly from the start. Taxing agencies can audit your recordkeeping and you want to make sure it is set up correctly.

That said, here are five things we think you should know.

QuickBooks Online calculates sales tax rates based on:

• Where you sell. Every state is different. If your business is located in Florida and you sell to a customer in Minnesota, you’ll be charging any sales tax levied by the state of Minnesota and possibly the city and county and other taxing authorities – if you have a connection, a “nexus” in that state (a physical location, active salesperson, etc.).
• What you sell.
• To whom you sell. Some customers (like nonprofit organizations) do not have to pay sales tax. You’ll need to edit their customer records to reflect this in QBO. Open a customer record and click the Edit link in the upper right. Click the Tax info tab and make sure there’s no checkmark in the box that says This customer is taxable. The Default tax code will be grayed out, and you can enter Exemption details in that field.

Customer records for exempt organizations should contain details for that exemption. You’ll need to see their exemption certificate or at least know its official number.

Intuit now offers a revamped version of QuickBooks Online’s sales tax features.

At some point, you’ll be asked if you want to switch to the new, more automated system. The actual mechanics of the process are simple, but you’ll be moving historical and in-process data to a new structure. If you have sales tax set up right now and your situation is at all complicated, you’re going to want our help with the transition.

This enhanced feature only supports accrual accounting.

You can combine individual tax rates.

If you are required to pay city, county, and state sales tax rates for a particular customer, for example, you can create a Combined tax rate that contains all of the individual components. The customer will only see the total on an invoice or sales receipt, but QuickBooks Online will track each one accordingly for payment and reporting purposes.

You can combine sales tax rates in QuickBooks Online (image above from current Sales Tax Center in QuickBooks Online, not the enhanced one).

Product and service records should contain sales tax information.

This is another area that will require some research. Just as some services are subject to tax, some products are not (like groceries in Arizona). So, you’ll need to find out what the rules are for what you sell. You can find this information on the website of the state’s Department of Revenue (sometimes called the Department of Taxation).

Once you know, you can record that status in QuickBooks Online. Open a product record by going to Sales | Products and Services and clicking Edit in the Action column or create a new one by clicking New in the upper right. Scroll down to Sales tax category in the record. You can choose between Taxable – standard rate and Nontaxable.

There’s a third option here: special category. This gets complicated. We can help you determine whether it applies to you.

QuickBooks Online tracks the sales tax you owe.

You can see what you owe to each agency by running the Sales Tax Liability Report, and record payments when you’ve made them. Summary and detail versions of the Taxable Sales report are also available.

Once you get sales taxes set up in QuickBooks Online, it’s easy to add them to the relevant sales forms. Getting to that point, though, takes time, study, and careful attention to detail. If you’re getting ready to sell, or you’re already selling and struggling with sales taxes, let us know. We can schedule an initial consultation to see how we can be of assistance.

 

Keep a constant watch on your accounts receivable to improve cash flow.

Quick: How many of your invoices are unpaid? Have any of your customers gone over 30 days past due? Did you bill all of the time and expenses for that project you just completed for a customer?

If you’re doing your accounting manually, there’s simply no way to get that information quickly. Depending on your bookkeeping system, you may not be able to get it at all.

QuickBooks Online has more than one solution for this problem. You see the first one every time you log in. The Dashboard contains a graphic in the upper left corner that tells you how many invoices are overdue and unpaid. Click on the colored bar labeled OVERDUE, and you’ll see a list of invoices with the unpaid ones right at the top.

You can tell at a glance how much of your money is tied up in unpaid invoices.

While this is important information for you to have as you start your workday, it doesn’t tell the whole story. To get that, you’ll need to access some of QuickBooks Online’s reports – five of them in particular. Click Reports in the left vertical pane, and then scroll down to the heading labeled Who owes you.

These reports are listed in two columns. Each has the outline of a star next to it. Click on the star, and the report will be added to the Favorites list at the top of the page. Click on the three vertical dots next to it, and you’ll be able to Customize the report. And as you hover over the title, you’ll see a small, circled question mark. Click on this to get a brief description of the report.

There are several reports in this list that can provide insight into where your outstanding revenue is. We recommend you run five of them at least once a week – more frequently if your business sells large quantities of products and/or services. The suggested are:

Accounts receivable aging detail

This report provides a list of invoices that are overdue, along with aging information. There are several columns in the report, but you’ll want to pay special attention to the last one: OPEN BALANCE.

Tip: If you have many customers or simply a high volume of unpaid invoices, you might consider running the Accounts receivable aging summary instead.

Changing the Content

Before you run the report, you should explore the customization tools provided for it. They won’t be the same for every report, but you can start to get an idea of what can be done. Hover over the report title and click Customize. A panel like the one pictured below will slide out of the right side of the screen.

QuickBooks Online provides deep customization tools for reports.

You can see some of your customization options in the image above. Beyond these, you can also work with filters and headers/footers. When you’re satisfied with your changes, click Run report.

If you want to run a report with its default settings, just click on the report title in the list to display it. You’ll have access to limited customization from there.

Four other reports you should be generating regularly are:

• Customer Balance Summary: Shows you how much each customer owes your business
• Open Invoices: Lists invoices for which there has been no payment
• Unbilled Charges: Just what it sounds like: tells you who hasn’t been invoiced yet for billable charges
• Unbilled Time: Lists all billable time not yet invoiced

We don’t expect you’ll have any trouble understanding reports like these; they’re fairly self-explanatory. QuickBooks Online offers many other reports, the standard financial reports that need to be generated monthly or quarterly, like Balance Sheet, Profit and Loss, and Statement of Cash Flows. You’ll absolutely need these should you apply for a loan or need to supply in-depth financials for any other reason. We can help you analyze them to get a comprehensive, detailed picture of your company’s fiscal health.

As Certified QuickBooks ProAdvisors, we can work with you to ensure that you are getting the most out of your QuickBooks accounting software. Send us an e-mail or call us today at 901-685-9411 to discuss your QuickBooks accounting needs with an experienced CPA. Or, request a free consultation online.

Assessing finance charges is a complicated process. But if you have a lot of late payments coming in, you may want to consider it.

There are many reasons why your customers send in payments past their due dates. Maybe they missed or misplaced your invoice, or they’re disputing the charges. They might not be very conscientious about bill-paying. Or they simply don’t have the money.

Sometimes they contact you about their oversight, but more often, you just see the overdue days pile up in your reports.

You could use stronger language in your customer messages. Send statements. Make phone calls if the delinquency goes on too long. Or you could start assessing finance charges to invoices that go unpaid past the due date. QuickBooks provides tools to accommodate this, but you’ll want to make absolutely sure you’re using them correctly – or you’ll risk angering customers and creating problems with your accounts receivable.

Setting the Rules

Before you can start, you’ll need to tell QuickBooks how you’d like your finance charges to work. It’s at this stage that we recommend you let us work with you. There’s nothing overly difficult about understanding finance charges in theory: you apply a percentage of the dollar amount that’s overdue to come up with a new total balance. But setting up your QuickBooks file with the finance charge rules you want to incorporate may require some assistance. If it’s done incorrectly, you will hear from your customers.

Here’s how it works. Open the Edit menu and select Preferences, then Finance Charge | Company Preferences.

Figure 1: Before you can start adding finance charges to overdue invoices, you’ll need to establish your company preferences.

What Annual Interest Rate percentage do you want to tack onto late payments? This is an issue we can discuss with you. Too low, and it’s not worth your extra time and trouble. To, high, and your customers may stop patronizing your business. And do you want to set a Minimum Finance Charge? Will you allow a Grace Period? If so, how many days?

You’ll need to assign an account to the funds that come in from interest charges. This needs to be an income account. In our example, it’s Other Income.

The next decision, whether to Assess finance charges on overdue finance charges, needs consideration – and some research. This may not be an option depending on the lending laws in the jurisdiction where your business is located. So again, if you want to charge interest on unpaid and tardy finance charges themselves, let’s talk.

When do you want the finance charge “countdown” to begin? When QuickBooks identifies a transaction that has not been paid within the stated terms, do you want the added charge to be applied based on the due date or the invoice/billed date?

Note: If your business sends statements rather than invoices, leave the Mark finance charge invoices “To be printed” box at the bottom of this window unchecked.

Applying the Rules

QuickBooks does not automatically add finance charges to your customers’ invoices. You’ll need to administer these additions yourself, though QuickBooks will handle the actual calculations. Open the Customers menu and select Assess Finance Charges to open this window:

Figure 2: You’ll determine who should have finance charge invoices created in the Assess Finance Charges window.

Make very sure that the Assessment Date is correct, as it has an impact on QuickBooks’ calculations. Being even a day off makes a difference. Select the customers who should have finance charges applied by clicking next to their names in the Assess column. QuickBooks will display the Overdue Balance from the original invoice, as well as the Finance Charge it has calculated.

• If you choose not to apply finances charges to a customer because he or she has provided a good reason for the late payment, be sure the box in the Assess column is unchecked.
• If you want to change the finance charge due for a valid reason, you can type over the amount in the last column. This would be a rare occurrence and should be exercised only after consulting with us.

Important: If there is an asterisk next to a customer’s name, there are payments or credit memos that have not yet been applied to any invoice.

When everything is correct, click the Assess Charges button at the bottom. QuickBooks will create separate invoices for finance charges for each customer who owes them.

We can’t stress enough the importance of consulting with us before you start to work with finance charges enough. Keep your company file accurate and your customers happy by getting this complex accounting element right from the start.

Call our Memphis, TN CPA now at 901-685-9411. We offer a free initial consultation to new clients so contact us today.