Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Search – Allows you to search for a Journal entry that imported.  This only searches 1 day at a time.
  • Logging – QuickBooks logs each entry and error. Search any date required, but note that the date for the QuickBooks is actual time and date (listed in Pacific Time, ie, California) that the Journal entry was entered.  Depending on how you use Night Audit, that may/not be the actual date of your System Date.

...

Cross checking the accounting integration

...

#1 The Folio posting that occur at night Audit

...

goes out to your email on record, as such:

From: "BookingCenter Support" <folioarch@bookingcenter.com>
Subject: MYPMSDO Charge Folio Results for 14-NOV-2025
Date: November 22, 2025 at 1:30:20 PM PST
To: info@bookingcenter.com

The following folios were charged Room Rent as a result of your Night Audit process for 14-NOV-2025
Guest: douglas, smith Folio Number: 11090062 Room: 221 Room Rent: 189
Guest: Amy, Tweddale Folio Number: 11133371 Room: 206 Room Rent: 194

#2 The email sent when

...

using the "BookingCenter to Your GL, each

...

day to your

...

email

...

on record that summarizes what was posted to QuickBooks,

...

as such:

From: BookingCenter GL to QuickBooks <admin@bookingcenter.com>
Subject: BookingCenter GL to QuickBooks result for MYPMSDO on 14-NOV-2025
Date: November 22, 2025 at 2:00:06 PM PST
To: info@bookingcenter.com
Reply-To: noreply@bookingcenter.com


Item: Totals for Room Rent Value: 383.00 Journal Entry created. ID: 8
Item: Totals for NONCARD Value: 1.00 Journal Entry created. ID: 9
Item: Totals for Taxes Value: 21.83 Journal Entry created. ID: 10
Item: AD Value: 2.00 Journal Entry created. ID: 11
Item: AR Value: 1977.10 Journal Entry created. ID: 12

...

From: BookingCenter GL Interface <admin@bookingcenter.com>
Subject: BookingCenter QBOE General Ledger JSON for A MYPMS demo hotel on 30-JAN-2025
Date: May 29, 2025 at 4:01:03 PM PDT
To: <Your GL Email>@bookingcenter.com
Reply-To: noreply@bookingcenter.com

[
   "ERROR",
   "No Transactions found for 30-JAN-2025"]

#3 The GL JSON array sent via email:

Below are whats was sent via email, the detail provided in the JSON for the same date as the example used here:

 {
       "property_id": "MYPMSDO",
       "property_name": "A MYPMS demo hotel",
       "transaction_date": "2025-NOV-14",
       "item_id": "Totals for Room Rent",
       "item_description": "Totals for Room Rent",
       "gl_id": "7",
       "gl_desc": "RoomRentTotals",
       "gl_type": "Credit",
       "gl_amount": "383.00",
       "offset_id": "1150040006",
       "offset_desc": "RoomRent Cash at Bank",
       "gl_offset_type": "Debit",
       "offset_amount": "383.00"
   }

 {
       "property_id": "MYPMSDO",
       "property_name": "A MYPMS demo hotel",
       "transaction_date": "2025-NOV-14",
       "item_id": "Totals for NONCARD",
       "item_description": "Totals for NONCARD",
       "gl_id": "6",
       "gl_desc": "NonCardTotals",
       "gl_type": "Credit",
       "gl_amount": "1.00",
       "offset_id": "1150040006",
       "offset_desc": "Non Cards Cash at Bank",
       "gl_offset_type": "Debit",
       "offset_amount": "1.00"
   }

 {
       "property_id": "MYPMSDO",
       "property_name": "A MYPMS demo hotel",
       "transaction_date": "2025-NOV-14",
       "item_id": "Totals for Taxes",
       "item_description": "Totals for Taxes",
       "gl_id": "1",
       "gl_desc": "TaxTotals",
       "gl_type": "Credit",
       "gl_amount": "21.83",
       "offset_id": "30",
       "offset_desc": "Tax Payables",
       "gl_offset_type": "Debit",
       "offset_amount": "21.83"
   }

 
   {
       "property_id": "MYPMSDO",
       "property_name": "A MYPMS demo hotel",
       "transaction_date": "2025-NOV-22",
       "transaction_ref": "Advance Deposits",
       "item_id": "AD",
       "item_description": "Advance Deposits",
       "gl_id": "18",
       "gl_desc": "AdvanceDeposit",
       "gl_type": "Credit",
       "gl_amount": "2.00",
       "offset_id": "4",
       "offset_desc": "AdvanceDepositOffset",
       "gl_offset_type": "Debit",
       "offset_amount": "2.00"
   },
   {
       "property_id": "MYPMSDO",
       "property_name": "A MYPMS demo hotel",
       "transaction_date": "2025-NOV-22",
       "transaction_ref": "Accounts Receivable",
       "item_id": "AR",
       "item_description": "Accounts Receivable",
       "gl_id": "1150040000",
       "gl_desc": "AR",
       "gl_type": "Credit",
       "gl_amount": "1977.10",
       "offset_id": "1150040007",
       "offset_desc": "AR Pedning",
       "gl_offset_type": "Debit",
       "offset_amount": "1977.10"
   

#4 the Journal report in QuickBooks.  Note, this is based on date and time - as Pacific time (California, USA) - of the import to QuickBooks, as such:

Image Added