Importing your bank transactions into QuickBooks saves time, improves accuracy, and makes you a better money manager.

It’s been a long time since your only options for learning about your bank balances and cleared transactions involved your telephone and your monthly statement. These days, accounting software and websites allow you to set up online connections to your financial institutions and download cleared transactions.

If you’re new to QuickBooks or you haven’t set up online banking yet, you may not realize how simple it can be (depending on your financial institution), or how safe it is. You can connect to one of your banks and import months of transactions in less than 10 minutes, depending on how active your accounts are, and again, your banks. And QuickBooks uses data protection that is similar to what banks themselves use. As long as you’re following personal security protocols on your own computer, you’re very unlikely to encounter problems.

Online banking saves an enormous amount of time. It provides daily updates on your accounts, and if you entered the original transactions correctly, accuracy is assured. This real-time view of your finances can help you avoid money problems, make better business decisions, and plan for your company’s future.

Here’s how it works.

The Bank Feeds Center

QuickBooks provides the tools required to set up and maintain online banking in the Bank Feeds Center. To get there, open the Banking menu and select Bank Feeds, then Bank Feed Center. Click Add account in the upper right. QuickBooks will display a message saying it needs to close all open windows. Click Yes. In the Bank Feed Setup window that opens, select your bank from the list or enter its name in the search box if it’s not there.

Not every financial institution provides a direct connection to QuickBooks, but many of the major ones do. If yours does, you’ll see a window like this:

Enter the user ID and password that you use to sign on to your bank’s website, then click Connect. You may be told that your financial institution needs more information. If that occurs, just follow the instructions. In our example, Discover Card wanted to send a temporary identification code as an email or text. Select your preference from the drop-down list and click Connect. Once you’ve retrieved your code and entered it, click Connect again. QuickBooks will open a window that displays your account(s) at the institution.

Now you have to tell QuickBooks where to download the transactions. Click the down arrow in the field under QuickBooks Accounts. You can select an existing account or create a new one. We want to create a new one here, so you’d click  Create New Account. You may recognize the Add New Account window if you’ve done this before. QuickBooks already knew that this was a credit card account, so it pre-selected that option in the Account Type field. If you’re connecting a checking account, for example, you would probably want to select Bank. Enter an Account Name. If you want to make it a Subaccount of another account, check that box and select the parent account from the drop-down list (or add a new one).

The rest of the fields here are optional. You can fill in the description and account number if you’d like, but don’t assign Tax-Line Mapping or Opening Balance without talking to us. Just leave them for now. When you’re done, click Save & Close. Click Connect in the window that opens after you’ve made sure your new account is showing in the field below QuickBooks Accounts.

If all has gone well, you’ll get a message saying that your account has been added to QuickBooks. Click Close. Go to Banking | Bank Feeds | Banks Feeds Center again. In the field next to Bank and Credit cards, click the down arrow to see a list if your new account isn’t already showing and select it. Click the rotating circle in the blue card below to download your first set of transactions (or anytime you want to refresh the feed). This will typically bring in 90 days of transactions, depending on your financial institution.

There are many ways financial institutions interact with QuickBooks’ bank feeds. This was the simplest one. You might have to contact your financial institution to get QuickBooks Direct Connect set up (fees may apply) or you may have to go to your bank’s website and select the statement or transactions you want to move into QuickBooks.

Next month, we’ll talk about managing the transactions you’ve downloaded into QuickBooks. In the meantime, we’re happy to help you troubleshoot your bank downloads if you need help.

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

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

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

Before You Start

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

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

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

Three Statement Types

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

One Way to Create Statements

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

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

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

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

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

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

Another Method

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

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