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 description inside of BookingCenter to the account codes & 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. If the use if of credit/debit or offsets isn't important to you, you can ignore these elements when processing the Transaction Transaction Summary Ledger GL file. But if your intention is to post the data to QuickBooks Online Edition, these are required to be setup properly. Because the Transaction Summary Ledger GL file is a version of the Transaction Summary report but , it 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 Receipt/ Item Group ID | Receipt/ Item Group Description | Site GL ID | Site GL Description | GL Credit/Debit option | Site Offset GL ID | Site Offset GL 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. In addition, for customers who use Direct Bills, the Direct Bill line on the Transaction Summary will not be sent in the GL file since that number is included in the Accounts Receivable Balance and should not be duplicated. Understanding GL MappingsThe options enabled for mapping to your accounting system GL include: Category: this matches the category summary of the Transaction Summary Report and Ledger GL file). For example, 'TOTAL CREDIT CARDS' Sub category: this matches the category summary of the Transaction Summary Report and Ledger GL file). For example, 'Visa' Account: This is the AccountID setup in your G/L system, such as "0012" where the credit/debit event will post and will be displayed the JSON array as "gl_id": "0012", Account Description: This is the Account Description setup in your G/L system, such as "RoomRentTotals" where the credit/debit event will post and will be displayed the JSON array as "gl_desc": "RoomRentTotals". Posting Type: This is where you wish to either Credit or Debit the specific account and will be displayed in the JSON array as "gl_type": "Credit" or "gl_type": "Debit" Offset: This is the AccountID setup in your G/L system, such as "0006" where the OFFSET credit/debit event will post and will be displayed the JSON array as "offset_id": "0006", Offset Description: This is the Account Description setup in your G/L system, such as "RoomRentOffset" where the credit/debit event will post and will be displayed the JSON array as "offset_desc": "RoomRentOffset Offset Type: This where you wish to balance the Credit or Debit specific account from above ('AccountID') with an 'OFFSET' account which will be displayed in the JSON array as "gl_offset_type": "Credit" or "gl_offset_type": "Debit". The "Offset Type" must be the opposite of what the Posting Types was else the 'books won't balance'. Live: yes/no (you can turn one of the mappings to NOT LIVE to stop it from appearing in your mappings area, but if it's still reporting on the Transaction Summary Report then it will be included in the JSON array sent to your G/L. *note: The $ amounts (or values) of the Debit/Credit and the matching 'Offset' Debit/Credit can be either positive or negative numbers, but will always be equal to each other. These values are not shown in the 'mapping area' (they differ each day), but they appear every day in the G/L file and are what gets posted automatically to the Accounts and Offset accounts. Totals or Details for Income accounts?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. If your G/L goal is to update daily Visa amounts separate from American Express amounts, for example, then you must map the Visa Account ID and Description from your G/L separate from the American Express ones and this will map them discreetly. However if you prefer to 'keep to simple' and keep the detail about daily credit card values in your GL as 'Credit Card', then use the category 'TOTAL CREDIT CARDS' and only the total of the aggregate will be posted to you G/L. You need to choose one or the other, not both. If you map both detailed credit cards type (such as VISA) and also aggregate 'TOTAL CREDIT CARDS', your G/L will end up with double amounts posted each day. The same is true of 'NON CREDIT CARDS', these are payment methods ('Receipt Types') such as CASH, Write-Off, check that can be mapped as detailed NON CREDIT CARDS (such as CASH) or aggregate 'NON CREDIT CARDS', but you should choose one or the other, not both. If you chose both, your G/L will end up with double amounts posted each 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. Advanced DepositsThe Advanced Deposits balance in BookingCenter (AD) will be sent in the JSON message and will update the G/L account of type 'liability' and that is mapped to the 'BookingCenter Advance Deposit. If using the Automated G/L Posting Product, the application will query the current balance in your General Ledger for the account mapped to Advanced Deposits as follows: "Advance Deposits" | "gl_id": "00002" | gl_desc": "AdvanceDeposit" | "gl_type": "Credit" | "gl_amount": "1345.67", The application will query the balance of the AD account (in example above, AccountID: 0002), reduce it to 0, then CREDIT the AD account with the current Advance Deposit amount $1,345.67. It then will make an 'offset' DEBIT posting to whatever the customer setup as their offset account to keep the Advanced Deposit balanced. The customer can always run the 'Advanced Deposit Report' in BookingCenter to see the details of bookings that supports the Advanced Deposit amount. *note, this balance is dynamic and will likely not be identical if run at a later time, as bookings may have been checked in, canceled, or payments applied to future bookings, thus altering the Advanced Deposit dynamic balance. Accounts ReceivableFrom QBOE: Accounts Receivable (A/R) account: needs to have a Customer in the Name Field. The A/R account is visible only after there are A/R transactions such as receive payments from invoices. BookingCenter doesn't use the internal QBOEAccounts Receivable (A/R) system. Instead, your accountant will create an AR account of type 'liability' and description: 'BookingCenter AR' and use the account code (customer-provided) to map to this. This amount will be equal to the AR Ageing 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 Company Accounts may have been paid off via an AR payment or DB: payments applied to bookings, thus altering this dynamic balance. Thus, the customer's GL will end up with an'BookingCenter AR' account that is managed by the GL JSON but the details of which Company owes how much is left detailed in BookingCenter and reflected as a Toal 'liability' nightly in the G/L. Transaction Summary Ledger GL fileFor 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 output: Transaction Summary
June 6, 2023 | Transaction Summary Ledger GL file
System Date: June 6, 2023
JSON Array Sample |
JSON Array Sample continued | Report 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 |
|
Transaction Summary Ledger GL fileFor 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 output:Transaction Summary
June 6, 2023 | Transaction Summary Ledger GL file
System Date: June 6, 2023 JSON Array Sample JSON Array Sample continuedReport 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$14$3861GRAND TOTAL: | $-141.59 | $-141.59 | $-141.59 | Advance Deposit : $1,235.90 Accounts Receivables: $9,465.23 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 |
Advance Deposit : $1,235.90 Accounts Receivables: $9,465.23 | American Express detail: { "success": true, "data": [ { American Express detail: { "success": true, "data": [ { "propertyID": "TEST", "propertyName": "Test hotel", "transactionDate": "2023-06-06", "ItemID": "AX", "Item description": "American Express", "GLCode": "AX", "GL description": "American Express", "amount": 105.00, "GLType": "debit" "GLOffsetIDpropertyID": "AXCreditRcTEST", "GLOffsetDescpropertyName": "AX Credit Card Receivables"Test hotel", "amounttransactionDate": 105.00"2023-06-06", "GLOffsetTypeItemID": "credit" }, Visa detail: {AX", "propertyIDItem description": "TESTAmerican Express", "propertyNameGLCode": "Test hotelAX", "transactionDateGL description": "2023-06-06American Express", "ItemIDamount": "VI"105.00, "Item descriptionGLType": "Visadebit", "GLCodeGLOffsetID": "VIAXCreditRc", "GL descriptionGLOffsetDesc": "VisaAX Credit Card Receivables", "amount": 15105.00, "GLTypeGLOffsetType": "debit"credit" }, Visa detail: { "GLOffsetIDpropertyID": "VICreditRcTEST", "GLOffsetDescpropertyName": "Visa Credit Card Receivables"Test hotel", "amounttransactionDate": 15.00"2023-06-06", "GLOffsetTypeItemID": "credit" }, TOTAL Credit Card summary: { VI", "propertyIDItem description": "TESTVisa", "propertyNameGLCode": "Test hotelVI", "transactionDateGL description": "2023-06-06Visa", "ItemIDamount": "Total Credit Card"15.00, "Item descriptionGLType": "Total Credit Carddebit", "GLCodeGLOffsetID": "Total_Credit_CardVICreditRc", "GL descriptionGLOffsetDesc": "Total Visa Credit Card Receivables", "amount": 13515.1500, "GLTypeGLOffsetType": "debit"credit" }, TOTAL Credit Card summary: { "GLOffsetIDpropertyID": "CreditCardRcTEST", "GLOffsetDescpropertyName": "Credit Card ReceivablesTest hotel", "amounttransactionDate": 135.15"2023-06-06", "GLOffsetTypeItemID": "credit" }, Cash detail:Total Credit Card", { "propertyID"Item description": "TESTTotal Credit Card", "propertyNameGLCode": "Test hotelTotal_Credit_Card", "transactionDateGL description": "2023-06-06Total Credit Card", "ItemIDamount": "Cash"135.15, "Item descriptionGLType": "Cashdebit", "GLCodeGLOffsetID": "CASHCreditCardRc", "GL descriptionGLOffsetDesc": "CASHCredit Card Receivables", "amount": 135.15, "GLTypeGLOffsetType": "debit"credit" }, Cash detail: { "GLOffsetIDpropertyID": "CASHRcTEST", "GLOffsetDescpropertyName": "CASH ReceivablesTest hotel", "amounttransactionDate": 135.15"2023-06-06", "GLOffsetTypeItemID": "credit" }, RENT detail: { Cash", "propertyIDItem description": "TESTCash", "propertyNameGLCode": "Test hotelCASH", "transactionDateGL description": "2023-06-06CASH", "ItemIDamount": "RENT"135.15, "Item descriptionGLType": "Room Rentdebit", "GLCodeGLOffsetID": "RENTCASHRc", "GL descriptionGLOffsetDesc": "Room RentCASH Receivables", "amount": 135.15.00, "GLTypeGLOffsetType": "credit" "GLOffsetID": "AD"}, | RENT detail: { "GLOffsetDescpropertyID": "Advance DepositTEST", "amountpropertyName": 15.00"Test hotel", "GLOffsetTypetransactionDate": "debit2023-06-06", }, TOT Tax: { "ItemID": "RENT", "propertyIDItem description": "TESTRoom Rent", "propertyNameGLCode": "Test hotelRENT", "transactionDateGL description": "2023-06-06Room Rent", "ItemIDamount": "TOT"15.00, "Item descriptionGLType": "TOTcredit", "GLCodeGLOffsetID": "TOTAD", "GL descriptionGLOffsetDesc": "Transient Occupancy TaxtAdvance Deposit", "amount": 515.00, "GLTypeGLOffsetType": "creditdebit" }, TOT Tax: { "propertyID "GLOffsetID": "TOTRecdTEST", "GLOffsetDescpropertyName": "TOTRecdTest hotel", "amounttransactionDate": 5.00"2023-06-06", "GLOffsetTypeItemID": "debit" }, Advanced Deposit: { TOT", "propertyIDItem description": "TESTTOT", "propertyNameGLCode": "Test hotelTOT", "transactionDateGL description": "2023-06-06Transient Occupancy Taxt", "ItemIDamount": "AD"5.00, "Item descriptionGLType": "Advance Depositcredit", "GLCodeGLOffsetID": "ADTOTRecd", "GL descriptionGLOffsetDesc": "Advance DepositTOTRecd", "amount": 12355.9000, "GLTypeGLOffsetType": "creditdebit" "GLOffsetID": "TOTAL_BANK"}, Advanced Deposit: { "GLOffsetDescpropertyID": "Total BANKTEST", "amountpropertyName": 100.00"Test hotel", "GLOffsetTypetransactionDate": "debit2023-06-06", }, Accounts Receivable: { "ItemID": "AD", "propertyIDItem description": "TESTAdvance Deposit", "propertyNameGLCode": "Test hotelAD", "transactionDateGL description": "2023-06-06Advance Deposit", "ItemIDamount": "AR"1235.90, "Item descriptionGLType": "Accounts Receivablescredit", "GLCodeGLOffsetID": "ARTOTAL_BANK", "GL descriptionGLOffsetDesc": "Accounts ReceivablesTotal BANK", "amount": 9465100.2300, "GLTypeGLOffsetType": "creditdebit" }, Accounts Receivable: { "propertyID "GLOffsetID": "TOTAL_BANKTEST", "GLOffsetDescpropertyName": "Total BANKTest hotel", "amounttransactionDate": 9465.23"2023-06-06", "GLOffsetTypeItemID": "debitAR", }, } | |
Advanced Deposit Advanced Deposits balance in BookingCenter (AD) will be sent in the JSON message. 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, canceled, or payments applied to future bookings, thus altering this dynamic balance. Accounts Receivables FileAccounts Receivable Balance with current balance will be sent in the JSON message. 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 to a Company Account. "Item description": "Accounts Receivables", "GLCode": "AR", "GL description": "Accounts Receivables", "amount": 9465.23, "GLType": "credit" "GLOffsetID": "TOTAL_BANK" "GLOffsetDesc": "Total BANK" "amount": 9465.23, "GLOffsetType": "debit" }, } | | Example of JSON output: |
|
|
Archived and Re-Try MessagesUpon triggering the file to your endpoint, BookingCenter will send an email with the array inside the body to the Property Address on file with a subject: Night Audit GL File <SystemDate> 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 message 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, as encapsulated in the archived email). The other Advanced Deposit Balance and Accounts Receivable Balance will likely not be identical, as those balances may have altered since that time, as these are dynamic balances. But this offers a ‘retry’ method. Email SummaryEvery night at Night Audit we send an email to the mail of the property with the subject: BookingCenter General Ledger JSON for <Hotel Name> on <date> and you should archive this in case you require a backup and can't access your JSON function.
|