Accounting Blog

Working with Downloaded Transactions in QuickBooks Online

Downloading transactions into QBO is the easy part. You still have work to do once they’re on board.

Its ability to download financial transactions is one of the five best things about QuickBooks Online. Without it, you’d spend a lot of time on tedious data entry, verifying which checks and deposits had cleared and entering new ones.

Instead, you can easily connect to your bank and bring in all your activity from the previous hours or day. QuickBooks Online stores this neatly in a register and provides tools for you to further describe and classify each transaction.

Setting Up the Connection

Haven’t connected your financial institution to QuickBooks Online yet? It’s easy. Click the Banking link in the toolbar, then Add Account in the upper right. The Find your bank window opens. Start entering the name of your bank, credit card company, or service like PayPal in the blank field. A list of potential matches will drop down; you simply select the one you want. A window like this will open:

ll you need to do to start downloading transactions into QuickBooks Online is select your financial institution and enter the User ID and Password you use to connect directly to the site.

You will have to go through some security procedures, and then QuickBooks Online will download 90 days of transactions (you can shorten this if you’d like). You’ll also be asked which QBO account should receive the transactions. After a few minutes, the register for that account will appear, displaying the transactions you just downloaded.

Warning: The mechanics of connecting to your bank and downloading your first batch of transactions may sound easy, but if everything is not absolutely clear to you as you’re going through the process, please contact us sooner rather than later.

Working with Transactions

Once you’ve downloaded a set of transactions, you’ll want to look at them. Again, click the Banking link in the navigation toolbar. Your accounts will appear in small boxes at the top of the page, along with two balances: the one that came from the financial institution and the one in QuickBooks Online. Select the one you want by clicking on it, and its register will open.

Tip: QuickBooks Online generally updates your accounts once daily. If you want to launch a manual update at any time, click on Update in the upper right corner.

Let’s look at one downloaded transaction to see what you can do with it. Make sure the For Review column is highlighted above the register. Select a transaction by clicking on it. A window like this will open below it:

QuickBooks Online does more than simply download financial transactions: It lets you define them in greater detail.

There are several options here, including:

  • Add to register. If you’re satisfied with the information as is, just click the Add button to the right (not pictured here).
  • Split. If you want to split the amount/category (Supplies, Tools, etc.)/class of a transaction, click Split (also off to the right and not pictured). A window will open to let you specify that.
  • Assign categories. QuickBooks Online may automatically make assignments to obvious categories, which you can change if incorrect. You can also click the down arrow to the right of that field and select your own from the list.
  • Bill an expense to a customer. Did you purchase something that needs to be billed to a customer? Click in the box under Billable and select the correct one from the drop-down list that opens.
  • Find matches. This can get complicated, and we recommend you let us work with you on it. Let’s say you entered an invoice in QuickBooks Online, and an income item for that exact amount gets downloaded from your bank. QBO will assume that those two “match,” and display them in the In QuickBooks column. You can click Undo if this is incorrect. But you can also click Find match in the transaction window, and QBO will open a list of possibilities.

As you can see from browsing the lists of downloaded transactions, there’s a lot to learn here. We’d be happy to get together and walk you through your first explorations of these powerful features.

5 QuickBooks Online Add-On Apps You May Need to Add

Not finding quite everything you need in QuickBooks Online? Here are some handy add-on apps available.

QuickBooks Online may work for you just fine as is. After all, it was designed to meet the needs of the millions of small businesses that want to manage and track their income and expenses, create records and transactions, and run reports to gauge their financial health. QuickBooks Online was also designed to grow along with your business. But there’s no need for Intuit to add internal features to do so. In fact, that would make it too expensive and unwieldy for many companies.

Instead, Intuit has partnered with other small business websites to provides add-ons–applications that extend the usefulness of QuickBooks Online in one or more areas, like accounts receivable and payable, inventory, and expense-tracking. They integrate easily to share data and do the extra work you need. Here are some of them to consider.

Bill.com

Bill.com automates your accounts receivable and payable processes. It supports electronic billing and payment, as well as multiple approval levels.

You can certainly enter and pay bills using QuickBooks Online. And you can send invoices to customers and receive payments. But adding a connection to Bill.com gives you more advanced options for accounts receivable and payable. Simply send your bills to Bill.com by scanning, emailing, faxing, or taking a picture with your smartphone. The site’s automation tools turn them into digital records and route them through your specified approvers. Once approved, they’re paid electronically or by paper check. Invoices are just as easy to process; customers can pay by using PayPal, credit card, or ACH. Bill.com’s mobile app makes it possible to keep up with invoices and bills while you’re out of the office.

Expensify

Are your employees still paper-clipping receipts to handwritten expense reports? This method is unnecessarily time-consuming – and often inaccurate. Expensify solves both problems. Your staff can take photos of receipts with their smartphones. Expensify then converts the expense information into coded digital records and submits them for approval based on your company’s policies. Credit card purchases can be automatically imported, too. All data is synchronized with QuickBooks Online in real-time and coded to reflect your preference of QBO’s expense accounts, customers/jobs, etc. Once you’ve approved a report, you can have the money deposited in the employee’s bank account the next day.

TSheets Time Tracking

TSheets employee scheduling software automates tasks that QuickBooks Online doesn’t do: scheduling and remote time-tracking for your hourly employees. Your staff no longer has to fill in paper timesheets. Instead, they can use their smartphones to track their hours and GPS location points. And while Excel is certainly better for creating schedules than paper, TSheets takes over that task, too. After you’ve approved timesheets, that information is sent over to QuickBooks, ready for use in your payroll processing.

quickbooks

Your employees can easily “punch” in and out using their smartphones. TSheets also uses GPS technology so that your staff members’ locations are always known to you.

SOS Inventory

QuickBooks Online performs some basic inventory management tasks. You can create records for items and use them in transactions, and keep track of the number of items in stock so you know when to reorder (or have a sale). SOS Inventory goes well beyond those capabilities. You can create sales orders, track cost history and serial numbers, and document work-in-progress (WIP). SOS Inventory supports multiple locations and the entire pick/pack/ship process.

Insightly CRM

You can create thorough customer records in QuickBooks Online and document some of your interaction. But it doesn’t facilitate true Customer Relationship Management (CRM) nor project management. Insightly CRM does both. It lets you build exceptionally thorough customer profiles so that you can view social streams, email history, and any events, opportunities, or events related to them. Its project management features include the ability to track by pipelines or milestones, define contact roles and custom fields, and generate advanced project reporting.

QuickBooks Online Integration Key

All of these apps can work in standalone settings, but their integration with QuickBooks Online and their mobile capabilities create powerful partnerships that help you serve both your customers and your employees in ways that QuickBooks Online alone can’t.

We’re not trying to sell you applications here. Our concern is that you’re getting as much out of QuickBooks itself as you can. We can steer you toward add-on solutions if that seems necessary, but we’re always happy to work with you on getting to know QuickBooks Online better and matching its capabilities to your company’s needs.

Are You Applying Finance Charges? Should You Be?

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

Beware the Social Media Swamp-Learn How to Deal with Unhappy Customers

The reach of social media goes beyond sharing family photos. Shoppers are reading product reviews online before deciding what to purchase. And disgruntled customers are sharing their displeasure with anyone who will read their rants.

A New Risk

The benefit of social media to small businesses is considerable. It has leveled the playing field in many ways. But it has also introduced new risks. One of the most critical is that bad reviews or negative comments could ruin your business’s reputation — or worse.

A Proactive Approach

How can you protect your business from online attacks? Here are some suggestions:

Join the conversation. If you’ve been visible on social media, you’ll have more credibility if something erupts. But that’s not the only reason to have a social media presence. Even if your business is never involved in an online dustup, social media offers an opportunity to market and promote your business and engage with your customers. Smartphones and tablets have made it even easier for people to go online.

Pay attention. Monitor the Internet for news about your brand. Routinely check online review sites (if appropriate) and social networking sites for references to your company, and run your company’s name through a search engine.

Be prepared. You can’t draft specific responses ahead of time, but you can identify your vulnerabilities and draft a response strategy. You’ll be well ahead of the game if you do this before a crisis hits rather than during one. You’ll also be able to dial down your emotions and respond more objectively. There’s another upside to identifying your vulnerabilities ahead of time: You have an opportunity to eliminate them.

Respond. Make sure you have the facts straight before you do anything. However, things can escalate rapidly online. So if you’re going to respond, do so quickly and publicly. That said, not every attack warrants a public response. The complaint may not be legitimate or the person complaining may be a troublemaker, in which case responding may be a waste of time.

Half Full

Any time your business is under attack — online or off — try looking at it as an opportunity to change some minds and bolster your reputation.

Five Strategies for Tax-Efficient Investing

As just about every investor knows, it’s not what your investments earn, but what they earn after taxes that counts. After factoring in federal income and capital gains taxes, the alternative minimum tax, and any applicable state and local taxes, your investments’ returns in any given year may be reduced by 40% or more.

For example, if you earned an average 6% rate of return annually on an investment taxed at 24%, your after-tax rate of return would be 4.56%. A $50,000 investment earning 8% annually would be worth $89,542 after 10 years; at 4.56%, it would be worth only $78,095. Reducing your tax liability is key to building the value of your assets, especially if you are in one of the higher income tax brackets. Here are five ways to potentially help lower your tax bill.1

Invest in Tax-Deferred and Tax-Free Accounts

According to Webtaxonline tax-deferred accounts include company-sponsored retirement savings accounts such as traditional 401(k) and 403(b) plans, traditional individual retirement accounts (IRAs), and annuities. Contributions to these accounts may be made on a pretax basis (i.e., the contributions may be tax deductible) or on an after-tax basis (i.e., the contributions are not tax deductible). More important, investment earnings compound tax deferred until withdrawal, typically in retirement, when you may be in a lower tax bracket. Contributions to non-qualified annuities, Roth IRAs, and Roth-style employer-sponsored savings plans are not tax deductible. Earnings that accumulate in Roth accounts can be withdrawn tax free if you have held the account for at least five years and meet the requirements for a qualified distribution.

Pitfalls to avoid: Withdrawals prior to age 59½ from a qualified retirement plan, IRA, Roth IRA, or annuity may be subject not only to ordinary income tax but also to an additional 10% federal tax. In addition, early withdrawals from annuities may be subject to additional penalties charged by the issuing insurance company. Also, if you have significant investments, in addition to money you contribute to your retirement plans, consider your overall portfolio when deciding which investments to select for your tax-deferred accounts. If your effective tax rate — that is, the average percentage of income taxes you pay for the year — is higher than 12%, you’ll want to evaluate whether investments that earn most of their returns in the form of long-term capital gains might be better held outside of a tax-deferred account. That’s because withdrawals from tax-deferred accounts generally will be taxed at your ordinary income tax rate, which may be higher than your long-term capital gains tax rate (see “Income vs. Capital Gains”).

Income vs. Capital Gains

Generally, interest income is taxed as ordinary income in the year received, and qualified dividends are taxed at a top rate of 20%. (Note that an additional 3.8% tax on investment income also may apply to both interest income and qualified (or non-qualified) dividends.) A capital gain or loss — the difference between the cost basis of a security and its current price — is not taxed until the gain or loss is realized. For individual stocks and bonds, you realize the gain or loss when the security is sold. However, with mutual funds, you may have received taxable capital gains distributions on shares you own. Investments you (or the fund manager) have held 12 months or less are considered short term, and those capital gains are taxed at the same rates as ordinary income. For investments held more than 12 months (considered long term), capital gains are taxed at no more than 20%, although an additional 3.8% tax on investment income may apply. The actual rate will depend on your tax bracket and how long you have owned the investment.

Consider Government and Municipal Bonds

Interest on U.S. government issues is subject to federal taxes but is exempt from state taxes. Municipal bond income is generally exempt from federal taxes, and municipal bonds issued in-state may be free of state and local taxes as well. An investor in the 32% federal income tax bracket would have to earn 7.35% on a taxable bond, before state taxes, to equal the tax-exempt return of 5% offered by a municipal bond. Sold prior to maturity or bought through a bond fund, government and municipal bonds are subject to market fluctuations and may be worth less than the original cost upon redemption.

Pitfalls to avoid: If you live in a state with high state income tax rates, be sure to compare the true taxable-equivalent yield of government issues, corporate bonds, and in-state municipal issues. Many calculations of taxable-equivalent yield do not take into account the state tax exemption on government issues. Because interest income (but not capital gains) on municipal bonds is already exempt from federal taxes, there’s generally no need to keep them in tax-deferred accounts. Finally, income derived from certain types of municipal bond issues, known as private activity bonds, may be a tax-preference item subject to the federal alternative minimum tax.

Look for Tax-Efficient Investments

Tax-managed or tax-efficient investment accounts and mutual funds are managed in ways that may help reduce their taxable distributions. Investment managers may employ a combination of tactics, such as minimizing portfolio turnover, investing in stocks that do not pay dividends, and selectively selling stocks that have become less attractive at a loss to counterbalance taxable gains elsewhere in the portfolio. In years when returns on the broader market are flat or negative, investors tend to become more aware of capital gains generated by portfolio turnover, since the resulting tax liability can offset any gain or exacerbate a negative return on the investment.

Pitfalls to avoid: Taxes are an important consideration in selecting investments but should not be the primary concern. A portfolio manager must balance the tax consequences of selling a position that will generate a capital gain versus the relative market opportunity lost by holding a less-than-attractive investment. Some mutual funds that have low turnover also inherently carry an above-average level of undistributed capital gains. When you buy these shares, you effectively buy this undistributed tax liability.

Put Losses to Work

At times, you may be able to use losses in your investment portfolio to help offset realized gains. It’s a good idea to evaluate your holdings periodically to assess whether an investment still offers the long-term potential you anticipated when you purchased it. Your realized capital losses in a given tax year must first be used to offset realized capital gains. If you have “leftover” capital losses, you can offset up to $3,000 against ordinary income. Any remainder can be carried forward to offset gains or income in future years, subject to certain limitations.

Pitfalls to avoid: A few down periods don’t necessarily mean you should sell simply to realize a loss. Stocks in particular are long-term investments subject to ups and downs. However, if your outlook on an investment has changed, you may be able to use a loss to your advantage.

Keep Good Records

Keep records of purchases, sales, distributions, and dividend reinvestment so that you can properly calculate the basis of shares you own and choose the shares you sell in order to minimize your taxable gain or maximize your deductible loss.

Pitfalls to avoid: If you overlook mutual fund dividends and capital gains distributions that you have reinvested, you may accidentally pay the tax twice — once on the distribution and again on any capital gains (or under-reported loss) — when you eventually sell the shares.

Keeping an eye on how taxes can affect your investments is one of the easiest ways you can enhance your returns over time. For more information about the tax aspects of investing, consult a qualified tax advisor.

Source/Disclaimer:

Example does not include taxes or fees. This information is general in nature and is not meant as tax advice. Always consult a qualified tax advisor for information as to how taxes may affect your particular situation.

Important Facts About the New Laws on Mortgage Interest Tax Deduction

If you are one of the millions of Americans who own your own home, you should be thinking about how President Trump’s latest tax bill helps or dents your finances; particularly when it comes to the ever-popular mortgage interest deductions. This article should put you ahead of the subject.

First off, if you are a homeowner with no intentions of changing anything soon, your mortgage deductions are unaffected (with a couple of exceptions we deal with below).

The new laws apply only to those buying a home after 15th December 2017. If you fall into this category it boils down to understanding 3 key items:

  • There’s a cap of $750,000 (previously $1 million) on your total mortgage value (covering private and secondary homes in aggregate) that qualifies for interest deduction.
  • Discussing interest rate deduction on new home purchase goes hand-in-hand with the cap placed on Property Tax Deduction – now set at $10,000 (previously unlimited).
  • The Standard Deduction has been nearly doubled for all categories of tax filers in 2018 onward.

Logically, anyone who intends buying in expensive locations or/and locations with property taxes above $10,000 should stop to think about it:

  • High property prices of course generally call for higher mortgage financing, And it often happens that premium locations are also the ones with the highest real estate taxes – a double whammy effect if you will.
  • In situations like this, it seems that the traditional enthusiasm around interest rate deductions may become somewhat jaded. It gives a whole new meaning to the popular realtor’s mantra, “location, location, location!”

The one escape hatch is to simply forget about itemizing interest payment and property tax claims; go to the expanded Standard Deduction now provided. But then again, the apparently increased relief offered by this new provision should be viewed alongside the knowledge that individual personal exemptions have been removed – which brings family size into the equation. If you have a lot of dependents (e.g. children or elderly parents) you may find yourself after all is said and done unchanged – or worse still, going backward.

Here’s another curveball that throws the cat amongst the pigeons: irrespective of when you bought or intend to buy your home/ homes (i.e. before or after the December 2017 law, it’s all the same) interest on second mortgages and on mortgages attached to unrented vacation residences is no longer deductible. Period. Given this, and all the other considerations are drawn into the conversation (as outlined above), it is impossible to provide a quick “catch-all” solution on interest rate deductibility. We can say this, however:

  • It is likely there’ll be a homebuyer movement away from expensive property purchases for the foreseeable future, resulting in a growing tendency to relocate to tax-friendlier regions.
  • The upper-middle class homebuyers will need to analyze these new tax provisions with a fine toothcomb, and even consider renting out vacation homes for part of the year to bring interest rate deduction back into the equation.
  • Those buying at home prices under the $750,000 cap limit with under-$10,000 property tax limits should have a far easier passage.

Conclusion: It’s at times like this that astute tax advice paves the way forward and dispels doubt. As you can see there are numerous considerations, especially for larger families and those fortunate enough to own more than one home. Also, those on the cusp of relocating should be looking at all the variables as well as state taxes before making the move. Our team is geared to answer your questions on every aspect of real estate related deductions. Contacting us sooner than later may be the wisest decision you can make this year.

Not Using QuickBooks Online? What You’re Missing Out On

If you dread every minute of the time you spend on accounting, you should know how QuickBooks Online can change your outlook.

How long would it take you to determine:

  • What your total expenses for this quarter are?
  • Whether or not your business is profitable as of today?
  • How much you’ve sold every month this year?
  • Which invoices are overdue?

If you’re using QuickBooks Online, you can get answers to all those questions—and more—in the time it takes you to sign on to the website.
That’s not an exaggeration. The first thing QuickBooks Online displays is what’s called its Dashboard. This is the site’s home page, which contains an array of charts and account balances that provide a quick overview of your finances. Click on an element here—say, a checking account balance—and you’ll be able to drill down and see the details behind it (in this case, an online account register). Click on the Expense graph, and a transaction report opens.

Your First Hours with QBO

QuickBooks Online is not one-size-fits-all. Its setup tools help you customize it to meet your own company’s needs.

QuickBooks Online works like other online productivity applications you may have used. It uses toolbars and buttons for navigation, drop-down lists and blank fields for data entry, and clickable links to open new related screens to trigger actions. Which is to say, the site is easy to use once you understand its structure. We can walk you through the early steps that are required, which involves tasks like: Using the provided setup tools to customize the site. Connecting QuickBooks Online to your bank and credit card company websites so you can work with transactions. Creating records for your customers, vendors, and the products and services you sell (you’ll be able to add new ones as your business grows). Learning about QuickBooks Online’s pre-built reports. Familiarizing yourself with the site’s workflow. Making the transition from your current accounting system.

How You’ll Benefit

Once you’re comfortable using QuickBooks Online, you’ll discover what millions of small businesses have already learned, that the site helps you:
Get paid faster. You can sign up with a payment processor to accept credit cards and direct bank withdrawals, which can speed up your customers’ responses to invoices. You’ll also be able to accept payments when you’re out of the office on your mobile devices.

Minimize errors. Once you enter data, QuickBooks Online remembers it. No more duplicate data entry that can cause costly mistakes.

Find any detail in seconds. QuickBooks Online has powerful search tools that allow you to find what you’re looking for quickly.
Better service customers. Because your customer profiles include transaction histories, you’ll be able to deal with questions and problems quickly and accurately.

Bill time as well as invoice products. QuickBooks Online supports sales of time-based services with capable time-tracking tools.

Improve your customers’ and vendors’ perception of you. Your business associates will know that you’re using state-of-the-art technology by the forms you share and the customer service you provide.

Save money and time. As the accountant rotterdam has noted, it does take some time to make the transition to QuickBooks Online. But you’ll quickly make that up with the hours you’ll save on accounting tasks, and be able to concentrate on tasks that improve your bottom line.

Be prepared to grow. Because all of your financial data is organized and easily accessible, you’ll be able to quickly generate reports that help you plan for a more profitable future. Banks and investors will need some of these if you decide to seek financing.

Mobile Access

Although you may do the bulk of your accounting work on your desktop or laptop, you’ll have access to many of the site’s features on your smartphone. Your home page displays both an abbreviated version of your browser-based dashboard and a list of recent transactions. You can view, edit, and build new customer, vendor, and product or service records. Snap a photo of a receipt to document an expense and look up or create invoices, estimates, and sales receipts. Record payments, view critical reports, and add notes. Of course, your mobile data is always synchronized with the site itself.

QuickBooks Online lets you do much of your accounting work when you’re away from the office with its mobile app.

Happy to Help

QuickBooks Online was designed for small business people, not accountants. But it includes features that are best used in conjunction with our consulting services, like advanced reports, payroll, and the Chart of Accounts. In fact, the site makes it easy for us to have access to your data so we have the ability to monitor and troubleshoot.

We’ve helped countless sole proprietors and small businesses move their accounting operations to QuickBooks Online, and we’ve seen the difference it’s made in their productivity as well as their attitude toward financial management. Contact us, and we’ll be happy to do the same for you.

Social media posts

Still doing your accounting manually? You’re spending unnecessary hours and experiencing needless frustration. Talk to us about QuickBooks Online.

Did you know you can do much of your accounting work and accept customer payments on your smartphone? Let us introduce you to QuickBooks Online.

Are you often away from the office? QuickBooks Online lets you handle accounting tasks from anywhere there’s an internet connection. We can tell you how.

Does your manual accounting system make it hard to keep track of customers and inventory? QuickBooks Online can organize and manage both. Contact us.

Getting Started with Accounts in QuickBooks Online, Part 1

QuickBooks Online was built to work with transactions downloaded from your online financial institutions. Here’s how to work with them.

The ability to import transactions from financial institutions into QuickBooks Online is definitely one of the best things about the site. You may have even signed up for that very reason.

By now, you’ve probably already set up at least one connection. But are you using all of the QuickBooks Online’s account tools? There’s a lot you can do once you’ve imported in data from your bank or credit card provider with the help of an accountant. Before you start managing your own money, look for Accountants to get help fast.

We’ll explore these features in this column and the next.

First Steps

If you’re a new subscriber, you may not have established these critical links yet. It’s an easy process. Start by clicking the Banking link in the left vertical navigation pane. In the upper right corner, click Add Account and enter the name of your financial institution if it’s not pictured. Then follow the instructions you’re given on the screen. These can vary depending on the bank or credit card provider, but you’re always at least asked to enter the user name and password that you use to log into each online.

Need help with this? Let us know.

Viewing Your Transactions

Once you’ve made a successful connection, you’ll be returned to the Bank and Credit Cards page. You should see a card-shaped graphic at the top of the screen for each account you’ve linked. Click on one. The table that opens is not your account register. The view here defaults to For Review, which refers to transactions you’ve downloaded. The All tab should also be highlighted; we’ll get to Recognized transactions later.

When you first download transactions into QuickBooks Online, before you’ve done anything with them, many will appear under For Review.

There’s a lot going on here, so don’t be surprised if you’re confused. Review each transaction by clicking on it. QuickBooks Online will have guessed at how it should be categorized, but you can change this by opening the list in the category field and selecting the correct one. It’s critical that you get this right since it will have an impact on reports and income taxes. If you need to split it between multiple categories, click on that button found to the right. If the transaction is Billable, check that box and choose a customer from the drop-down list. If you don’t see this box, click the gear icon in the upper right and select Account and Settings | Expenses. Check to see that Make Expenses and Items Billable is turned On (click on Off, then check the appropriate box to turn it on).

Next, determine how you want to process the transaction by clicking on one of the three buttons at the top of the transaction box. Do you want to accept it and add it to that account’s register? Do you want QuickBooks Online to Find (a) Match for it (like a payment that matches an invoice, for example)? Or, do you want to transfer it to another account? Once you’ve made one of these three selections, the transactions that you’ve added or matched will move under the In QuickBooks tab (where you can still Undo them) and will be available in the account’s register.

Other Options

You can save time by using QuickBooks Online’s Batch Actions tool or even with DPS Accounting .

Say you run across some duplicate or personal transactions that you don’t want to appear in the current account’s register. Check the box in front of each, then click the arrow in the Batch Actions box. Select Exclude Selected. They’ll then be available under the Excluded tab. You can also Accept or Modify multiple transactions simultaneously by using this tool.

So far, you’ve been viewing All your transactions. Click on Recognized to the right of it. These are transactions that are already familiar to QuickBooks Online because they’ve appeared before and/or have been matched, or because you’ve created Bank Rules for them (we’ll address that concept next month). You’ll need to address these the same way you did the transactions in the For Review section; you can either Add or Transfer them.

If you’re new to QuickBooks Online, this may all sound pretty complicated. It can be at first. But once you’ve worked with downloaded transactions for a while, you’ll understand the flow much better. If you’re not clear on the process from the start, it can lead to trouble. Contact us at your convenience. We’d be happy to sit down with you and go through it all using your own company’s data; the familiarity may help.

Social media posts

If you’re new to QuickBooks Online, there’s a lot you need to understand about dealing with downloaded transactions out the gate. Let us help.

When you download transactions into QuickBooks Online, the site sometimes automatically “matches” them to existing entries. We’re here to explain and help you navigate this. Tired of reviewing downloaded transactions one by one in QuickBooks Online? Click on the Batch Actions button to explore this feature. We can show you how.

QuickBooks Online often guesses at how downloaded transactions should be categorized. You should always check these for accuracy, and we can show you how.

Resolve to Do These 3 Things in QuickBooks Online This Month

‘Tis the season for making resolutions and setting goals. Try exploring these three areas to dig deeper into QuickBooks Online.

By now, many New Year’s resolutions have already been made – and broken. Though they’re usually created with the best of intentions, they’re often just too ambitious to be realistic.

 

For example, you might decide to learn more about QuickBooks Online and keep up with your accounting chores more conscientiously in 2019. That’s hard to quantify. How will you know if you achieved that goal?

 

Instead, why not pick three (or more) specific areas and focus on them this month? We’ll get the ball rolling for you by making some suggestions.

 

Explore the QuickBooks Online mobile app:

 

Yes, QuickBooks Online itself is already mobile; you can access it from any computer that has an internet connection and browser. But you probably don’t always lug a laptop around when you’re away from the office, and you’re sometimes at locations were using it wouldn’t be practical. But you can always pull out your smartphone and fire up the QuickBooks Online app, available for both iOS and Android.


No matter how small your smartphone (this image was captured on an iPhone SE), you can still do your accounting tasks using QuickBooks Online’s app.

QuickBooks Online’s app replicates a surprising percentage of the features found on the browser-based version. You can create, view, and edit invoices, estimates, and sales receipts for example, as well as see abbreviated customer and vendor records. Your product and service records are available there, including tools for recording expenses on the road.

 

Create a budget for one month:

 

Budgets are intimidating. That’s one reason why some small businesses don’t create them. So instead of trying to estimate what your income and expenses will be for an entire fiscal year, just build a budget for one month. In QuickBooks Online, you’d click the gear icon in the upper right, then select Budgeting. Click Add budget in the upper right to open the New Budget window.

 

Give it a name, like “February Budget,” and select FY2019. Leave the Interval at Monthly, and open the Pre-fill data? menu to click on Actual data – 2018 (if you have data from last year). Then click Create Budget in the lower right corner. Look at last year’s February numbers and estimate how they might change in 2019. Replace the old numbers with your new ones.

Creating a framework for a budget in QuickBooks Online is easy.

We’re suggesting you try it for just one month, so you get a feel for how this tool works. And that experiment will probably leave you with some questions. We can help you go further and complete an annual budget.

 

Customize your sales forms:

 

Every piece of paper and email you send to your customers contributes to their impression of you. Are you presenting an attractive, consistent image of your business to them? QuickBooks Online can help with this. It offers simple (for the most part) tools that allow you to modify the boilerplate forms offered on the site – without being an experienced graphic designer.

 

Start by clicking on the gear icon in the upper right and selecting Your Company | Custom Form Styles. Unless you’ve done some work in this area before, the screen that opens will have just one listed entry: your Master form, the one that comes standard in QuickBooks Online. To see what you can do, click Edit at the end of that line. Your four options are:

 

  • Design. This section contains links to modifications you can make to your sales forms’ visuals. You can, for example, add a logo or color and change the default fonts. 

Want to change your logo or other elements of your sales forms? QuickBooks Online has the tools.

  • Content. Do you want to add or remove the standard columns (Date, Quantity, etc.) displayed on your invoices? You can do so by checking and unchecking boxes.
  • Emails. QuickBooks Online sends email messages with forms; you can edit them here.
  • Payments. This is a reminder that QuickBooks Online supports online payments, which can help you get paid faster.

There’s more you can do to make your sales forms look professional and polished. We can help you with these tools – and any others you want to explore to expand your use of QuickBooks Online. It’s a new year, and who knows what might come your way over the next 12 months? Contact us if you want to prepare for the new accounting challenges that 2019 might present.

 

Social media posts

 

Did you resolve to grow your understanding of QuickBooks Online in 2019? We can help you explore new features.

 

Go mobile in 2019: Download the QuickBooks Online app for your smartphone. You’d be surprised at how much it can do for you while you’re on the go.

 

How are things going with your 2019 budget? If you don’t have one yet, let us show you how QuickBooks Online simplifies this critical task.

 

QuickBooks Online’s sales forms (like invoices) may work fine for you. Do you know, though, how they can be customized to fit the image of your business? Ask us.

How Does QuickBooks Online Handle Mobile Expenses?

If you purchase several items and services away from the office, QuickBooks Online can help you record them while you’re out and about.
QuickBooks Online’s mobile app, available at the Apple App Store and Google Play, can do many of the same tasks that it performs on your office desktop. You can, for example:

  • Check account balances.
  • Add and edit estimates, invoices, and sales receipts.
  • Add and edit customers, vendors, products, and services.
  • Record invoice payments.

One of the most common uses of the app, though, is the recording of expenses. Rather than coming home from a trip with your briefcase stuffed full of receipts and notes about purchases you made, you can document them on the road using your mobile device. When you get back to the office and log on to QuickBooks Online, they’ll all be there.

How It Works


You can snap a photo of a receipt with your smartphone and attach it to an expense you record in QuickBooks Online’s mobile app.
Open your QuickBooks Online mobile app and click the plus (+) sign at the bottom, then tap the Expense icon. The New Expense screen will open. If you have a paper receipt, lay it flat on a table in a well-lighted area. Click the camera icon and then the Take Photo link. If you took the picture outside of QuickBooks Online for some reason, you’d select the Choose Existing link. Your device’s camera will open, and you’ll see four squared corners on the edges of the screen.

Hover your device over the receipt. You’ll need to position the camera so the receipt area that you want to be captured appears within the four corners. QuickBooks Online will provide advice along the way to help you do this. When you’re in the right place, you’ll see the phrase, Great! Snap the pic. Click the shutter icon below, and your device will snap the photo and display it. If you want to use it, click Use this photo (if you want to try again, click the X in the upper left of the screen).

QuickBooks Online will open the New Expense screen. You’ll see a miniature version of your receipt in the upper left corner. Looking at your original version—it will be too small to see here—fill in the blanks with the data from the purchase. Be sure to click the Billable button if you can bill someone else for it. Make any notes you’ll need in order to remind yourself of the transaction, and Add a Split if you need to divide the transaction between categories, customers or vendors, or billable status. Click Save when you’re done.

Automatic Synchronization


Once you’ve entered an expense in QuickBooks Online’s mobile app, it will be synchronized with your desktop, browser-based version.
Of course, no duplicate data entry is required once you’ve entered a receipt in the QuickBooks Online mobile app – the two versions always update each other.

Once you’re back at your desktop, on the browser-based version of QuickBooks Online, click Expenses in the toolbar to open the Expense Transactions screen. You should see the transaction you just created on your mobile device first in line on the list that displays. Click View/Edit at the end of that line to see it. Look toward the bottom under Item Details to see the link to an attachment that contains the photo you snapped of the receipt.


The record of the expense you entered on your mobile device will contain a link to an attachment that contains the photo of your receipt.
Of course, you don’t have to take a picture of your receipt with your mobile device. You can simply enter the details of your expense and Save the record.

QuickBooks Online’s mobile app can help you save time and improve the accuracy of your work done away from the office. As we mentioned earlier, the app is capable of doing much more than simply recording receipts. We’d be happy to run you through its pieces to make sure your remote accounting work is done correctly and this is done by companies like DPS Accounting  which manage the best accounting system.

Social media posts

Have you downloaded and explored QuickBooks Online’s iOS or Android mobile app? There’s a lot you can do away from the office. Let us show you how.

If you come home from trips with a briefcase full of receipts, you should consider entering them quickly and remotely on the QuickBooks Online mobile app.

Collecting a lot of receipts on the road? Snap photos of them using QuickBooks Online’s mobile app. Your expense record will sync with the browser-based version.

Did you know when you take a picture of a receipt using QuickBooks Online’s mobile app, it appears as an attachment in that expense record in your desktop version?

1 2 3 15