If your bank supports downloading transactions to a CSV format (a comma-separated values format that can be read by Excel), you can download your banking activity to a CSV format and then import it into your QuickBooks Online Bank account. First, log in to your bank’s website and save your banking transactions. QBO can import CSV files formatted in either three or four columns.
An Acceptable Three-Column Format
Date
Description
Amount
1/1/2019
Example payment
-100.00
1/1/2019
Example deposit
200.00
This is what it looks like in a four-column format.
An Acceptable Four-Column Format
Date
Description
Credit
Debit
1/1/2019
Example payment
100.00
1/1/2019
Example deposit
200.00
Open your CSV file using Excel and make sure it matches one of these formats; if necessary, edit it. Then, follow these steps to import the transactions:
Connect your bank accounts to QuickBooks so it can download your transactions. Categorize transactions and add them to QuickBooks, so QuickBooks can start doing the work for you. You can use Umpqua online banking to download your bank transactions into QuickBooks. Click here for a step-by-step guide.
Choose Transactions → Banking in the Navigation bar.
Click the arrow beside the Update button and, from the menu that appears, click File Upload.
The Upload File page appears.
Click the Browse button, select the CSV file you downloaded from your bank’s website, and click Next.
Select the account into which you want to import transactions and click Next.
On the Map CSV Columns screen that appears, match the fields in QBO to the fields in your CSV file and then click Next.
The transactions you can import from your CSV file appear, with a check box to the left of each transaction. To avoid importing a particular transaction, select its check box.
Click Next.
QBO displays the number of transactions that will be imported and asks if you want to import the transactions.
Click Yes to import the transactions.
When QBO finishes importing the transactions, a confirmation screen appears.
Click Finish.
The Bank and Credit Cards page appears, and the transactions you imported appear on the New Transactions tab.
People come to QuickBooks Learn & Support for help and answers—we want to let them know that we're here to listen and share our knowledge. We do that with the style and format of our responses. Here are five guidelines:
Keep it conversational. When answering questions, write like you speak. Imagine you're explaining something to a trusted friend, using simple, everyday language. Avoid jargon and technical terms when possible. When no other word will do, explain technical terms in plain English.
Be clear and state the answer right up front. Ask yourself what specific information the person really needs and then provide it. Stick to the topic and avoid unnecessary details. Break information down into a numbered or bulleted list and highlight the most important details in bold.
Be concise. Aim for no more than two short sentences in a paragraph, and try to keep paragraphs to two lines. A wall of text can look intimidating and many won't read it, so break it up. It's okay to link to other resources for more details, but avoid giving answers that contain little more than a link.
Be a good listener. When people post very general questions, take a second to try to understand what they're really looking for. Then, provide a response that guides them to the best possible outcome.
Be encouraging and positive. Look for ways to eliminate uncertainty by anticipating people's concerns. Make it apparent that we really like helping them achieve positive outcomes.