Qbo downloaded files name and memo fields reversed

It is important to use different Account Numbers for different accounts. If you convert for multiple accounts, if you have four or five accounts, please, make sure, to use different Account Numbers, when you convert. That's why to avoid confusion, use the actual Account Number or use four last digits of the actual Account Number. So, when you use it, you don't have to remember which Account Number you use for which account.

You can set the End balance if you like. It really is not important, but you can set it, if it is important for you, when you reconcile the account. But it will calculate the balance from actual transactions. Bank ID has to be all digits numbers.

It can be any number and for different accounts, it could be the same number, but has to be a number. Some software demands that Branch ID has to be set. For Quickbooks, it doesn't matter. Encoding, if you are importing some non-lighting characters you can use Unicode, Hebrew, Japanese, depending on what your accounting software requires.

Quickbooks reads that number and checks that number is allowed to be, or the bank representing that number is allowed to be imported. The '' is a default number for ''Wells Fargo''. You can leave this number. But you can use different numbers, but you must use them carefully. For example, you can click 'Look up' and if you have Quickbooks installed on your computer, you will see the full list.

Some banks have just Banking, some banks have just Credit Card. For example, if we uncheck 'Credit Card', you can see some only Banking, so you cannot import Credit Cards. And if we uncheck 'Banking', you cannot import Checking Account. If you mark both of them, you can choose any bank. It is really not important which Bank you choose. But you can choose the name of the Bank, which is close to your Bank, any name you like. The Bank label you see only during import. It is not relevant to the actual account you choose in Quickbooks.

You are choosing an account to which you want to import your Data. It sets before value here, typical values to have your QBO file imported. It is important, that Payee is limited to thirty-two characters by QBO specification. And Memo is limited to two hundred fifty characters by QBO specification.

So you will see a shorter version in a Payee column and when you import into Quickbooks, you will see the shorter version for a Payee column.

So let's try to convert. Check Date, check Amount is negative and Deposits is positive and click the 'Convert' button. In this example, we imported a true file. Now it says to 'Use an existing account' or 'Create a new Quickbooks account'. We have no accounts yet, so we will choose to 'Create a new account'. The important moment here, that you may have the account, but you already use it to download transactions directly from your Bank.

But then you try to import and it doesn't list here. You have to edit the account. Has this been fixed? This is really annoying - why would the downloaded as not be in the bank memo - the other stuff is no help. There isn't an exact time frame on when the Downloaded As column will be available in the Register.

I'd recommend doing the workarounds shared on this thread as of the moment if you didn't try it yet. I understand that having an option to move the Downloaded As a column in the Chart of Accounts section is important for your business.

With this, I'll route you to a page where you can post feature suggestions. This way, our engineers can find a way on how to make this feature happen shortly. Additionally, I'd recommend checking our QuickBooks Blog page regularly to know our latest news and enhancement in QuickBooks. Lastly, here is a list of an article that may help you with the banking most commonly asked questions: Get started with Bank Feeds.

Please let me know in the comment section if you have any follow-up questions about your banking. I'm always here if you need further assistance. Take care. Enter a search word. Turn off suggestions. Enter a user name or rank. Turn on suggestions. Showing results for. Search instead for. Did you mean:. Connect with and learn from others in the QuickBooks Community. Join now. Level 1. Labels: QuickBooks Desktop. Reply Join the conversation. Best answer March 19, Best Answers. QuickBooks Team. Let me show you how: Go to the Edit menu and choose Find.

Select the Simple tab and click the Transaction Type drop-down. Choose the transaction type you want to search. Fill in the fields that appear and click Find. Click the transaction you want to see and hit the Go To button. Once the transaction opens, enter the description on the Description column. Everyone needed the "Downloaded As" moved into "Bank Memo" column. This is manual process. But still solved my problem.

Let me share some information on how QuickBooks handles your downloaded data. Here's how: Go to the Banking menu. Choose Bank Feeds. If they are switched, then select the checkbox for Switch signs of amounts on output and the amounts will be correctly output to your. Select Create qbo at the bottom of the Preview Screen to finish the conversion and create your.

Run subsequent conversions of CSV statements from the same bank with Convert, select a file and then Convert to qbo to create your. On Microsoft Windows, the easiest way to enter the license is to copy the license file csv2qbo. To enter the license string manually from within the program select the License button, and paste or type the full license code into the dialog. After you enter your license, your license email will be shown in the program title bar, and in About. See Appendix A for guidelines on creating a file from scratch.

You may also run csv2qbo Convert from the Windows Start Menu, or run csv2qbo. If you are running the portable version, run csv2qbo portable.

Use the Settings button to bring up the Settings dialog:. First use the Account Type pull-down menu to select the correct type for the. In addition there are four pieces of account information that may be inserted into the. This is a four or five digit number that QuickBooks uses to identify the financial institution. Select " Lookup Type some or all of the name of your financial institution into the search box at the top to search within the list.

Scroll down the list to find your bank and select it. The bank URL is also included to help resolve ambiguity if your bank has a name that is similar to other banks. If your bank is not listed, then QuickBooks will not import. The only workaround is to use an FID from some other bank. You can still name the account to include the name of your financial institution. So long as you as not also doing QuickBooks Direct Connect downloads into the same account, it will work just fine.

There are some Financial Institutions that provide Direct Connect, but do not support Web Connect, and if you use one of these, you will have to create two accounts and move transactions from one to the other. Just remember that the FID is critical, and although csv2qbo Convert will run without one, it will give a warning, and QuickBooks will give an error when reading the QBO file. All files require an account number and bank accounts also require a bank routing number.

If you don't want to save your accounts numbers for security reasons, then you can skip entering this this information. If you do provide your account number to be inserted into the. If you are always importing into the same account, then csv2qbo Convert will save the information from session to session, so you do not have to re-enter it. For PayPal users, your account number is the email address you use to sign into PayPal.

Note that csv2qbo Convert does not access the Internet at all, so any information entered is only saved on your computer, and is not sent over other web or to any other computers. To determine the account number to use in the.

The bank account routing number is required by. However, it is not actually used by QuickBooks, so if you don't specify one, csv2qbo Convert will insert a default value and QuickBooks will accept it. Lastly, the currency needs to be specified.

US Dollars are the initial setting, use the drop down to select a different currency. Use the Settings menu to select the date format that is used in your CSV file.

If your dates have the month name or abbreviation rather than a number, then this setting is not applicable. Note that there is no need to specify a date format for QBO files. Normally bank statements will have charges as negative numbers and payments as positive numbers. That is what Quicken expects. Many credit card companies switch things so that charges are positive - showing an increase in your balance - and payments are negative.

Use the Settings dialog to select Charges are positive, Payments are negative Switch signs if this is the type of data in your CSV file. Column names can be preassigned to your conversions. Whenever you use Preview Mode, the column names are saved and automatically assigned to subsequent conversions. See the description of Preview Mode, in the following section.

The current column names are displayed in the text box in this section. You can also read predefined column setting from a CSV format file. To read presets select the Load Preset button, and use the open file dialog to open a csv file with the column names. A preset CSV file is just a single line of text with the column names separated by commas.

You can also save the current displayed column names to your own preset file with Save Preset. Select the checkbox for Use column names to enable or disable the column settings. When reading transactions from payment systems such as PayPal, the transaction is often composed of a gross amount, a transaction fee, resulting in a net amount.

The Separate splits in output transactions option specifies whether split transactions such as these create one transaction in the.

When transactions are split, the QuickBooks import will create one QuickBooks transaction that is the received payment amount, and another transaction that is the transaction fee.

This enables you to match up payments with invoices, and to track transactions fees in a separate account. If the transaction is not split, such a transaction will be imported as a single transaction with the net amount. See more about specifying split amounts in the description of Preview Mode, in the following section. If you are just getting started, then use Preview Mode. To run either mode, start with the Convert button.

Select the Convert button and this will bring up the file chooser dialog. Navigate to the folder containing the. This will bring up a preview window that displays the contents of your CSV file. The account type at the top of the window will be fixed to the QuickBooks account type you chose in the Settings menu. At the bottom of each column is a selector that contains the name of the data in that column. It may have already been set correctly by csv2qbo Convert based on column headings in the CSV file.

If it's not correct, use the pull-down to select the correct type of data. Each type can only be used in one column, so types that have already been used will be grayed out. If you have many columns, you can increase the width of the columns of interest by going to the header row and dragging the column separator to increase the width of the column, and of course drag a corner of the window to enlarge it as well. Some credit card files also have the the signs of amounts reversed so that credits have a minus sign.

In this case the checkbox for Switch signs of amounts should be selected. This will ensure that debits and credits are correctly labeled in the.

The checkbox for Hide unmapped columns will hide all the columns that do not currently have a name assigned. This is very useful for files that come from PayPal or Stripe that have too many columns for them all to be readable.

The only required fields are the Date , and depending on whether the transaction amounts are in one column or two, either Amount or Credits and Debits. If your data has an Amount column that has positive amounts for both credits and debits i.

When the Separate Splits option is set under Settings , you can specify which columns contain amounts that are to be split. For these columns, if there is an amount present, it will generate its own transaction, with a payee of the column name.