Question

Invoice date & service date

Forum|Forum|7 years ago
November 22, 2018
2 replies
48 views

Hi there)

In QB online we have service date and invoice date. Is it possible to run PL report, where only the service date will be showed in Revenue section, not the invoice date.

Where I can find that settings?

QuickBooks Online

J

JamesDuanT

QuickBooks Team

Hello EkaterinaPiskunS_33,

Currently, we're unable to run the Profit and Loss Detail report that shows the service dates. I'd recommend sending feedback to our Product Development Team by clicking the Gear icon in the upper-right corner and selecting Feedback.

Meanwhile, you can customize the Sales by Product/Service Detail report. You can use this for reference while pulling up Profit and Loss Detail report.

Select Reports on the left menu and search Sales by Product/Service Detail.
Click the Customize button and go to the Rows/Columns section.
Click Change columns and put a check mark in the Service Date box.
Click Run report.

I'd also recommend reaching out to your accountant to see if they know other reports that display the data you need.

Feel free to let me know if you need anything else.

Y

YDK

According to accrual account the P&L should reflect the service date not the invoice date???

A

alvinmathew

That is exactly what I am thinking

K

Klent

Level 8

Hi there, YDK.

I can share some information about how the Profit and Loss (P&L) report works in QuickBooks Online.

Please take note that when you use an accrual basis for your bookkeeping, you record income when you sell or ship an item. You count expenses when you obtain a purchase. The original transaction and the time money changes hands are separate events for accounting purposes.

If you set your P&L report to an accrual basis, it will show all your income regardless of whether your customers have paid your invoices. Additionally, the date that would reflect on this report is the actual date when you created the invoice.

To ensure that the dates on your financial report reflect your real-life business activities, you'll want to issue the invoice right after you provide the service or sell the product.

Additionally, here some articles that you can read to help streamline the reporting process and get the most out of QuickBooks’ financial reporting capabilities:

Do you have any other questions in mind? Feel free to leave them below and I'll get back to you as soon as I can.

Y

YDK

Thank you for your quick response

But I think that my question still stands. According to accrual accounting you earn the money when the service is rendered not when you create the invoice so the P&L should reflect the service date not the invoice date?

I create the invoice when the customer orders the service and I get paid before the service is rendered so I enter the invoice date on the date that I send out the invoice and I enter the service date to reflect the date the service is provided. I think the P&L should run according to the service date not the invoice date?

I have seen that another person asked that Quickbooks should fix this.

R

R3k1n

I am having the exact same problem. The work around a I have are time consuming and involve taking numbers from the p&l and numbers from the transaction by service date into an excel spreadsheet. So frustrating. Please fix so we can run an accrual P&L based on service date, not invoice date.

Hi! Quickbooks should really do something about the service date... But in the meantime, we've spent lot of time thinking about this... Thought about using the 'service date' but it's pretty much useles since it doesn't affect the date of income. So.. I'm in the hospitality business, and normally how we proceed with our clients is the following:
- 50% deposit is made on the booking date (i.e. today)
- 50% 90 days before the booking date.

I sell events very often 1-2 years in advance.

So what we did is that we put the 'Invoice Date' as the date of the wedding (on which the service is rendered, so taxes are perceived and income is actually made), and the 'Due Date' of said invoice as of 90 days in advance. (so that I can see in my cashflow that I have money coming in, etc.).
For the 1st 50% deposit, we just receive payment separetely and apply such payment on the invoice of the client (which brings the new Balance Due to 50% of the total invoice).

What happens in QBO is that the payment (made today) is recorded as a negative Account Receivable. At year end, we switch all such negative amounts to a Deferred Income as it's 'cleaner' for analysis purposes..

Any thoughts on this procedure? Really scratched my head, and found it's the easiest for clients, and also.. internally.

Sign up

Login with SSO

Let's get you signed in

Login with SSO