cancel
Showing results for 
Search instead for 
Did you mean: 
Ellen1332
Level 1

I have a file of credit card transactions that also has the Account assigned. Can I import the Account somehow so I don't have to manually match them?

The account names are exact because they are from a Quickbooks export. I imported the transactions backwards (as credit card credit instead of debit) and assigned them to accounts. Now I need to import them the right way but they already have the account.
2 Comments 2
SarahannC
Moderator

I have a file of credit card transactions that also has the Account assigned. Can I import the Account somehow so I don't have to manually match them?

For now, importing accounts isn't part of the format, Ellen1332.
 

We use the CSV file to upload transactions from the bank feed. It has two formats which are the 3-column and 4-column formats. 

 

The 3-column format. This format has a DateDescription, and Amount column.

 

The 4-column format. This format has a DateDescriptionCredit, and Debit column.

 

As we can see, accounts are not included in the two formats. Thus, we're unable to import accounts together the credit card transactions. Still, I'd like to clarify if you have manually imported or linked your credit card account in QuickBooks.

 

Also, if you mean to upload or put the transactions in a specific account in QuickBooks, select the QuickBooks account dropdown arrow during the import process. I'll show you how:

 

  1. Go to the Transactions menu.
  2. Select Bank transactions, or go to Bank transactions.
  3. Click Upload from file.
  4. Select Browse and then select the file you downloaded from your bank. Then select Next.
  5. In the QuickBooks account dropdown, select the account. Then select Next.

 

On the other hand, if these are categorized transactions, we can undo and exclude them. Then, re-import. We can visit this link for more details: Unmatch downloaded bank transactions or move them to another account. From there, we'll learn how we can correct imported transactions account by manually moving downloaded transactions to another account.

 

To manage your bank data from time to time, we can check the articles below:

 

 

If you're referring to something else, please let me know. I can provide more details about it. If you have questions about handling bank data in the program, I'm always here for you. Take care!

SarahannC
Moderator

I have a file of credit card transactions that also has the Account assigned. Can I import the Account somehow so I don't have to manually match them?

Hi Ellen1332,


Hope you’re doing great. I wanted to see how everything is going about importing accounts and matching transactions. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.


Looking forward to your reply. Have a pleasant day ahead!

Need to get in touch?

Contact us