We are thrilled to announce that Prestige Accounting Services Group (previously Prestige Wealth Accounting Group) has joined forces with Bacchetta & Company in an exciting new partnership!

How Do You Move Transactions from Your Bank into QuickBooks Online?

QuickBooks Online makes this an easy trip but be sure you know how the site handles them once you’ve moved them.

Manual transaction entry doesn’t make sense anymore – not when QuickBooks Online makes the process of importing them from your bank so easy. If you enter them on your own, you risk data transposition errors, which can create inaccuracies in your customer billing, reports, and income taxes. Plus, it takes an inordinate amount of time that you could use in running other areas of your business.

If you’re still using a manual method, we suggest you consider setting up connections to your online banks. Once your transactions are delivered to QuickBooks Online, the site provides tools that allow you to view them and make sure they’re complete before you store them. Whenever you need to see them, you’ll be able to find them easily.

Here are step-by-step instructions to how this all works.

Making a Connection

In order to do this, you’ll of course need to have set up a username and password for your online bank accounts if you haven’t done so already. In QuickBooks Online, click Bookkeeping in the navigation toolbar. It should open to Transactions | Bank transactions. Click Link account over to the right.

A page opens with suggested financial institutions. If yours isn’t there, enter it in the search field at the top. If there are multiple options, be sure to select the correct one and click it.  

If your bank isn’t listed on the page of options, enter its name, and then click on the correct one if there’s more than one entry.

 Click Continue and go through any of the security steps your financial institution may have. You’ll get to a page that says, Which accounts do you want to connect?, with a drop-down list displaying options from your Chart of Accounts. Select the type of account you’re creating (checking, credit card, etc.) and continue to follow the onscreen instructions until your connection is complete and QuickBooks Online has downloaded your transactions.

WARNING: It’s important that you set up your linked accounts correctly since you’re dealing with the Chart of Accounts. If any step is confusing, we can schedule a session to go over online account connections with you.

Dealing with Transactions

Once you’ve connected to all your online accounts, you’ll see that they appear on the Bank transactions page, displayed in small boxes containing their balances and the number of transactions they contain (there might be quite a few when you first download). You can also see how recently each account was updated (click Update anytime you want to refresh an account). 

Once you’ve connected to an online bank account, you can see how many transactions were downloaded and what its balance is. 

 Click one, and its register will appear below. Above that, you’ll see three labeled bars:

  • For review. QuickBooks Online puts all downloaded transactions in this list.

  • Categorized. Your transactions will move to this list after you’ve assigned categories to them.

  • Excluded. If you happen to run into duplicate transactions, you can move them here.

Below that, you’ll see that you can filter your transactions by date, by type, or by description, check number, or amount.

WARNING: As you continue to work with accounts, you may occasionally find that a connection has been unlinked. When that happens, just repeat the connection process again.

Working with Individual Transactions

You’ll want to set some time aside the first time you download transactions so you can look at each one and add or edit its content. Click one to open its detail box, as shown below. The top line defaults to Categorize. First, select the correct Vendor/Customer (or + Add new), then check the Category and change it from the drop-down menu if it’s incorrect.
 

 You can add or edit a lot of details for your individual transactions. 

 There’s one more field here that’s very important. If you’re purchased something on behalf of a customer, be sure to select the correct one from the drop-down list under the Customer field and click the Billable box. QuickBooks Online will make this transaction information available to you the next time you invoice the customer. Other fields not shown in the above image are optional, like Tags, Memo, and Add attachment. When your transaction is complete, click Confirm to move it to the Categorized list.

There are two other options in these individual transaction boxes besides Categorize: Find match (match downloaded payments to invoices, for example) and Record as transfer (move money from one account to another). These are advanced topics that aren’t necessarily intuitive, so we can schedule a session to go over them if you anticipate needing to use them.

The mechanics of connecting to your banks in QuickBooks Online aren’t complicated, but you may run into problems in moving transactions along when they’re first downloaded. Let us know if we can help here. It’s much easier to get it right from the start than to try to untangle transactions that weren’t processed properly.

Share this article...

More About Us

Get to Know Prestige Accounting Services Group (previously Prestige Wealth Accounting Group)


Offices in Flemington, NJ and Califon, NJ

Our Mission: At Prestige Accounting Services Group (previously Prestige Wealth Accounting Group), we are on a mission to redefine the tax experience for individuals and small businesses. With a focus on personalized service, strategic planning, and expert guidance, we aim to empower our clients to succeed financially with confidence and ease.

Expertise in Action: With a wealth of experience and a team of dedicated professionals, we specialize in individual and small business tax preparation. While we excel in all areas of taxation, our passion lies in serving the unique needs of small business owners in New Jersey. We understand that small business taxation requires specialized knowledge and attention to detail, which is why we go above and beyond to ensure our clients receive the guidance and support they deserve.

Tailored Solutions for Every Client: Whether you're a high-net-worth individual seeking comprehensive tax planning or a small business owner in need of accounting and bookkeeping assistance, we have the expertise to meet your needs. Our team takes the time to understand your specific situation and develop customized solutions that align with your goals and objectives.

Why Choose Us?: What sets us apart from other New Jersey tax firms is our commitment to excellence and innovation in the field of taxation. We don't just prepare tax returns; we provide strategic insights, proactive planning, and actionable advice to help our clients achieve their financial goals. With a team of two CPAs, an EA, and an ERO, we have the expertise and resources to deliver exceptional service and results.

Your Success is Our Priority: At Prestige Accounting Services Group (previously Prestige Wealth Accounting Group), we measure our success by the success of our clients. We are dedicated to building long-lasting relationships, providing unparalleled service, and helping our clients thrive in today's ever-changing tax landscape.

We can't wait for you to experience the Prestige Accounting Services Group (previously Prestige Wealth Accounting Group) difference.

Tax & Small Business Updates

Get the latest in tax and small business updates and issues that affect your finances and growth prospects.

I confirm this is a service inquiry and not an advertising message or solicitation. By clicking “Submit”, I acknowledge and agree to the creation of an account and to the and .

Flemington Office

Looking for tax help in Flemington, NJ? You can find us at:

Millburn Office

Looking for tax help in Millburn, NJ? You can find us at:

Califon Office