Hotel Receipt Tabulator

Quickly parse out and tabulate relevant business expenses from your hotel receipt. Simply enter the relevant beginning line items (see samples provided) in the first box, copy and paste the text (see second sample) from the PDF that they email you after your stay into the second box, and hit calculate to get a tally of the costs of those items without all the extra noise.

This has been tested with a number of hotel receipts like Hilton and Marriott, but may not always work correctly. I recommend doublechecking your math the first few times you use it.

Total of Identified Labels:

Enter the labels that appear before the dollar amounts you want to include here:
GUEST ROOM GUEST ROOM STATE SALES TAX OCCUPANCY TAX Room Charge Occupancy Sales Tax State Occupancy Tax Parking Tax Daily Parking

Enter the text from your Doubletree invoice here:
DOUBLETREE MCLEAN TYSONS CORNER 1960 CHAIN BRIDGE RD MCLEAN TYSONS CORNER, VA 22102 United States of America TELEPHONE 703-893-2100 • FAX 703-356-8218 Reservations www.hilton.com or 1 800 HILTONS DOUBLETREE MCLEAN TYSONS CORNER 3/9/2023 12:16:00 PM DATE REF NO DESCRIPTION CHARGES 3/5/2023 1341555 TAVERN FOOD $30.00 3/5/2023 1341555 MISC SALES TAX 6% $1.80 3/5/2023 1341556 MISC SALES TAX 6% $4.32 3/5/2023 1341557 TAVERN TIPS $6.00 3/5/2023 1341578 DAILY FOOD & BEVERAGE CREDIT ($15.00) 3/5/2023 1341618 GUEST ROOM $171.50 3/5/2023 1341618 STATE SALES TAX 6% $10.29 3/5/2023 1341618 OCCUPANCY TAX 7% $12.01 3/6/2023 1341809 CAFE FOOD BREAKFAST $19.95 3/6/2023 1341809 MISC SALES TAX 6% $1.20 3/6/2023 1341810 CAFE- SERVICE CHARGE $10.99 3/6/2023 1342161 DAILY FOOD & BEVERAGE CREDIT ($15.00) 3/6/2023 1342205 GUEST ROOM $242.53 3/6/2023 1342205 STATE SALES TAX 6% $14.55 3/6/2023 1342205 OCCUPANCY TAX 7% $16.98 3/7/2023 1342547 CAFE FOOD BREAKFAST $15.95 3/7/2023 1342547 MISC SALES TAX 6% $0.96 3/7/2023 1342548 CAFE- SERVICE CHARGE $7.39 3/7/2023 1343013 DAILY FOOD & BEVERAGE CREDIT ($15.00) 3/7/2023 1343052 GUEST ROOM $260.96 3/7/2023 1343052 STATE SALES TAX 6% $15.66 3/7/2023 1343052 OCCUPANCY TAX 7% $18.27 3/8/2023 1343430 CAFE FOOD BREAKFAST $15.95 3/8/2023 1343430 MISC SALES TAX 6% $0.96 3/8/2023 1343431 CAFE- SERVICE CHARGE $7.39 3/8/2023 1343655 TAVERN FOOD $18.00 3/8/2023 1343655 MISC SALES TAX 6% $1.08 3/8/2023 1343656 TAVERN WINE $45.00 3/8/2023 1343656 MISC SALES TAX 6% $2.70 3/8/2023 1343657 MISC SALES TAX 6% $1.08 3/8/2023 1343658 TAVERN TIPS $15.00 3/8/2023 1343861 DAILY FOOD & BEVERAGE CREDIT ($15.00) 3/8/2023 1343909 GUEST ROOM $242.53 3/8/2023 1343909 STATE SALES TAX 6% $14.55 3/8/2023 1343909 OCCUPANCY TAX 7% $16.98 3/9/2023 1344241 AX *1008 ($1,293.53) 3/9/2023 1344294 CAFE FOOD BREAKFAST $15.95 3/9/2023 1344294 MISC SALES TAX 6% $0.96 3/9/2023 1344295 CAFE- SERVICE CHARGE $7.39 Page:1 TWEEDY, JONATHAN Room No: 152/NKRD Arrival Date: 3/5/2023 2:28:00 PM 103 PLEASANT DRIVE, APT A Departure Date: 3/9/2023 12:16:00 PM Adult/Child: 1/0 CARRBORO NC 27510 Cashier ID: EGUEST UNITED STATES OF AMERICA Room Rate: 171.50 AL: HH # 269613383 DIAMOND VAT # Folio No/Che 307870 A Confirmation Number: 54941214 DOUBLETREE MCLEAN TYSONS CORNER 3/9/2023 12:16:00 PM DATE REF NO DESCRIPTION CHARGES 3/9/2023 1344407 AX *1008 ($24.30) **BALANCE** $0.00 Hilton Honors(R) stays are posted within 72 hours of checkout. To check your earnings or book your next stay at more than 6,500+ hotels and resorts in 119 countries, please visit Honors.com CREDIT CARD DETAIL APPR CODE 121328 MERCHANT ID 4410109011 CARD NUMBER AX *1008 EXP DATE 05/27 TRANSACTION ID 1344241 TRANS TYPE Sale Page:2