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 (via our QuickBooks app: "BookingCenter to Your GL", but the GL array of data works with other web-accessible GL systems, as well.  Contact us for assistance.

...

Because BookingCenter is designed with daily checks built-into MyPMS, we reduce the 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 keeps the daily activity 100% accurate, while avoiding duplication of managing the Accounts Receivable and Advanced Deposit liabilities accounts in both the PMS and the your 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, 

Posting the GL data to QuickBooks OnlineEdition via the BookingCenter app: "BookingCenter to Your GL"

When the GL is automatically placed into automated to your QuickBooks, using the QuickBooks app called "BookingCenter to Your GL", an you have access to a web service that enables you to setup, map, and test the GL process between MyPMS and your QuickBooks system. The area looks like this:

Image Added

  • Mapping Accounts – This checks that your mappings are correct in QB and BookingCenter.
  • QuickBooks Accounts – loads all QuickBooks Accounts directly from Quickbooks.
  • QuickBooks Customers – loads all QuickBooks Customers directly from Quickbooks (used for AR).
  • A/R and A/D - shows the QuickBooks account that is connected to the mapping in BookingCenter.
  • Tech/Setup - shows the ClientID / Token settings etc.
  • Import - Allows you to see the JSON and Import to QB if needed. (Note when you import, it will import to QB).
  • Search – Allows you to search for a Journal entry that imported.  This only searches 1 day at a time.
  • Logging – we log each entry and error. Seach any date required.

In addition, when you are using the "BookingCenter to Your GL, each day an email summary will be sent to your 'billing email' address email summary will be sent that summarizes what was posted to QuickBooks, and looks as follows:

...