Why Wont Ny Excell File Upload to Quickbooks
How to import CSV or Excel files as QBO into Quickbooks
This tutorial shows how to catechumen a CSV or Excel file with transactions, typically downloaded from your bank or you can create information technology by yourself, to QBO (Spider web Connect) format and import into Quickbooks desktop. We will use the CSV2QBO utility. IMPORTANT: CSV2QBO is now replaced with the Transactions app, which converts from more formats and converts to more than formats.
Click PC download, if you lot download for PC or for Mac if y'all download for Mac. The utility is digitally signed and yous can verify, that it is verified by publisher ProperSoft Inc.
We will use a sample.csv file. You can download a sample.csv file from https://www.propersoft.net page, as well.
Open the CSV file, it has four transactions: iii expenses and one eolith.
Look at the file, by clicking on the 'Source Tab'. There is a 'Table View' tab, that shows the CSV file is a Tabular array.
And there is a 'Raw View' tab, that shows how actually the file looks like, if you open it, as a text file.
Information technology has the start line, equally column names. It is very helpful for the converter, if your CSV file has the start line, equally column names in common English words, like Appointment, Amount, Debit, Credit, Payee, Memo, Bank check #, Blazon. The converter is able to understand these column names and maps, without your manually mapping the file. It configures out, that this is the 'Appointment' column, this is the 'Amount' column, this is the 'Payee' column, this is the 'Memo' column, this is the 'Check #' column, and and then on.
What do you come across at the Transaction tab? You encounter how the converter understood your CSV file. If your CSV file has multiple Date columns, information technology may cull the showtime column or the column it decides nearly advisable. But it could be not the column you lot want to utilize, and then you can review Mapping if needed or you can reassign columns. Or allow'southward say some columns take some Payee and Memo columns and they could be switched, like the converter decides, especially if the columns are not properly marked and at that place is no first line, as column names. Information technology sees the Text column and uses, every bit a Memo cavalcade, it is another column. Text column uses as Payee, but for your specific file it could be a different way like this column has to exist Payee, this column has to be Memo or your CSV file doesn't have Payee and Memo, it has simply a long description, and then you can use this clarification for both Memo and Payee. Another of import moment to expect at, that expenses must be negative and deposits must exist positive. It applies the same role for Checking Account, Savings Account, Credit Card. But for some Credit Bill of fare files, the CSV file applies in an contrary mode, Amount applies in the reverse way. What does information technology mean? It unremarkably looks like this: some Credit Card files accept expenses as positive numbers because from the Credit Card Company perspective view is increasing the balance of your Credit Card and payments to the business relationship are negative numbers since your increasing rest on your Credit Card. But for QBO files the rule doesn't apply. And then, if the Credit Card or Checking Account expenses must be negative and deposits or payments to the account must be positive. If you see Data, like this, you lot should click the button 'Change +/-' once per file and verify, that your expense amounts are negative and deposits are positive.
Another important moment. Let's say some dates, especially for customers or users outside the Us, you may see dates in different formats. And so you may see dates on your CSV file, in this case, the Date applies as engagement/month/year. For U.s. users it could be month/date/year. The converter tries to empathize the engagement format on your CSV file. And for some obvious cases, like this one, you lot tin see, that this is modern twelve, this is the month, this is iv digits year. So it configures out itself, that this is the date format is day/month/twelvemonth. On the Transaction tab, information technology shows, that the Date is always in the format: year/month/date.
Regard and so how data on your CSV file, this is how you see the Engagement on the Transaction tab. Then you can verify, that this is correctly parsed. If you come across something not expected, let's say month and engagement are switched, you tin tell the converter which format to expect. Y'all can see, in this example, the default is month/day/year, but the converter was able to figure out for these dates, that dates are twenty-four hours/month/year. In cases, when information technology'southward not obvious, for example, Jan, viii, you can adjust this and the converter volition reload the file.
The left sidebar is for the CSV file to Mapping, to tell the converter how the Data wait like. For instance, we want to modify Payee and Memo. We click 'Review Mapping'. And so what do we see? That Memo is assigned to 'Memo' and Payee is assigned to 'Payee'. We tin can change it if needed. For example, your file doesn't have cavalcade names, then y'all would see Make full ane, Fill 2, Make full 3, Fill 4. This is similar your preview. So you tin can see which ane is Fill 1, Fill up 2, Fill iii. And here you select, which Field you want to be Check #, which Field yous want to be the Amount.
Allow'south say yous take two columns: one Debit, one Credit or one Withdrawal, ane Deposit. Then you gear up Amount to 'Practise not use', and set Debit Column to 'Debit Amount' and Credit Column to 'Credit Amount'. Sometimes you have 2 columns, one Amount column, but they are all positive. Just there is another special column, that has values, like Debit, Credit. For this case, you even so use for Amount, and and then you would utilize Record Type, to tell this is the cavalcade, that has Debit and Credit values and configure out which transaction is the expense and which transaction is income.
The QBO file doesn't have the QBO format, doesn't carry expense, income accounts. And then, when y'all import Data into Quickbooks, that'due south when you assign expense and income accounts to the transaction. These 2 columns: Account Type and Account Number are not for expense, income accounts, they are for multiple accounts. So if your CSV file has a Checking Account and Credit Carte Account, this column tells which business relationship is which and then you can utilize this setup.
The QBO files do non have Split capabilities for transactions. Simply you can use this Carve up setup, for case, for PayPal files to set: Split up 1 is gonna be like fee, Carve up two is gonna be like net or Split 1 - internet, Split two - fee. What it volition do for the QBO file? It volition create 2 separate transactions: one is for the fee, one is for the net. So when it is imported into Quickbooks, you can assign dissimilar expense accounts for the fee and for the net.
These 2 columns: Output Account Type and Output Account ID, you can set them as part of Mapping. So afterwards, when y'all use Mapping, y'all don't take to prepare Account Blazon too as Business relationship Number. It will be set as function of Mapping.
The right part here is for the output QBO file. The first thing to look at is Account Type. If we put the cursor on the Account Type, here y'all can see a clarification. So the Account Type is important to choose.
If y'all are importing Credit Card files, you lot must select Credit Carte. Quickbooks will read your Account Type from the QBO file and will let you to import into Business relationship, only into this same Business relationship Type, that it sees on the QBO file. For case, the QBO file has a Checking Account, and then information technology will show you Checking Accounts to choose from. If the QBO file has a Credit Card Business relationship, then Quickbooks volition show y'all simply Credit Bill of fare Accounts to choose from Quickbooks to import. If you have just ane file or one account, the Account Number could exist any number and you can set it as an actual Account Number, you lot can use maybe iv concluding digits of your actual account, y'all can put the whole account there if you lot like. It is important to use different Business relationship Numbers for different accounts. If you convert for multiple accounts, if you have four or v accounts, please, brand sure, to apply different Account Numbers, when you convert. That'south why to avoid confusion, use the bodily Account Number or use four last digits of the actual Account Number. Then, when you utilise information technology, you don't take to recall which Business relationship Number you employ for which account.
Currency for Quickbooks has to be the United states if you accept Quickbooks United States Edition. For Canadian Quickbooks, it has to be CAD or USD, if you have a multi-currency setup. For Quickbooks Us Edition it has to be US Dollars. Fifty-fifty if you are importing for the non-USD account, in Quickbooks Us yous must use Usa Dollars Currency.
You can prepare the Finish balance if you like. Information technology actually is not of import, but you can set it, if it is important for you, when yous reconcile the account. Quickbooks will show yous that End Residual when you lot import a QBO file. But information technology will calculate the rest from actual transactions. Bank ID has to be all digits numbers. It can exist any number and for different accounts, it could be the aforementioned 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 bookkeeping software requires.
INTU.BID is something that is present on the QBO file. Quickbooks reads that number and checks that number is allowed to be, or the bank representing that number is allowed to be imported. The '3000' is a default number for ''Wells Fargo''. You tin leave this number. ''Wells Fargo'' is normally the well-nigh stable from Quickbook'southward perspective, it commonly e'er imports. But you can use different numbers, but you lot must utilize them carefully. For example, you can click 'Expect up' and if you accept Quickbooks installed on your estimator, yous will see the total list. 'Supports' Banking and Credit Card is importing. Some banks take simply Cyberbanking, some banks take just Credit Card. For example, if we uncheck 'Credit Card', you lot tin can encounter some just Banking, then you lot cannot import Credit Cards.
And if we uncheck 'Banking', you cannot import Checking Business relationship. If yous mark both of them, y'all can cull any banking concern. It is really non important which Depository financial institution y'all choose. But y'all can choose the proper noun of the Bank, which is close to your Banking concern, any proper name y'all like. The Bank label you see only during import. It is not relevant to the actual account you cull in Quickbooks. And then y'all can import ''The Citizens State Bank of Curay'' only putting on the QBO file, but your actual account in Quickbooks could be from the different Depository financial institution. You are choosing an account to which you desire to import your Data.
The button 'Us' - for U.s.a. Customers (if you have United states of america Edition of Quickbooks), 'Canada' - for Canadian Customers (if you have Canadian Edition of Quickbooks). Information technology sets before value here, typical values to accept your QBO file imported.
'Duplicate Payee as Memo when missing' - if your CSV file has just 1 column, you can use this checkbox and duplicate both of them. It is of import, that Payee is limited to thirty-two characters past QBO specification. And Memo is limited to ii hundred l characters by QBO specification. And then you lot will meet a shorter version in a Payee column and when you import into Quickbooks, you lot will meet the shorter version for a Payee column.
So let's effort to convert. Check Date, check Amount is negative and Deposits is positive and click the 'Convert' push button.
In Quickbooks, the QBO file is a Spider web Connect file. In this instance, nosotros imported a true file. Click 'File' - 'Utilities' - 'Import' - 'Web Connect Files'.
Choose and open a sample.qbo.
And so you tin can meet, that the Banking concern label is '3000' - "Wells Fargo Banking company", Account Type - Checking and the Account number is those numbers. At present it says to 'Use an existing account' or 'Create a new Quickbooks account'. We take no accounts yet, so we will choose to 'Create a new account'. The important moment here, that you may have the account, just you already utilise it to download transactions straight from your Depository financial institution. But you demand to import some transactions for the previous month and you are using CSV2QBO to convert those transactions to QBO format. Only then you try to import and it doesn't list here. You have to edit the account. You lot unlink information technology first to import a QBO file, and so you lot unlink it again and link it back to your Banking company.
Web Connect file was successfully imported. Where is it imported?
It is imported into Bank Feeds, not into the bodily business relationship, but outset into Bank Feeds. This is the second place where you tin encounter the Bank Label: just when y'all import yous run across the Bank label and when you review transactions. That Banking company label volition not be seen anywhere once y'all review transactions. That's why it is not important, which Depository financial institution you choose for the QBO file. Every bit long, as this Bank is allowed to be imported. Click on the 'Transaction Listing' button to review transactions. Why exercise we have to review transactions?
Because it is the Quickbooks process to import QBO files. Usually, the process too called 'Matching'. When you match the Payee names on the QBO file, that usually do non match your Payee names or does not match Vendor records you take in Quickbooks. And then, Payee, you run into as 'Downloaded every bit'.
And the 'Payee' is not empty (the Vendor record is not selected still).
'Select Name Type' is where you select your Vendor records. When you create the Vendor record there is also a default expense business relationship to set, so in your Vendor records practice set your default expense or income business relationship. Considering this account will be prefilled here when you choose Vendor record.
If all transactions look good, you lot tin can select them and then corroborate. When you corroborate transactions, they volition be added to the annals.
In that location is also a checkbox 'Testify Bank Memo'. It will evidence, that 'Memo' from the QBO file may have important information for you lot when y'all review transactions. Then, practice click on this checkbox, if you want to see the 'Memo' from the QBO file.
Related articles
- Convert a CSV file to IIF and import into QuickBooks (2017)
- Convert a CSV file to QBO format and import into QuickBooks
- How to import a CSV file into Quickbooks Online
Source: https://www.propersoft.net/howto/import-csv-or-excel-files-as-qbo-into-quickbooks