Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
G
guest-account-th
March 22, 2024
Question

Why my debits turned into credits from an upload file?

  • March 22, 2024
  • 1 reply
  • 9 views
No text available

1 reply

S
SirielJeaBModerator
Moderator
March 22, 2024

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.

G
guest-account-thAuthor
March 25, 2024

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

 

G
GenmarieMQuickBooks Team
QuickBooks Team
March 25, 2024

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:

 

 

 

 

 

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 QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement