Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello 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.
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 |
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here