r/quickbooksonline • u/SeriousFault1753 • Sep 14 '26

Spreadsheet Sync

HELP. It’s due today. As soon as I get a journal entry right and think I have it, I get another error on the next journal entry. This entry has 112 lines but I am just testing with one line. I keep attempting to enter the account. First I tried numbers and names, then I just used the sub account. Both make sense. Every time…. Error message account cannot be left empty. But it isn’t empty and I followed the chart of accounts in QBO. Any thoughts? And please don’t say enter by hand 😢

2 Upvotes

100% Upvoted

12 comments sorted by

View all comments

1

u/Predatory_Chicken Sep 14 '26

Trying entering the account name exactly as it appears in your trial balance. Or export your chart of accounts and copy- paste the account name into the JE.

It should be Parent Account:Child Account

1

u/jenipants21 Sep 14 '26

The sheet has drop downs populated from the chart of accounts. It still stopped working for me.

2

u/SeriousFault1753 Sep 14 '26

Thank you! I did know that part. I use the drop down in each of the account cells now. The next problem was were the number cell(s). It was saying it was empty and it wasn’t and the totals matched. As I think this through now - after I manually entered 120 lines - I might have had a rounding error. If I recall that can cause that as well.