Revenue Trial Balance for Hotels - Main Document Used for Controlling and Reporting Purposes

Hotel Management Course: Revenue and Income Audit Fundamentals What is Revenue and How do we Record in Hotels
9 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$4.99
List Price:  $50
You save:  $45.01
€4.63
List Price:  €46.43
You save:  €41.79
£3.97
List Price:  £39.84
You save:  £35.87
CA$6.82
List Price:  CA$68.35
You save:  CA$61.53
A$7.55
List Price:  A$75.70
You save:  A$68.14
S$6.73
List Price:  S$67.50
You save:  S$60.76
HK$38.98
List Price:  HK$390.61
You save:  HK$351.63
CHF 4.51
List Price:  CHF 45.24
You save:  CHF 40.72
NOK kr54.26
List Price:  NOK kr543.73
You save:  NOK kr489.46
DKK kr34.58
List Price:  DKK kr346.49
You save:  DKK kr311.91
NZ$8.30
List Price:  NZ$83.18
You save:  NZ$74.88
د.إ18.32
List Price:  د.إ183.64
You save:  د.إ165.31
৳546.12
List Price:  ৳5,472.22
You save:  ৳4,926.09
₹416.06
List Price:  ₹4,169.01
You save:  ₹3,752.94
RM23.65
List Price:  RM237
You save:  RM213.34
₦6,162.65
List Price:  ₦61,750
You save:  ₦55,587.35
₨1,389.71
List Price:  ₨13,925
You save:  ₨12,535.28
฿183.42
List Price:  ฿1,837.93
You save:  ฿1,654.50
₺161.44
List Price:  ₺1,617.68
You save:  ₺1,456.23
B$25.31
List Price:  B$253.62
You save:  B$228.31
R92.35
List Price:  R925.45
You save:  R833.09
Лв9.05
List Price:  Лв90.76
You save:  Лв81.71
₩6,766.66
List Price:  ₩67,802.25
You save:  ₩61,035.58
₪18.54
List Price:  ₪185.85
You save:  ₪167.30
₱284.74
List Price:  ₱2,853.17
You save:  ₱2,568.42
¥763.79
List Price:  ¥7,653.25
You save:  ¥6,889.45
MX$84.68
List Price:  MX$848.50
You save:  MX$763.81
QR18.16
List Price:  QR182.05
You save:  QR163.88
P67.79
List Price:  P679.25
You save:  P611.46
KSh659.32
List Price:  KSh6,606.48
You save:  KSh5,947.15
E£238.99
List Price:  E£2,394.71
You save:  E£2,155.72
ብር285.64
List Price:  ብር2,862.14
You save:  ብር2,576.50
Kz4,171.64
List Price:  Kz41,800
You save:  Kz37,628.36
CLP$4,701.99
List Price:  CLP$47,114.21
You save:  CLP$42,412.21
CN¥36.11
List Price:  CN¥361.86
You save:  CN¥325.75
RD$289.15
List Price:  RD$2,897.38
You save:  RD$2,608.22
DA671.61
List Price:  DA6,729.65
You save:  DA6,058.03
FJ$11.24
List Price:  FJ$112.66
You save:  FJ$101.42
Q38.67
List Price:  Q387.57
You save:  Q348.89
GY$1,041.02
List Price:  GY$10,431.15
You save:  GY$9,390.12
ISK kr696.80
List Price:  ISK kr6,982
You save:  ISK kr6,285.19
DH50.19
List Price:  DH502.91
You save:  DH452.72
L88.14
List Price:  L883.23
You save:  L795.08
ден285.06
List Price:  ден2,856.31
You save:  ден2,571.25
MOP$40.05
List Price:  MOP$401.32
You save:  MOP$361.27
N$92.11
List Price:  N$922.98
You save:  N$830.86
C$183.18
List Price:  C$1,835.52
You save:  C$1,652.33
रु664.41
List Price:  रु6,657.44
You save:  रु5,993.03
S/18.57
List Price:  S/186.13
You save:  S/167.55
K19.23
List Price:  K192.74
You save:  K173.50
SAR18.71
List Price:  SAR187.52
You save:  SAR168.81
ZK134.22
List Price:  ZK1,344.96
You save:  ZK1,210.73
L23.05
List Price:  L231.04
You save:  L207.98
Kč116.12
List Price:  Kč1,163.58
You save:  Kč1,047.45
Ft1,806.23
List Price:  Ft18,098.50
You save:  Ft16,292.26
SEK kr53.82
List Price:  SEK kr539.37
You save:  SEK kr485.54
ARS$4,382.42
List Price:  ARS$43,912.11
You save:  ARS$39,529.68
Bs34.46
List Price:  Bs345.29
You save:  Bs310.83
COP$19,381.49
List Price:  COP$194,203.37
You save:  COP$174,821.87
₡2,543.28
List Price:  ₡25,483.82
You save:  ₡22,940.53
L122.92
List Price:  L1,231.72
You save:  L1,108.79
₲37,252.87
List Price:  ₲373,275.29
You save:  ₲336,022.41
$U190.71
List Price:  $U1,910.97
You save:  $U1,720.25
zł20.06
List Price:  zł201.01
You save:  zł180.95
Already have an account? Log In

Transcript

I got is doing recording in reporting. So, how they do what kind of daily reporting they have to do, they have to do daily reports, which is they have to prepare a daily revenue report, which is also there in your templates and then they have to prepare a report for payment collection and then they have to prepare ensure that consistency is in ADR. So, they have to make sure that the average rate look nice they are calculated properly. So, this is the daily task of recording and reporting for In summary, what they have to do monthly is they have to check monthly officer entertainment check summary, you all have officer checks, right? You all have free checks. So you have to summarize the officer check and do rate.

Then you have to check the complimentary and how to look nights then you have to check the monthly service child report. monthly service charges calculated by somebody trying to pay out of the sap So then you have to calculate that and also the revenue segment report on a monthly basis. So these are the daily and monthly requirements for income audit. Now in the next slide, we will go into them individually one by one. Okay, so the first thing we're going to see now is a trial balance system trial balance. Okay, this system Calvin's is coming from the system that we use, the one that you have is if you have a different system, I'm using a different so that you can see both every system generates a different trial balance, opera generate different tablets.

Pretend to different fo easy, fO fO use different so this template in your book is come from I come from another software. So I'm showing I'm showing you two different trial balance so that you can understand each of them separately. Okay every system is a trial balance differently, but there are a few things which are common in every trial. The one is total revenue and total settlements, they have come together, okay. So there is a debit side and credit side. So the credit side is revenue, debit side is what you set out to collect as a settlement.

So those two tend together. Okay, so total revenue and net settlements has to tell you all the time, that's the basic thing of provenance and that is separate out the room revenue. So here you can see the trial balance, this is so the first is this part is about the room every day, right? It has a tariff, it extra bed, it has the retention charges, then you have food and beverage for each and every outlet. There is another revenue column. Correct.

And then there's other sales, laundry day and others department laundry department transportation. So, this one This part is only okay. So they are separating between the room fnb and other departments. So they are the trial balance is given. So this revenue is net revenue excluding the service charge and the Texas the Texas are on another side here the government and service charge is separate. Now you have paid us what is paid out paid out means the one that you are giving money to the cash in cash for many different ways like you are giving money to the guests in advance for using in any other any kind of services.

So, the guests may want to book a taxi outside but he may not have cash. So he will ask you Okay, can you give me some advice, I will sit down with my credit card at the time of checkout. So that is called freedom. Normally paid out in the hotel and out for internal use internal services. Let's say you want to use Make something you want to use a babysitting service or you want to use any service which is in the hotel, you need to pay cash, which is provided by a third party. So, those are the those are the trade offs you have this is this part is up and then after that you have collections, advanced collections, and then advanced access, then you have collection company or foreign exchange.

So, these are listing out all the collections. And then then after that summary, so the idea is somebody will see totals of the room total of the revenue and total off the settlement is same 1569 and 1569. Right. So in every trial balance, that is part of revenue, together with the the settlement because every time you have a guest ledger, what is guest ledger outstanding revenue Offering what you need to collect from the guests. And collections actual collections will always tell you together that's the first test of travelers. So, in the in your trial balance, there is no figure.

So, you cannot check in the in the summary that we give you there is no there is no amount mentioned. But in here you can see the amounts. Right. So these are to tell you together so in your systems whenever you are so you are using who is using Oprah, you're using Oprah. So you have seen the travels Italy together. Yes.

Not exactly the revenue in collection. You already have our from the previous day. So means we have a guest ledger, the previous uncollected amount, then you have revenue of the day. So it becomes and then you have something to carry out carry forward on next day because you cannot collect that the guest has not yet checked out. So, the net balance should be collect should be equal to the collections collections and advance taxes or any other collections means cash credit card or what however, you have collected the money. So, those are the two together and when you when collection part okay.

So, that is that is a very very important test of a trial balance. So, that also we always be putting it together. And then also trial balance normally give you the advanced deposit, how much advance deposit is pending in the system so that you can use them for future check in checkout. So, the the basis of the income or the because the basis of all the revenue reports is this trial balance. The basis of all the transactions from income audit is this trial balance. So, the first thing income auditor does in the morning is pick out a trial balance and check it Telly on The first thing is it should tell you Okay, the second thing after that is to check the document supporting document for example, there is adequate right there is normally a lot of allowance for some trial balance, they record allowances rebates as part of the transaction, some trial balance record allowance as a separate column.

So, the first thing is what they do is they collect all the supporting documents, all the bills, settlements, all the revenue for you all the advance all the miscellaneous check all the manual checks, correct all the collections lips So, if you see you have been working in income or you have worked as cashier you when you do the cashier report, you have to collect all the documents and give it to the income auditor to check so what they do, they match the trial balance total of all the collections total of all the bills total of all the checks They will check with the province, they will check. Okay, how many we bid for you are there we just sign and then they will match the total with the system? Is it complete or not? So the first thing that income auditor does is check the completeness of the documents.

Whatever document has been submitted by front office, what did whatever document have been submitted by the front office or fnb or other departments in the checks the waves, the little bits, everything it needs to tally with the trial balance. So the first thing is the most important document is balance. Then this trial balance is converted into a daily revenue report. So the daily revenue report also you have a template that's a big template has four or five pages template, right though I'm not including that template in my slides, but because I would have been using is a summarized version. Okay, but that template is coming out of this panel. So all the FNV revenue, all the average check, everything has come from the balance.

Okay? So progress is very important document

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.