How to Download Bank Feed Transactions in QuickBooks

QuickBooks Desktop supports bank feeds. Using this feature, you can connect your business’s credit card and bank accounts to your QuickBooks Desktop account. When you make a financial transaction, it will then appear automatically in your QuickBooks Desktop account. To take advantage of this feature, however, you must download your bank feed transactions in QuickBooks Desktop

Download With Direct Connect

You can download your bank feed transactions using Direct Connect. Start by clicking the “Banking” menu in QuickBooks Desktop. Under “Bank Feeds,” choose “Bank Feeds Center.” You can then choose the credit card or bank account that you want to connect to your QuickBooks Desktop account.

Selecting “Download Transactions” will initiate the download process. QuickBooks Desktop will automatically download transactions from the connected credit card or bank account. You won’t have to manually enter the transactions. Rather, QuickBooks Desktop will take this burden off your shoulders by downloading them automatically.

Download With Web Connect

In addition to Direct Connect, you can download your bank feed transactions using Web Connect. Start by clicking the “Banking” menu and choosing “Bank Feeds,” followed by “Banking Center.” You can then select your bank and choose “Download Transactions.”

Web Connect works by allowing you to log in to your account online. Upon clicking the “Download Transactions” link, you’ll be redirected to the login page for your credit card or banking account. You can then log in to your account, at which point QuickBooks Desktop will begin to download transactions from your account.

Reviewing Transactions

You may want to review transactions after downloading them. To review transactions, go back to the “Banking” menu and select “Bank Feeds,” followed by “Bank Feeds Center.”

In the Bank Feeds Center, you should see several categories. Each category features a transaction type. You can go through these categories to review your transactions.

In Conclusion

You don’t have to manually enter your business’s financial transactions in QuickBooks Desktop. An easier solution is to download them. There are two primary ways that you can download transactions from a credit card or bank account: Direct Connect or Web Connect. Direct Connect will automatically download the transactions once you’ve connected the account. Web Connect, in comparison, requires you to log in to your account online. Regardless, you can use either of these methods to download bank feed transactions in QuickBooks Desktop.

Have anything else that you’d like to add? Let us know in the comments section below!

QuickBooks 101: How to Create a Custom Email Template

You don’t have to send the same generic-looking invoice or receipt to all of your business’s customers. If you use QuickBooks, you can create custom email templates for forms such as these. It’s a native feature of QuickBooks Desktop. Custom email templates serve the same purpose as the default forms, but they allow you to customize the included elements to fit your business’s needs. How do you create a custom email template exactly?

Switch to Single-User Mode

Make sure your QuickBooks account is in single-user mode. QuickBooks offers single-user mode and multi-user mode. The former means only a single user can access the company file, whereas the latter means multiple users can access the company file. If your QuickBooks account is currently in multi-user mode, go ahead and switch it to single-user mode.

Single-user mode is available by clicking the “File” menu in QuickBooks and selecting “Switch to Single-User Mode.” Switching to single-user mode will ensure that you have the necessary permissions to create a custom email template.

Choose a Transaction Type

When you’re ready to create a custom email template, click the “Edit” menu and choose “Preferences.” You should see an option for “Send forms.” Clicking this option will reveal a “Company Preferences.” After selecting the “Company Preferences” tab, choose “Email” as the default delivery method.

The “Email Templates” menu has several different types of transactions from which you can choose, such as invoices, estimates, statements, sales orders, sales receipts, purchase orders, overdue invoices and more. Choose the transaction type that you want to create the custom email template for. Keep in mind that you can create multiple email templates for any given transaction type.

Add the Template

Upon choosing a transaction type, you should see an option for “Add Template.” Clicking the “Add Template” option will add it to your QuickBooks account.

QuickBooks will require you to enter a name for the template. The name won’t be shown in the actual form, meaning your business’s customers or vendors won’t see it. Nonetheless, you should choose a memorable and relevant name so that you can recognize the template internally. After naming the template, you can then customize it. You can enter a custom subject line and body text, and you can add dynamic data t using the “Insert Field” option. When finished, click “Save” to complete the process and save your new custom email template.

Did this tutorial work for you? Let us know in the comments section below!

How to Prevent Windows Firewall From Blocking QuickBooks

Is your computer’s firewall preventing you from accessing QuickBooks? The Windows operating system (OS) comes with a built-in firewall. It will automatically scan incoming and outgoing network traffic. If there’s a threat, the firewall will block it. But the Windows firewall often flags otherwise safe and legitimate programs as being threats. It may even block QuickBooks. When blocked, you may still be able to open QuickBooks, but you won’t be able to connect it to the internet.

Use the File Doctor Tool

If Windows firewall is blocking your locally installed copy of QuickBooks Desktop, you should start by running the File Doctor tool. It’s available in the QuickBooks Tool Hub, which you can download here. After opening QuickBooks Tool Hub, click “Company File Issues.” You should then see an option to run the File Doctor tool.

The File Doctor tool will prompt you to select your company file. After choosing your company file, click “Check your file and network.” The File Doctor tool will then scan your company file and network for potential problems.

Change the Firewall Settings

In some cases, the File Doctor tool will resolve firewall-related problems. In others, you may need to change the firewall settings.

You can change the settings for Windows firewall in just a few easy steps. While viewing the desktop screen on your computer, navigate to the search box and enter “firewall.” Next, open the Windows Firewall settings page from the search results list and choose “Advanced Settings.”

The settings page should have an option to create new rules. Firewalls, of course, are based on rules. They allow or deny network traffic based on rules. You can create a new rule that allows QuickBooks to access the internet from your computer.

Don’t Forget Antivirus Software

Antivirus software can have similar effects on QuickBooks — as well as other locally installed programs — as a firewall. It may wrongfully flag Quickbooks as being a threat, in which you may not be able to access or run the accounting software.

If you’re struggling to use QuickBooks, you should check your antivirus software settings. There may be an option to add “exceptions.” You can specify programs, such as QuickBooks, that the antivirus software will ignore. Regardless, antivirus software and firewalls can both block QuickBooks. The good news is that you can typically remove the block by using the File Doctor tool, changing the firewall settings or changing the antivirus software settings.

Did this tutorial work for you? Let us know in the comments section below!

Why You Should Use QuickBooks Cash Flow Planner

QuickBooks is packed with useful features, one of which is cash flow planner. As the name suggests, cash flow planner is designed to help businesses plan and track their cash flow. Regardless of what your business sells — products, services, etc. — your business probably has money coming into it and going out of it. The term “cash flow” is used to describe this incoming and outgoing money.

What Is Cash Flow Planner?

Cash flow planner is a tool in QuickBooks that can forecast your business’s cash flow. It works by automatically analyzing your business’s historical cash flow and using that information to predict your business’s future cash flow. Cash flow planner will create forecasts revealing your business’s expected cash flow over the next 90 days.

Benefits of Using Cash Flow Planner

With cash flow planner, you’ll have a better understanding of your business’s future cash flow. You can essentially identify cash flow problems before they occur. If your business is expected to have little or no cash on hand in the near future, for instance, cash flow planner may reveal this upcoming problem. You can then cut back on your business’s expenses, increase your business’s revenue or otherwise secure more cash.

You can always manually review your business’s historical cash flow, but cash flow planner automates this process so that you can focus on other activities. Whether you currently use QuickBooks — or if you’re thinking about switching to the popular accounting software — you should take advantage of cash flow planner.

How to Use Cash Flow Planner

Before you can use cash flow planner, you’ll need to link your business’s credit card and bank accounts to your QuickBooks account. Doing so will allow QuickBooks to analyze your business’s historical cash flow, which is necessary for QuickBooks to predict your business’s future cash flow.

Once you’ve linked your business’s credit card and bank accounts to your QuickBooks account, you can access cash flow planner by navigating to “Cash flow” and choosing “Planner.” You should see a settings icon on the cash flow planner page. Clicking this icon will allow you to customize the tool’s settings. You can select LinkedIn accounts, choose transaction types, specify a threshold and more. When finished, click “Save.”

You can export the cash flow planner by choosing “Export as PDF.” QuickBooks will then export the planner to your computer via a Portable Document File (PDF).

Have anything else that you’d like to add? Let us know in the comments section below!

How Does Transaction Tagging Work in QuickBooks?

When using QuickBooks, you may come across an option to tag your business’s transactions. Millions of businesses use QuickBooks. Developed by Intuit, it’s become the world’s most popular accounting software. There are features in QuickBooks, however, that often go unnoticed, one of which is transaction tagging. What is transaction tagging exactly, and how does it work?

What Is Transaction Tagging?

Transaction tagging is a feature in QuickBooks that’s designed to track financial transactions with custom labels known as tags. Financial transactions can include invoices, expenses and bills. Depending on your business’s industry and what it sells, you may want to create tags to track these financial transactions. In QuickBooks, there’s an option to create tags. You can create tags to categorize and track your business’s financial transactions.

While they are both used for similar purposes, tags and categories aren’t the same. Categories are found in the chart of accounts. You can use categories to prepare your business’s taxes. Tags, on the other hand, are transaction-level labels. Tags are specifically designed to track transactions.

How Transaction Tagging Works

You might be wondering how transaction tagging works in QuickBooks. When you create a new tag, you can add it to all financial transactions that match the criteria for which you created the tag. If your business operates in several geographic regions, for instance, you may want to create a separate tag for each of these regions. You can then track all of the financial transactions per region. Tags won’t affect the value or other properties of the transactions with which they are used. Rather, they are used simply for tracking and categorization purposes.

How to Create Tags

In QuickBooks Online, you can create new tags by accessing “Settings,” followed by “Tags.” Next, select “New” and choose “Tag group.” QuickBooks will then prompt you to enter a name for the group. When finished, click “Save.”

Now you can create tags for the newly created group. After pulling up a transaction, enter the name of a tag in the “Tags” field. You’ll also need to select a group for the tag. Assuming you already created a group in the previous step, you can add the tag to this group. QuickBooks will add the tag to the transaction so that you can track it more easily.

Have anything else that you’d like to add? Let us know in the comments section below!

Keep Your Accounting Data Safe With Intuit Data Protect

Data loss is a serious problem for small businesses. Research by the National Cybersecurity Alliance shows that over half of all small businesses are forced to close within six months of experiencing a data loss event. With Intuit Data Protect, however, you can safeguard your business’s accounting data. Available for QuickBooks Desktop Pro Plus, Premier Plus and Enterprise, this subscription service will automatically back up your accounting data.

What Is Intuit Data Protect?

Intuit Data Protect is a backup service offered by the accounting software provider of its namesake. If you use one of the aforementioned versions of QuickBooks, you’ll be able to access it at no additional charge. When configured, it will automatically back up the files and folders that contain your accounting data.

It’s important to note that Intuit Data Protect isn’t limited to accounting data. You can use it to selectively back up your business’s accounting data, or you can use it to back up your entire computer.


Like with other software, there are certain requirements for using Intuit Data Protect. It only works on Windows computers, for instance. You can’t install Intuit Data Protect on other operating systems (OSs), nor can you install it on a virtual Windows machine. Rather, you must install Intuit Data Protect locally on a Windows computer — specifically the computer that contains your company file.

You’ll also need to configure your computer to identify Intuit Data Protect as a “Trusted Site.” Search for “Internet Options” in the Windows search field at the bottom of the taskbar and select “Security.” You should see an option for “Trusted sites.” Select this option, after which you can add Intuit Data Protect and its associated sites.

Getting Started With Intuit Data Protect

To get started with Intuit Data Protect, launch QuickBooks on the computer that contains your company file and navigate to the “File” menu.” Choose “Back Up Company,” followed by “Activate Online Backup.”

You’ll be prompted to log in using the credentials associated with your Intuit Data Protect account. After logging in, choose your company file, followed by “Continue.” Make sure there’s a checkmark in the box for “Back up local selected documents,” after which you can click “Continue” once again. Go through the remaining options, and when you are finished, QuickBooks will automatically back up your company file.

Have anything else that you’d like to add? Let us know in the comments section below!

How to Run a Cash Disbursements Journal Report in QuickBooks

Looking to create a cash disbursements journal report? Not to be confused with a cash disbursements journal report, it will reveal all of the checks your business has written for a given period. At the end of a fiscal quarter, for instance, many businesses run a cash disbursements journal so that they can review their expenditures. Cash disbursements journal reports specifically focus on check-based payments that businesses make to vendors, suppliers and other businesses. If you use QuickBooks Desktop, you can run a cash disbursements journal report in just a few easy steps.

Step #1) Access Custom Reports

To run a cash disbursements journal report in QuickBooks Desktop, you’ll need to access the custom reports section. Click the “Reports” menu and select “Custom Reports.” You can then select “Transaction Detail” to customize the report.

Step #2) Customize It

You’ll need to select a date range for your cash disbursements journal report. You’ll also need to check off various columns for information such as the type, memo, split and amount. Cash disbursements journal reports are fully customizable, so feel free to experiment with different customization options when running them. And remember, you can always go back and run a new cash disbursements journal report if you aren’t satisfied with the initial report.

Step #3) Choose a ‘Total By’ Criteria

QuickBooks will prompt you to choose a “total by” criteria. This will determine the way in which QuickBooks calculates the total amount that your business spent during the period. Available options for the “total by” criteria include payee, account or month.

Step #4) Select ‘Filters’ Tab

After choosing a “total by” criteria, select the “Filters” tab. You should see a list of available filters. For a cash disbursements journal report, select “Transaction type” from the available list. You can then click the drop-down menu for “Transaction type” and select “Multiple transactions.” Next, check off the appropriate columns for information such as check, paycheck and bill payment. To complete the process, click “OK.”

In Conclusion

Journal reports are an invaluable feature of Intuit’s popular accounting software. If you use QuickBooks, you can run journal reports to gain insight into your business’s finances. A cash disbursements journal report is a specific type of journal report that focuses on checks your business has written. You can run a cash disbursements journal report in QuickBooks by following the steps outlined here.

Have anything else that you’d like to add? Let us know in the comments section below!

How to Customize Invoices With ‘Past Due’ in QuickBooks?

If your business allows customers to pay for products or services after the delivery or completion of those products or services, you’ll need to take precautions to ensure that they pay on time. Not all customers will pay their invoices on time. Research shows that over 10 percent of all invoices are paid late. In QuickBooks, however, you can customize invoices with “past due.” This otherwise simple label will make overdue invoices stand out so that you contact those customers to request payment.

Enable the ‘Past Due’ Label for Templates

You can enable the “past due” label for one or more invoice templates. While logged in to QuickBooks Desktop, click the “Lists” menu and choose “Templates.” Scroll through the available list until you find the template for which you want to enable the “past due” label. Select the option to edit the template. Under the “Company & Transaction Information” section, click “Print Past Due Stamp,” followed by “OK.” Opening an overdue invoice will then prompt QuickBooks to add the “past due” label to it.

Add From an Invoice

The former method will automatically show the “past due” label on all overdue invoices with the selected template. But another method to leverage this QuickBooks feature is to manually add it from an invoice. Upon discovering an overdue invoice, open it in QuickBooks. Navigate to the “Formatting” section and select “Manage Templates.” You can then choose a template for the invoice. And under the “Company & Transaction” section,” click “Print Past Due Stamp..” You can complete the process by clicking “OK.”

How the ‘Past Due’ Label Works

The “past due” label is a feature in QuickBooks that’s designed to help business owners collect payments on late, overdue invoices. It will add a label or stamp to the top of invoices. This label will reveal “past due,” indicating that the customer needs to make a payment.

After adding the “past due” label to an overdue invoice, though, you’ll need to send the invoice to the customer. You can email invoices directly to customers. If you don’t know the customer’s email address, on the other hand, you can use direct mail. Once you’ve added the “past due” label to the customer’s invoice, print out the invoice. Next, you can place the invoice in an envelope and mail it to the customer’s home or business address.

Have anything else that you’d like to add? Let us know in the comments section below!

The Beginner’s Guide to Undeposited Funds in QuickBooks

Are you familiar with undeposited funds in QuickBooks? It’s a native feature of the popular accounting software. With undeposited funds, you can essentially consolidate multiple customer payments before depositing that money into your bank account. For a better understanding of undeposited funds, keep reading.

What Are Undeposited Funds?

Undeposited funds are exactly what they sound like: funds that your business has received but hasn’t yet deposited into its bank account. When customers pay you for goods or services, QuickBooks may place those funds in a temporary account. Known as an undeposited funds account, it will consolidate the customers’ payments. You can then initiate a transfer to move the money from the undeposited funds account to your bank account.

What’s the Purpose of Undeposited Funds?

By using undeposited funds, you can make fewer bank deposits. It’s designed primarily to consolidate customer payments. For example, you may have 10 customers, each of whom pay you $100. Without undeposited funds, you would have to make 10 bank deposits. Undeposited funds, however, allows you to consolidate the payments. Rather than making 10 bank deposits of $100 each, you can make a single bank deposit of $1,000.

How to Enable Undeposited Funds

In QuickBooks Desktop, you can enable undeposited funds in just a few easy steps. Start by accessing the “Edit” menu and navigating to “Preferences.” You should see a “Payments” option on the list. Click the “Payments” option and choose the “Company Preferences” tab.

Next, click the “Use Undeposited Funds as a default deposit to account” box so that it has a checkmark in it. Verify the box has a checkmark, after which you can complete the process by selecting “Ok.” You can now choose the undeposited funds account when you create sales receipts.

What About QuickBooks Payments?

If you use QuickBooks Payments to facilitate business-related transactions, you won’t need to use undeposited funds. QuickBooks Payments will automatically handle customer payments and the necessary bank deposits. For invoice payments and sales receipts, though, you may want to use undeposited funds.

You can also check your undeposited funds account to determine which customer payments are being held in it. The undeposited funds account is available to view in your Chart of Accounts. Navigate to the “Lists” menu and select “Chart of Accounts.” You can then right-click the “Undeposited Funds” link and choose “QuickReport: Undeposited Funds.”

Have anything else that you’d like to add? Let us know in the comments section below!

5 Tips for Smoother Reconciliations

Reconciling your business’s credit card and bank statements is essential to preventing accounting errors. Mistakes can happen when recording financial transactions. You may accidentally record the wrong transaction or the wrong amount in QuickBooks. By reconciling your business’s credit card and bank statements, you can find and fix errors such as this. Reconciliation is an auditing process in which you match the financial transactions recorded in QuickBooks to those listed on your business’s credit card and bank statements. Below are five tips for smoother reconciliations.

#1) Start With Oldest Statements

There’s an order in which you should reconcile your business’s credit card and bank statements. Always start with your business’s oldest statements while working your way to your business’s newest statements. If it’s been three months since you last reconciled your business’s statements, for instance, you should begin with the oldest statements from three months ago. Assuming there are no discrepancies, you can move on to the statements from two months ago, followed by last month’s statements.

#2) Use the ‘Hide Transactions’ Feature

When performing reconciliations in QuickBooks, there’s an option to hide all transactions after the statement’s end date. You can use this feature to focus exclusively on a single statement. You won’t see transactions from other statements in QuickBooks. When selected, this feature will hide all transactions after the opened statement’s end date.

#3) Place a Checkmark Next to Matched Transactions

You should place a checkmark next to matched transactions. Matched transactions are those that appear in Quickbooks and one of your business’s credit card or bank statements. Ideally, all of your transactions should match, meaning there are no discrepancies. Placing a checkmark next to a transaction in the QuickBooks reconciliation window indicates it’s accurate and, thus, matched to a statement.

#4) Include Interest and Fees

A common mistake business owners make when reconciling their transactions is omitting interest fees. If you have any business loans or credit cards, you’ll probably have to pay interest on them. Some lenders may charge fees as well. Payments involving interest and fees are transactions. And like all other transactions, you’ll need to reconcile them. Make sure the interest and fees recorded in QuickBooks are the same as those listed on your business’s credit card and bank statements.

#5) Match QuickBooks Transactions to Statement Transactions

The transactions recorded in your QuickBooks account should match those on your business’s credit card and bank statements. In other words, don’t assume that your QuickBooks transactions are accurate. Statement transactions are always accurate, so you should make sure your QuickBooks transactions match them.

Have anything else that you’d like to add? Let us know in the comments section below!



Please read our documentation file to know how to change colors as you want