I want to ensure you can successfully import your First National Bank data to QuickBooks Online (QBO).
Make sure you've selected the correct columns in the mapping stage. QBO can import CSV files that use either a 3-column or 4-column format. The file should contain the following information: Date, Description, and Amount.
See the sample screenshot below.
Here are the formats that you'll need to check:
Remove zeroes (0) from the file and leave those cells blank.
Select the column header labels (from the dropdowns) that match the column header labels in your CSV file.
Choose the Date format in a single format.
If the file format is properly map, you can now import transactions again. Here’s how:
Go to the Banking tab located on the upper left side.
Click the Update drop-down arrow and choose File Upload.
Hit the Browse button, then locate the file and Open.
From the QuickBooks Account drop-down list, select the First National bank and click Next.
Choose a Date, date format, Description, and Account.
Put a checkmark on the transactions you want to import, then tap Next again.