Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

How can I spread the revenue from a Customer Invoice into multiple months? Without multiple invoices.

accounting invoice hotel invoicing

3 Vastaukset

4968 Näkymät

Volodymyr

The hotel wants to have Profit and Loss report based on each day customers stayed at the hotel.

Example:

Reservation #1:

- check-in: 25 Oct 2018

- check-out: 4 Nov 2018 (10 nights stay)

If we make one invoice for the whole stay with a Due Date = 4 Nov 2018 - all the revenue from this reservation will go to November.

In this case the hotel wants to have revenue separated by days so that if they generate Profit and Loss for October - they should see revenue from 6 nights of this reservation, and 4 nights go to November revenue.

The only solution we can see is to make 10 separate invoices:

1 invoice = 1 night stay

This solution is not really useful in the mean of reconciliation of customer payments to these 10 invoices.

Are there any other solutions you can think of?

Thanks a lot for any comments!

Ray Carnes (ray)

Jake,

Thank you so much for your answer. It look really nice.

What type of account should "suspense account" be? Here're types of accounts:

Receivable, Payable, Bank and Cash, Credit Card, Current Assets, Non-current Assets, Prepayments, Fixed Assets, Current Liabilities, Non-current Liabilities, Equity, Current Year Earnings, Other Income, Income, Depreciation, Expenses, Cost of Revenue

I'm thinking it should be "Current Liabilities" - right?

Jake Robinson

Hi Volodymyr

10 invoices is a lot of work, both in creation and reconciliation, for every stay that would be a nightmare.

The biggest issue is that each journal entry can only have a single date, this means to you need at least N journal entries for an N night stay. However, if you split the accounts receivable across these journals it again becomes difficult to reconcile.

To keep it as a single invoice with a single accounts receivable entry, you could set the income of the room stay product to a suspense account, and any time a journal item was made for this suspense account, create another journal entry for each quantity, one for each day to move from the suspense account to the proper income account:

--- Journal Entry 1, Dated 4 Nov 2018 (Made by the invoice)

Accounts Receivable: 500

Suspense Account: 500

--- Journal Entry 2, Dated 26 Oct 2018 (Made manually or by custom module)

Suspense Account: -50

Income: 50

--- Journal Entry 3, Dated 27 Oct 2018 (Made manually or by custom module)

Suspense Account: -50

Income: 50

And so on, copying journal entry 2 and 3 for the rest of the 10 day period.

Regards,
Jake Robinson

Ermin Trevisan

It's all about your definition of the product and corresponding customizations. You can try the hotel management application https://www.odoo.com/apps/modules/11.0/hotel/ or do it yourself by inspecting the code.

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to generate customer invoice in hotel management? invoice hotel	0 lokak. 25	6271
Automating Invoice Sending to Accountant Email accounting invoice	1 syysk. 25	877
Analytic Accounting in v17 Ratkaistu accounting invoicing	3 heinäk. 25	3626
Journal Entry PB-Tab/2025/00007 is not valid. In order to proceed, the journal items must include one and only one outstanding payments/receipts account. accounting invoicing	1 maalisk. 25	2161
Unselect the Show in Invoices Footer option Ratkaistu accounting invoice	3 helmik. 25	3851

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!