I'll share the steps to help you import your CSV file with more than three columns.
Are you trying to import your bank transactions from a CSV file? Other than the usual 3-column format, we also accept files with four columns. Generally, it has the Date, Description, Credit, and Debit columns.
When you're ready to import your file, here's how you can do it:
Go to the Transactions menu, then head over to the Banking tab.
Click the Upload transactions button (if this is your first time), or select the Upload from file option under the arrow icon (beside Update).
Browse for your CSV file, then click Next.
Choose the account where you want to put the transactions, then proceed with Next.
Map your columns, then review your transactions.
Finish the import process.
Are you trying to import your data such as customers, products, services, and vendors? The number of columns depends on what list you want to import. You'll want to download our sample files for each data as a guide. Here's how:
Click the Gear icon, then choose Import data.
Choose the type of data you want to upload.
Click the download sample file link.
Compare the columns between the sample file and your CSV data.
Read this article to learn more about moving your lists to QuickBooks Online.
Need help creating transactions, managing your lists, and running reports after importing your data? You can check out our articles for tutorials how.