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

PNC Bank csv file and debits

PNC bank csv file doesn’t identify debits in amount column. There is a separate (one) column that lists the transaction as either “debit” or “credit”. Short of going through every debit and placing a “-“ before the amount how can I fix this.

Solved
Best answer January 27, 2021

Best Answers
ShiellaGraceA
QuickBooks Team

PNC Bank csv file and debits

Thanks for reaching out to us, @jks1057.

 

Since the each banks format CSV file differently, you'll want to fine tune your formatting before uploading to QBO.

 

To do so:

 

  1. Open your CSV file.
  2. Add one column for your Credit.
  3. Manually sort the amount under this column. You can also reach out to your bank to review the Debit and Credit amounts.

 

Once you're done, upload them into QuickBooks Online. You can learn more about the CSV file format at this article: Format CSV files in Excel to get bank transactions into QuickBooks.

 

If you need help with other tasks in QBO, you can browse for specific topics here and look for responses that fit your concern.

 

Keep me posted if you still have questions or concerns with your bank transactions. I'll be around for you. Take care and have a wonderful rest of the week.

View solution in original post

2 Comments
ShiellaGraceA
QuickBooks Team

PNC Bank csv file and debits

Thanks for reaching out to us, @jks1057.

 

Since the each banks format CSV file differently, you'll want to fine tune your formatting before uploading to QBO.

 

To do so:

 

  1. Open your CSV file.
  2. Add one column for your Credit.
  3. Manually sort the amount under this column. You can also reach out to your bank to review the Debit and Credit amounts.

 

Once you're done, upload them into QuickBooks Online. You can learn more about the CSV file format at this article: Format CSV files in Excel to get bank transactions into QuickBooks.

 

If you need help with other tasks in QBO, you can browse for specific topics here and look for responses that fit your concern.

 

Keep me posted if you still have questions or concerns with your bank transactions. I'll be around for you. Take care and have a wonderful rest of the week.

View solution in original post

Fiat Lux - ASIA
Level 15

PNC Bank csv file and debits

@jks1057 

Utilize the trial license of this converter app to isolate the issue.

https://www.moneythumb.com/?ref=110

 

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up