Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello quiveringbee@gma,
Yes, you can create a 3 or 4 columns layout of a CSV file for your bank transactions. Let me help you with how to create the format.
To start with, make sure to layout the Date, Description, and Amount as the column header of your CSV file. That being said, here's a screenshot for your visual reference.
Additionally, you can also browse for the content of this helpful article so you can easily review your transactions after uploading them: Learn how to create and use rules to quickly categorize recent and past transactions.
If you have any other concerns, please let me know in the comments below. I'll be here to help. Stay safe!
Thanks, but I know how to add bank transactions. I was able to add a "sales tax" transaction by creating a .csv file with
Date | Type | Title | Info | Currency | Amount |
11/1/2020 | Transaction | Sales tax for order # | Sales Tax | USD | ($9.99) |
and importing via the Cash account. What I am looking for is if I can also import fields for Notes field. Also wondering if I should enter "business" under type and if "sales tax" should go under "category"?
Really just looking if anyone has ALL the column headers that one can use to import a transaction so that I don't have to go into the app and manually enter what hasn't been entered or set.
I appreciate the additional clarifications on what you're trying to achieve, quiveringbee@gma.
Let me shed some light on the import format for .cvs file layout in QuickBooks Self-Employed (QBSE).
When importing transactions in QBSE, you can only map up to 5 types of fields (Date, Description, Amount, Debit, and Credit). Only the fields mentioned will be recognized in QBSE regardless if it has a sales tax or under a business or personal type of category.
You might want to visit this article where we provide updates regarding the progress of this project: Custom categories in QuickBooks Self-Employed.
If you need other references for future use, you can check out these helpful links:
The Community is always open if you have other questions. I'll be around to help. Wishing you a great day ahead!
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