Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowIt doesn't like my file for some reason. What is the perfect format it needs to be in?
What data type do you need to import? Bank statement or else?
It’s a pleasure to have you here in the Community space, Erin. Please note that each bank configures CSV files differently. I’ll offer some insights on the correct file format to ensure your transactions are successfully imported.
QuickBooks Self-Employed supports uploading CSV files in either a 3-column or 4-column format. The 3-column format includes date, description, and amount.
On the other, the 4-column format comprises date, description, credit, and debit amounts.
For more detailed information, check out this article: Format CSV files in Excel to get bank transactions. While this is intended for QuickBooks Online, the same concepts can also be applied in QuickBooks Self-Employed.
On the other hand, you can connect your bank account to QBSE to automatically download all your transactions.
Additionally, I'll add this article to maintain organized financial records and streamline your bookkeeping process for the future use: Categorize transactions in QuickBooks Self-Employed.
Consider this thread your go-to resource whenever you have questions about importing CSV file. You can also create a new discussion here in the Community space for assistance.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here