Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
This is my Quickbooks Desktop work flow...
1. When a customer payment is recevied, I go to the invoice and select Receive Payment.
2. I then go to Record Deposit, find the related Invoice and record the check number and date of deposit.
I have two issues.... When I run a Standard P & L Report using Cash Basis why does it list (each line of) the invoice instead of the just the total deposit amount? See screen shot. Next, sometimes I see a deposit listed in the report AND the invoice items which all add up to the deposit amount which is also listed in the same P & L report which means the income is being double counted in the P & L report.
Thanks for coming by, @Kittery.
I'll share some information about the cash versus accrual accounting method in the report. The cash basis method takes place when you had the money in hand. Take note that this doesn't take into any A/R or A/P accounts. That said, it applies to payments from clients whether in the form of cash, checks, or credit card receipts. Thus, in your Transaction Detail report, you'll see invoices where payment is received on that period.
Learn more about this method in the articles below:
Cash vs. accrual accounting: What’s best for your small business?
About the double deposit, you'll want to verify if this isn't a duplicate entry. You can just click on the transaction to check. From there, you can delete the duplicate record.
Otherwise, follow the steps to re-sort your accounts. This helps fix the odd behavior of your Chart of Accounts. It makes your lists go back to their default order. So if you have manually changed the order of your list, re-sorting will undo these changes.
Here's how:
If you need help with other report tasks, browse this link to go to our general report topics with articles. Look for responses that fit your concern.
Leave a reply anytime if you still have questions or concerns with Profit and Loss reports. I'm just a comment away. Take care and have a fantastic week ahead.
Thank you SheillaGrace for the reply. I am famliar with the difference between cost and accrual basis. My question is if I'm running a report in cash basis why are invoices AND deposits appearing? Why aren't the Deposit totals OR just the Invoices listed (assuming they've been paid on the listed date)?
Thank you SheillaGrace for the reply. I am famliar with the difference between cost and accrual basis. My question is if I'm running a report in cash basis why are invoices AND deposits appearing? Why aren't the Deposit totals OR just the Invoices listed (assuming they've been paid on the listed date)?
Hello there, Kittery.
Thank you for reaching out to us with your concern about running the Profit and Loss report. I'm happy to share some insights with you about cash and accruals.
When running the Profit and Loss report, you will see the invoices and deposits that have already been paid when you run a report for cash. For accruals, it would also show invoices and deposits that are not being paid yet.
You can also check on how to differentiate cash and accrual basis.
You can always reach out to me if you need anything else about running a Profit and Loss report. I'm here for you. Have a good one.
RE: My question is if I'm running a report in cash basis why are invoices AND deposits appearing?
Based on your original description of what you do, "I then go to Record Deposit, find the related Invoice and record the check number and date of deposit.", I think the reason is that you're coding deposits using an income account. After receiving a payment and applying it to an invoice, the deposit should be linked to that payment, and when it does it will be associated with the Undeposited Funds account - an asset - and not an income account. Such deposits won't appear anywhere on your P&L, either on a cash or accrual basis.
When creating a deposit after receiving a payment, the Payments to Deposit window should appear automatically, making it easy to pick the payment(s) you are depositing. If not, then click the Payments button at the top of the window and it'll appear.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here