--- title: How to Integrate Hotel PMS with SQL Accounting description: Find out how to export transactions from the hotel property management system (PMS) to the SQL Accounting Software. Streamline hotel accounting with PMS integration. Automate journal entries, track revenue, reduce manual work, and improve financial accuracy. image: https://page.mysoftinn.com/hubfs/4-Aug-15-2025-03-42-54-5483-AM.png --- [![Softinn](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/softinn-logo/softinn-logo-main-with-mascot.svg)](https://www.mysoftinn.com) - Products - [Property Management System](https://www.mysoftinn.com/hotel-pms-front-desk-system) - [Booking Engine](https://www.mysoftinn.com/hotel-booking-engine) - [Hotel Website CMS](https://www.mysoftinn.com/hotel-website-cms) - [Hotel Channel Manager](https://www.mysoftinn.com/hotel-channel-manager) - [Hotel Kiosk](https://www.mysoftinn.com/hotel-kiosk) - [AI New](https://www.mysoftinn.com/ai) - Segments - [Independent Boutique Hotel](https://www.mysoftinn.com/boutique-hotel-management-system) - [Hotel Chains](https://www.mysoftinn.com/hotel-chain-management-system) - [Resort & Villa](https://www.mysoftinn.com/resort-management-system) - [Short-Term Vacation Rental](https://www.mysoftinn.com/airbnb-management-software) - [Campsite](https://www.mysoftinn.com/campsite-management-system) - [Airport Hotel](https://www.mysoftinn.com/airport-hotel-management-system) - Roles - [Admin & Owner](https://www.mysoftinn.com/hotel-owner) - [Manager](https://www.mysoftinn.com/hotel-manager) - [Front Desk](https://www.mysoftinn.com/hotel-front-desk-receptionist) - [Housekeeping](https://www.mysoftinn.com/hotel-housekeeper) - [Maintenance](https://www.mysoftinn.com/hotel-maintenance-technician) - [Finance](https://www.mysoftinn.com/hotel-finance-accountant) - [Marketing and Sales](https://www.mysoftinn.com/hotel-marketing-sales) - Resources - [Knowledge Base](https://blog.mysoftinn.com) - [E-books](https://page.mysoftinn.com/guide-and-resources?hsLang=en-my) - [Product Training](https://page.mysoftinn.com/softinn-product-training-session?hsLang=en-my) - [Blog & Articles](https://page.mysoftinn.com/en) - [Product Updates](https://blog.mysoftinn.com/category/product-updates/) - [Partner & Integration](https://www.mysoftinn.com/integrations) - Company - [About Softinn](https://www.mysoftinn.com/about-us) - [Contact Us](https://www.mysoftinn.com/contact-us) - [Careers](https://page.mysoftinn.com/careers?hsLang=en-my) - [Pricing](https://www.mysoftinn.com/pricing) [Free Trial](https://page.mysoftinn.com/softinn-signup-form?hsLang=en-my) [Login](https://portal.mysoftinn.com/auth/login) Hotel PMS # How to Integrate Hotel PMS with SQL Accounting Hafizah Last updated 11 Jan 2026 ![](https://page.mysoftinn.com/hubfs/4-Aug-15-2025-03-42-54-5483-AM.png) # At the end of every month, your finance team spends hours manually transferring reports from the hotel PMS to the accounting software. The process is time-consuming, especially when it has to be done one by one.  In this blog, we’ll explore how integrating your hotel PMS with accounting software can streamline this process and save your team valuable time. ## **How to Integrate Hotel PMS with SQL Accounting ** ![SQL COMB-1](https://page.mysoftinn.com/hs-fs/hubfs/SQL%20COMB-1.png?width=332&height=269&name=SQL%20COMB-1.png) Integrating your Hotel PMS with SQL accounting helps hotel owners and accountants save time, reduce manual entry, and improve accuracy. In this guide, we’ll walk you through **how to integrate your Hotel PMS with SQL**, step-by-step. **Step 1: Check PMS Compatibility ** Ensure your hotel PMS supports integration with SQL Accounting **Step 2: Ensure SQL XLS n MDB is Installed** Ensure that you have the import tools in your desktop. Please contact your reseller to install it. **Step 3: Connect the PMS to SQL Accounting ** Use XLSX file format export to transfer accounting records from the PMS to SQL Accounting **Step 4: Map Accounts & Taxes** In your PMS settings, map: 1. Revenue accounts (room, F&B, etc.) 2. Payment methods (cash, card, e-wallet) 3. Tax codes (SST, etc.) **Step 5: Export the Transaction Journal in XLSX format from your PMS.** This file contains the revenue and payment data. **Step 6 : Log in to SQL Financial Accounting.** Access your SQL account. **Step 7 : Open SQL XLS n MDB** Access your SQL Excel import tools and start importing. **Step 8: Select the type of data you want to import** Go to GL on the navigation bar, then choose Journal Entry and click Get File to choose the file that you want to import. **Step 9 : Click on Verify and import the XLSX file and check for any errors.** If the document number matches, it will set to OK; if not, an error mark will appear in the data. **Step 10 : Click Post A/c to send the data to SQL Financial Accounting** **Step 11: Review the list of imported data in SQL Financial Accounting** Check the data you imported based on the type of data you choose. Ensure all data has been correctly imported. ## **Benefits for your hotel** **Auto-generated Excel journals ✅** Instead of manually keying in your data to the accounting software, hotel PMS and SQL integration helps to generate the data in one click. **Faster monthly closing ✅** The structured export helps streamline the entire reporting process, allowing your team to focus on analysis rather than data cleaning. **Save time ✅** Your finance team no longer needs to manually key in the same data into SQL, which saves time. **Real-time financial visibility for your accountant ✅** This ensures that your daily revenue reports are always up to date, consistent, and free from manual errors. **SST-compliant invoicing and accounting ✅** Your hotel stays compliant with government tax requirements and avoids potential penalties or audit issues. ## **Frequently Ask Questions (FAQs) ** 1. **What is SQL accounting integration with Hotel PMS?** SQL integration with Hotel PMS connects your PMS to SQL, allowing automatic transfer of financial data. It saves time, reduces manual work, and speeds up report closing. 2. **Do I need an SQL accounting license to integrate?** No. If you're using file import methods (like XLSX or MDB) through SQL Accounting’s built-in import tools, no additional license is required. It’s a simple integration that doesn’t involve API or direct database access. 3. **Is the exported file ready for import into SQL accounting?** Yes. Most PMS systems export data in **SQL-friendly formats** such as CSV, XML, or Excel. If your PMS export data in **Excel (.xlsx)** format, it can be imported into SQL using tools like **"SQL XLS and MDB Import"** or similar data import tools. These tools allow you to map Excel columns to SQL table fields, making it easy to transfer data accurately. 4. **Can I choose which transactions to include in the journal?** Yes. Most PMS systems allow you to filter or select specific transaction types (e.g., revenue only, or exclude deposit transfers) before exporting the journal, depending on your reporting needs. 5. **What PMS is compatible with SQL accounting?** Softinn PMS works smoothly with SQL for streamlined accounting. ## **Summary** The integration of hotel PMS and SQL accounting helps to streamline your finances. The process involves ensuring PMS compatibility, setting up the SQL accounting software , mapping accounts and tax codes, exporting data in Excel format, and importing it into SQL accounting.  By exporting a structured transaction journal from the PMS and importing it into SQL accounting, your finance team can save time, reduce errors, and speed up monthly reporting.   Let automation handle your journals. [Get a trial now.](https://page.mysoftinn.com/softinn-signup-form?hsLang=en-my)   [![Share on facebook](https://7528309.fs1.hubspotusercontent-na1.net/hub/7528309/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/facebook-color.png?width=24&name=facebook-color.png)](http://www.facebook.com/share.php?u=https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fhow-to-integrate-hotel-pms-with-sql-account%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on linkedin](https://7528302.fs1.hubspotusercontent-na1.net/hub/7528302/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/linkedin-color.png?width=24&name=linkedin-color.png)](http://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fhow-to-integrate-hotel-pms-with-sql-account%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on twitter](https://7528304.fs1.hubspotusercontent-na1.net/hub/7528304/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/twitter-color.png?width=24&name=twitter-color.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fhow-to-integrate-hotel-pms-with-sql-account%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fhow-to-integrate-hotel-pms-with-sql-account%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=) [![Share on pinterest](https://7528311.fs1.hubspotusercontent-na1.net/hub/7528311/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/pinterest-color.png?width=24&name=pinterest-color.png)](http://pinterest.com/pin/create/button/?url=https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fhow-to-integrate-hotel-pms-with-sql-account%3Futm_medium%3Dsocial%26utm_source%3Dpinterest&media=) [![Share on email](https://7528311.fs1.hubspotusercontent-na1.net/hub/7528311/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/email-color.png?width=24&name=email-color.png)](mailto:?subject=Check%20out%20https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fhow-to-integrate-hotel-pms-with-sql-account%3Futm_medium%3Dsocial%26utm_source%3Demail%20&body=Check%20out%20https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fhow-to-integrate-hotel-pms-with-sql-account%3Futm_medium%3Dsocial%26utm_source%3Demail) ##### Tags [Hotel PMS](https://page.mysoftinn.com/en/tag/hotel-pms) ![Hafizah](https://app.hubspot.com/settings/avatar/6d54a18ee4b2e54d4361cd5364583585) ##### Hafizah Hi! I’m Fizah, and I work in Digital Marketing at Softinn, helping hotels and homestays stay updated with all the latest industry tips, tools, and best practices. #### Stay in the Loop! Get the latest hotel management insights, tips, and industry updates delivered to your inbox monthly. No spam, just valuable content. - Monthly expert insights - Industry trends & best practices - Exclusive tips & resources [Subscribe Now](https://page.mysoftinn.com/softinn-blog-subscription?hsLang=en-my) We respect your privacy. Unsubscribe anytime. #### Comments ##### Recent Posts [![The e-Invoice Exemption Increased to RM3Million : What It Means For Your Hotel?](https://page.mysoftinn.com/hubfs/Blog%20Banner%202026%20-%20einvoice1-1.png)](https://page.mysoftinn.com/en/the-e-invoice-exemption-increased-to-rm3million-what-it-means-for-your-hotel?hsLang=en-my) ###### [The e-Invoice Exemption Increased to RM3Million : What It Means For Your Hotel?](https://page.mysoftinn.com/en/the-e-invoice-exemption-increased-to-rm3million-what-it-means-for-your-hotel?hsLang=en-my) [![7 Cloud PMS Safety Facts for Small Hotels](https://page.mysoftinn.com/hubfs/banner%20for%207%20cloud%20pms%20safety%20facts.png)](https://page.mysoftinn.com/en/7-cloud-pms-safety-facts-for-small-hotels?hsLang=en-my) ###### [7 Cloud PMS Safety Facts for Small Hotels](https://page.mysoftinn.com/en/7-cloud-pms-safety-facts-for-small-hotels?hsLang=en-my) [![Hotel Booking Engine Integration for Lower OTA Costs](https://page.mysoftinn.com/hubfs/banner%20for%20hotel%20booking%20engine%20integration%20for%20lower%20ota%20costs.png)](https://page.mysoftinn.com/en/hotel-booking-engine-integration-for-lower-ota-costs?hsLang=en-my) ###### [Hotel Booking Engine Integration for Lower OTA Costs](https://page.mysoftinn.com/en/hotel-booking-engine-integration-for-lower-ota-costs?hsLang=en-my) [![8 Hotel Booking Engine Mistakes That Cost You Direct Bookings](https://page.mysoftinn.com/hubfs/banner%20for%208%20hotel%20be%20mistakes.png)](https://page.mysoftinn.com/en/8-hotel-booking-engine-mistakes-that-cost-you-direct-bookings?hsLang=en-my) ###### [8 Hotel Booking Engine Mistakes That Cost You Direct Bookings](https://page.mysoftinn.com/en/8-hotel-booking-engine-mistakes-that-cost-you-direct-bookings?hsLang=en-my) [![Hotel PMS Payments and Chargeback Protection Guide](https://page.mysoftinn.com/hubfs/banner%20for%20hotel%20pms%20payments%20and%20chargeback.png)](https://page.mysoftinn.com/en/hotel-pms-payments-and-chargeback-protection-guide?hsLang=en-my) ###### [Hotel PMS Payments and Chargeback Protection Guide](https://page.mysoftinn.com/en/hotel-pms-payments-and-chargeback-protection-guide?hsLang=en-my) # Get Your Free Trial Now! [Start Trial](https://page.mysoftinn.com/softinn-signup-form?hsLang=en-my) No credit card required #### Products [Property Management System](https://www.mysoftinn.com/hotel-pms-front-desk-system) [Hotel Channel Manager](https://www.mysoftinn.com/hotel-channel-manager) [Booking Engine](https://www.mysoftinn.com/hotel-booking-engine) [AI](https://www.mysoftinn.com/ai) [Hotel Website CMS](https://www.mysoftinn.com/hotel-website-cms) [Hotel Kiosk](https://www.mysoftinn.com/hotel-kiosk) [Softinn API](https://api.mysoftinn.com/swagger/ui/index) [Pricing & Plan](https://www.mysoftinn.com/pricing) #### Segments [Independent Boutique Hotel](https://www.mysoftinn.com/boutique-hotel-management-system) [Resort & Villa](https://www.mysoftinn.com/resort-management-system) [Hotel Chains](https://www.mysoftinn.com/hotel-chain-management-system) [Short-Term Vacation Rental](https://www.mysoftinn.com/airbnb-management-software) [Campsite](https://www.mysoftinn.com/campsite-management-system) [Airport Hotel](https://www.mysoftinn.com/airport-hotel-management-system) [Customer Success Stories](https://www.mysoftinn.com/hotel-clients) #### Resources [Knowledge Base](https://blog.mysoftinn.com) [Blog and Articles](https://page.mysoftinn.com/en) [Product Update](https://blog.mysoftinn.com/category/product-updates/) [Product Training](https://page.mysoftinn.com/softinn-product-training-session?hsLang=en-my) [Partner & Integration](https://www.mysoftinn.com/integrations) #### Company [About Softinn](https://www.mysoftinn.com/about-us) [Contact Us](https://www.mysoftinn.com/contact-us) [Careers](https://page.mysoftinn.com/careers?hsLang=en-my) [Press Kit](https://page.mysoftinn.com/hubfs/Softinn%20Press%20Kit%202025.pdf?hsLang=en-my) [Terms & Services](https://page.mysoftinn.com/terms-of-service?hsLang=en-my)|[Privacy Policy](https://page.mysoftinn.com/privacy-policy?hsLang=en-my) Softinn builds the next-generation hotel management system for hotels in Southeast Asia. [![Facebook Logo](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/social-media/facebook-footer.png)](https://www.facebook.com/mySoftinn) [![Linkedin Logo](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/social-media/linkedin-footer.png)](https://www.linkedin.com/company/softinn) [![Twitter Logo](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/social-media/twitter-footer.png)](https://x.com/mysoftinn) [![Youtube Logo](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/social-media/youtube-2.svg)](https://www.youtube.com/c/Softinn) [![Instagram Logo](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/social-media/instagram-logo.svg)](https://www.instagram.com/mysoftinn/) --- © 2013-2026 Softinn Solutions Sdn. Bhd. 201201044886 (1029363-M). TIN: C-23412633070. SST No: M10-2208-32100003. All rights reserved. Made with ♥ in Malacca, Malaysia. ![Softinn Logo](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/softinn-logo/softinn-logo-main-with-mascot.svg) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Hafizah", "url" : "https://page.mysoftinn.com/en/author/hafizah" }, "dateModified" : "2026-01-11T23:54:32.617Z", "datePublished" : "2025-07-01T07:02:00.000Z", "headline" : "How to Integrate Hotel PMS with SQL Accounting", "image" : [ "https://page.mysoftinn.com/hubfs/4-Aug-15-2025-03-42-54-5483-AM.png" ], "mainEntityOfPage" : { "@id" : "https://page.mysoftinn.com/en/how-to-integrate-hotel-pms-with-sql-account", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://page.mysoftinn.com/hubfs/230813-softinn-block-green.png" }, "name" : "Softinn Solutions Sdn. Bhd." } } ```