cancel
Showing results for 
Search instead for 
Did you mean: 
guest-account-th
Level 1

Why my debits turned into credits from an upload file?

 
3 Comments 3
SirielJeaB
QuickBooks Team

Why my debits turned into credits from an upload file?

Hello there,

 

To assist you efficiently, kindly provide us with more specific details regarding your concern. Please let us know which activity you want to perform and which part of QuickBooks you are facing difficulties with. This information will enable me to give you with the correct information and instructions that you need. You can also send us screenshots for better visual references.

 

I am looking forward to your prompt response.

guest-account-th
Level 1

Why my debits turned into credits from an upload file?

I am moving a company to QB.

There are payments that was made to cover different expenses from one account to another. in that same account there was reversed transactions / adjustments. When I upload the excel file the debit became credit, and the credit became debit.

Amount
16,432.74
2,933.25
1,028.62
1,335.43
-863.12
-1,476.73
390.51
-390.51
656.71
984.4
775.87
744.03
990.86
541.92
561.87
1,384.4
-788.65
-5,851.41

 

GenmarieM
QuickBooks Team

Why my debits turned into credits from an upload file?

Thanks for getting back, 

 

I'm here to provide insights into uploading your transactions using an Excel file without reversing the credit and debit transactions in QuickBooks Online (QBO).

 

First off, when manually uploading your transactions using an Excel file, consider using the 4-column format. This format has a Date, Description, Credit, and Debit column. 

 

You can refer to the picture below as your guide:

4 column format.JPG

 

 

 

 

 

Moreover, ensure that each transaction is accurately recorded with the appropriate debit and credit amounts to avoid discrepancies.

 

Also, you can visit this article for detailed information about the CSV format: Format CSV files in Excel to get bank transactions into QuickBooks.

 

Furthermore, you can categorize your bank transactions in QuickBooks Online. This can help you identify tax deductions and tell you where your business makes and spends money.

 

Come back to this post if you have other concerns about uploading your bank transactions to QuickBooks Online. I'll be here to lend a hand. Have a good one!

Need to get in touch?

Contact us