And for the UK edition, GBP currency must be set. For the Canadian edition, you can use USD and CAD. For multiple accounts, use a different Account ID for each account.Ĭurrency should be USD even for non-USD accounts for Quickbooks US edition. Account ID must be all digits for Quickbooks. Set the Account ID (number) and the Account Type. Keep the default value if your bank is not listed (3000-Wells Fargo or any allowed bank). You can try to locate your bank, make sure a bank you choose supports the account type you are converting for. The INTU.BID value defines the bank label shown during import. Set INTU.BID number to match your bank or use a default value. Review transactions before converting, check that dates are correct, have the correct year, expenses are negative and payments to the account are positive.Ĭlick the 'Charges/Withdrawals' are positive if expenses are positive on the CSV file.
Start CSV2QBO and select a CSV or Excel file.
Download it from the CSV2QBO download page. Make sure you are using the latest version of CSV2QBO.
Follow the steps below for the Windows version, followed by the Mac version.
