New Member

Solved

Downloading bank transactions

5 replies
64 views

I downloaded my initial bank transactions, which was limited to 90 days of transactions. How do I download the rest of the year?

QuickBooks Online

JenoPAnswer

QuickBooks Team

Let me help with your banking transactions, drwillf1.

You can check with your bank to see if they can give you a CSV file of your banking transactions. Then, import them to QuickBooks Online. Here's how:

Go to the Banking menu and select Banking.
Select the bank or credit card account.
Click the drop-down arrow beside Update and select File upload.
Click Browse, then look for the file and click on it.
Click Open.
Follow the on-screen instructions to upload the file.

You can also use Quicken (QFX), QuickBooks Online (QBO), or Microsoft Money (OFX) files in case your bank doesn't support CSV files. Check out these guide articles for more details:

Leave a reply below if you need anything else. Have a great day!

JenoP

Answer

QuickBooks Team

Let me help with your banking transactions, drwillf1.

You can check with your bank to see if they can give you a CSV file of your banking transactions. Then, import them to QuickBooks Online. Here's how:

Go to the Banking menu and select Banking.
Select the bank or credit card account.
Click the drop-down arrow beside Update and select File upload.
Click Browse, then look for the file and click on it.
Click Open.
Follow the on-screen instructions to upload the file.

You can also use Quicken (QFX), QuickBooks Online (QBO), or Microsoft Money (OFX) files in case your bank doesn't support CSV files. Check out these guide articles for more details:

Leave a reply below if you need anything else. Have a great day!

D

DrB430

its not downloading the transactions as there is a display saying that there are no new transactions and try again tomorrow

PreciousB

Level 6

Thanks for joining this conversation, DrB430.

When transactions don't automatically download, there may be issues with the connection of your bank into QuickBooks Online.

We can fix this by manually updating the bank account between two to three times. It'll refresh the connection and can resolve bank problems. I'm here to guide on how to do this.

Go to the Banking menu on the left pane.
Hit the pencil icon beside the account name.
Click Edit sign-in info.
Enter your bank login credentials.
Click Update.

In case you get a different error message while manually updating the bank, please see this article: Fix banking errors.

Please contact me directly by adding a comment if you need anything else in QuickBooks Online. I'm always ready to help.

C

CcpaTmmaMmf

My bank only downloads files as a .pdf but my Quickbooks (Mac version) doesn't recognize .pdf to set up my digital banking. What do I do?

R

Ryan_M

Moderator

Hi @CcpaTmmaMmf,

I'm here to lend a hand in setting up your online bank connection.

Before you proceed though, we recommend you contact your bank to confirm what type of connections are available for them, if there would be charges in using the service, and what information you need to set up and use the feature.

There are 2 types of connections available, and these are direct connect and web connect. You'll find the setup steps for both in this article: Set up and use Online Banking (Mac).

For the web connect option, since you mentioned that you can only download a PDF file from your bank, you'll need a 3rd party app that can convert this to a .QBO file.

I'll be around in case you need further help. Feel free to comment below, and I'll get back to you.

Sign up

Login with SSO

Let's get you signed in

Login with SSO