Hi, Finance.
Let's make sure that your file is formatted correctly, so we can successfully import your journal entry.
First off, what specific information is missing on your Journal Entry? Providing this will help me provide a more targeted solution.
In the meantime, please make sure that the following information are included in your spreadsheet as these are the required ones:
- Journal No
- Journal Date
- Journal Code
- Account Name
- Journal
- Debits
- Credits
- Date Format
If your spreadsheet includes any new accounts, kindly ensure they are added to your chart of accounts prior to importing.
Furthermore, when the Warn me if duplicate journal number is used option is enabled in the settings, you won't be able to upload some entries with existing numbers. Let's turn off that preference before importing the file. Here's how:
- Go to the Gear icon.
- Choose Account and settings.
- Head to the Advanced tab, then go to Other preferences.
- Turn off the Warn me if duplicate journal number is used option.
- Hit Save, then Done.
Additionally, if you’d like to print journal entry reports in QuickBooks for future reference, here’s a helpful guide: Print a Journal Entry Report.
If you have any questions or need assistance with importing transactions into QuickBooks, please don’t hesitate to reply to this email. I’m here to help!
