Versions Compared

Key

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

For customers who are subscribed to the General Ledger (GL) postings interface, BookingCenter provides a service to map the Transaction Categories, Inventory Items, and Receipt Types so that your General Ledger (GL) can be keep current - automatically.  The service posts each day's Transaction Summary to your GL system, either manually or via a machine process as a JSON array, that has been 'mapped' to the GL system you use.  BookingCenter can provide this mapping as a service for customers of Quickbooks Online Edition, but we are happy to work with other web-accessible GL systems, as well.  Contact us for assistance.

...

  1. A unique URL we provide that uses an API key to keep secure each client's data.  This string requires a customer to place a date into the string to receive the array of data for that specific day, and that data must be earlier than the current System Date.
  2. BookingCenter can provide a simple web form that can be placed on your accountant's secure page that enables a date entry to acquire the JSON array.
  3. BookingCenter sends an automated daily email at Night Audit with the JSON is embedded into an email so that it an be human- or machine-read from whatever tool a customer uses.  This email is also a 'backup' file that can be kept for a long as necessary to validate what occurred at Night Audit.

...

Because BookingCenter creates a General Ledger GL array of data that matches the Transaction Summary data, it is important to understand that the date requested must be earlier than the current System Date.  This is because a GL should only be machine-updated once per day, at Night Audit, so the feature is meant to be run immediately after Night Audit. One can automate this feature using either Manual or Automatic Night Audit. Because the JSON will always equal the Transaction Summary data, one can always go backward in time to request the array. Just as someone can go back and request the Transaction Summary report, for example, Feb 20, 2023.

...

Because BookingCenter is designed for properties to manage simply, taking advantage of the checks built-into MyPMS, we reduce the complexity for Users and avoid complexity of managing the Accounts Receivable and Advanced Deposit liabilities accounts in your GL. When issuing Payments and Charges to Folios, as well as Cancelling and Editing Bookings, the traditional Guest Ledger and City Ledger required Users to allocate these events to specific GL code(s) to decide what account to credit/debit.  Instead, because of the checks built-into MyPMS, GL automation keep the daily activity 100% accurate, while avoiding duplication of managing the Accounts Receivable and Advanced Deposit liabilities accounts in both the PMS and the GL.  When automating your GL, BookingCenter does this by 're-setting' the daily Accounts Receivable and Advanced Deposit liabilities account totals, and then posting the new number each day.  For example, if the GL account for Accounts Receivable was $1,250 'yesterday', we read that total, offset it with a -1250 entry, then post the current (ie 'today') Accounts Receivable amount that was accurate as of Night Audit and detailed in the Accounts Receivable Aging report. We do the exact same thing with the Advanced Deposit liabilities account.  This saves a property a lot of accountant time and frees up staff to focus on guests and the art of hospitality - not allocating Payments & Charges to Folios and Cancellations & Edits to specific GL accounts to track these events in a GL system, 

Examples of a GL JSON array

Below are examples off of what is provided and in our JSON syntax:

 { 
        "property_id": "TEST",
        "property_name": "TEST Property",
        "transaction_date": "2020-JAN-02",
        "item_id": "RENT",
        "item_description": "Room Rent",
        "gl_id": "2500",
        "gl_desc": "Rent",
        "gl_type": "Credit",
        "gl_amount": "4404.78",
        "offset_id": "3500",
        "offset_desc": "Rentoffset",
        "gl_offset_type": "Debit",
        "offset_amount": "4404.78"
    },
    {
        "property_id": "TEST",
        "property_name": "TEST Property",
        "transaction_date": "2020-JAN-02",
        "item_id": "Totals for Miscellaneous Items",
        "item_description": "Totals for Miscellaneous Items",
        "gl_id": "00009",
        "gl_desc": "MiscTotals",
        "gl_type": "Credit",
        "gl_amount": "250.00",
        "offset_id": "00090",
        "offset_desc": "MiscTotalsOffset",
        "gl_offset_type": "Debit",
        "offset_amount": "250.00"
    },
    {
        "property_id": "TEST",
        "property_name": "TEST Property",
        "transaction_date": "2020-JAN-02",
        "item_id": "CLEANING",
        "item_description": "Exit cleaning fee",
        "gl_id": "1012",
        "gl_desc": "ExitClean",
        "gl_type": "Credit",
        "gl_amount": "250.00",
        "offset_id": "10212",
        "offset_desc": "ExitCleanOffset",
        "gl_offset_type": "Debit",
        "offset_amount": "250.00"
    },

 {
        "property_id": "TEST",
        "property_name": "TEST Property",
        "transaction_date": "2020-JAN-02",
        "item_id": "Totals for CARDS",
        "item_description": "Totals for CARDS",
        "gl_id": "00003",
        "gl_desc": "CardsTotal",
        "gl_type": "Credit",
        "gl_amount": "19326.72",
        "offset_id": "00030",
        "offset_desc": "CardsTotalOffset",
        "gl_offset_type": "Debit",
        "offset_amount": "19326.72"
    },
    {
        "property_id": "TEST",
        "property_name": "TEST Property",
        "transaction_date": "2020-JAN-02",
        "item_id": "CA",
        "item_description": "Mastercard",
        "gl_id": "1001",
        "gl_desc": "MasterCard",
        "gl_type": "Credit",
        "gl_amount": "12162.00",
        "offset_id": "1002",
        "offset_desc": "MasterCardOffset",
        "gl_offset_type": "Debit",
        "offset_amount": "12162.00"
    },

 
    {
        "property_id": "TEST",
        "property_name": "TEST Property",
        "transaction_date": "2020-JAN-02",
        "item_id": "VI",
        "item_description": "Visa",
        "gl_id": "1003",
        "gl_desc": "Visa",
        "gl_type": "Credit",
        "gl_amount": "7164.72",
        "offset_id": "1004",
        "offset_desc": "VisaOffset",
        "gl_offset_type": "Debit",
        "offset_amount": "7164.72"
    },
    {
        "property_id": "TEST",
        "property_name": "TEST Property",
        "transaction_date": "2020-JAN-02",
        "item_id": "Totals for NONCARD",
        "item_description": "Totals for NONCARD",
        "gl_id": "00004",
        "gl_desc": "NonCardsTotal",
        "gl_type": "Credit",
        "gl_amount": "2789.00",
        "offset_id": "00040",
        "offset_desc": "NonCardsTotalOffset",
        "gl_offset_type": "Debit",
        "offset_amount": "2789.00"
    },
    {
        "property_id": "TEST",
        "property_name": "TEST Property",
        "transaction_date": "2020-JAN-02",
        "item_id": "DEBIT",
        "item_description": "Debit",
        "gl_id": "1007",
        "gl_desc": "Debit",
        "gl_type": "Credit",
        "gl_amount": "2789.00",
        "offset_id": "1008",
        "offset_desc": "DebitOffset",
        "gl_offset_type": "Debit",
        "offset_amount": "2789.00"
    },
    {
        "property_id": "TEST",
        "property_name": "TEST Property",
        "transaction_date": "2024-FEB-26",
        "transaction_ref": "Advance Deposits",
        "item_id": "AD",
        "item_description": "Advance Deposits",
        "gl_id": "00002",
        "gl_desc": "AD",
        "gl_type": "Credit",
        "gl_amount": "12.50",
        "offset_id": "102",
        "offset_desc": "ADOffset",
        "gl_offset_type": "Debit",
        "offset_amount": "12.50"
    },
    {
        "property_id": "TEST",
        "property_name": "TEST Property",
        "transaction_date": "2024-FEB-26",
        "transaction_ref": "Accounts Receivable",
        "item_id": "AR",
        "item_description": "Accounts Receivable",
        "gl_id": "00001",
        "gl_desc": "AR",
        "gl_type": "Credit",
        "gl_amount": "28637.20",
        "offset_id": "101",
        "offset_desc": "AROffset",
        "gl_offset_type": "Debit",
        "offset_amount": "28637.20"
    }