Icon

The Importance of Cross-Checking Eviivo and QuickBooks Before Charging

Learn why it's crucial to cross-check Eviivo and QuickBooks before charging customers to avoid discrepancies and ensure accurate billing.

By Tim Moody

In this guide, we'll learn how to ensure accuracy when processing customer charges by cross-checking data between Eviivo and QuickBooks. This process is crucial to avoid discrepancies that can lead to charging incorrect amounts. By carefully verifying details such as dates, rates, and taxes, you can prevent errors and maintain consistency in your financial records. We'll also cover how to handle the check-in process, including updating customer information and sending confirmations. This guide aims to help you streamline your workflow and enhance customer satisfaction by minimizing billing errors.

Let's get started

I want to document this quickly because it highlights the importance of cross-checking what Eviivo believes people owe with what QuickBooks calculates.

1
Click here
Step #1: Click here

I can't stress enough how important it is to do this before you charge. I'm referring to a customer who submitted the registration form and requested us to charge the card on file. This customer, as you can see on the invoice, made a change at one point. This occurred during a particularly busy period, possibly during the snowstorm in February.

2
Click on "CD"
Step #2: Click on "CD"
3
Click on "Changed from Mrs. Otis : 02 / 21 / 2025-02 / 25 / 2025 to Mrs. Otis : 03/01/2025 - 03/04/2025 on or around 2/16/2025"
Step #3: Click on "Changed from Mrs. Otis : 02 / 21 / 2025-02 / 25 / 2025 to Mrs. Otis : 03/01/2025 - 03/04/2025 on or around 2/16/2025"

I don't remember exactly why, but I adjusted the important things first. I changed the dates because they were delaying their stay by about a week and a half. I updated the calendar and the book, but I forgot to update QuickBooks immediately. Later, when sending the SCI, I noticed the invoice didn't match the calendar. I emailed the client for clarification. It was a bit embarrassing, but he was happy to help and confirmed the calendar dates were correct.

I came in and adjusted the invoice. Now, I'll revert it to how it was when I found it.

4
Click here
Step #4: Click here

He owes a balance of $222, which includes two weekend nights and one weeknight.

5
His balance is shown here
Step #5: His balance is shown here

In QuickBooks, it shows $222.75, which matches the physical invoice. However, these don't always align. This is why I advise everyone to cross-check QuickBooks directly before charging with Eviivo, not just relying on the printed invoice. In this case, both the printed invoice and QuickBooks agreed, but they were incorrect. Eviivo shows a balance of $191.25 and, as it turns out, this is the correct amount!

6
Click on "$ 191.25"
Step #6: Click on "$ 191.25"

I started thinking about why the amount was different. Why was it higher in QuickBooks than in Eviivo? I couldn't understand it, so I began examining other details. He paid a $360 deposit.

7
Click on "$ 360.00"
Step #7: Click on "$ 360.00"

I can see that right there in Eviivo. In QuickBooks, his invoice also shows a $360 deposit was applied.

8
Click on "360.00"
Step #8: Click on "360.00"

Hmm, alright, good so far. So next, I reviewed the tax amount.

9
Shown here: $27.75 according to QB
Step #9: Shown here: $27.75 according to QB

The tax amount does not match Eviivo's calculation.

I could determine that by checking the charges in Eviivo.

10
Click on "Charges"
Step #10: Click on "Charges"

Below, you can see the charges, including the occupancy tax for each of the three nights.

11
🤔
Step #11: 🤔

It's slightly less than what QuickBooks indicates. It came out to $26.25, while QuickBooks says $27.75.

12
I know, cat. I know.
Step #12: I know, cat. I know.

At this point, I was quite confused.

I clicked on the bill tab in Eviivo, where you can see all the various charges in Eviivo.

13
Click on "Bill"
Step #13: Click on "Bill"

You can see everything clearly. It breaks it down, showing the deposit he paid right here.

14
Click here
Step #14: Click here

The weekend room rate is $195 per night.

15
Click here
Step #15: Click here

The tax for that night was $9.75.

16
Click here
Step #16: Click here

The weeknight rate is $165.

17
Click here
Step #17: Click here

The tax on it, followed by the weeknight rate again.

18
Click here
Step #18: Click here

...OH WAIT...

I checked the invoice in QuickBooks and realized I made a significant mistake.

19
Look at the quantities...
Step #19: Look at the quantities...

It showed a quantity of two weekend rates instead of one. However, if you check the calendar, March 1st was a Saturday, and our weekend rates apply only on Friday and Saturday nights.

20
Click on "6:54 PM"
Step #20: Click on "6:54 PM"
21
Click on "1"
Step #21: Click on "1"

He was staying Saturday, Sunday, and Monday. I had the quantities reversed on his invoice.

He originally planned for four nights but reduced it to three. Previously, he would arrive on a Friday and stay for four nights. I mistakenly reduced the quantity on the wrong line item, which confused me. Now that I've identified the error, I can adjust the quantities to one weekend rate and two weekdays. QuickBooks now shows he owes $191.25 is the balance due.

22
Yay!
Step #22: Yay!

That is precisely what Eviivo believes the balance is!

23
Click on "$ 191.25"
Step #23: Click on "$ 191.25"

This illustrates the importance of never clicking "charge" until you've thoroughly cross-checked with QuickBooks. If there's any discrepancy, identify it before proceeding.

24
Click on "Payments"
Step #24: Click on "Payments"

Don't assume one is correct and the other is wrong. If I had to guess, I would have thought QuickBooks was correct. Sometimes, when you make changes in Eviivo, it doesn't always update the rate as expected, and you may need to adjust it manually. I found that quite interesting. Normally, I don't get surprised like that, but I did with this one tonight!

That's all I wanted to share. It was a good example of why that's important. But, I'll complete the rest of this check-in process with you. Why not? Payment method time!

25
Click here
Step #25: Click here

Select the first option in the system. This indicates that the card stored in the Eviivo booking engine will be charged.

26
Click on "Card / VCC via the System"
Step #26: Click on "Card / VCC via the System"

Double-check the amount AGAIN: $191.25

27
Click on "191.25"
Step #27: Click on "191.25"

Return to QuickBooks and verify that everything is correct. Yes, again! You can't be too careful here folks.

28
Click here
Step #28: Click here
29
Click here
Step #29: Click here

$191.25 is correct. At this point, I like to grab the notation, copy it, and then save and close.

30
Right-click on "Mrs. Otis: 03/01/2025 - 03/04/2025"
Step #30: Right-click on "Mrs. Otis: 03/01/2025 - 03/04/2025"
31
Click on "Copy"
Step #31: Click on "Copy"
32
Click on "Save & Close"
Step #32: Click on "Save & Close"

Exit the invoice now. Also, notice how it says "SP" on the rep.

33
Click here
Step #33: Click here

I had already completed that part of the check-in process before recording this - he had selected yes for promotions. When checking someone in, we obviously charge any balance if applicable, but we also check if they want promotions. If they don't, we mark it as NA for not answered. The rep field will never be blank if they have stayed here. It's only blank until their first time coming here. If nothing else is selected, we choose NA. I had already filled in any missing address information, phone numbers, or similar details - we always need to check those (specifically for certain OTA guests, as we don't always get their address or email for example when they book through an OTA).

It's ready to go. Go back into Eviivo and click "charge."

Before I do that, please take note.

34
Looky here:
Step #34: Looky here:

"Email Confirmation" is automatically checked, meaning he will receive a receipt, as will we.

35
Click on "Charge"
Step #35: Click on "Charge"

Bombs away! It takes just a moment. 🙏

36
Payment successful! 😎
Step #36: Payment successful! 😎

A small green box appears near the top. Then, if you look just below it, you should see the charge, and the status will indicate "charged."

37
Click here
Step #37: Click here
38
Click on "Charged"
Step #38: Click on "Charged"

If it says anything else, you need to contact the guest to check if their card expired or if something else went wrong. That's it. Now, I can close the Eviivo booking and return to QuickBooks.

39
Click on "New Transactions ▼"
Step #39: Click on "New Transactions ▼"
40
Click on "Receive Payments"
Step #40: Click on "Receive Payments"
41
Click here
Step #41: Click here
42
Type "191.25"
43
Ensure it goes to the General Operating Fund
Step #43: Ensure it goes to the General Operating Fund
44
Click on "operating fund"
Step #44: Click on "operating fund"
45
and confirm it's from Eviivo.
Step #45: and confirm it's from Eviivo.

Currently, things are changing.

A new keyboard is coming with improved macro capabilities, which will change the specific key. However, we have a special key for this. The exciting part is that with the new keyboard, if something is copied, you don't even need to paste it. Just press one key and see what happens.

46
Type "CardPointe: Balance: "
47
Type "Ctrl + V"

^ those two steps were one key stroke, folks. MAGIC.

Save and close.

48
Click on "Save & Close"
Step #48: Click on "Save & Close"
49
Here, you can see that one key typed out the card point balance and then pasted whatever was copied.
Step #49: Here, you can see that one key typed out the card point balance and then pasted whatever was copied.

Take note moving forward. At the end of the day, while I don't mind what people do if they get it right, I'm really emphasizing copy-paste. Why? Because consistency is crucial, and having a consistent notation is extremely important. You can see why here. The invoice is notated in a specific way, and then there's a deposit processed through CardPoint with that exact notation. Additionally, a balance was processed through CardPoint with the same notation.

50
Click on ":"
Step #50: Click on ":"

I like to email a copy of the paid invoice, even though we both will receive a receipt for the charge.

Let's send a copy of the paid invoice.

51
Click here
Step #51: Click here

I prefer to change the subject line, as it automatically populates with the reservation confirmation.

52
Drag here
Step #52: Drag here

Change it to just "paid invoice" or something similar, right?

53
Click here
Step #53: Click here
54
Type "Ctrl + A"

'A' stands for "All" - I reckon, anyway. This will highlight the entire table, allowing you to easily press backspace to remove it.

55
Type "Backspace"

I wish I could stop that from appearing, but I don't think I can. Since there's no default signature, I start by going to the signature option and choosing standard.

56
Click on "Signature"
Step #56: Click on "Signature"
57
Click on "Standard"
Step #57: Click on "Standard"

You can type a personal note.

58
Click here
Step #58: Click here

Type your message in your own words, then click send.

59
Something like this.
Step #59: Something like this.
60
Click on "Send"
Step #60: Click on "Send"

You can double-check again to ensure you haven't forgotten to enter anything in the promo field.

61
Click here
Step #61: Click here

This often happens, including to me. I might forget to add something, especially if it's ignored. If it's ignored, you should write "N/A" for not answered.

62
Click here
Step #62: Click here
63
Click here
Step #63: Click here

He confirmed yes, so we mark SP for send promo.

64
Click here
Step #64: Click here
65
Click here
Step #65: Click here

Save and close.

66
Click on "Save & Close"
Step #66: Click on "Save & Close"

And that's it. It's a strong reminder to be very careful. There's nothing more embarrassing than charging the wrong amount, especially if it's more than they should pay. In this case, it would have been about $30. Most people might not be furious about that, but if it were $300 or $3,000, they might be.

I've seen that happen, so please be careful. I'm also reminding myself.

The Importance of Cross-Checking Eviivo and QuickBooks Before Charging