Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWe 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.
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.
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!
"Contact tech support" was not really the answer I needed.
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 Date, Vendors, Customers, 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:
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!
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.
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.