You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

This area determines the structure of the General Ledger (G/L) files we export to the accounting systems such as QuickBooks and others.  It allows a property to use their internal MyPMS tracking capabilities to automate accounting postings that conform the posting files (JSON messages) to the setup of their General Ledger system.

G/L Mapping

The mappings area are where all Inventory Groups and Items that are present on your Transaction Summary Report will allow you to 'map' the Item/Group and decryption inside of BookingCenter and have that map to the account code & description you use in your accounting system. Further, it will allow you to place an 'offset' account  code & description used in your accounting system so that the Transaction Summary GL file generated will also provide an 'offset' posting.  The ability to post whether the file will have a 'credit' or 'debit' label - for either side of the Transaction Summary Ledger GL file - is also manageable in this area.  

Because the Transaction Summary Ledger GL file is a version of the Transaction Summary report but is only applicable to single day (the 'Site date') the MTD (month to date) and YTD (year to date_ values are never included.


The columns that are enabled for mapping include

Inventory Item/Group 1 ID | Inventory Item/Group 1 Description | Site GL ID | Site GL Description | Credit/Debit option | Site Offset GL ID | Site Offset GL Description | Description | Offset Credit/Debit option

Two 'special condition Groups' called 'Credit Cards' - which are the total of all active Receipt Types set as 'Credit Cards' - and Non Credit Card -  which are the total of all active Receipt Types NOT set as 'Credit Cards' such as CASH, Write-Off, etc. are included as summaries of the 'Credit Card' and 'Non Credit Card' payments for the day.  Each of these matches the values on the Transaction Summary Report for the day. 

Besides these 2 'special condition Groups', the Transaction Summary Ledger GL file will include all  Items and their respective summary numbers for the day. Your Transaction Summary Ledger GL file will contain all Items and Groups that are present on your Transaction Summary Report.  

Transaction Summary Ledger GL file

For customers enrolled in the G/L program, BookingCenter will save an endpoint you will provide and during Night Audit, we trigger three messages to you when the System Date increments, as that is the indication that the day ’closes’ in BookingCenter.  This event happens when the staff does it, or if you are set to Auto Night Audit, when that time occurs. This is when the Transaction Summary Ledger GL file will trigger to your endpoint.  The file is a JSON array that is equal to the 'Today' column in the Transaction Summary Report for that specific System Date.  An example is included here:

Sample  Transaction Summary Report out

Transaction Summary
June 6, 2023

Category

Type

TODAY

MTD

YTD


Credit Card


 

American Express

$-105.00

$-105.00

$-205.77


 

Mastercard

$-100.44

$-100.44

$-150.78


 

Visa

$-15.00

$-15.00

$-115.00




 

TOTAL Credit Card:

$-220.44

$-220.44

$-471.55


Gift Certificates


 

Gift Certificate

$100.00

$100.00

$100.00




 

TOTAL Gift Certificates:

$100.00

$100.00

$100.00


Non Credit Card


 

Cash

$-135.15

$-135.15

$-260.15


 

Check

$0.00

$0.00

$0.00


 

Gift Certificate Redeemed

$0.00

$0.00

$0.00




 

TOTAL Non Credit Card:

$-135.15

$-135.15

$-260.15


Room Rent


 

Room Rent

$100.00

$100.00

$451.50




 

TOTAL Room Rent:

$100.00

$100.00

$451.50


Tax


 

Sales tax

$9.00

$9.00

$16.03


 

TOT

$5.00

$5.00

$22.58




 

TOTAL Taxes:

$14.00

$14.00

$38.61



 

GRAND TOTAL:

$-141.59

$-141.59

$-141.59

Advanced Deposit File

Advanced Deposits balance in BookingCenter (AD) will be sent as a JSON message to the same endpoint. The amount in this file will be equal to the Advanced Deposits Report that was accurate as of the Night Audit event. *note, this balance is dynamic and will likely not be identical if run at a later time, as bookings may have been checked in or or payments applied to future bookings, thus altering this dynamic balance.

Accounts Receivables File

Accounts Receivable Balance with current balance will also be sent as a JSON message to the same endpoint.  The amount in this file will be equal to the Account Receivable Aging report that was accurate as of the Night Audit event. *note, this balance is dynamic and will likely not be identical if run at a later time, as the Accounts Receivable may have had more charges or payments applied.

Archived and Re-Try Messages

Upon triggering the files to your endpoint, BookingCenter will send an email with. the files attached to the Property Address on file with a subject: Night Audit GL Files so that you have a backup to view what was posted at Night Audit. In addition, BookingCenter will provide an endpoint where you could validate using your Hotel/Site credentials, then pass in a date (the desired 'System Date'), and BookingCenter will send the messages again to your endpoint for that date’s data. The Transaction Summary with that System Date would be identical to what was sent at the initial time (ie, at original Night Audit event). The other 2 messages: Advanced Deposit Balance and Accounts Receivable Balance will not be identical, as those balances may have altered since that time, as these are dynamic balances.  But this offers a ‘retry’ method. 


PMS Tab











  • No labels