Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowCan someone please help me decipher what QB wants me to do with my journal entries balancing out?
Background - I lost all my bank feeds from mid-August of last year through December. I've had to go back and create all new .csv for each month. Now, I've completed the Journal .csv for the new Journal Entries option in Import Data. Now, I've completed all the necessary steps except this one:
Journal entry lines must balance debits with credits. Go back to your CSV and correct the journal entries with these numbers.
Unfortunately, I'm not an accountant and don't know the specific lingo of what this means. I'm trying to get my QB taxes over to my accountant but can't do anything without this last step. If anyone can explain how this works, I would really appreciate the help. I've been doing this for the past 8 hours, so my brain may be a little warped!
Thank you for taking the time to read this and hopefully answer my sill question.
Hello there, PG1274.
I can see how crucial it is to upload your journal entries into QuickBooks so that you may thoroughly organize your bank feeds within the program. Let me provide insights on how importing data works in QBO and ensure you can achieve your goal efficiently.
To start with, please know that before importing your journal entries, you'll need to make sure everything looks correct in your spreadsheet. Your file includes following info:
You can refer to this article for more details so you have the appropriate CSV format: Import journal entries in QuickBooks Online.
Then, the error you received indicates that your JE data in the CSV file needs to equalize the total debit and credit balances. That being said, I recommend going over those figures and ensuring that everything is in shape. You can consider consulting your accountant to ask for additional guidance on how to correctly handle the transactions, particularly the account to be used for debit and credit.
In case you need steps on how you can manually record and delete journal entries in your QBO, you can read this article: Reverse or delete a journal entry in QuickBooks Online.
If you have any follow-up questions regarding the importing JE process, or you need help with another task, please let me know in your reply below. I'd be glad to help you further. Take care.
You can use MT Online or one of the converter tools (e.g csv2qbo @ $60 one time license) as a workaround.
https://www.moneythumb.com/?ref=110
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