Return to site

Import csv into quickbooks desktop for mac

broken image

But it could be not the column you want to use, so you can review Mapping if needed or you can reassign columns. If your CSV file has multiple Date columns, it may choose the first column or the column it decides most appropriate. What do you see at the Transaction tab? You see how the converter understood your CSV file. It configures out, that this is the 'Date' column, this is the 'Amount' column, this is the 'Payee' column, this is the 'Memo' column, this is the 'Check #' column, and so on. The converter is able to understand these column names and maps, without your manually mapping the file. It is very helpful for the converter, if your CSV file has the first line, as column names in common English words, like Date, Amount, Debit, Credit, Payee, Memo, Check #, Type. There is a 'Table View' tab, that shows the CSV file is a Table.Īnd there is a 'Raw View' tab, that shows how actually the file looks like, if you open it, as a text file. Look at the file, by clicking on the 'Source Tab'. Open the CSV file, it has four transactions: three expenses and one deposit. You can download a sample.csv file from page, as well. The utility is digitally signed and you can verify, that it is verified by publisher ProperSoft Inc. Click PC download, if you download for PC or for Mac if you download for Mac.