cancel
Showing results for 
Search instead for 
Did you mean: 
Yo_Be_Low
Level 3

Journal Entries lack descriptive content on reports

We take in a lot of customer deposits/prepayments, and also pay deposits. Because there is often a significant amount of time between the time we accept/pay a deposit and the event, we book those payments to/from us in a Customer Prepayment/Deposit liability account or a Pre-Paid Expense asset account.

 

When the event occurs so that all revenue and expenses for the event need to be recognized, I create a journal entry to move the customer deposits from Customer Prepayments to Sales, and from Pre-Paid Expense to Expenses.

 

The problem is with reporting. On a P&L detail report, the journal entry line items do not display the customer/vendor name, who made/received the payment even though I have entered the customer name in the journal entry. (There's a field for that). So I have no idea from whom the revenue came from when I look at the report (nor who the expense went to). Additionally, on the report, I've now lost the date in which these payments were made and instead only see the date of the journal entry which isn't useful.

 

Is there a better way of doing the above rev rec so I can see the important descriptive information on reports? Specifically, I'm looking for who made/received the payment, and when it was made.

 

I suppose instead of journal entries I could go back and try to edit the original transactions, but that leaves a poor audit trail.

 

 

4 Comments 4
Tori B
QuickBooks Team

Journal Entries lack descriptive content on reports

Hey there, @Yo_Be_Low

 

Thanks for taking the time to reach out to the Community for support and sharing your concerns. 

 

Based on your needs for the report, I recommend contacting our Technical Support Team. This way, an agent can review your account in a secure environment and they have the tools to remote into your screen so they can check out the setup of your transactions and help to customize the report in the best way for you. I've included some steps to contact support below. 

 

  1. Sign in to your QuickBooks Online company.
  2. Select Help (?).
  3. Click on Talk to a human.
  4. Choose a way to connect with support (Callback, Chat, Etc.). 

 

In the meantime, feel free to check out this help article that covers everything you need to know about reports in QuickBooks Online: Run reports in QuickBooks Online

 

Please let me know if you have additional questions or concerns. Take care and have a great day! 

Yo_Be_Low
Level 3

Journal Entries lack descriptive content on reports

"Contact tech support" was not really the answer I needed.

MJoy_D
Moderator

Journal Entries lack descriptive content on reports

I can share some information about the report that you’re trying to generate, @Yo_Be_Low

 

You can generate a Journal report in QuickBooks Online (QBO). This one will show you the debits and credits for each transaction, listed by date.

 

After generating the report, you can customize it to show only Journal Entries. Then, include the DateVendorsCustomers, and the Last Modified columns in the report. 

 

The Last Modified column will show the date and time when the transaction was created or edited. 

 

Here’s how to generate the report:

 

  1. Go to the Reports menu and look for Journal
  2. Click to run the report. 
  3. Select the Customize button at the top. 
  4. Under the Rows/Columns section, select the checkbox of the rows and columns that’ll appear on your report like the DateVendorsCustomers, and Last Modified.
  5. Scroll down to the Filter section and select the checkbox for the Transaction Type and choose Journal Entry
  6. Click on the Run report button once you’re done.

 

Refer to the following article for more information about running and customizing your reports in QBO: Customize reports in QuickBooks Online.

 

Then, check this article for detailed guidance in saving the report with its customization settings to easily find it the next time you'll need it: Memorize reports in QuickBooks Online

 

Should you need further assistance in generating your report, let me know by leaving a reply below. I'll be here to lend a hand. Keep safe and have a wonderful day!

john-pero
Community Champion

Journal Entries lack descriptive content on reports

Despite an additional staff answer, journal entries do not report properly by name. One better way to receive your deposits is to simply Receive Payment and with no open invoices selected the payment t will record a customer credit memo. Once you bill the customer apply the c.m.  You can also in company settings have the cm auto apply. 

 

This only reduces amount due at your end as customer still receives a total invoice so to further improve.

1. Receive deposit as a Sales Receipt post to Prepayments.

2. Final Bill or Sales Receipt for total due and add a line (negative) for Prepayment. Now customer will get a proper Invoice with correct amount due.

Need to get in touch?

Contact us