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

Should I import the Transaction Date or the Date Posted on a CSV file?

Hello,

 

I'm trying to import transactions from a credit card into Quickbooks Self-Employed (online version). The CSV file has columns for both Transaction Date and Date Posted. Which one should I keep to import?

 

Much thanks!

Solved
Best answer January 25, 2022

Best Answers
DivinaMercy_N
Moderator

Should I import the Transaction Date or the Date Posted on a CSV file?

Hello there, @DrKathyIsIn. I want to ensure you'll be able to import your CSV file in QuickBooks Self-Employed (QBSE) seamlessly.

 

In QBSE, importing CSV files can be done using a 3-column (Date, Description, and Amount) or 4-column (Date, Description, Credit, and Debit) format. You'll want to use the transaction date since it's the day the transaction is created. However, I'd recommend seeking advice from your accountant to verify which date is appropriate to use. This is to ensure your books have accurate data.

 

Once confirmed all the needed information, you're now ready in uploading your CSV file to QBSEuploading your CSV file to QBSE

 

You'll want to categorize your transactions to make sure they are assigned to the correct line of your Schedule C.

 

Feel free to get back here if you have any other concerns about importing transactions to your QBSE account. I'll be always around to help. Take care. 

View solution in original post

2 Comments 2
DivinaMercy_N
Moderator

Should I import the Transaction Date or the Date Posted on a CSV file?

Hello there, @DrKathyIsIn. I want to ensure you'll be able to import your CSV file in QuickBooks Self-Employed (QBSE) seamlessly.

 

In QBSE, importing CSV files can be done using a 3-column (Date, Description, and Amount) or 4-column (Date, Description, Credit, and Debit) format. You'll want to use the transaction date since it's the day the transaction is created. However, I'd recommend seeking advice from your accountant to verify which date is appropriate to use. This is to ensure your books have accurate data.

 

Once confirmed all the needed information, you're now ready in uploading your CSV file to QBSEuploading your CSV file to QBSE

 

You'll want to categorize your transactions to make sure they are assigned to the correct line of your Schedule C.

 

Feel free to get back here if you have any other concerns about importing transactions to your QBSE account. I'll be always around to help. Take care. 

adriana882008
Level 2

Should I import the Transaction Date or the Date Posted on a CSV file?

Quickbooks uploads the Posting Date and not the Transaction date when the transactions come through the bank feed and the credit card account is connected to QBO. 



 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us