Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 6, 2025
Question

What are the only categories needed to have on a CSV file to be able to import it on Quickbooks? Thank you

  • October 6, 2025
  • 1 reply
  • 3 views
No text available

1 reply

QuickBooks Team
October 6, 2025

It depends on the type of data you’re importing to QuickBooks, @wellbeingbypatrick.

First, could you clarify what you mean by “categories needed”? Are you asking about the file format? If so, I’ll share examples of file formats compatible with QuickBooks.
 

For Bank Transactions, your CSV file must contain a minimum of three or four columns. 

The three-column format includes: Date, Description, and Amount.

image.png

The four-column format includes: Date, Description, Credit, and Debit.

image.png

You can also download the sample format within QuickBooks. 
 

Here's how:
 

  1. Go to the Gear icon and select Import data.
  2. Choose the type of data from the list.
  3. Click Import.

    image.png
  4. Select Download import guide or download CSV file sample.

    image.png

    If you mean something else, feel free to add your comments below.