Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
PG1274
Level 1

Need help with uploading Journal Entries for missing bank fees months. Don't understand what 'Journal entry lines must balance debits with credits. Go back to your CSV and correct the journal entries with these numbers.' Means..any help?

Can 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.  

2 Comments 2
ChristieAnn
QuickBooks Team

Need help with uploading Journal Entries for missing bank fees months. Don't understand what 'Journal entry lines must balance debits with credits. Go back to your CSV and correct the journal entries with these numbers.' Means..any help?

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:

 

  • Journal No.
  • Journal Date
  • Account Name
  • Journal
  • Debits
  • Credits

 

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.

4Gal
Level 11

Need help with uploading Journal Entries for missing bank fees months. Don't understand what 'Journal entry lines must balance debits with credits. Go back to your CSV and correct the journal entries with these numbers.' Means..any help?

@PG1274 

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

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us