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!
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?