How to Set Up QuickBooks® for Your E-commerce Business

Digital TouchstoneLeave a comment

Setting up QuickBooks for your e-commerce business is a great way to manage your finances, track sales, and stay on top of your financial health. Below is a step-by-step guide to help you set up QuickBooks for your e-commerce business:

  1. Choose the Right QuickBooks Version:
    QuickBooks offers different versions, including QuickBooks Online and QuickBooks Desktop. For most e-commerce businesses, QuickBooks Online is recommended because it provides easy access from anywhere with an internet connection and has a variety of integrations with e-commerce platforms.
  2. Sign Up for QuickBooks Online:
    Go to the QuickBooks website and sign up for an account. You’ll need to provide some basic information about your business during the registration process.
  3. Set Up Your Company Profile:
    After signing up, you’ll be prompted to set up your company profile. Fill in your business details, including the business name, address, industry, and tax information.
  4. Link Your Bank Accounts and Payment Processors:
    Connect your business bank accounts and any payment processors you use for your e-commerce transactions. This will enable QuickBooks to automatically import your financial data, saving you time on manual data entry.
  5. Configure Sales Tax Settings:
    If your e-commerce business is required to collect sales tax, set up your sales tax settings in QuickBooks Online. This will ensure that sales tax is accurately tracked and applied to transactions.
  6. Import Your Chart of Accounts:
    A chart of accounts is a list of all the categories where you record financial transactions. QuickBooks provides a default chart of accounts, but you can customize it to match your e-commerce business needs.
  7. Integrate E-commerce Platform:
    If your e-commerce platform supports integration with QuickBooks, set up the integration to automate the flow of data between the two systems. This integration will help streamline the process of importing sales, inventory, and customer information.
  8. Record Sales and Expenses:
    As you start making sales and incurring expenses, record them in QuickBooks. Categorize transactions correctly using the chart of accounts you set up earlier.
  9. Manage Inventory (if applicable):
    If your e-commerce business involves selling physical products, QuickBooks can help you manage your inventory. You can track the quantity and value of your products, making it easier to understand your stock levels and profitability.
  10. Reconcile Your Accounts:
    Regularly reconcile your bank accounts, credit cards, and payment processor accounts with your QuickBooks records. This process ensures that all transactions are accurately recorded and that your financial statements are up to date.
  11. Run Financial Reports:
    QuickBooks offers various financial reports, such as profit and loss (income statement), balance sheet, and cash flow statement. Use these reports to gain insights into your e-commerce business’s financial performance and make informed decisions.
  12. Set Up Budgets (optional):
    If you want to plan and monitor your e-commerce business’s financial goals, consider setting up budgets in QuickBooks. Budgets help you track your actual performance against your projected targets.

Remember that while setting up QuickBooks for your e-commerce business can be relatively straightforward, it’s essential to maintain good bookkeeping practices consistently. Regularly update your financial records, reconcile accounts, and review financial reports to keep your business financially healthy and compliant. If you’re uncertain about any aspect of the setup process, consider consulting with a QuickBooks expert for guidance.

We are happy to help!

The Benefits of Hiring a QuickBooks© ProAdvisor for Your Small Business

Digital TouchstoneLeave a comment

Small business owners often have a lot on their plate, from managing employees to overseeing daily operations, and everything in between. With so many responsibilities, it can be difficult to keep track of financial records and ensure that all finances are in order. This is where a QuickBooks ProAdvisor can help.

A QuickBooks ProAdvisor is a certified professional who is trained in using QuickBooks accounting software. Hiring a ProAdvisor can bring numerous benefits to your small business, including:

  1. Expertise and Knowledge: A QuickBooks ProAdvisor is an expert in using QuickBooks software and can offer advice and support on everything from setting up the software to creating reports and managing your finances. They have the knowledge and experience to help you make informed decisions about your business.
  2. Time-Saving: As a small business owner, you likely have a lot of tasks to manage on a daily basis. By hiring a QuickBooks ProAdvisor, you can save time and focus on other areas of your business that require your attention. A ProAdvisor can take care of your bookkeeping, payroll, and tax-related tasks, leaving you with more time to grow your business.
  3. Accurate Financial Reporting: QuickBooks ProAdvisors can help ensure that your financial records are accurate and up-to-date. This can help you make better business decisions based on accurate financial data.
  4. Cost-Effective: Hiring a full-time bookkeeper or accountant can be expensive for a small business. By hiring a QuickBooks ProAdvisor, you can get the expertise you need at a fraction of the cost.
  5. Training and Support: QuickBooks ProAdvisors can provide training and support to you and your employees, ensuring that everyone is familiar with the software and can use it effectively.
  6. Peace of Mind: With a QuickBooks ProAdvisor handling your finances, you can have peace of mind knowing that your financial records are accurate and up-to-date.

In conclusion, hiring a QuickBooks ProAdvisor can be a valuable investment for small business owners. By providing expertise, saving time, ensuring accurate financial reporting, being cost-effective, offering training and support, and providing peace of mind, a ProAdvisor can help you take your business to the next level.

Save Time, Keystrokes with Recurring Transactions in QuickBooks© Online

Digital TouchstoneLeave a comment

Your time as a business owner is valuable. Don’t waste any of it doing duplicate data entry.

Accounting takes time. And the last thing you need when you’re working with your company’s finances is activity that takes unnecessary minutes. If you’ve created a record or transaction once, you don’t want to have to enter the information a second or third time.

That’s why using QuickBooks Online is so far superior to manual accounting. It remembers everything, so you can use data again when you need it. But sometimes you have to give it a little guidance.

That’s the case with recurring  transactions. If you have forms that you create repeatedly, with very few changes (like utility bills), you can “memorize” the transactions. When the bill comes around the next month, you can modify any details necessary and dispatch it again. Here’s how it works.

Three Options

To get started, enter a transaction that you want to save and be able to use again (with changes). Let’s say it’s an invoice that you send to a customer once a month who has a service contract for network maintenance. When you’ve completed the form, look toward the bottom of the screen and click Make recurring. The screen will now read Recurring Invoice, with new content as pictured below.

Graphical user interface, application Description automatically generated

You can specify transactions as recurring and add details like frequency and start/end dates.

If you want to change the Template name to something that will remind you of its purpose, you can do so. In the field beneath Interval, select Daily, Weekly, Monthly, or Yearly, and then indicate what day of the month the transaction should occur. Enter a Start date and End [date] or select None if the length of service is open-ended. In example above, you would receive a reminder from QuickBooks Online three days before the invoice is scheduled to go out. The service contract has no ending date, so you’d continue to get reminders until you change the template.

Next to the Template name is a field labeled Type. QuickBooks Online gives you three options for taking action on the recurring transaction. It can be:

  • Scheduled. This is an automated option that should be used with caution. If you select this, your transaction will go out as scheduled with no intervention from you. Only the date will change.
  • Reminder. QuickBooks Online will send you a reminder ahead of the scheduled date. You can specify how many days ahead you should receive it. Then it’s up to you to make any necessary changes and send it out.
  • Unscheduled. QuickBooks Online will do nothing except save your template.

When you’ve completed all of the required fields, click Save template in the lower left. 

Using Recurring Transactions

If you’ve chosen the Scheduled option for any transactions, you don’t have to do anything more with it until you want to change its content or status. To find your list of recurring transactions so you can process any that are you earmarked as Reminder or Unscheduled, click the gear icon in the upper right of the QuickBooks Online screen. Under Lists, click Recurring transactions.

Graphical user interface Description automatically generated

The Recurring Transactions table

The screen that opens displays a table containing all of your recurring transactions. You can learn just about everything you need to know about those transactions here: Template Name, Type, Txn (Transaction) Type, Interval, Previous Date, Next Date, Customer/Vendor, and Amount. 

The last column in the table, labeled Action, opens a menu that displays different options depending on the  type of transaction. For our Reminder example, you can: 

  • Edit (edit the template, not the transaction)
  • Use (opens the original transaction that you can edit, save, and send)
  • Duplicate (duplicate the template)
  • Pause (stop sending reminders temporarily)
  • Skip next date
  • Delete

Looking Ahead

We’re a month into 2023 now. What does this year look like for you? Is QuickBooks  Online doing everything you need it to do? If you’re starting to outgrow your version, we’d be happy to consult with you about upgrading to another service level (Essentials, Plus, or Advanced). Or if you know the version you’re using is supposed to do something you need but you can’t quite figure it out, let us know. We want 2023 to be a good year for you, and we’d like to make your accounting work as painless and productive as possible.

What Can QuickBooks Online’s Mobile App Do?

Digital TouchstoneLeave a comment

If you haven’t checked out QuickBooks Online’s free mobile app, you might be surprised at how much it can do.

There was a time when leaving the office meant you were done with work for the day. These days, many homes are offices. And easy mobile access has made it difficult to get away from work.

That can be a good thing, especially if you’re a small business owner who must keep a close eye on what goes on outside of regular hours. Many productivity websites have mobile companion apps that make it possible to pick up where you left off when you were sitting at your laptop or desktop.

QuickBooks Online is one of them. Its mobile apps (iOS and Android, which look and work similarly) can’t replicate absolutely everything on the website. For example, you can’t work with projects or pay contractors or define sales taxes or run most reports. But they do a good job of providing the tools you’d most likely need when you’re away from your regular workspace. Let’s take a look at them.

A Terrific User Experience

Intuit did a great job designing its mobile apps to be easy to use on small screens. It takes very little time to learn how to navigate around, and individual working screens are clean, attractive, and understandable. 

When Should You Use Apps?

There are only two things that QuickBooks Online’s apps can do that the desktop version can’t: track mileage and snap photos of receipts. There are other situations when it’s very convenient to have the apps available, like creating a sales receipt or invoice for a customer in person, adding basic details for a new customer or vendor, or checking your account balances. It’s probably best to do the bulk of your work on your desktop or laptop when you can, to avoid errors caused by small—and abbreviated—screens.

Navigation Icons

The apps open to a screen called Today, which is their version of a desktop application’s Dashboard. There are links to actions like creating an invoice and looking up a customer, as well as a to-do list, the QB Assistant (a support tool), your account balances, a link to recent transactions, and real-time information about the status of your invoices and bills.

The other three icons at the bottom of the screen serve as navigation tools. The one on the far right labeled Menu opens two screens that can be toggled back and forth. One is Shortcuts, pictured below, a series of links to common actions. The other, All, opens a more traditional, comprehensive menu of links to individual app functions, like a Profit and loss report, Sales receipts, and Products & services.

The QuickBooks Online app’s Shortcuts screen

Besides those functions, there are links to other financial activities on the All screen. The ones you’d be most likely to use remotely are:

  • Transactions. The ones you’ve imported from your banks are available via this shortcut, as well as any you’ve entered manually on your desktop or phone. You can also get to the list by clicking on an account name on the Today screen.
  • Receipt snap. Using your phone’s camera, you can take a picture of a receipt. The app will pull some of its data and deposit it on an expense form that’s accessible on the app and the desktop version, where you can fill in the blanks and see the picture. 
  • Invoices and Estimates. View, modify, and add them.
  • Customers and Vendors. Abbreviated versions of your records.
  • Expenses and Bill Pay.
  • Mileage. Enter trip data manually or automatically, through your phone’s location services.

Data entry on the mobile apps is as easy as it is on the browser-based version of QuickBooks Online.

About Your Business

Another bottom-of-screen icon takes you to My business, which provides an update (charts and numbers) of your income, expenses, and profitability. And another is Cash flow. Cash flow is actually a pretty complex accounting concept that you can’t fully absorb on a mobile phone screen, but it’s very important that you have a good understanding of how your company is doing. You can ask us about this.

Give It A Try

January is always a good time to develop new habits. We’ll be talking about some of these next month, but in the meantime, you might download and explore QuickBooks Online’s mobile app. You probably won’t need our help learning to use it, but we’re always happy to step in and assist when you’re having trouble with desktop QuickBooks Online.

5 QuickBooks Online Tasks You Should Do Before January 1

Ida_BencomoLeave a comment

It’s probably your busiest month of the year. But there are things you can do to make your return from the holidays less stressful.

December always goes by so quickly. Seems like you’ve just finished Thanksgiving dinner and it’s time to ring in the New Year. You could probably spend the entire month on your personal obligations. But it’s also the end of the year, which means your busiest period if you’re a retailer. Even if you’re not, you probably have sales goals to try to meet. And you may have employee issues that need to be addressed before the calendar turns over.

On top of all of this, you should be closing out your books for the current year (as much as you can) in preparation for the new one. If you’ve been using QuickBooks Online conscientiously all year, your job will be a lot easier. But you’ll still need to carve out some time for year-end tasks.

We don’t expect that you’ll necessarily be able to wrap absolutely everything up by New Year’s Eve. You may be waiting for your customers and employees to do their part. But here are five things you can do amidst all of your other personal and professional plans that will help you get a jump on January.

Analyze your 2022 sales.

You won’t have your final numbers until the year is over, but you can get a good start in December. There are several QuickBooks Online reports that can give you a clear, understandable look at your 2022 sales. Click Reports in the toolbar and scroll down to Sales and customers. You can run reports that will tell you what your sales were by Class, Customer, Customer Type, and Product/Service, in summary or detail. The reports are customizable, so you can specify date ranges and group the results by, for example, Transaction Type, Customer, and Account.

You can customize and run QuickBooks Online’s Sales reports.

Warning: If you’re not clear about whether you should run reports in Cash or Accrual mode, let us help you with this. The distinction is important.

Know What You Owe

If money is tight at the end of the year, this will be a challenge. But you don’t want to come back from the holidays to a lot of past-due notices. To see what still needs to be paid, click Reports again and scroll down to What you owe. If you want the straight scoop right away, run Unpaid Bills. For a more detailed look, create the Accounts payable aging detail report. This groups your outstanding payables by days past due.

Know Who Still Owes You Money

This is a question that’s probably on your mind all year, but it’s especially important as the year winds down. It may be difficult to get delinquent customers to pay up in December, but you should at least know where you stand with them. Click the Reports tab again and scroll down Who owes you. Generate two reports there: Accounts receivable aging detail and Open Invoices. 

You might also want to spend an hour coming up with some strategies that would encourage customers to pay faster. If you’re at a loss about this, we could sit down together and come up with a plan.

Create statements for past-due customers

Customer statements are something like reports. They display sales transactions within a given period. Statements can serve two purposes. Sometimes, customers just want a list of their invoices and payments for their records. You can also use statements as a reminder to customers who are past due on their accounts.  Click New in the upper left corner, and then click Statement under Other.  There are three types, but you’d be most likely to create and send two of them:

  • Open Item. Displays all open, unpaid invoices for the last 365 days. 
  • Transaction Statement. Lists all transactions for the selected date range.

You can send statements to customers to remind them of overdue payments or just to provide a record of transactions for a given period.

Clean up your customers and vendor lists

If you only have a few of each, your list is probably current. But if you’ve been adding customers or vendors for years without ever editing the list, you’re probably spending too much time scrolling. You don’t have to delete them. You can just make them inactive. Click Sales in the toolbar, then Customers. If you know a customer has no open activity and you want to hide them, click in the box in front of the company or customer’s name. Repeat this for as many as you want, then click Batch actions in the upper left, then Make inactive.

A Busy Month

Don’t worry if you don’t get to all of these by the end of the year. But do add them to your January task list if you don’t. You might also consider having us run the standard financial reports that are available in QuickBooks Online Reports, under For my accountant. You can create reports like Trial Balance yourself, but they can be hard to analyze accurately. We’d be happy to set up a time after the first of the year to go over these after all of your 2022 transactions are in.

How QuickBooks© Online Tracks Products and Services, Part 1

Digital TouchstoneLeave a comment

What products and services does your company sell? Do you have enough to fulfill existing and future orders? QuickBooks Online can tell you.

Most small businesses maintain a changing inventory of multiple products. Even if you sell one-of-a-kind goods, you need to know what you’ve sold and what’s available. And if your company sells services, you also have to keep track of what you’re able to offer customers.

QuickBooks Online can meet these needs. It allows you to create detailed records for both products and services. If you carry inventory, it can make sure that you always know what’s available to sell. When you enter sales and purchase transactions, the site draws on the records you’ve created to help you complete invoices, sales receipts, purchase orders, etc., without having to leave the form you’re working on.

Creating your records initially can take some time. And your products and services require regular monitoring and maintenance. But if you’re conscientious about these tasks, you’re not likely to run short on inventory or have too much money tied up in products that aren’t selling fast enough.

Preparing QuickBooks Online

Before you begin creating records and tracking inventory, you need to make sure that QuickBooks Online is set up correctly. Click the gear icon in the upper right. Under Your Company, click Account and settings. Click the Sales tab in the toolbar. You’ll see the Products and services section near the middle of the screen.

Graphical user interface, text, application, chat or text message Description automatically generated

Make sure you’ve turned on the Products and services features you’re going to need.

Toggle the slider buttons on and off by clicking on them, and be sure to save your changes when you’re done. One option allows you to turn on price rules. This is still classified as a beta feature, but it’s live on the site. It’s also quite complicated to set up and can create confusion for your customers and revenue loss for you if it’s not done correctly. Let us help if you want to use this tool.

Creating Your Product and Service Records

Your first task, of course, is to build your product and service records. Hover your mouse over Sales in the left vertical toolbar on the home page and select Products and Services. The screen that opens is your home base for dealing with inventory and services. Eventually, it will contain a detailed table containing information about both. Two large buttons at the top of the page warn you when you have Low Stock or you’re Out of Stock.

Click New in the upper right corner. A vertical panel slides out from the right displaying your four options for Product/Service information. They are:

  • Inventory. If you buy and/or sell products whose quantities you must track, these items are considered inventory.
  • Non-inventory. You may have products that you buy and/or sell, but you don’t need to track the amount you have in stock. These are considered non-inventory.
  • Service. These are, well, services that you provide to customers, like landscaping or web design. You might sell these by the hour or project, for example.
  • Bundle. You might call these assemblies. Bundles are multiple products and/or services that you sell as a package for one price.

Click on Inventory for this example. Here is a partial view of the pane you’ll see:

Graphical user interface, text, application, email Description automatically generated

You can track your inventory levels and reorder points when you create inventory product records in QuickBooks Online.

To create a product or service record, just fill in the blanks on the form and save it. Some fields are optional. In fact, only three are required: Name, Initial quantity on hand, and As of date. Of course, your inventory tracking and the use of product and service records in transactions and reports will be much more effective if you complete as many of the fields as possible. We recommend that you at least provide answers in some additional fields (some of which aren’t shown here), including:

  • Category (will be useful in reports, for example)
  • Reorder point (will keep you from running out of items)
  • Inventory asset account (you can leave the default, Inventory Asset)
  • Description (for sales forms)
  • Sales price/rate (what the customer will be charged)
  • Description (for purchase forms)
  • Cost (what you pay to buy it)
  • Expense account (often Cost of Good Sold, but you can ask us to be sure)

Next month, we’ll discuss how QuickBooks Online makes these records available as you complete other tasks, like transactions. In the meantime, please let us know if you have other questions we can answer that would help you use QuickBooks more effectively. We hope you’re enjoying your summer!

Some Small Businesses Are Recovering. Is Yours?

Digital TouchstoneLeave a comment

The COVID-19 pandemic isn’t over, but many small businesses are on the upswing. How QuickBooks Online can help if yours isn’t.

Intuit recently did a survey documenting the financial losses that many small businesses had experienced since March 2020. Not surprisingly, the report, Intuit QuickBooks Small Business Recovery, found that COVID-19 has had a significant impact on the financial health of U.S. small businesses.

But many of the companies surveyed have proved to be resilient. As of March 31, 2021, 61 percent of them saw an annual revenue increase compared to pre-COVID days.

How would you have answered the survey? If indeed you did suffer financial and personnel losses because of the pandemic, has your business started to rebound yet? If not, there are actions you can take in QuickBooks Online to help in your recovery. Here are some of them.

Transactions: Watch your income and expenses like a hawk.

QuickBooks Online provides excellent transaction-tracking tools that help you document income and expenses.

How much time do you spend working with your downloaded transactions? If you take advantage of the excellent tools QuickBooks Online provides, you may notice patterns that you’ll want to explore and modify. For example, are you spending too much in one or more particular areas? When and where is your income dipping?

It’s critical that you connect to as many online financial institutions as possible, so you get a complete picture of your income and expenses. Once you have, click on Transactions in the toolbar, which should open to the Banking page. If you’re only going there to make sure there are no unrecognized entries, you’re missing out on some of QuickBooks Online’s transaction-tracking tools. In the image above, we’ve specified a vendor and chosen a Category and Tags. This will make your reports more meaningful and actionable.

If you don’t know what it means to Find Match, we can show you how that works. It’s a real time saver. 

Sales: Make it easier for customers to pay you.

We’ve written about accepting online payments in this column before. It’s especially important if you’re struggling. You may actually be losing sales if you don’t let potential customers pay online through a credit card or bank account transfer. And existing customers may pay faster if they can do business with you in that way.

QuickBooks Payments makes this possible. There are some nominal fees involved, but the potential increase in your income should more than cover them. Let us know if you want us to help you set up a merchant account.

When you set up a merchant account through QuickBooks Payments, you may find that your customer base will grow, and existing customers will pay faster.

Expenses: Categorize expenses with tax time in mind.

You’ve probably already filed your 2020 income taxes, but we’re well into 2021, and it’s not too early to start thinking about your current tax situation. QuickBooks Online helps you track your income carefully, but it’s equally important to make sure you know what your tax-related expenses are. You want to get every deduction and credit you can. So when you’re looking at transactions, like we described above, make very certain that you’re assigning the correct categories to each of them. 

We can help you run reports on a quarterly basis that should be of help when you make estimated tax payments. That way, you may be able to reduce your quarterly obligation during the 2021 tax year and won’t have to wait until you file in 2022 to see savings.

Time: Make sure your billable hours are billed.

Unless you have an organized, easy-to-use method for tracking billable time, some hours are likely to fall between the cracks. QuickBooks Online provides effective tools in this area. As you go through your downloaded transactions, you may see expenses that can be billed to a customer. Select the Customer/project and check the Billable box so you’ll be able to include it on their next invoice.

You can mark expenses as billable to customers in your Transactions register.

As you create time entries for you and/or your employees, you can also mark those hours as billable.

Reports: Run basic, critical reports regularly.

You can’t know how your business is doing financially unless you create reports. Besides the quarterly and standard financial reports we can run and analyze for you, you can—and should—be generating reports yourself through QuickBooks Online. Here are some of the ones we suggest:

  • Budget vs. Actuals. If you’ve put the time and effort into creating a budget, it’s critical that you gauge your progress regularly and make adjustments as needed.
  • Open Invoices. Who have you billed that hasn’t paid?
  • Accounts Receivable Aging Detail. Who owes you, and how far behind are they?
  • Sales by Product/Service Detail. What is selling well and what isn’t? You can make decisions about your product and service lines by viewing this report. This is especially important when your sales are sluggish.
  • Business Snapshot. This is a series of charts and lists that provides a quick visual overview of key data.

QuickBooks Online can’t, of course, revive your business if the pandemic has created conditions that are out of your control. But that shouldn’t stop you from controlling what you can, no matter what your situation is. It was designed not only to automate and streamline your daily accounting work, but also to provide the information you need as you evaluate your present situation and plan for the future. Please call on us if you need help making optimal use of QuickBooks Online.

How to Use Tags in QuickBooks Online

Digital TouchstoneLeave a comment

Where is your money coming from? Where is it going? You can use tags in QuickBooks Online to find out.

QuickBooks Online offers numerous ways to help you track your sales, expenses, and profitability. If you’re using QuickBooks Online Plus or Advanced, you can create and assign Classes to transactions to differentiate between, for example, store departments or product lines. Some of the site’s reports are designed specifically for these tools, like Sales by Class and Profit and Loss by Class. 

You can assign Categories to products and services to gain insight into your sales and inventory. There’s a different set of Categories that you’ll use when you record bills and expenses. These are important for reporting and tax purposes. You can also add a Location field to sales transactions so you can track sales by stores, sales regions, or counties, for example.

What Are Tags?

Then there are Tags, which are fairly new to QuickBooks Online. These are customizable labels that you can assign to transactions (invoices, expenses, and bills). They’re more flexible than the tools we’ve already mentioned – they allow you to track your money any way you want. They don’t affect your books, and they’re not included in the customization criteria for reports. But there are two reports specifically designed for them: Profit and Loss by Tag Group and Transaction List by Tag Group.

Creating Your Own Tags

Once you’ve given your group a name, you can start adding tags to it.

Before you create a tag, you need to create a Group. Groups consist of related tags that share a common theme. For example, say you do some event planning. You might have a group titled Events. Individual events might read, for example, Grayson Wedding, Spring Art Show, and Hillman Conference.

To get started, click the gear icon in the upper right. Under Lists, click Tags to get to the tool’s home page. (You can also click on the Transactions link in the toolbar, then click the Tags tab.) Click New, then Tag group. A vertical panel slides out from the right. Enter a name in the Group name field. Click the down arrow to select a color, then click Save. 

Enter your tags one by one in the fields labeled Tag name. Click Add after each one until your list is complete. Click the Edit button to make any changes. When you’re finished, click Done. The main Tags page will open again, and you’ll see your new group under Tags and Tag Groups. Repeat to add as many as you’d like, up to 300 tags.

Using Tags

You can add tags to any transaction that contains a field for them

.

Let’s look at how you’d use tags in an expense. Click the Expenses link in the toolbar, then New transaction | Expense in the upper right. Click the down arrow in the Payee field in the upper left and select + Add new. Enter Billy’s Bridal in the Name field Leave the Type as Vendor and click Save. Back on the Expense screen, select the Payment account, Payment date, and Payment method for the expense (reference number is optional).

Directly below those fields, you’ll see the Tags field. Click Manage tags if you need to add or edit one; the right vertical pane you saw before will slide out. Otherwise, click in the field below Tags. Your list of tags will drop down. Select Grayson Wedding to move it into the field. You can assign as many tags as you’d like to transactions, but you can only select one tag from each group. Finish the expense and save it. 

Go back to the Tags home page, and you’ll see that there’s a link to one transaction in the Events row. At the end of each row is the Action column, where you can run a report, add a tag, and enter or delete a group. Your expense total appears in the Money Out (by tag) box above it. 

Tags are a great addition to the tools QuickBooks Online provides to help you track incoming and outgoing funds. If you’re not familiar with the others we mentioned at the beginning of this column and want to learn how to explore them, let us know. We’d be happy to walk you through their use and help you understand how they can make your finances more understandable.

Should You Charge Late Fees? QuickBooks Can Help

Ida_BencomoLeave a comment

Do you have a lot of aging receivables? Assessing finance charges can speed up customer payments.

Have your customers been submitting payments later than usual these last several months? It wouldn’t be surprising. Many businesses are struggling to pay bills these days. Still, you need to get paid – and on time. Tardy receivables have a negative impact on your own cash flow.

We’ve discussed ways to encourage prompt payment in past columns. For example, you can start accepting credit/debit cards and direct bank transfers, make sure invoices go out immediately after a sale, or offer a premium like a small one-time discount for paying on time 12 months in a row to name a few.

You can also assess finance charges on remittances that come in after the due date. QuickBooks provides the tools to allow this.

Setting It Up

Before you start charging extra for late payments, you’ll need to do some setup work in QuickBooks. Open the Edit menu and select Preferences, then Finance Charge. Click the Company Preferences tab. You’ll see a window like this:

Graphical user interface, text, application Description automatically generated

You can set your own preferences for assessing finance charges in QuickBooks.

You’ll have to answer these questions and enter your responses in the window:

What will your Annual Interest Rate (%) be?

What will you set as a Minimum Finance Charge?

Will you allow a Grace Period? This is the number of days given to your customers to make their payments after the due date before finance charges kick in. This is typically from 15-21 days.

Where should captured finance charges go? In this example, the Finance Charge Account has been assigned to Other Income. 

Do you want to Assess finance charges on overdue finance charges? Some jurisdictions don’t allow you to charge interest on overdue interest charges. If you want to do this, check on your local lending laws – specifically state usury laws which may limit the amounts that can be charged.

When will you start to Calculate charges? In this example, the due date is selected. So, QuickBooks will start to add finance charges 21 days after the stated due date. If you choose invoice/billed date, you’ll want to make your grace period longer. This can be rather a confusing concept. Contact us if you want a deeper explanation.

Assessing Finance Charges

There’s one more issue on the Preferences screen that you’ll need to resolve. QuickBooks offers two ways to notify customers about finance charges. You can’t include them on invoices, like you may be used to seeing on credit card bills. Rather, you have to print separate invoices that only contain the finance charges. 

If you put a check in the box in front of Mark finance charge invoices “To be printed,” you can print them out separately. If you leave the box blank, the finance charges will appear on the customer’s next statement. Click OK when you’re done with this window.

Graphical user interface, table Description automatically generated

QuickBooks can find the overdue invoices that need to have finance charges applied and display them in a window like this one.

Open the Customers menu and select Assess Finance Charges. A window like the one in the image above will open. Make sure that the Assessment Date is the actual date you want to assess charges, which may not be the current date. Click in the Assess column to create a checkmark for every customer you want to charge. When you’re done, click Assess Charges.

When you’re ready to print finance charge invoices, open the File menu and select Print Forms | Invoices to open a window like this:

Graphical user interface, table Description automatically generated

Invoices with an FC preceding the number are finance charge invoices ready for printing.

Lots to Learn

Besides knowing whether you can charge finance charges on existing finance charges, there are other considerations. For example, do your state’s lending laws allow you to use the phrase “finance charge” or must you use something like “late fee?” When should you assess finance charges? Have you notified your customers of your intent to begin assessing finance charges? This is definitely something they should know in advance. You might need to add this to your customer message on invoices.

We can’t tell you whether finances charges are the path you should take to improve your cash flow as there are many issues to consider. But we can help you with the mechanics of doing so and are here to answer any questions. Let us know if you want to get started using this tool, we can help.

New to QuickBooks® ? Try These 5 Activities

Digital TouchstoneLeave a comment

QuickBooks can be overwhelming when you first start using it. Here are five ways to familiarize yourself with some of its features to get you up and running in no time.

Tackling any new piece of software can be daunting. Add a complex process like accounting to the mix, like QuickBooks does, and you may feel apprehensive about your ability to learn how to use it. 

But QuickBooks was designed for small businesspeople, not for accountants nor technical wizards. It uses familiar language and forms, and it works like other Windows programs. That doesn’t mean, though, that you’ll be able to just jump in and start completing your accounting tasks. 

Here are five steps you can take to start familiarizing yourself with QuickBooks that will get you up and running in no time. We’ll assume that you’ve already created your company file. If you need help with this critical first step, let us know.

Open a sample file.

While you’re exploring QuickBooks, it’s a good idea to work with a sample file. That way, you can look around and practice without risking compromising your company file. You’ll be able to see how completed records and transactions should look and try your hand at entering sample data of your own.

QuickBooks comes with sample files that allow you to practice entering data without harming your own company file.

Before you open a sample file, you’ll need to close your current company. Click on File in the upper left to open that menu, then select Close Company. A window will open that should have your company file in its list. Below that, you’ll see three boxes containing different options. Click on the down arrow next to Open a sample file, as pictured above (this may look slightly different in your version). Choose the one you want to open and click on it. QuickBooks will load again with that file open. When you’re done looking at the sample file, go to File | Close Company again. The No Company Open window should appear again. Click on your company file name and then on Open to return to your own file.

Learn where your lists are.

You’ll be storing a great deal of information in lists. QuickBooks maintains these automatically sometimes when you enter information in a record or transaction. For example, when you create a record for a product or service you sell, it goes into a master list that you can access by opening the Lists menu at the top of the screen and clicking on Item List. You’ll also open the Lists menu when you want to add options to an existing type of list, like Class List (QuickBooks allows you to assign Classes to transactions so you can group related information, like New Construction or Remodel if you’re a contractor).

You’ll sometimes select from lists of commands in QuickBooks. This is the menu for the Item List.

Try a Transaction.

There are two transactions you’ll probably be using the most: invoices and sales receipts. QuickBooks comes with templates that resemble these sales forms’ paper counterparts. You simply fill in the blanks by entering data and selecting options from drop-down lists. Open the Customers menu and select Create Invoices. Click the back arrow above Find in the upper left corner to see sample invoices. Then click the right arrow to get back to a blank form and create an invoice by clicking the down arrows in blank fields to see your sample lists.

Explore Snapshots.

Once you start entering records and transactions, you’ll want to be able to access that information in ways that provide insight on how your company is doing. You’ll eventually start running reports in QuickBooks, but the software also accomplishes this through its Snapshots. There are three of them, and they all provide these overviews by using data tables and charts. Open the Company menu and click on Company Snapshot, then click the tabs to move between Company, Payments, and Customer. You’ll learn how QuickBooks provides real-time information about your finances.

Look at the Income Tracker.

It’s easy to see the status of your invoices (and estimates) in QuickBooks. Open the Customers menu and select Income Tracker. Colored bars at the top of the screen show you what’s outstanding and what’s been paid. A list of the related transactions appears below these bars.

This partial view of the Income Tracker tells you how much money is tied up in unbilled Time & Expenses and unpaid Invoices.

As we said earlier, QuickBooks can be overwhelming when you first start to use it. We can ease that transition by providing training and helping you move your existing accounting information over to the software. If you’ve started using QuickBooks on your own and you have questions, we can always step in to offer answers.

Stay healthy, and best wishes for a more prosperous 2021.